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. b. Add an abbreviated income statement to your spreadsheet that incorporates the cost from Requirement a. Page 534 Home Inter Page Layout Copy Format Painter Clipboard N29 Arial Font ATC 11-6 working 7th edals - Microsoft Excel Formula Dat Review View -10 A A WT General Merge & Center Alignment A B C 1 Chapter 11 Working with Excel Auto- A Conditional Format Cell Formatting as Table-Styles Styles Inset Delete Format Sart & Find & Clear Eating D E F G H J K L M Name: 2 3 4 5 6 7 Direct Materials Used 8 Direct Labor 1,600 units manufactured and sold Schedule of Cost of Goods Manufactured (Variable) 1,600 x $ 480 = (Variable) 1,600 x $ 30= 768,000 48,000 per unit $480.00 $ 30.00 9 Manufacturing Overhead 10 Manufacturing Space Rent (Fixed) 12 x $3,000 36,000 11 Utilities (Fixed) 12 x $ 600 7,200 Janitadal Condnes Clved) 13 e 100 5750