B D F G H 4 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work area as indicated. E 1 Formula: Subtract; Cell Referencing 2 3 E4.7 - Using Excel to Determine Manufacturing Costs PROBLEM 5 The following information relates to the operations of Favre 6 Company: Finished Goods Inventory, beginning $ 29,000 9 Finished Goods Inventory, ending 16,000 Cost of goods available for sale 185,000 11 12 a. What was Favre's cost of goods manufactured for the period? b. What was Favre's cost of goods sold for the period? 15 7 8 a. Cost of goods manufactured 10 b. Cost of goods sold 13 14 16