ock AutoSave ACCT 322 Home Insert Draw Page Layout Formulas Data Review View XLSTAT Tel X N 32 AA BIU- 119 A Question 3 (26 minutes, 16 marks) 3nfomation for Paradigm Lates xfx B D E H 14 Us Year Units sold 2012 34) 4500 $114.000 2013 15,000 $118,000 2014 15.500 $121.000 2015 16,000 $124,000 2016 13,500 $109.000 2017 2018 13,000 $144,000 22.000 $163.000 2019 23,500 $175,000 2000 24.000 $176.000 2021 22.500 $180.000 17 Uses known teamed 21 22 25 Depreciation expe $140.000 par 10% of sales 18.500 each mon $240,000 per year Cost of goods d 20 Thenone ta ista is 20% 21 Required 25 37 Using the high hot path.co esc " ! Q @ 2 O 2 * ** M #3 3: " Q " " $ 4 25 % LLI E R A SDF T MacBook 66 Autove om ACCT Home Insert Draw Page Layout Formulas Data Review View XLSTAT Arial A A Text Paste A Merge & Cede 19 xvfx B C E 0 H 6) in 2022 the company plans to sell 25,000 units at a selling price of $75 per unit. Prepare a contribution format income statement for the year ending December 31, 2022 using the template below. Use the high-low estimates above for the mixed uses cost Paradigm Limited Income Statement (projected, contribution format) Year ended December 31, 2022 10 marks Sales Variable c COGS Sales Commissions Variable utites 00 Total variatio 61 Contbuton margin 2 Fixed costs Depreciation 65 Sales salaries 60 Fixed sides 67 Total faed co 68 Operating come 20 Net Income 22 75 176 " 79 no 82 83 Per Unit % of Sales T Quot Sect destination and press ENTER t esc # " " 2 1 @ 2 2 0 Question3 Question * 80 " FA " #3 $ 4 85 % Mac 66 ACCT 3224 W Excel File Edit View insert Format Tosis Data Window Help 060 Page Layout Formulas Date Review View XLSTAT 4. Home Insert Mid BIUN 119 Question 3 (26 minutes 14 mar 3ation for Party Lis D Und cost 2012 14,300 $114.000 2013 2014 15.300 15,000 $116.00 $121306 2010 2014 2017 16,000 $12400 13,500 $100000 10,000 $144.000 2018 22,000 $163,000 2018 23,500 $175,000 2020 24,000 $17000 2001 22.500 $1000 Omer ests and their cost formulas are st Depreciation exper Sales comm Cost of goods N Required T Q esc 27 * 93 ! @ 1 2 tab Q A 3: #3 M S A $ E FA MocB 5 6 $ 94 % D R T LL F Excel File Edt View Insert Format Tools Data Window Help Autolave ACCT 3224 winter: Home Insert Dr Page Layout Formulas Data View XLSTAT T DAA Act 05- 6 A. 41 42 M A . Paradyn Linde Year ended December 31, 2023 T 5 Variable co Coo S Sales Commis V Conbun margin 2 Fred ce 3 Deprecation 65 S F 67 Total feed 68 Operating come 69 Tax 70 Net income Part Question Quest esc " * ! 1 @ 2 2 Cab Q G 80 = #3 3 W B: $ 55 4 de % *5 MacBoo 96 LLI E R T