1. Use the Data information above to prepare a Statement of Cost of Goods Manufactured in good form using only Excel cell reference.

2. Compute the cost of producing one Lotion last month. Compute your answer using cell references.

3. Use the Data information above to prepare a Statement of Cost of Goods Sold in good form using only Excel cell referencing.

4. Use the Data information above to prepare an Income Statement in good form using only Excel cell reference. Include a column showing the percent of each line item of sales. (Round your percentage answers to two significant digits

DATA: Production in units Sales in units Beginning Finished Goods in Units Ending Finished goods in units Unit selling price 29.000 27,000 1,000 3,000 $22 End of the Beginning of the year- month-December 1, December 31, 20xx 20XX $15,000 $25.000 $12,000 $10,000 $26.000 $15.000 Inventories: Raw Materials Work in process Finished goods Costs: Direct labor Raw materials purchased Variable Overhead Fixed Overhead Selling expenses Administrative expenses $71,500 $150,000 $30,000 $20,000 $100,000 $25,000