Manning Cassey Computers (MCC) plans to produce and sell 1,600 computers for $720 each in the next fiscal year. The company€™s cost data follow.

Required
a. Construct a spreadsheet to calculate the cost of goods manufactured and the cost per unit for MCC. Use formulas in the schedule so that the cost of goods manufactured will automatically be calculated as you change the number of units sold.
b. Add an abbreviated income statement to your spreadsheet that incorporates the cost from Requirement α.

Spreadsheet Tip
Build the spreadsheet so that the number of units in cell E3 can be changed and cost of goods manufactured and net income will be recalculated automatically.

Transcribed Image Text:

Components from wholesaler Assembly labor Manufacturing space rent Utilities Janitorial services Depreciation of equipment Labor time per computer $480 per computer $15 per hour $3,000 per month $600 per month $480 per month $3,840 per year 2 hours