how to do these questions by excel

H30 > c H M N a. 19 AB D E G 11 12 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the Instructions tab you will be 13 marked wrong. 14 15 Requirements Compute the budgeted operating income for each of the following deviations from the original budget 16 data. (Consider each case independently.) Enter all amounts as positive values. Do NOT Use parentheses or a minus 17 sign for amounts to be subtracted, b. Refer to the budgeted operating income based on the original budget data 18 in all calculations 1 Determine the budgeted operating income based on the original budget data. 2 A 10% increase in contribution margin, holding revenues constant 21 3 A 10% decrease in contribution margin, holding revenues constant 22 4 A 5% increase in fixed costs 23 5 A5% decrease in fixed costs 6 A 5% increase in units sold 25 7 A 5% decrease in units sold 26 8 A 10% increase in fixed costs and a 10% increase in units sold 9 A5% increase in fixed costs and a 5% decrease in variable costs 28 10 Which of these alternatives yields the highest budgeted operating income? 29 30 Saving & Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded. a. Navigate back to the activity window - screen where you downloaded the initial spreadsheet INSTRUCTIONS ENTERANSWER 20 24 27 31 32 33 34 Help M B4 PDF Pro 10 Y2 XLSTAT Y3 Search Y1 o zs G M D 1 1. Determine the budgeted operating income based on the original budget data. (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the 2 Instructions tab you will be marked wrong.) N 3 4 Revenues 5 Variable costs 6 Contribution margin 7 Fixed costs 8 Budgeted operating income 9 10 2. A 10% Increase in contribution margin, holding revenues constant (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the 11 Instructions tab you will be marked wrong) 12 13 Revenues 14 Variable costs 15 Contribution margin 16 Fixed costs 17 Budgeted operating income 18 19 3. A 10% decrease in contribution margin, holding revenues constant (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the 20 Instructions tab you will be marked wrong) 21 22 Revenues INSTRUCTIONS ENTERANSWER e 32 PM 5/16/2020 2 PII (1) Prisen 18 Home Eerd Pop F4 B6 6 Share o com F G M N E 19 3. A 10% decrease in contribution margin, holding revenues constant (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the 20 Instructions tab you will be marked wrong) 21 22 Revenues 23 Variable costs 24 Contribution margin 25 Fixed costs 26 Budgeted operating income 27 28 4.A 5% increase in fixed costs (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the 29 Instruction tabs you will be marked wrong 30 31 Revenues 32 Variable costs 33 Contribution margin 34 Fixed costs as Budgeted operating income 30 37 5. A 5% decrease in fixed costs (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the 38 Instructions tab you will be marked wrong.) 39 10 Revenues INSTRUCTIONS ENTERANSWER E G H B D F 37 5. A 5% decrease in fixed costs (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the 38 Instructions tab you will be marked wrong.) 39 40 Revenues 41 Variable costs 42 Contribution margin 43 Fixed costs 44 Budgeted operating income 45 46 6. A 5% increase in units sold (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the 47 Instructions tab you will be marked wrong.) 48 49 Revenues 50 Variable costs 51 Contribution margin 52 Fixed costs 53 Budgeted operating income 54 55 7. A 5% decrease in units sold (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the 56 Instructions tab you will be marked wrong.) 57 58 Revenues INSTRUCTIONS ENTERANSWER B6 B G H A D E F 55 7. A 5% decrease in units sold (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the 56 Instructions tab you will be marked wrong.) 57 58 Revenues 59 Variable costs 60 Contribution margin 61 Fixed costs 62 Budgeted operating income 63 64 8. A 10% increase in fixed costs and a 10% increase in units sold (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the 65 Instructions tab you will be marked wrong.) 66 67 Revenues 68 Variable costs 69 Contribution margin 70 Fixed costs 71 Budgeted operating income 72 73 9. A 5% increase in fixed costs and a 5% decrease in variable costs (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the 74 Instructions tab you will be marked wrong.) 75 76 Revenues INSTRUCTIONS ENTERANSWER B G H A 68 Variable costs D E F 69 Contribution margin 70 Fixed costs 71 Budgeted operating income 72 73 9. A 5% increase in fixed costs and a 5% decrease in variable costs (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the 74 Instructions tab you will be marked wrong.) 75 76 Revenues 77 Variable costs 78 Contribution margin 79 Fixed costs 80 Budgeted operating income 81 82 10. Which of these alternatives yields the highest budgeted operating income? 83 Alternative with highest budgeted 84 operating income 85 86 87 88 89 90 91 92 H30 B E F H D G 1 Cost-Volume-Profit Analysis 2 CVP exercises 3 The Deli-Sub Shop owns and operates six stores in and around Minneapolis. You are given the fol 4 corporate budget data for next year: 5 6 8 Revenues $11,000,000 7 Fixed costs $3,000,000 Variable costs $7,500,000 9 10 Variable costs change based on the number of subs sold. 11 12 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. Cell references formulas should be based on the original data. If you copy/paste from the Instructions tab you w 13 marked wrong. 14 15 Requirements Compute the budgeted operating income for each of the following deviations from the original bud 16 data. (Consider each case independently.) Enter all amounts as positive values. Do NOT use parentheses or a minus a