Instructions You will be using Microsoft Excel to answer this question. Follow the steps below to complete the question
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 AHE BETA Gradable Excel Exercise 4.7 Subtract; Cell Referencing_1_evalresponse Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri v 11 A X [G Custom Wrap Text 2 Insert v Delete Format Paste BIU y A Merge & Center Y Sensitivity Conditional Format Cell Formatting as Table Styles 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 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? 8 9 10 11 12 13 14 15 16 17 14 19 20 21 22 23 24 25 26 27 28 Incorrect Cost of goods manufactured $ 156,000 Score: 0.0 out of 5 Feedback: Use a mathematical formula with cell references to the Problem area to determine the cost to be transferred into the finished Goods Inventory account. b. What was Favre's cost of goods sold for the period? Instruction: 50% of your score. Formula: Subtract; Cell reference Use a mathematical formula with cell references to the Problem area Cost of goods sold $ 169,000 29 30 32 33 34 35 36 37 38 39 Summary Cell 112 note by Author Enter Answer 2 - + 100%
