Can you please solve problem 24. Part A? THANK YOU!! sales are credit sales) Acm
ID: 2416845 • Letter: C
Question
Can you please solve problem 24. Part A? THANK YOU!!
sales are credit sales) Acm unts receivable turnover = 30 times ( Accountsy turnover63525 times receivable turne 9425 times 9.625 times erage inventory turnover = 6.3525 Property and equipment turnover 1 Food inventory turnover 1 times I1. Depreciation eense - 1o percent of book vatue at yeure 12 Long-term 9 Bev t of book value at year-end 9 times accounts payable -term debt 13 Interest rate- 10 percent 14. Tax rate=20 percent s500 15 16. Average food and beverage check 17. Size of motel Average room rate = sa.00 25 rooms Occupancy percentage = 80 percent Undistributed Operating Expenses Beverage cost percentage = 22 percent 18. Number of food and beverage checks = 30800 ses = 335 percent of total revenue 19. 38 40 percent 21. Food cost percentage 22 labor and other cost percentage = 30 percent 23. Food and beverage 24. Rooms labor and other cost percentage = 40 percent of total food and beverage sales 25. Food sales = 62 ½ percent 26, 27, to 1 Debt-equity ratio Return on owners' equity = 1.330667 percent g of the year is the same as at the end ct Assume that the balance sheet at the beginning of the year is Fear Note: For this problem, food and beverage is a single combined de department Problem 24 Part A: The Hudson Hotel, a 100-room limited-service operation, has following data for the months of September and October: tion, has provided you wih th September October Single rooms sold Double rooms sold Room revenue Number of paid guests 1,000 1,600 950 1,610 $221,000 $222,720 Required 1. Compute the paid occupancy for September. 2. What was the monthly ADR for October? 4,520 4,653 2 What was the monthly ADR for October?Explanation / Answer
The Hudson Hotel Details Sep Oct Total Rooms availble @100 rooms per day 3,000.00 3,100.00 Total rooms sold 2,600.00 2,560.00 1 Paid Occupancy -Sep=2600/3000= 86.67% 2 Total revenue Oct = 222,720.00 Total rooms sold 2,560.00 Average daily rate=222720/2560= $ 87.00 3 Total revenue Sep = 221,000.00 Total Rooms availble @100 rooms per day 3,000.00 Monthly RevPar Sep=221000/3000= $ 73.67 4 double rooms sold -Oct 1,610.00 No of single room sold -Oct 950.00 Total guests in single room -Oct 950.00 Total no of guests in Oct 4,653.00 Total guests in Double rooms-Oct 3,703.00 Avg no of guests per double room=3703/1610 2.30