Expert Answer:MBA 6100 Case Study 1 Al Dente’s Italian Restauran

  

Solved by verified expert:This is a case study question with 5 parts.See attached document
case_study_1_al_dente_mba_6100.pdf

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
Expert Answer:MBA 6100 Case Study 1 Al Dente’s Italian Restauran
Just from $10/Page
Order Essay

MBA 6100 Case Study 1 Spring 2019
As a recently hired MBA intern, you are working in a consulting capacity to
provide an analysis for Al Dente’s Italian Restaurant.
A financial income Statement is presented below:
Sales
Cost of sales (all variable)
Gross Margin
Operating expenses:
Variable
Fixed
Total operating expenses:
Administative expenses (all fixed)
Net operating income
$2,698,000
$1,557,563
$1,140,438
$277,975
$213,675
This income statement presents the sales, expenses and pre-tax operating income
for a local eating facility. At Al Dente, the average meal cost for lunches and dinners
are $20 and $40 respectively. Al Dente serves both lunch and dinner 300 days per
year and serves twice as many lunches as dinners.
As the MBA intern you are to prepare a managerial accounting focused report
to the owners of Al Dente’s Italian Restaurant, to include the following:
1. Prepare a contribution margin income statement using the given financial data.
Use the following format:
Sales
Variable costs
Cost of sales
Operating
Total variable costs
Contribution margin
Fixed costs
Operating
Administrative
Total fixed costs
Net operating income
2. Compute the break-even volume of the number of lunches and dinners. Assume
that the CM% for each meal category is the same as the average CM% as calculated
in #1. Hint: To solve a break even sales mix, use the horizontal formula:
$491,650
$564,375
$84,413
Net operating income = ($Sales – $Variable costs) – $fixed costs
Net operating income = $CM – $fixed costs
At Breakeven, NOI = $0
Therefore, $CM = $ Fixed costs
Now solve for the unit $CM for each item. Let X be the number of dinners, 2X the
number of lunches. $CM is the combined total of the $CM for dinners, and the $CM
for lunches.
3. Using the CM income statement format, verify that your calculated break-even volume for
lunches and dinners results in a NOI of zero (hint: in your prepared CM statement from #1,
breakout the Sales dollars
into subcategories lunch and dinner as shown below, using the values of X for in the # of
meals cells).
Present the entire CM statement at the BE level.
4. The owner of the restaurant is thinking of increasing sales through additional advertising,
which she will incur as an administrative expense. The proposed additional advertising
campaign will cost $25,000. She anticipates that the additional advertising expense will result
in an additional 6 lunches and 3 dinners on average, per day. Illustrate the impact on NOI
assuming the changes above (hint: show a revised CM statement). Hint: for this type of ‘whatif’, compare the additional contribution margin impact on NOI given the change in units and
change in fixed costs.
5. In order to increase NOI, the owner of the restaurant is considering adjustments to the
quality of food ingredients currently used. Rather than using premium ingredients, use of
average quality ingredients would reduce the cost of food by 15%. The owner proposes to not
change the current meal pricing. As the consultant, prepare a memo to the owner that
presents the pros and cons of this change in operations. What are the potential impacts on
revenue, costs, and net operating income may result from this change? The owner does not
want to see a decrease in net operating income. Could the owner make this change and
absorb a decrease in customers, and how would you demonstrate numerically to support your
analysis? What other factors or consequences of this decision should the owner consider
besides the financial impact of the change?
Hint: this qualitative analysis is to be thorough. Expect to present 400 words or so, and
support your analysis using calculated or given accounting data.

Our essay writing service fulfills every request with the highest level of urgency.
attachment

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code ESSAYSHELP