In: Accounting
Given the following information:
| 
 Prior Year (Budget)  | 
 Prior Year (Actual)  | 
 Current Year (Budget)  | 
 Current Year (Actual)  | 
|
| 
 Beginning Inventory (Units)  | 
 0  | 
 0  | 
 ?  | 
 ?  | 
| 
 Sales (Units)  | 
 600,000  | 
 580,000  | 
 575,000  | 
 570,000  | 
| 
 Manufactured (Units)  | 
 600,000  | 
 590,000  | 
 640,000  | 
 610,000  | 
| 
 Selling Price ($/unit)  | 
 9.99  | 
 9.90  | 
 9.95  | 
 10.00  | 
| 
 Variable Manufacturing Cost ($/unit)  | 
 4.92  | 
 4.90  | 
 5.00  | 
 4.95  | 
| 
 Total Fixed Manufacturing Costs ($)  | 
 1,584,000  | 
 1,561,000  | 
 1,625,000  | 
 1,599,531  | 
| 
 Variable Selling Cost ($/unit)  | 
 1.00  | 
 1.01  | 
 0.99  | 
 1.00  | 
| 
 Total Fixed SG&A Costs ($)  | 
 350,000  | 
 353,000  | 
 352,850  | 
 348,000  | 
Other information:
Required:
Given :
Actual unit sold in the prior year = 58000
Actual units manufactured in the prior year = 590000
Therefore, ending inventory during the prior period = 590000-580000 =10000
The ending inventory of the prior period will be the beginning inventory for the current period.
Therefore, beginning inventory for the current period = 10000
Current year current year
budget actual
| 
 
  | 
||
| 
 Beginning Inventory (Units)  | 
 ?  | 
 10000  | 
| 
 Sales (Units)  | 
 575,000  | 
 570,000  | 
| 
 Manufactured (Units)  | 
 640,000  | 
 610,000  | 
| 
 Selling Price ($/unit)  | 
 9.95  | 
 10.00  | 
| 
 Variable Manufacturing Cost ($/unit)  | 
 5.00  | 
 4.95  | 
| 
 Total Fixed Manufacturing Costs ($)  | 
 1,625,000  | 
 1,599,531  | 
| 
 Variable Selling Cost ($/unit)  | 
 0.99  | 
 1.00  | 
| 
 Total Fixed SG&A Costs ($)  | 
 352,850  | 
 348,000  | 
1.) income statement for the Current Year based on Variable Costing:
| 
 particulars  | 
 amount  | 
 amount  | 
| 
 Sales  | 
 5700000  | 
|
| 
 Less Variable cost of goods sold  | 
||
| 
 Opening inventory (10000x4.9)  | 
 49000  | 
|
| 
 (+) VC of goods manufactured  | 
 3019500  | 
|
| 
 VC of goods available for sale  | 
 3068500  | 
|
| 
 (-)closing inventory (50000x4.95)  | 
 247500  | 
|
| 
 Gross contribution margin  | 
 2821000  | 
|
| 
 (-) variable selling cost  | 
 570000  | 
|
| 
 Contribution margin  | 
 2251000  | 
|
| 
 Less: period expenses  | 
||
| 
 Fixed manufacturing expense  | 
 1599531  | 
|
| 
 Fixed SG and A cost  | 
 348000  | 
 1947531  | 
| 
 Net operating income  | 
 303469  | 
income statement for the Current Year based on Absorption Costing.
| 
 particulars  | 
 amount  | 
 Amount  | 
| 
 sales  | 
 5700000  | 
|
| 
 Less cost of goods sold:  | 
||
| 
 Opening inventory  | 
 75500  | 
|
| 
 + COGM  | 
 4619031  | 
|
| 
 Cost of goods available for sale  | 
 4694531  | 
|
| 
 - Closing inventory  | 
 378500  | 
 4316031  | 
| 
 Gross profit  | 
 1383969  | 
|
| 
 Less selling expenses  | 
||
| 
 variable  | 
 570000  | 
|
| 
 fixed  | 
 348000  | 
|
| 
 Net operating income  | 
465969 | 
net income using absorption costing is greater than using variable costing by 162500 (465969-303469).
also, ending inventory using absorption costing is 378500 and using variable costing is 247500. this is because fixed manucaturing expense is added to ending inventory in absorption costing.