excel question

Calibri (Body) 12 AA E Wrap Text Paste BIUV A v = E Merge & Centre v % G92 4 X V fx B C D E F G H Cost-Volume-Profit Analysis Free work cells CVP exercises Answer cells Martin Inc. owns and operates seven stores in and around Indianapolis. You are given the following corporate budget data for next year: 6 Revenues $12,000,000 7 Fixed costs $3,500,000 8 Variable costs $8,000,000 0 Variable costs change based on the number of subs sold. GE 12 Answer cells must remain in the same location so do not insert/ delete columns or rows in the file. Numeric answers must include a formula or reference so 70 8. A 10% increase in fixed costs and a 10% increase in units sold 72 Revenues Variable costs 74 Contribution margin + 75 Fixed costs 76 Budgeted operating income 77 8 9. A 5% increase in fixed costs and a 5% decrease in variable costs 79 80 Revenues 81 Variable costs 82 Contribution margin 83 Fixed costs 84 Budgeted operating income 86 10. Which of these alternatives yields the highest budgeted operating income? 87 Alternative with highest budgeted operating income 89 90 93 94 95 CH3A + Enter esc F1 F5 F6 a 3 4. b O WX Calibri (Body) 12 A ab Wrap Text General Paste BIUV A Merge & Centre v % 19 00 Condition Formatting G92 X V fx B C D E F G M Cost-Volume-Profit Analysis Free work cells CVP exercises Answer cells Martin Inc. owns and operates seven stores in and around Indianapolis. You are given the following corporate budget data for next year: Revenues $12,000,000 Fixed costs $3,500,000 Variable costs $8,000,000 Variable costs change based on the number of subs sold. 12 Answer cells must remain in the same location so do not insert/delete columns or rows in the file. Numeric answers must include a formula or reference so do not hard enter the answe 13 14 1. Determine the budgeted operating income based on the original budget data. 15 5 Revenues 7 Variable costs + 8 Contribution margin 19 Fixed costs 20 Budgeted operating income 21 22 2. A 10% increase in contribution margin, holding revenues constant 23 4 Revenues 5 Variable costs 26 Contribution margin 27 Fixed costs 28 Budgeted operating income 0 3. A 10% decrease in contribution margin, holding revenues constant 31 32 Revenues Variable costs 34 Contribution margin Fixed costs Budgeted operating income 38 4. A 5% increase in fixed costs 39 40 Revenues CH3A Enter MacBook Pro esc FI EA FS @ 2 ZL W E R T Y UHome Insert Draw Page Layout Formu Calibri (Body) 12 A A ag Wrap Text General Paste BIUV A Merge & Centre v % G92 X v fx B C D E F G H K Cost-Volume-Profit Analysis Free work cells Answer cells 2 CVP exercises 4 Martin Inc. owns and operates seven stores in and around Indianapolis. You are given the following corporate budget data for next year: Revenues $12,000,000 Fixed costs $3,500,000 Variable costs $8,000,000 Variable costs change based on the number of subs sold. 11 12 Answer cells must remain in the same location so do not insert/delete columns or rows in the file. Numeric answers must include a formula or reference so do 45 46 5. A 5% decrease in fixed costs 47 48 Revenues 19 Variable costs + 50 Contribution margin 51 Fixed costs 52 Budgeted operating income 53 54 6. A 5% increase in units sold 55 56 Revenues 57 Variable costs 58 Contribution margin 59 Fixed costs 0 Budgeted operating income 7. A 5% decrease in units sold 63 Revenues 65 Variable costs 6 Contribution margin 67 Fixed costs 68 Budgeted operating income 69 70 8. A 10% increase in fixed costs and a 10% increase in units sold 71 72 Revenues D CH3A + Enter esc FI 20 F3 F4 F5 F6 2 4