In: Economics
Company A is considering replacing its current production line. The current line has fixed cost 350,000 per year, has variable cost 10 per unit and sells for 14 per unit.
The new production line will have fixed cost of 500,000, variable cost of 9.6 per unit and sells for 16 per unit.
1. Determine the breakeven quantities for both lines.
2. Plot the two profit relations.
3. Determine the breakeven quantity between the two alternatives.
Must be completed in Microsoft Excel
Break even formula: (SP-VC) x no. of units = Fixed Cost
Now having known this we formulate a data table for both the alternatives and then plot the profit curves on a graph:
Existing | ||||||
Units | SP | Sales= SP x units | VC per unit | VC=VC per unit x units | FC | Profit = Sales-VC-FC |
117500 | 14 | 1645000 | 10 | 1175000 | 350000 | 120000 |
110000 | 14 | 1540000 | 10 | 1100000 | 350000 | 90000 |
102500 | 14 | 1435000 | 10 | 1025000 | 350000 | 60000 |
95000 | 14 | 1330000 | 10 | 950000 | 350000 | 30000 |
87500 | 14 | 1225000 | 10 | 875000 | 350000 | 0 |
80000 | 14 | 1120000 | 10 | 800000 | 350000 | -30000 |
72500 | 14 | 1015000 | 10 | 725000 | 350000 | -60000 |
65000 | 14 | 910000 | 10 | 650000 | 350000 | -90000 |
57500 | 14 | 805000 | 10 | 575000 | 350000 | -120000 |
Proposed | ||||||
Units | SP | Sales | VC per unit | VC | FC | Profit |
108125 | 16 | 1730000 | 9.6 | 1038000 | 500000 | 192000 |
100625 | 16 | 1610000 | 9.6 | 966000 | 500000 | 144000 |
93125 | 16 | 1490000 | 9.6 | 894000 | 500000 | 96000 |
85625 | 16 | 1370000 | 9.6 | 822000 | 500000 | 48000 |
78125 | 16 | 1250000 | 9.6 | 750000 | 500000 | 0 |
70625 | 16 | 1130000 | 9.6 | 678000 | 500000 | -48000 |
63125 | 16 | 1010000 | 9.6 | 606000 | 500000 | -96000 |
55625 | 16 | 890000 | 9.6 | 534000 | 500000 | -144000 |
48125 | 16 | 770000 | 9.6 | 462000 | 500000 | -192000 |