AFEX

Universal template calculator

Calculate manufacturing profitability

Enter capacity, materials, labor, electricity and fixed expenses. Results update automatically.

● Calculations run on your device. Data is not sent to a server.

Plastic product

Material, energy and scrap calculation structure.

Template figures are illustrative and only help you understand and start the calculation. Adapt every value to your project.

01

Product and production capacity?

Enter capacity, materials, labor, electricity and fixed expenses. Results update automatically.

pcs
h
%
%
%
Machine capacity / hour249,600 pcs
Break-even point193,689.6 pcs
Sales plan164,636.16 pcs
02

Materials per product?

490 so‘m
48 so‘m

Other variable costs

%
03

Monthly operating expenses?

kW
%
%

Additional monthly expenses

04

Price, tax and investment?

%

Additional taxes and levies

Changing the mode sets the rate automatically — adjust it to your case. With several taxes (e.g. profit tax + VAT + property tax) add them to the list below.

—

If a loan is used — optional

%
%
%
%
05 · Advanced financial settings?

Currency conversion

Depreciation

%

Days for automatic working capital

06 · Scenario settings?
Conservative
%
%
%
Optimistic
%
%
%

Check 3 scenarios?

Stress testConservative57.43 mln so‘m
Revenue
231.48 mln so‘m
Margin
24.8%
Payback
15.0 mo
Base caseBase111.29 mln so‘m
Revenue
304.58 mln so‘m
Margin
36.5%
Payback
7.7 mo
PotentialOptimistic141.07 mln so‘m
Revenue
345.09 mln so‘m
Margin
40.9%
Payback
6.1 mo

12-month cash flow?

Shows monthly revenue, operating cash, loan payment, net cash and cumulative position.

260.22 mln so‘m
%
%
%
%
%
%
%
%
%
%
%
%
Net cashCumulative
Jan: 23.59 mln so‘mFeb: 47.51 mln so‘mMar: 71.43 mln so‘mApr: 87.37 mln so‘mMay: 111.29 mln so‘mJun: 111.29 mln so‘mJul: 111.29 mln so‘mAug: 111.29 mln so‘mSep: 111.29 mln so‘mOct: 111.29 mln so‘mNov: 111.29 mln so‘mDec: 111.29 mln so‘mCumulative: -836.41 mln so‘mCumulative: -788.9 mln so‘mCumulative: -717.47 mln so‘mCumulative: -630.1 mln so‘mCumulative: -518.81 mln so‘mCumulative: -407.52 mln so‘mCumulative: -296.23 mln so‘mCumulative: -184.94 mln so‘mCumulative: -73.65 mln so‘mCumulative: 37.64 mln so‘mCumulative: 148.93 mln so‘mCumulative: 260.22 mln so‘mJanFebMarAprMayJunJulAugSepOctNovDec
Plan?Sales?Revenue?Operating cash?Loan?Net cash?Cumulative?
January · 45.0%74,086.27137.06 mln so‘m23.59 mln so‘m0 so‘m23.59 mln so‘m-836.41 mln so‘m
February · 60.0%98,781.7182.75 mln so‘m47.51 mln so‘m0 so‘m47.51 mln so‘m-788.9 mln so‘m
March · 75.0%123,477.12228.43 mln so‘m71.43 mln so‘m0 so‘m71.43 mln so‘m-717.47 mln so‘m
April · 85.0%139,940.74258.89 mln so‘m87.37 mln so‘m0 so‘m87.37 mln so‘m-630.1 mln so‘m
May · 100.0%164,636.16304.58 mln so‘m111.29 mln so‘m0 so‘m111.29 mln so‘m-518.81 mln so‘m
June · 100.0%164,636.16304.58 mln so‘m111.29 mln so‘m0 so‘m111.29 mln so‘m-407.52 mln so‘m
July · 100.0%164,636.16304.58 mln so‘m111.29 mln so‘m0 so‘m111.29 mln so‘m-296.23 mln so‘m
August · 100.0%164,636.16304.58 mln so‘m111.29 mln so‘m0 so‘m111.29 mln so‘m-184.94 mln so‘m
September · 100.0%164,636.16304.58 mln so‘m111.29 mln so‘m0 so‘m111.29 mln so‘m-73.65 mln so‘m
October · 100.0%164,636.16304.58 mln so‘m111.29 mln so‘m0 so‘m111.29 mln so‘m37.64 mln so‘m
November · 100.0%164,636.16304.58 mln so‘m111.29 mln so‘m0 so‘m111.29 mln so‘m148.93 mln so‘m
December · 100.0%164,636.16304.58 mln so‘m111.29 mln so‘m0 so‘m111.29 mln so‘m260.22 mln so‘m

