Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer these in excel & show the excel formulas please. thank you WILL RATE Compute the budgeted operating income for each of the following

Please answer these in excel & show the excel formulas please. thank you WILL RATE

image text in transcribed

image text in transcribed

Compute the budgeted operating income for each of the following deviations from the origina budget data. (Consider each case independently.) a. Enter all amounts as positive values. Do NOT use parentheses or a minus sign for amoun to be subtracted. b. Refer to the budgeted operating income based on the original budget data in all calculations. (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 or if you type the numbers in, you will be marked wrong.) Alternatives: 1. Determine the budgeted operating income based on the original budget data. 2. A 10% increase in contribution margin, holding revenues constant. 3. A 10% decrease in contribution margin, holding revenues constant. 4. A 5% increase in fixed costs. 5. A 5% decrease in fixed costs. 6. A 5% increase in units sold. 7. A 5% decrease in units sold. 8. A 10% increase in fixed costs and a 10% increase in units sold. 9. A 5% increase in fixed costs and a 5% decrease in variable costs. The Deli-Sub Shop owns and operates six stores in and around Minneapolis. You are given the following corporate budget data for next year: Variable costs change based on the number of subs sold. 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. Ilf you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Paul E. Dascher, Jerry R. Strawser, Robert H. Strawser, Ronald M. Copeland

8th Edition

0873937643, 978-0873937641

More Books

Students also viewed these Accounting questions

Question

differentiate the function ( x + 1 ) / ( x ^ 3 + x - 6 )

Answered: 1 week ago

Question

1.5 Summarize HRM issues for small businesses.

Answered: 1 week ago