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