Sensitivity analysis?

%-10%-5%0%+5%+10%
-20%56.25 mln so‘m67.83 mln so‘m79.4 mln so‘m90.97 mln so‘m102.55 mln so‘m
-10%69.3 mln so‘m82.32 mln so‘m95.34 mln so‘m108.37 mln so‘m121.39 mln so‘m
0%82.35 mln so‘m96.82 mln so‘m111.29 mln so‘m125.76 mln so‘m140.22 mln so‘m
+10%95.41 mln so‘m111.32 mln so‘m127.23 mln so‘m143.15 mln so‘m159.06 mln so‘m
+20%105.39 mln so‘m122.41 mln so‘m139.43 mln so‘m156.45 mln so‘m173.47 mln so‘m

Compare projects?

Add a saved project to compare.

Cost structure?

What the full cost of one product is made of.

Materials: 554.64 so‘mElectricity: 34.36 so‘mPackaging: 120 so‘mLogistics and other: 80 so‘mLabor: 122.45 so‘mFixed expenses: 170.07 so‘mDepreciation: 48.16 so‘mTax and commission: 92.5 so‘m

1 product

1,222.19 so‘m

  • Materials554.64 so‘m45%
  • Electricity34.36 so‘m3%
  • Packaging120 so‘m10%
  • Logistics and other80 so‘m7%
  • Labor122.45 so‘m10%
  • Fixed expenses170.07 so‘m14%
  • Depreciation48.16 so‘m4%
  • Tax and commission92.5 so‘m8%

Investment structure?

Where the initial money goes. 860 mln so‘m

  • Equipment650 mln so‘m 76%
  • Delivery and customs65 mln so‘m 8%
  • Installation and launch25 mln so‘m 3%
  • Working capital120 mln so‘m 14%

Calculation method

The calculator derives cash flow, unit cost, margin and payback with the formulas below. All values are monthly.

  1. Good output = capacity × hours × days × utilization % × (1 − scrap %)
  2. Sales volume = good output × sales plan %
  3. Variable cost / product = materials ÷ (1 − scrap) + electricity + packaging + logistics
  4. Fixed expenses = payroll × (1 + bonus) × (1 + social tax) + rent + admin + marketing + maintenance + other
  5. Contribution / product = price − variable cost − commission − unit taxes (mode + % of revenue, % in price, amount per unit)
  6. Break-even (units) = (fixed expenses + depreciation + fixed monthly taxes) ÷ contribution
  7. Operating cash = revenue − variable − fixed − commission − tax
  8. Depreciation / month = (equipment + delivery + installation) × (1 − residual %) ÷ (years × 12)
  9. Payback (months) = total investment ÷ operating cash
  10. Annual ROI = accounting net profit × 12 ÷ total investment

Sources

Happy with the numbers? Let’s turn the project into an exact quote.

AFEX GROUP specialists help with equipment selection, delivery and commissioning. Call us or pick equipment in the catalog and request a price.

Call · +998 93 381 6699Equipment catalog

Calculations are preliminary. Verify the final budget, taxes and loan terms with a specialist.