Stanley Manufacturing Company, which sold 16,000 units of product at $20 per unit, collected the following information regarding three different levels of production.

Required
a. Construct a spreadsheet that includes the preceding data in the top of the spreadsheet. The rows for fixed overhead per unit and full absorption cost per unit should be based on formulas.
b. Include absorption costing income statements at these three levels of production like those in Exhibit 11.10. Use formulas so that the number of units produced in the preceding table can be changed and net income will be recalculated automatically.
c. Include variable costing income statements at these three levels of production like those in Exhibit 11.11. Use formulas so that the number of units produced in the preceding table can be changed and net income will be recalculated automatically.

Transcribed Image Text:

Inventory Costs Fixed overhead Number of units produced Fixed overhead per unit Variable manufacturing costs Full absorption cost per unit $100,000 16,000 $100,000 20,000 $100,000 25,000 $6.25 $12.00 $18.25 $4.00 $12.00 $16.00 $5.00 $12.00 $17.00