ATC 11-6 Spreadsheet Assignment Using Excel 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. Components from wholesaler $480 per computer Assembly labor $15 per hour Manufacturing space rent $3,000 per month Utilities $600 per month Janitorial services $480 per month Depreciation of equipment $3,840 per year Labor time per computer. 2 hours 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. Page 534 b. Add an abbreviated income statement to your spreadsheet that incorporates the cost from Requirement a