ATC $11-6($Static$)$ 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

Assembly labor

Manufacturing space rent

Utilities

Janitorial services

Depreciation of equipment

Labor time per computer

Required

a$.$ Complete the 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.

Spreadsheet Tip

Explore the power of formulas by copying cells $A18$:$H33$ into the scratchpad area below, There you will be able to modify the

information currently in cells A$18,$ D$43,$D$44,$D$46$:D$48,$D$53,$ and E$49$ and see the resulting changes. You will need to modify the

formulas in the "per unit" calculations to reflect the new cell reference for units manufactured and sold.

Use the Open Excel in New Tab button to launch this question.

When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.