5. Randy Moran is the GM of the Holiday Plaza Hotel, a 350-room full-service hotel located on the Interstate near the city center. Randy is preparing a short-range achievement budget for his property for the upcoming month. He is doing so at the request of the hotel owners, who wish to know Randy's best estimate of profits the hotel will generate next month. Based on previous months' operating results, Randy has summarized his estimates for next month as follows: Randy's Next Month Estimates Total revenue $800,000 Food and beverage sales as % of total revenue 25.0% Other Operated Departments as % of total revenue 3.096 Rental and Other Income as % of total revenue 2.0% Rooms department expense as % of sales 30.0% Food and beverage expense as % of sales 75.0% Other Operated Departments expense as % of sales 85.0% Rentals and Other Income expense as % of sales 0.0% Administrative and General expense 9.0% Sales and marketing costs 7.0% 5.0% Property Operation and Maintenance expense 4.0% Utility costs $8.000 Monthly rent 2.0% Property and Other taxes as % of total revenue 1.0% Insurance as % of total revenue Given the information he has compiled, help Randy develop the hotel's achievement budget for next month and then answer the questions that follow: Randy's Achievement Budget: Next Month Budget REVENUE Rooms Food and Beverage Other Operated Departments Rentals and Other Income Total Revenue $800,000 100.0 DEPARTMENTAL EXPENSES Rooms Food and Beverage Other Operated Departments Total Departmental Expenses TOTAL DEPARTMENTAL INCOME UNDISTRIBUTED OPERATING EXPENSES Administrative and General Sales and Marketing Property Operation and Maintenance Utilities Total Undistributed Expenses GROSS OPERATING PROFIT MANAGEMENT FEES 5.0% INCOME BEFORE FIXED CHARGES FIXED CHARGES Rent Property and Other Taxes Insurance Total Fixed Charges NET OPERATING INCOME LESS: REPLACEMENT RESERVES 2.09 ADJUSTED NET OPERATING INCOME a. What will be the amount of rooms department expense Randy should budget for next month? b. What will be the amount of food and beverage department expense Randy should budget for next month? c. What is the percentage amount of gross operating profit (GOP) Randy should anticipate for next month? d. What will be the income before fixed charges that Randy anticipates for next month? e. How much uncommitted cash could be available to the hotel's owners next month if Randy's achievement budget is accurate