In: Accounting
A process making 2000 metric tons of a product selling for P1.60 per kg. total cost of production is 84.375% of the total sales while the ratio of the fixed cost to the variable cost is 0.35:1.0. Variable costs consist of 50% labor cost and 40% raw material cost. if the management proposes increasing the selling price by 10% due to 20% increase in the cost of its raw materials,
a. determine the peso change in net profit at full capacity if tax rate is 34%
b. determine the % change in the breakeven point
c. determine the fixed cost per poundat new break even point
Calculation of Variable and Fixed Cost
| Particulars | Amount |
| Total Revenue(2000*1000*1.6) | 3200000 |
| Total Cost(3200000*84.375%) | 2700000 |
| Total Fixed Cost(2700000*0.35/1.35) | 700000 |
| Total Variable Cost(2700000-700000) | 2000000 |
| Total Material Cost(2000000*40%) | 800000 |
| Total Labour Cost(2000000*50%) | 1000000 |
| Other Variable Cost(2000000-800000-1000000) | 200000 |
Preperation of Income Statement
| Particulars | Scenario 1 Calculation | Scenario 1 | Scenario 2 Calculation | Scenario 2 | |
| Sales Revenue | 3200000 | 2000*1000*(1.6*110%) | 3520000 | ||
| Less Variable Cost | |||||
| Material Cost | 800000 | 800000*120% | (960000) | ||
| Labour Cost | 1000000 | (1000000) | |||
| Other Variable Cost | 200000 | (2000000) | (200000) | ||
| Contribution | 1200000 | 1330000 | |||
| Less: Fixed Cost | (700000) | (700000) | |||
| Net Profit before tax | 500000 | 660000 | |||
| Less: Tax | 500000*34% |
(170000) |
660000*34% | (224400) | |
| Net Profit after Tax | 330000 | 435600 |
a) Percentage Change in Net Profit
(435600-330000)/330000*100=32%
b) Determining Percentage Change in Break even Point
| Particulars | Scenario1 calculation | Scenario 1 | Scenario 2 calculation | Scenario 2 |
| Fixed Cost | 700000 | 700000 | ||
| Contibution/unit | 1200000/2000000kg | 0.6 | 1330000/2000000kg | 0.665 |
| BEP in units | 700000/0.6 | 1166667kg | 700000/0.665 | 1052632kg |
| BEP in pound | 1166667*1.6 | 1866667 | 1052632*1.76 | 1852632 |
| % Change in BEP units | (1166667-1052632)/1166667*100 | -9.77% | ||
| % Change in BEP pound | (1866667-1852632)/1866667*100 | -0.75% |
c)
Fixed cost per unit in pound at new BEP
700000/1052632kg = 0.66 Pound per unit