11:28 AM Tue Mar 26 Lab 6-Manufacturing Costs March 21-22 copy e* a Draw Formulas Data Review View TablePhotos Camera Shapers Recommended 111 Charts s Chart Comment Link 6 Knick Knacks R Us is a manufacturer of art and craft items. Information for the first month of operations is as follows: Sales Indirect Labor Materials Purchased Gross Profit Indirect materials used Cost of Goods Manufactured Materials Inventory at end of first month Other factory overhead Work-in-Process inventory at end of first month All Beginning Inventories 850,000 62,000 315,000 235,000 33,000 640,000 20,000 13,500 30,000 0 10 12 13 14 15 16 17 18 19 20 REQUIRED: Prepare the manufacturing statement required below using Excel and 21 answer the accompanying questions directly on your excel spreadsheet. Be sure to SHOW ALL WORK 22 so that your logic in answering the items can be followed (Items 3, 5, and 6). Be sure to number and 23 label your answers. 24 Cost Classification Mfg Stmt 123 31 1 What was the amount of direct materials used? 2 What was the amount of direct labor cost? 3 What was the amount of total factory overhead? 4 Determine the amount of cost of goods sold (show all work) 5 Determine the amount of ending finished goods inventory ( 640