AutoSave OFF OFF ARE Home Insert Draw Page Layout Formulas Data Review Share Comments BETA Gradable Excel Exercise 4.7 Subtract; Cell Referencing_1_evalresponse View Tell me Wrap Text Custom Merge & Center Conditional Format Cell Formatting as Table Styles Calibri v 11 X [G A 2 Insert v Delete Format Paste BIU y A Y Sensitivity Ov Sort Filter Find & Select Analyze Data Check for Updates 112 K L L M N o P Q R S 5 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. f. 156000 AR C D E F G 1 J 1 Formulas: Subtract; Cell Referencing 2 3 E4.7-Using Excel to Determine Manufacturing Costs Student Work Area PROBLEM Required: Pravice input into cells shaded in yellow in this 5 The following information relates to the operations of Favre template. Use mathematical formulas with cell references to 6 Company the Problem or work area as indicated. $ $ Finished Goxxis Inventory, beginning Finished Goods Inventory, ending Cost of goods available for sale 29,000 16.000 185.000 a. What was Favre's cost of goods manufactured for the period? Cost of goods manufactured $ 156,000 b. What was Favre's cost of goods sold for the period? 8 9 10 11 12 13 14 15 16 17 14 19 20 21 22 23 24 25 26 27 28 Cost of goods sold $ 169,000 29 30 32 33 34 35 36 37 38 39 Summary Enter Answer 2 - + 100% AutoSave OFF OFF HES Chapter4 WileyPLUS Homework_Question7 (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Liberation Sans v 12 ~ A Wrap Text Text LG Insert v Delete Format Paste BIU 3 oy A Merge & Center $ % 2 Y Sensitivity Conditional Format Cell Formatting as Table Styles Ov Sort Filter Find & Select Analyze Data Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A1 f. Formulas: Subtract; Cell Referencing A E F 1 Formulas: Subtract; Cell Referencing D G L L M N o P Q R S 5 Student Work Area Required: Pravice input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work area as indicated. a. What was Favre's cost of goods manufactured for the period? Cost of goods manufactured b. What was Favre's cost of goods sold for the period? 3 E4.7-Using Excel to Determine Manufacturing Costs PROBLEM 5 The following intomation relates to the operations of Favre 6 Company Finished Gexxis Invertory, beginning $ $ 29.000 9 Finished Goods Inventory, ending 16.000 10 Cost of goods available for sale 185.000 11 12 13 14 15 16 17 14 19 20 21 22 23 24 25 26 27 28 Cost of goods sold 29 30 32 33 34 35 36 37 38 39 Enter Answer + 2 - + 100%