In: Accounting
Type of Data |
2015 |
2016 |
Units of AIIPad produced and sold |
800 |
900 |
Selling price |
$450 |
$430 |
Pounds of direct material used |
3,200 |
3,300 |
Direct material cost per pound |
$35 |
$35 |
Manufacturing capacity in units |
12,000 |
11,000 |
Total conversion costs |
$1,800,000 |
$1,650,000 |
Conversion cost per unit of capacity |
$150 |
$150 |
Selling and customer service capacity |
customers |
90 customers |
Total selling and customer service costs |
$495,000 |
$495,000 |
Selling and customer service capacity cost and customer |
$500 |
$550 |
Assuming Titan had 70 customers in 2015 and 80 customers in 2016,
Particulars 2015 2016
Revenue; 800*450;900*430 360,000 387,000
Direct Material Cost 3200*35;3300*35 112,000 115,500
Conversion Cost 1,800,000 1,650,000
Selling and Customer Service cost 495,000 495,000
Total Cost 2,407,000 2,260,500
Profit/Loss (2,047,000) (1,873,500)
Suppose that during 2016, the overall market for AllPads grew 3%. The decrease in the selling price of the AllPad and increase in market share (that is, sales increases greater than 3%) are the result of Titan’s strategic actions.
Type of Unit | 2015 | 2016 | ||||
Units | Price/Cost per Unit | Total Amount | Units | Price/Cost per Unit | Total Amount | |
All Pad Produced & Sold | 800 | $ 450.00 | $ 360,000.00 | 900 | $ 430.00 | $ 387,000.00 |
Direct material used | 3200 | $ 35.00 | $ 112,000.00 | 3300 | $ 35.00 | $ 115,500.00 |
Total conversion Cost | 800 | $ 150.00 | $ 120,000.00 | 900 | $ 150.00 | $ 135,000.00 |
Total Selling & Customer Service Cost | 70 | $ 500.00 | $ 35,000.00 | 80 | $ 550.00 | $ 44,000.00 |
Operating Income | $ 93,000.00 | $ 92,500.00 |
Operating Income has reduced by $ 500 even though the sales has increased.