There are 15 questions in the Excel that I upload.

Final Exam HOS 372 B Managerial Accounting Winter 2016 Name:___________________ Question 1. A motel has the following annual sales revenue and average room rate for the past five years. During this five-year period there were no changes in the type or number of rooms available and clientele/mix remained essentially the same. Year 1 2 3 4 5 Revenue $2,802,858 $2,858,734 $2,961,104 $3,041,400 $3,106,182 ADR $85.00 $88.30 $90.25 $92.50 $95.00 Index Current $ a. Prepare room rate trend numbers from the average room rates using 100% as the base trend index number for Year 1. b. Use room rate index numbers to conver the revenue to current dollars. c. Comment on the trend in current value dollars: 2. The Outback Steakhouse, which increased its number of locations by 11% over the three year period, reports the following: Note: Numbers are ANNUAL! 2014 2015 2013 $1,759,285 $1,950,275 $1,809,017 Sales $624,088 $596,976 Cost of Sale $527,786 Food Invento $23,036 $29,718 $33,165 a. Show your calculations for the inventory turnover: 1. 2014 2011: 2. 2015 2012: b. Show your calculations for the inventory carrying period in days: 1. 2014: 2. 2015: c. Evaluate the results. Is the inventory control process operating well? What external economic events might account for any change that you observe? 3. You have the following information taken from the balance sheets for two successive years for a hotel operation: Total Assets Total Liabilities Total Stockholder's Equity For each year, calculate: Year 2014 Year 2015 $442,200 $406,700 $328,450 $282,950 $113,750 $123,750 A. Total Assets to Total Liabilities Ratio 2014 2015 B. Total Liabilities to Total Assets Ratio 2014 2015 C. Total Liabilities to Total Equity Ratio 2014 2015 Discuss changes that have taken place over the two year period from the viewpoint of an investor who has been asked to loan the hotel money for expansion. 4. Assuming total Standard cost is $15,431 and total standard sales revenue is $53,211, determine the standard cost percentage: Assuming the total actual cost is $16,250 and total actual sales revenue is $52,985, determine the actual cost percentage: What are the variances in: Revenue $'s: Food Cost %: 5. 185 Room Hotel Assume Annual: Occupancy Revenue: Fixed Cost: Fixed Portion Rooms: Fixed Portion Admin/OH Fixed Portion Fixed Costs Profit Variable Cost? $ B/E Volume $'s: B/E Rooms Sold-Room Nights 7. $ CM per Room Sold 6. % 0f Current Volume 18% 28% 15% 25% $ 75% ADR $195 $ % Determine the operating income necessary to yield a net after-tax income of $85,000 using a current tax rate of 14% $ Calcuate the annual revenue for each of the following: 350 room Property, RevPAR $167.50, Occupancy 70% 85 seats, 1.7 turns, $26.50 Average Check. 8. Assume a retaurant owner is showing a positive income for 9 month of the year, but loses money in the last quarter. Should she stay open during the last 3 months of the year? Sales Revenue Variable Costs Fixed Costs Total Costs Operating Income 9 Months $378,000 $283,500 $45,000 $328,500 $49,500 Last 3 Months $18,000 $16,500 $11,000 $27,500 -$9,500 Total $396,000 $300,000 $56,000 $356,000 $40,000 Show the total Annual operating income if she closes for the last three months Discuss why she should close or stay open: 9. You are analyzing a company for investment purposes. From the financial statements and stock listing you find the following information: a. Common Stock at $2 par $36,000,000 b. Earnings $70,000,000 c. Market Price $28.75 Calculate the Shares Outstanding ______________EPS ____________ P/E Ratio ___________ 10. A restaurant's Annual sales are $1,585,000 and the average check is $22.57. There are 100 seats in the restaurant. What is the turnover? _______________ 11. Cost of Sales for beverages for the year is $275,600. The inventory is $38,000. How many inventory turns do you do per year?____________ How many days on hand ___________. 12. A cocktail lounge had sales revenue in May of $40,000. Budgeted revenue was $42,000. List three possible questions that could be asked, the answers to which might explain the $2,000 difference. ________________________________________________________________ _________________________________________________________________ _________________________________________________________________ 13. An 80-seat coffee shop is open for all three meals every day of the year. Calculate sales revenue for the coming year including daily turnover of seats and the average check for the entire operation. Turnover Average Check Customers Breakfast 1.1 $11.00 Lunch 1.9 $15.00 Dinner 0.9 $18.00 Total operation Fill in the blanks including daily Average Check (Average for all meals) 14. A motel has 40 units. During the month of June, its average room rate is expected to be $165, and its room occupancy 76%. In July, the owner is planning to raise room rates by 10% and occupancy is expected to be 81%. In August no further room rate increases are expected, but occupancy is expected to be 87%. For each of the three months of June, July and August calculate the budgeted rooms revenue. June July August 15. Find the Ticker Symbol for Boeing Aircraft: What is the current price? (opening Price Today!) What is the 52 week trading Range? What is the latest Dividend What is the Yield? What is the P/E ratio (TTM)? What does the P/E ratio express? What does it mean? What is the Debt/Equity Ratio for 2015? (You will have to calculate this) Is the company highly leveraged? (Over 2.5 would be considered highly leveraged?) What is the nature of the largest portion of the debt? How will this impact the ability to borrow more funds? Y/N _____ What backs up the level of accounts payable (Look at current assets) If you were a supplier to Boeing Aircraft would you be worried? _______________________________________________________________ Revenue