Excel File Edt View Insert Format Tools Dub Window Heb Atom BE CHOBA (Empty! Home Insert Draw Page Layout Formas Review View XUSTAT Telma X Call AN 1 et Gene Data Pie 5 - 9 C 010 XF C D 1 GV CUP w Mine window wants and and India You are the following corporate $17,000,000 SL500,000 SA000,000 Varet 10 Warehong other Athe 3. L. Dermine the bed og omegn 15 1. 13 Vinable 10 C 19 fuper 2. Are incarga be COM CHA 4 MacBook Air esc 30 004 B c D E G 1 Cost-Volume-Profit Analysis 2 CVP exercises 3 Free workels Antwercely 4 Martin Inc. ow and operates seven stores in and around Indianapolls. You are given the following corporate budget data for next years 5 6 Revenues $13,000,000 7. Fred costs $3,500,000 8 Variable costs $8,000,000 9 10 Variable costs change based on the number of subsold 11 12 Answer cells must remain in the location se do not mert/delet eum or rows in the file Numericawwers must includes formule or refer 36 Budgeted operating income 37 18 4.A 5X Increase in fixed costs 39 40 Revenues 41 Variable costs 42 Contribution margin 43 Fixed costs 4 Budgeted operating income 45 46 5. A SX decrease in fixed costs 47 4 Revenues 49 Variable costs 50 Contribution margin 31. Fred costs 52 Budgeted operating income 54 6. A 5% increase in units sold 55 SE Reveres 57 Variable costs s nimi CHA 17.00 MacBook Air . esc GO 000 80 F2 F3 FA # 3 $ 4 % 5 2 6 Ch 03AE Home Insert Draw Page Layout Formulas Data Review View XLSTAT Tell me cor (Body 12 - A A General P A- Fare Center 9 E67 x x D E o H 1 A 1 CostVolumeProfit Analysis 2 CVP exercises Free work eh Answer Martin news and operates en stores in and around Indianapolis. You are given the following corporate budget data for next year Revers $12.000.000 Flued cost $3,500,000 8 Variable costs SR 000.000 9 10 Variable costs change based on the number of subs sold 11 12 Answers remain in the same location denied cons of rows in the file Namere war must include formar sa Contribution margin 59 ad costs 60 Budgeted operating income 61 62 7. ASN decrease in units sold 5 Revenues 65. Variable costs 66 Contribution margin 67 Fixed costs Budgeted operating income 59 70 8. A 10% Increase in fixed costs and a 10% Increase in units sold 71 72 Reve 7 Variable costs 4 Contribution margin 25 Fleed costs 75 Budgeted operating income 79. A 5% increase in fixed costs and a 5% decrease in variable costs 80 Revenues CHIA 12.004 MacBoo esc BO 000 inn Calibri (Body) 12 Wrap Text ' ' a-A- BTV e Marge Center E67 Xfx A B c D F G 1 Cost-Volume-Profit Analysis 2 CVP exercises Free workcell Answer cells 4 Martinicows and operates seven stores in and around Indianapolis. You are given the following corporate budget data for next year 5 6 Revenues $12,000,000 7 Fixed costs $3,500,000 8 Variable costs SR.000.000 9 10 Variable costs change based on the number of subs sold 11 12 Answer alls must remain in the same location sa do cotinsert/delete columns of rows in the file Numericanswers must include a form 75 Fixed costs 76 Budgeted operating income 72 78 9. A 5% increase in fixed costs and a 5% decrease in variable costs 79 10 Revenues 81 Variable costs 12 Contribution margin 83 Fixed costs 84 Budgeted operating income * 16 10. Which of these alternatives yields the highest budgeted operating income? 87 Alternative with highest budgeted B operating Income 19 90 91 92 93 94 95 CHA + 2006 Maci 000 esc