Subject Cost accounting: Part 1: Use the information in part 1 for Juicy Lemonade Company to complete a Cost of Goods Manufactured Statement and a Cost of Goods Sold Statement for the year ended 2019. All reports should be prepared in Excel with good form. The following cost and inventory data were taken from the records of the juicy Lemonade company for the year 2019.

Cost incurred

Depreciation factory equipment $30,000

Depreciation office equipment $7000

Supplies factory $1,500

Maintenance factory equipment $20,000

Utility factory $8000

Sales commissions $30,000

Indirect Labor $54,500

Rent factory building $70,000

Purchases of direct materials (net) $124,000

Direct labor $80,000

Advertising expense $90,000

Costs incurred inventories:

January 1 December 31

Direct materials $9000 $11,000

Work in progress $6000 21000

Finished goods $69,000 $24,000