The following cost and inventory data are taken from the accounting records

Mason Company of the Year Just Done:

Sales ..................................................................... .. 555,000 dollars

Incurred costs:

Direct labor cost... $66,000

Purchases of raw materials ... 118 thousand dollars

Manufacturing costs ... $70,000

Advertising expenses ................................ 90 thousand dollars

Sales salaries ... $55,000

Depreciation and office equipment ...... 3000 dollars

Date: ............................ 1/1/2020 to 31/12/2020

Stocks:

Raw materials.....................................................................................................................................................................................................................................

In progress...15,000 dollars....12,000 dollars

Finished merchandise.....$21,000...$35,000

Calculate and then report the excel file to me explaining the solution