Variable Costing: (spreadsheet assignment #3)
March:
Beginning inventory = 2,500 units $26,500 ($10,000 variable)
Production = 32,000 units
Sales = 31,000 units @ $50 each
VMC (DM, DL, and VOH) = $129,600
FMC = $300,000
VS/A costs = $124,000
FS/A costs = $550,000
April:
Beginning inventory = ?
Production = 33,000 units
Sales = 34,000 units @ $50 each
VMC (DM, DL, and VOH) = $133,650
FMC = $300,000
VS/A costs = $126,000
FS/A costs = $550,000
Required: Variable costing income and full-absorption costing income for both March and
April. Prepare automated reports for both income methods for both months. A proper solution
will include a separate input section (under a separate tab) in which only data items will be
entered (you may use one input tab for both months). In a separate section (under another tab),
you should link items from the input tab to an output section that contains the income reports
(you may use one section for both variable and full-absorption costing income). Using the
information above, your solution will be for these periods
