Vikas

Spreadsheet Assignment

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.

Answered
Other / Other
19 Jan 2016

Answers (1)

  1. Vikas

    Spreadsheet Assignment

    Spre ****** ******
    To see full answer buy this answer.
    Answer Attachments

    1 attachments —

    • img
      Accounting198486.xls

Report As Dispute

Share Your Feedback

Give Review : A+ A B C D F