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 Finished Goods Inventory, ending 16,000 Cost of goods available for sale 185,000 a. What was Favre's cost of goods manufactured for the period? b. What was Favre's cost of goods sold for the period? 7 8 a. Cost of goods manufactured b. Cost of goods sold 9 10 11 12 13 14 15 16