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.

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.

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.