90.2K

Verified Solution

Link Copied!

could u add excel formulas

Corte clau Sheen . 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: Revenues $12,500,000 Fured costs $3,750,000 Variable costs 58,250,000 Variable costs change based on the number of subs sold. Awes estran the same location so do not insert/delete columns of rows in the file. Numeric answers must include a formular 1. Determine the budgeted operating income based on the original budget data, 517.500,000 51.250.000 Revenue Variable costs Contributionary Fixed costs Budgeted operating income 2. A 10% Increase in contribution margin, holding revenues constant Revenues Variable costs Cottomar dos Buted operating come 3. A 10% decrease in contribution margin holding revenues constant Revenues Varatec Contribution we costs 3 Sheet D E Budgeted operating income 37 38 4.A 5% increase in fixed costs 39 40 Revenues 41 Variable costs 42 Contribution margin 43 Fixed costs 14 Budgeted operating income 45 46 5.A 5% decrease in fixed costs 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 5 Contribution margin 59 Fixed costs 00 Budgeted operating income 62 7. A5% decrease in units sold 6 04 Revenues 65 Variable costs Contribution margin Fixed costs Budgeted operating income 01 70 8. A 10% increase in fixed costs and a 10% increase in units sold 72 Revenues 125% T Text Insert Table Chart Zoom View + CH3A Sheet A Revenues 65 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 12 Revenues 73 Variable costs 74 Contribution margin 75 Fixed costs 78 Budgeted operating income 77 78 9. A 5% increase in fixed costs and a 5% decrease in variable costs 79 30 Revenues 31 Variable costs B2 Contribution margin 33 Fixed costs 84 Budgeted operating income 85

Answer & Explanation Solved by verified expert

See Answer