This is Hospitality Managerial Accounting management. I am having a test review so I need the answer to study and the real test is on Monday but chapter 7 temple due tomorrow Saturday and also assignment 7 I need the solution on temple 7 but I need how to get the answer and the solution on the test review

\fHOS 372 Test #1 6. Summer 2015 Page 2 Prepare a common-size (vertical) analysis for Dulce's Sweet Shoppe for two years Be sure to fill-in all of the missing amounts: 11 points 2013 Revenue Cost of Food Gross Profit Labor Costs Rent, Operating Other Expense Total Expense 20L4 o/o $1,518 $ o/o 1,836 466 561 385 454 289 332 201 L75 Operating Profit 7. Using the various percentages computed above, comment on the results. Be specific as to what may have contributed to the changes in the financial situation of the restaurant. 4 points 8. Katie's Capstone Coffee Shop reported the following data for 2011 and 2Ot2. Perform a horizontal analysis. 10 points 2013 Revenue Cost of Sales Gross Profit Store Expense Other Expense Total Expense $ 2(JL4 10,383 A Ao/o $7t,775 4,645 5,325 3,745 4,425 L-692 1JB5 Operating Profit 9. Comment on these results: Consider the changes in all costs and expenses compared to the change in revenues. Why did profit change? 4 points 10. Victoria is considering the use of Debt to supply a portion of the capital in her new business, Mullaly MICE Marketing. This would add Leverage to the capital structure. a. Explain the possible advantage of leverage: 4 points 11. 6 points b. Discuss the potential risk associated with leverage: Sylvie's Sawbones Steakhouse has the following data. Total Assets are $10,000,000 and Total Liabilities are $8,000,000. Show your calculations for the following: a. b. c. Owner's Equity: Liabilities to Equity ratio: Is this operation highly leveraged? Explain your reasoning. Summer 2015 HOS 372 Page 3 Test #1 (30 days), had Longtao,s sing for Your Supper Diner, open every day in the month of June salei of g415,0b0 and cost of sales were $258,000 for that month. $ 38,000 May 31 inventorY: $ 48,000 June 30 inventorY your computations for the following: catculate and show L2. 70 points 13. a. b. c. Average InventorY - 2 Points Inventory Turnover Ratio - 4 points Inventory Holding Period in days - 4 points dining room with 6o seats The Standley Room Only Hotel has 2OO guest rooms and a small guests only. There is no bar area or lounge' open for dinner onty, *tri.tr caters to hotel of October' The hotel recorded the following information foithe 31 days in the month r Room division revenue was $925,000' r A total of 5,200 rooms were occupied' r A total of 9,,78o guests are using the 5,200 rooms occupied. r Dining room food revenue was $103,200' o Dining room alcohol revenue was $25,819' . The F&B manager reports that dining room served a total of 7 ,726 guests' . Cost of food sales was $26,409' . Cost of alcohol sales was $4,955' r Room division labor costs were $152,028' o Dining room labor costs were $16,011' calculate the following for the Hotel and show your computations' a) RevPAR average Per daY ComPutation: b) Room occuPancy Percentage ComPutation: c) 76 points Food cost Percentage d) Beverage cost Percentage ComPutation: ComPutation: e) Dining room labor cost Percentage ComPutation: 0 Average check, dining room ComPutation: oer dav s) Dining room averaEe seat turnover ComPutation: h) Average dailv revenue per dining room seat ComPutation: computed make sense! Please review your calculations to insure that the amounts Summer 2015 HOS 372 Page 4 Test #1 t4. The Vladimirova Hotel's computer has been crashed by a Russian hacker. The manager can only access partial data. You are asked to do a little forensic accounting. Cash is $7,OOO, A/R is $5rOOO, Inventory is $26,OOO, Payrol! is $4,OOO, Prepaid Expenses are $13rOOO and Equipment & Building is $5O,OOO. There might be some other fixed assets but the manager is not good with numbers and cannot remember what they are. Show calculations. a. Compute the Current Assets b. Current Assets were 20olo of Total Assets. What are the Tota! Assets? c. What is the Fixed Assets value? d. The current ratio is 1.5 to 1. What are the Current Liabilities? 12 points Compute the Quick Ratio g. 15. If you were a lender would you be satisfied with this Quick Ratio? The following is given for one day of operation at Mengjie's Wonderful Wuhan Restaurant: Units Sold Beef Pork Fish Chicken Total Standard Cost Menu Price 100 3.80 3.50 7.20 2.00 Total Cost a. b. Food Cost o/o 18.00 50 70 120 14.00 21.00 12,00 CM o/o: Total Contribution $: 78 points Total Sales Using the form provided, compute and fill in the standard food cost, sales and food cost percentages for each item that day and the Compute the totals, 72 points total actual food cost given the following: 4 points Beginning inventory: $38O Food purchases: $1,45O Food returns: $8O (purchases from supplier which were returned) Cooking liquor: $4O (transferred from the bar) Show computation. Ending inventory: $42O. Actual Cost: $ o/o of Sales: Compare the actual cost data to the standard cost data and list some possible causes for the difference. 2 points / Hospitality Managerial Accounting: HOS 372 Test #1 - 12 points - Summer Name: 1. 5 points 2O15 Section: The following are room revenues and corresponding average room rates for Omar's OmniHotel. Using 2OO7 as a base =100, compute the room rate index for the 6 years: Show Calculations! Year Average Room Rate Index $2,933,000 $140.00 100.0 2008 $3,127,OOO $145.00 2009 $3,346,000 $1s0.00 2010 $3,594,000 $1ss.00 2rJ11 $3,7t1,000 $160.00 20t2 3 points Avg. Room Rate 2007 2. Revenue $3,923,000 $ Compute the total percentage change in revenue in #1. Did the change in Average Room Rate explain all of the increase in Revenue? What else might have changed? Change in Revenue 2Ol2 vs 2OO7: 3. 6 points 165.00 _Vo Other factors (if any): The check average at the Lauren Detroit Diner increased from $18.5O in 2O11 to $21.75 in 2012. The average net operating income per guest has increased during the same period from $2.OO to $2.O5. Perform a horizontal analysis. 2()t2 2011 A$ Ao/o Check Average Cost per Guest Income per Guest 4. Comment on what you see from the analysis in 5. Convert historic revenue at 2 points 6 points #3. Is there a problem? lvan's Flower Inn to current level revenue using this Year Revenue CPI Index 20fJ7 $3,133,000 207.3 2008 $3,185,000 2t5.3 2009 $3,250,000 274.5 2010 $3,394,000 278.t 2011 $3,421,000 224.9 2()t2 $3,478,000 229.6 Converted Revenue CPI Index