5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 26 27 29 30 Case 2. Elena Visten is the manager of the Hoffbrau House, a German-themed restaurant that features steaks and roasted Bavarian-style pork dishes. Elena wants to compare this year's operating results to last year's results. Complete the two-year comparison she has begun, and then answer the questions that follow. (7 points) 31 Hoffbrau House Sales Food Beverage Total sales Cost of Sales Food Beverages Total cost of sales Labor Management 28 Direct operating expenses Music & entertainment Marketing Utilities Staff Employee benefits Total labor Prime Cost Other Controllable Expenses This Year ($) 3,499,939 773,228 1,151,165 144,849 299,913 771,206 167,720 198,215 11,436 95,295 133,413 Last Year ($) 3,025,618 622,649 997,622 132,370 269,262 628,277 138,828 171,114 3,228 61,342 103,314 $ Difference % 32 33 34 35 36 37 Occupancy costs Equipment leases 39 Depreciation & amortization 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 56 57 Administrative & general expenses Repairs & maintenance Total other controllable expenses Controllable Income Non-controllable expenses 58 Total non-controllable expenses Restaurant Operating Income Interest expense Income Before Income Taxes Income taxes Net Income 106,731 53,366 180,000 0 83,861 127,334 313,850 93,628 48,429 168,000 0 58,114 c. What was the operation's EBITDA this year? (1 point) (Type your answer here) 121,450 261,315 a. One of Elena's goals was to increase sales by 15 percent. Did Elena meet that goal? (1 point) (Type your answer here) b. Another of Elena's goals was to increase her operation's net income by 8.5 percent. Did Elena meet that goal? (1 point) (Type your answer here) 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 26 27 29 30 Case 2. Elena Visten is the manager of the Hoffbrau House, a German-themed restaurant that features steaks and roasted Bavarian-style pork dishes. Elena wants to compare this year's operating results to last year's results. Complete the two-year comparison she has begun, and then answer the questions that follow. (7 points) 31 Hoffbrau House Sales Food Beverage Total sales Cost of Sales Food Beverages Total cost of sales Labor Management 28 Direct operating expenses Music & entertainment Marketing Utilities Staff Employee benefits Total labor Prime Cost Other Controllable Expenses This Year ($) 3,499,939 773,228 1,151,165 144,849 299,913 771,206 167,720 198,215 11,436 95,295 133,413 Last Year ($) 3,025,618 622,649 997,622 132,370 269,262 628,277 138,828 171,114 3,228 61,342 103,314 $ Difference % 32 33 34 35 36 37 Occupancy costs Equipment leases 39 Depreciation & amortization 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 56 57 Administrative & general expenses Repairs & maintenance Total other controllable expenses Controllable Income Non-controllable expenses 58 Total non-controllable expenses Restaurant Operating Income Interest expense Income Before Income Taxes Income taxes Net Income 106,731 53,366 180,000 0 83,861 127,334 313,850 93,628 48,429 168,000 0 58,114 c. What was the operation's EBITDA this year? (1 point) (Type your answer here) 121,450 261,315 a. One of Elena's goals was to increase sales by 15 percent. Did Elena meet that goal? (1 point) (Type your answer here) b. Another of Elena's goals was to increase her operation's net income by 8.5 percent. Did Elena meet that goal? (1 point) (Type your answer here)
Expert Answer:
Answer rating: 100% (QA)
Difference This Year Last Year Sales Food 3499939 3025618 474321 1568 Beverage 773228 622649 150579 2418 Total Sales 4273167 3648267 624900 1713 Cost ... View the full answer
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Posted Date:
Students also viewed these finance questions
-
(10 points) Given that ry + xy = 1. 1. Find a solution of the differential equation that satisfies the initial condition y(1) = 10. Answer: y = 2. Find a solution of the differential equation that...
-
Dana, runs an illegal gambling joint and here are her expenses and income. Gross income $300,000 Expenses: Rent $30,000 Maintenance $6000 Bribes to police $20,000 Supplies. $4,000 Food and drink...
-
an 5 of 5 | Review Mode: Question 13 of 20 A survey asked 1,150 pe to choose their favorite laundry detergent from brands D, E, and F. Of the people surveyed, percent chose D as their favorite brand....
-
How do money market funds differ from other types of mutual funds in terms of how they use the money invested by shareholders? Which security do money market funds invest in most often? How can a...
-
Refer to Exercise 7.39 and the Analytical Chemistry (Dec. 15, 2009) study in which scientists used high-performance liquid chromatography to determine the amount of drug in a tablet. Recall that 25...
-
Follow the steps below to prove the LLN without using CLT. (a) Let \(X\) be a random variable with mean \(\mu\) and variance \(\sigma^{2}\). Then for any real number \(\alpha>0,...
-
Trattner Company had a beginning inventory on January 1 of 100 units of Product SXL at a cost of $20 per unit. During the year, purchases were: Mar. 15 300 units at $23 Sept. 4 ... 290 units at $28...
-
Short-Term (Operating) financial planning begins with the forecast. Based on this forecast, operating expenses can be estimated and then pro forma income statement and cash budget can be prepared....
-
5. In a study of the performance of a computer printer, the size (in kilobytes) and the printing time (in seconds) for each of 22 small text files were recorded. A regression line was a satisfactory...
-
A South African bank experiences a financial deficit and enters into a classic fixed 91 day repurchase agreement with the SARB at a repo rate of 3.50%FOUR of the following bonds serve as the...
-
Sonia is a non-commissioned employee working for LSW, an engineering company in Quebec. Under the terms of her contract, she is required to use her own automobile to travel to various clients across...
-
A firm has commenced production of a new product with a planned selling price of 252,000 KHR. Production was at the planned level of 100,000 units although 20,000 of these remained unsold at the...
-
A string is wrapped several times around the rim of a small hoop with a radius of 0.0800 m and a mass of 0.150 kg. The free end of the string is held in place and the hoop is released from rest...
-
A survey of 100 businesses revealed that the mean after-tax profit was $80,000 and the standard deviation was $15,000. Determine the 90% confidence interval estimate of the mean after-tax profit. a....
-
At the beginning of the current season on December 1, the ledger of Rainbow Store showed Cash $31,850, Inventory $52,550, and Share CapitalOrdinary $84,400. At the end of fiscal year December 31,...
-
Find a least expensive route, in monthly lease charges, between the pairs of computer centers in Exercise 11 using the lease charges given in Figure 2. a) Boston and Los Angeles b) New York and San...
-
Use Solver to determine the minimum number of coins needed to make change for 92 cents.
-
In the file named Problem39data.xlsx, you are given data on clients audited by QXZ Inc. You are told if a given firm is large or small and if they passed or failed their June audit. If the firm is...
-
The file named Lineupdata.xlsx gives the number of minutes played by various five-player combinations (lineups). Lineup 1 played 10.4 minutes, and so on. Use text functions to put this data into a...
-
Scientists propose that the first macromolecules in protobionts were a. DNA molecules. b. RNA molecules. c. proteins. d. all of the above.
-
Which of the following function(s) is/are carried out by piRITS or piRISC? a. Inhibits transcription of TEs b. Causes the degradation of TE RNA c. Causes chromosome breakage d. Both a and b are...
-
In the CRISPR-Cas system, what does tracrRNA bind to? a. crRNA and Cas1 protein b. crRNA and Cas2 protein c. crRNA and Cas9 protein d. Cas1 and Cas2 proteins
Study smarter with the SolutionInn App