AutoSave Off Week 5 Homework Problems (2) - Excel Search Formulas Data Review View Help ab Wrap Text General Merge & Center $ % 9500-00 Alignment N Number Reactivate File Home Insert Draw Page Layout Liberation Sans 11 ' Paste BI U Clipboard Font ] Conditional Format as Cell Formatting Table Styles A joey wagner Insert v DxDelete Styles Format Cells SUBSCRIPTION EXPIRED To keep using Excel without interruption, please reactivate now. SIGN IN TO OFFICE It looks like your stored credentials are out of date. Please sign in as jdog3200922@gmail.com so we can verify your subscription. Sign In B5 fx Units sold A B C D E F G H J K L M N 1 Problem 5-1 Variable and Full Costing: Sales Constant but Production Fluctuates Spencer Electronics produces a wireless home lighting device that allows consumers to turn on home lights from their cars and light a safe path into and through their homes. Information on the first three years of business is as follows: 23456 Units sold 2017 20,000 2018 2019 20,000 Total 20,000 60,000 Units produced 20,000 25,000 15,000 60,000 7 Fixed production costs $750,000 8 Variable production costs per unit 150 $750,000 150 $750,000 150 9 Selling price per unit 250 250 250 10 Fixed selling and administrative expense 220,000 220,000 220,000 11 12 Required 13 a. Calculate profit and the value of ending inventory for each year using full costing. 14 15 P5-1 Edit Type here to search 2017 2018 2019 C JW Share Sort & Find & Select Filter Editing 0 Comments 4 Analyze Data Analysis ^ P 0 + 100% 1:55 PM 2/14/2021 1 AutoSave Off Week 5 Homework Problems (2) - Excel Search Formulas Data Review View Help ab Wrap Text General Merge & Center $ % 9500-00 Alignment N Number Reactivate File Home Insert Draw Page Layout Liberation Sans 11 ' Paste BI U Font ] Conditional Format as Cell Formatting Table Styles A joey wagner Insert v DxDelete Styles Format Cells SUBSCRIPTION EXPIRED To keep using Excel without interruption, please reactivate now. SIGN IN TO OFFICE It looks like your stored credentials are out of date. Please sign in as jdog3200922@gmail.com so we can verify your subscription. Clipboard Sign In JW Share 0 Comments 4 Filter Sort & Find & Select Analyze Data Editing Analysis ^ B5 fx Units sold A B C D E F G H I J K L M N 14 15 2017 2018 2019 16 Fixed production costs 17 Number of units 18 Fixed production cost per unit 19 Variable production costs per unit 20 Full cost per unit 21 Sales 2222222223 24 25 Cost of goods sold Gross margin Selling and administrative expense 26 Net income 27 28 29 Cost per unit 30 Number of units Value of ending inventory P5-1 Edit Type here to search 5,000 [ Q C O P + 100% 1:55 PM 2/14/2021 1 AutoSave Off File Home Insert Draw Page Layout Liberation Sans 11 ' Paste BI U Clipboard Font ] Week 5 Homework Problems (2) - Excel Search Formulas Data Review View Help ab Wrap Text General Merge & Center $ % 9500-00 Alignment N Number Reactivate SUBSCRIPTION EXPIRED To keep using Excel without interruption, please reactivate now. SIGN IN TO OFFICE Conditional Format as Cell Formatting Table Styles It looks like your stored credentials are out of date. Please sign in as jdog3200922@gmail.com so we can verify your subscription. A joey wagner Insert v DxDelete Styles Format Cells Sign In B5 fx Units sold A B C D E F G H | J K L M N 333333334 32 b. Explain why profit fluctuates from year to year even though the number of units sold, the selling 33 price, and the cost structure remain constant. SKIP 35 36 37 38 39 40 c. Calculate profit and the value of ending inventory for each year using variable costing. 41 Variable cost of goods sold Contribution margin 42 43 Sales 44 45 46 47 48 Fixed production costs Fixed selling and admin. expense Net income P5-1 Edit Type here to search 2017 2018 2019 Q C JW Share Sort & Find & Select Filter Editing O 0 Comments 4 Analyze Data Analysis ^ P 1:55 PM 2/14/2021 + 100% 1 JW Share 0 Comments 4 Filter Sort & Find & Select Analyze Data Editing Analysis ^ AutoSave Off File Home Insert Draw Page Layout Liberation Sans 11 ' Paste BI U Clipboard Font ] Week 5 Homework Problems (2) - Excel Search Formulas Data Review View Help ab Wrap Text General Merge & Center $ % 9500-00 Alignment N Number Reactivate SUBSCRIPTION EXPIRED To keep using Excel without interruption, please reactivate now. SIGN IN TO OFFICE Conditional Format as Cell Formatting Table Styles It looks like your stored credentials are out of date. Please sign in as jdog3200922@gmail.com so we can verify your subscription. A joey wagner Insert v DxDelete Styles Format Cells Sign In B5 A B fx Units sold C D E F G 40 c. Calculate profit and the value of ending inventory for each year using variable costing. 41 42 43 Sales 44 Variable cost of goods sold 45 Contribution margin 46 Fixed production costs 47 Fixed selling and admin. expense 48 Net income 49 50 Number of units 51 Cost per unit 52 Value of ending inventory 53 2017 2018 5,000 2019 54 d. Explain why, using variable costing, profit does not fluctuate from year to year. 55 SKIP 56 P5-1 Edit Type here to search Q H I J K L M N C O P 0 1:55 PM + 100% 2/14/2021 AutoSave Off File Home Insert Draw Page Layout Liberation Sans 11 ' Paste BI U Clipboard Font ] Week 5 Homework Problems (2) - Excel Search Formulas Data Review View Help ab Wrap Text General Merge & Center $ % 9500-00 Alignment N Number Reactivate SUBSCRIPTION EXPIRED To keep using Excel without interruption, please reactivate now. SIGN IN TO OFFICE Conditional Format as Cell Formatting Table Styles It looks like your stored credentials are out of date. Please sign in as jdog3200922@gmail.com so we can verify your subscription. A joey wagner Insert v DxDelete Styles Format Cells Sign In B5 A 52 B C Units sold D E F G H I J K L M N 53 Value of ending inventory 54 d. Explain why, using variable costing, profit does not fluctuate from year to year. 55 56 57 58 59 60 61 62 63 64 65 66 67 SKIP 68 P5-1 Edit Type here to search Q C JW Share Sort & Find & Select Filter Editing O 0 Comments 4 Analyze Data Analysis ^ P 1:55 PM 2/14/2021 + 100% 1