Please solve all the yellow boxes and include how you got those numbers

0 E G 1 Cost Volume-Profit Analysis 2 CVP exercises Free work cells 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 7 Fixed costs Variable costs $12,500,000 $3,750,000 $8,250,000 + 10 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 Numer answers must include a formula or reference so do not hard enter the answer 14 1. Determine the budgeted operating income based on the original budget data. 15 16 Revenues 17 Variable costs 18. Contribution margin Fored costs 20 Budgeted operating Income 21 22. 2. A 10% Increase in contribution margin, holding revenues constant 27 24 Revenues 25 Variable costs 26. Contribution margin 27 Fixed costs 3. Budgeted operating income 29 30 3. A 10% decrease in contribution margin, holding revenues constant 31 32 Revenues 33 Variable costs 34 Contribution margin 35 Fixed costs 36 Budgeted operating income Cost-Volume-Profit Analysis CVP exercises Free work cells 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 Fixed costs Variable costs $12,500,000 $3,750,000 $3,250,000 Variable costs chance based on the number of subs sold. 1 2. 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 ans $ 4.A 5% increase in fixed costs 0 Revenues 1 Variable costs 2 Contribution martin 3 Fixed costs 14 Budgeted operating Income 35 6 5. A S% decrease in fixed costs 27 0 Revenues Variable costs 50 Contribution margin 51 Fixed costs 52 Budgeted operating income 53 54 6. AS% Increase in units sold 55 56 Revenues 57 Variable costs 58 Contribution margin 59 Fixed costs GO Budgeted operating income E D G B Free work cells Answer cells 1 Cost-Volume-Profit Analysis 2 CVP exercises 3 11 4 Martin Inc. owns and operates seven stores in and around Indianapolis. You are given the following corporate budget data for next year: 5 6 Revenues $12,500,000 7 Fixed costs $3,750,000 8 Variable costs $8,250,000 9 20 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 fou 62 7. A 5% decrease in units sold 63 64 Revenues 65 Variable costs 66 Contribution margin 67 Fixed costs 68 Budgeted operating income 69 70 B. A 10% increase in fixed costs and a 10% Increase in units sold 71 72 Revenues 73 Variable costs 74 Contribution margin 75 Fixed costs 76 Budgeted operating income 72 78 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