Hover over the red tab in the upper right corner of a cell to see the formula. D E G The following is a list of costs and amounts for Stella Industries' latest month. Stella makes one product, a metallic, reusable water bottle. Stainless steel sheet metal $ 6,523 Rubber caps 3,284 President's salary 4,752 Shipping to customers 1,154 Wages for maintenance crew 2,865 9 Insulation for bottles 1,141 10 Stainless steel finishing solution 585 11 Sandpaper 256 12 Advertising expense 6,985 13 Assembler wages 12,853 14 Depreciation on office equipment 152 Depreciation on milling machine 3,974 16 Property tax for factory 1,554 17 Supervisor salary 3,258 18 19 Required: 20 Use the information above to calculate the amounts below. 21 Tip: Keep the cells in the formulas in the order given in the data. 22 23 1. Direct Costs 23,801 Formula -84+85+69+813 24 2. Indirect Costs 12,492 25 3. Direct Materials 10,948 26 4. Direct Labor $ 12,853 27 5. Manufacturing Overhead 12,492 28 6. Prime Cost 23,801 29 7. Conversion Cost 25,345 30 8. Total Product Cost 36,293 31 9. Period Cost $ 13,043 32 10. Variable Cost 28,661 33 11. Fixed Cost 20,675 34