+1835 731 5494 Email: instantessays65@gmail.com

Spreadsheet Assignment

$12.99

Description

Spreadsheet Assignment Stanley Manufacturing Company, which sold 16,000 units of product at $20 per unit, collected the following information regarding three different levels of production. Inventory Costs Fixed Overhead $100,000 $100,000 $100,000 Number of units Produced $16,000 $20,000 $25,000 Fixed Overhead per Unit $6.25 $5.00 $4.00 Variable Manufacturing Costs $12 $12 $12 Full absorption cost per unit $18.25 $17 $16 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. 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. Use formulas so that the number of units produced in the preceding table can be changed and net income will be recalculated automatically.

Reviews

There are no reviews yet.

Be the first to review “Spreadsheet Assignment”

Your email address will not be published. Required fields are marked *