plz add excel formulas

VARI + Collaborate CHBA Sheen C 0 E F H 1 J K 1 Cost-Volume-Profit Analysis CVP exercises 2 Free work cells Answer cells 3 Martin Inc, owns and operates seven stores in and around Indianapolis. You are given the following corporate budget data for next year: Revenues $12,500,000 Fixed costs $3,750,000 Variable costs $8,250,000 9 10 Variable costs change based on the number of subs sold. 11 1 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 1. Determine the budgeted operating income based on the original budget data, 1 Revenues S 12,500,000 1 Variable costs $8.250.000 Contribution margin Fixed costs 30 Budgeted operating income 21 11 2. A 10% increase in contribution margin, holding revenues constant 24 Revenues 21 Variable costs 20 Contribution margin 21 Fixed costs 11 Budgeted operating income 20 30 3. A 10% decrease in contribution margin, holding revenues constant 11 12 Revenues 11 Variable costs 34 Contribution margin Fixed costs + 3 Sheet1 E F G C D Budgeted operating income 37 38 4.A 5% increase in fixed costs 39 40 Revenues 41 Variable costs 42 Contribution margin 43 Fixed costs 44 Budgeted operating income 45 46 5. A 5% decrease in fixed costs 47 48 Revenues 49 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 39 Fixed costs 60 Budgeted operating income 61 62 7. A 5% decrease in units sold 63 64 Revenues 65 Variable costs 66 Contribution margin 67 Fixed costs 68 Budgeted operating income 59 70 8. A 10% increase in fixed costs and a 10% increase in units sold 71 72 Revenues T Text Sh + B E 125% Insert Table Chart View Zoom 3 Sheet1 D A Revenues 66 Variable costs 66 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 73 Variable costs 74 Contribution margin 76 Fixed costs 76 Budgeted operating income 77 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 85