If ABC Company reports the following information:

Sales$160,000

General and AdministrativeExpenses9,000

Beginning Raw MaterialsInventory6,000

Ending Raw MaterialsInventory5,000

Beginning Work-in-ProcessInventory3,000

Ending work-in-ProcessInventory2,000

Beginning Finished GoodsInventory4,000

Ending Finished GoodsInventory6,000

DirectLabor29,000

MaterialPurchases92,000

Mfg. Overhead (insurance % taxes)20,000

How would you render the following statements in Excel?

1. ABC's Cost of Goods Manufactured Statement.
2. ABC's Cost of Goods Sold Statement.
3. ABC's Income Statement for ABC Co.