In: Accounting
Please solve the following question in detiels !
A company has $25 per unit selling price, $7.00 per unit in variable production cost and $2.00 per unit in variable selling and administrative cost. The annual fixed production cost is $400,000. The annual fixed selling and administrative cost is $50,000.
Complete the table below for each year. Assume a FIFO flow.
|
|||||||||||||||||||||||||||||||||||||||||||||||||
Answer:-
Working Note:
Year | ||||||
Particulars | 2016 | 2017 | 2018 | 2019 | ||
Units Produced | 120000 | 150000 | 100000 | 100000 | ||
Units Sold | 110000 | 120000 | 140000 | 100000 | ||
Selling price per unit | $25 | |||||
a) | Variable Production cost per unit | $7 | ||||
b) | Variable S&A OH | $2 | ||||
Annual Fixed Production Cost | $400,000 | |||||
Annual Fixed S&A OH | $50,000 | |||||
Variable Cost per unit(a+b) | 9 |
Variable Costing Income Statement | |||||
Amount($) | |||||
Particulars | 2016 | 2017 | 2018 | 2019 | |
Sales | $2,750,000 | $3,000,000 | $3,500,000 | $2,500,000 | |
Less: | Variable Cost per unit | $990,000 | $1,080,000 | 1260000 | 900000 |
Contribution | $1,760,000 | $1,920,000 | $2,240,000 | $1,600,000 | |
Less: | Fixed Production Cost | $400,000 | $400,000 | $400,000 | $400,000 |
Fixed S&A OH | $50,000 | $50,000 | $50,000 | $50,000 | |
Operating Income under Variable Costing | $1,310,000 | $1,470,000 | $1,790,000 | $1,150,000 | |
Cost per unit under Variable Costing | |||||
Amount($) | |||||
Particulars | 2016 | 2017 | 2018 | 2019 | |
Variable Cost | 990000 | 1080000 | 1260000 | 900000 | |
Fixed Cost | $450,000 | $450,000 | $450,000 | $450,000 | |
Total Cost | $1,440,000 | $1,530,000 | $1,710,000 | $1,350,000 | |
Units Produced | 120000 | 150000 | 100000 | 100000 | |
Cost per unit | $12.00 | $10.20 | $17.10 | $13.50 | |
Valuation of Closing Inventory under Variable Cost | |||||
Amount($) | |||||
Particulars | 2016 | 2017 | 2018 | 2019 | |
Opening Stock | 0 | 10000 | 40000 | 0 | |
Units Produced | 120000 | 150000 | 100000 | 100000 | |
Units Sold | 110000 | 120000 | 140000 | 100000 | |
Closing Stock | 10000 | 40000 | 0 | 0 | |
Cost per unit | $12.00 | $3.75 | $17.10 | $13.50 | |
Closing Inventory($) | $120,000.00 | $150,000.00 | $0.00 | $0.00 | |
Absorption Costing Income Statement | |||||
Amount($) | |||||
Particulars | 2016 | 2017 | 2018 | 2019 | |
Sales | 2750000 | 3000000 | 3500000 | 2500000 | |
Less: | Cost of goods sold | ||||
Variable Production cost per unit | $770,000 | $840,000 | $980,000 | $700,000 | |
Annual Fixed Production Cost | $400,000 | $400,000 | $400,000 | $400,000 | |
Gross Profit | $1,580,000 | $1,760,000 | $2,120,000 | $1,400,000 | |
Less: Variable S&A OH | $220,000 | 240000 | 280000 | 200000 | |
Fixed S&A OH | $50,000 | $50,000 | $50,000 | $50,000 | |
Operating Income under Absorption Costing | $1,310,000 | $1,470,000 | $1,790,000 | $1,150,000 | |
Cost per unit under Absorption Costing | |||||
Amount($) | |||||
Particulars | 2016 | 2017 | 2018 | 2019 | |
Variable Production cost per unit | $7 | $7 | $7 | $7 | |
Variable S&A OH | $2 | $2 | $2 | $2 | |
Fixed Production Cost($400000) | $3.33 | $2.67 | $4 | $4 | |
Fixed S&A OH | $0.45 | $0.42 | $0.36 | $0.50 | |
Cost per unit | $12.79 | $12.08 | $13.36 | $13.50 | |
Valuation of Closing Inventory under Variable Cost | |||||
Amount($) | |||||
Particulars | 2016 | 2017 | 2018 | 2019 | |
Opening Stock | 0 | 10000 | 40000 | 0 | |
Units Produced | 120000 | 150000 | 100000 | 100000 | |
Units Sold | 110000 | 120000 | 140000 | 100000 | |
Closing Stock | 10000 | 40000 | 0 | 0 | |
Cost per unit | 12.79 | 12.08 | 13.36 | 13.50 | |
Closing Inventory($) | 127878.788 | 483333.33 | 0 | 0 |