You are provided with the following data. Assume the company uses FIFO.

Required:

Note: All amounts should be entered as positive values.

Compute the Ending Inventory.

Compute the Absorption Costing Unit Product Cost.

Construct the Absorption Costing Income Statement.

Compute the Variable Costing Unit Product Cost.

Construct the Variable Costing Income Statement.

INCLUDE ALL EXCEL FORMULAS$/$EXCEL EQUATIONS FOR ENTRY INTO THE SPREADSHEET! Don't bother solving it if you dont include the Excel formula$/$equation for each entry in the tabel!!!!!