first five picture are material for solution.

rest of are budget questions...

B D 1 2 Crown Hotel Operating Budget for Quarter ending on September 30, 2020 3 4. Aug Sep 5 6 7 Sales Rooms: Days Available Rooms available # Occupancy Rate (%) Parameters - Budget July 31 31 125 125 100% 95% 30 125 8 85% 9 10 Sales Restaurant: Days Available Seats Available Turnover Rate 31 31 30 70 70 70 1.20 1.20 0.85 11 12 13 14 15 16 17 Selling price ( $/hr): Average Daily Rate (ADR) $ - Rooms Average Check $ - Restaurant 118 118 118 18 18 18 18 15 15 15 Housekeeping: Hourly Wage rae (S/hr): 1 housekeeper /occupancy Hours per shift 20 20 20 8 8 8 19 20 21 22 23 24 25 26 27 20 20 20 Restaurant Servers: 1 Server per guests Hourly wage rate ($/hr) Hours per shift Cover page 15 15 15 8 Read this first Input 8 8 Static Budget Actuals Flexible budget Var Analysi Ready D E 16 B Average Daily Rate (ADR) $ - Rooms Average Check $ - Restaurant 118 118 118 - 17 18 18 18 18 19 20 Housekeeping: Hourly Wage rae (S/hr): 1 housekeeper /occupancy Hours per shift 15 15 15 20 20 20 8 8 8 20 20 20 Restaurant Servers: 1 Server per guests Hourly wage rate ($/hr) Hours per shift variable OH expenses -$/room 15 15 15 8 8 8 11 11 11 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 65000 Fixed overhead: Manager & supervisor salaries Receptionist & Front office staff * Marketing & Promotional expenses *Depreciation on fixed assets Property taxes and insurance expenses Office supplies 65000 9000 4000 9000 4500 65000 9000 4000 4000 8000 2500 5500 4000 8000 2500 8000 2500 *Increase in marketing expense in Sept because Hotel taking part in Hospitality Marketing Show *Depreciation increased in Sept due to purchase of additional asset 40 41 42 For Food purchase budget Cover page Read this first Input Static Budget Actuals Flexible bud LA B C D E F 30 Fixed overhead: 31 Manager & supervisor salaries 65000 65000 65000 32 Receptionist & Front office staff 9000 9000 9000 33 * Marketing & Promotional expenses 4000 4000 4500 34 *Depreciation on fixed assets 4000 4000 5500 35 Property taxes and insurance expenses 8000 8000 8000 36 Office supplies 2500 2500 2500 37 38 39 *Increase in marketing expense in Sept because Hotel taking part in Hospitality Marketing Show 40 * Depreciation increased in Sept due to purchase of additional asset 41 42 For Food purchase budget 43 1 Cost of sales amounts assumed to be 30% of sales from the restaurant budgetted sales 44 2 Beginning inventory is $3,500 and Forecasted food sales for October is $55,000 45 3 Hotel Crown's standard is 20% of next month's requirements as a desired ending inventory. 46 47 Cash Collection Budget 48 1 Accounts receivable, beginning balance on July is 15000 49 2 60% of Crown's Restaurant sales charged to customers' room to be paid when they check out 50 3 40% of restaurant sales paid immediately by credit card 51 4 60% of room revenue will be paid by credit card at the time of check out 52 5 40% of room revenue comes from corporate customers, hotel invoice them to pay later (credit sales) 53 of Credit sales, 25% will be collected in same month in which sales is made 54 of Credit sales, 50% will be collected one month after sales were made 55 of Credit sales, 25% will be collected 2 months after sales were made 56 Cover page Read this first Input Static Budget Actuals Flexible budget Ready K M N O Crown Hotel Actuals forQuarter ending on September 30, 2020 03 Total Sales Rooms: Days Available Rooms available # Occupancy Rate (%) Parameters - Actual July Aug 31 31 125 125 100% 95% Sep 30 125 80% 31 31 30 Sales Restaurant: Days Available Seats Available Turnover Rate 70 70 70 1.05 1.00 0.85 Selling price ( $/hr): Average Daily Rate (ADR) S - Rooms Average Check $ Restaurant 120 120 120 19 19 18 16 16 15 Housekeeping: Hourly wage rae ( $/hr): 1 housekeeper /occupancy Hours per shift 20 20 20 8 8 8 20 20 20 14 13 13 Restaurant Servers: 1 Server per guests Hourly wage rate ($/hr) Hours per shift variances Rubric 8 8 8 +- 10096 03:07 AM Average Check $ - Restaurant M N 19 19 18 Housekeeping: Hourly wage rae (S/hr): 1 housekeeper /occupancy Hours per shift 16 16 15 20 20 20 8 8 8 20 Restaurant Servers: 1 Server per guests Hourly wage rate (S/hr) Hours per shift variable OH expenses $/room 20 20 13 14 13 8 8 8 10 10 10 60000 60000 60000 11000 11000 Fixed overhead: Manager & supervisor salaries Receptionist & Front office staff *Marketing & Promotional expenses * Depreciation on fixed assets Property taxes and insurance expenses Office supplies 10000 6000 4000 4500 5000 5500 5000 8000 2000 8000 8000 2000 2000 *Increase in marketing expense in Sept expense increased as hotel decided from Silver to Platimum package in Marketing Show ariances Rubric A 1 B D Crown Hotel Operating Budget for Quarter ending on September 30, 2020 N 3 Quarters Aug July Sep Q3 Total 4 5 6 7 Sales budget 8 Number of rooms sold 9 Number of meals/guests served 10 Sales Rooms $ 11 Sales Restaurant $ 12 Total sales 13 14 # of required staff for rooms 15 # of required staff for restaurant 16 Total housekeeping cost 17 Total restaurant servers cost 18 variable OH expenses 19 Total variable costs 20 21 Fixed Overhead: Cover page Read this first Sale Input Static Budget Actuals Flexible budget Var Analysis - Static and Flex 1 B C D E Crown Hotel Operating Budget for Quarter ending on September 30, 2020 2 3 4 Quarters Aug July Sep Q3 Total 5 16 Total housekeeping cost 17 Total restaurant servers cost 18 variable OH expenses 19 Total variable costs 20 21 Fixed Overhead: 22 Manager & supervisor salaries 23 Receptionist & Front office staff 24 Marketing & Promotional expenses 25 Depreciation on fixed assets 26 Property taxes and insurance expenses 27 Office Supplies 28 Total Fixed Cost 29 30 Total 31 Cover page Read this first Input Static Budget Actuals Flexible budget Var Analysis - Static and Flex Sales Ready A 1 B C D E Crown Hotel Operating Budget for Quarter ending on September 30, 2020 Quarters Aug July Sep Q3 Total 2 3 4 5 6 7 Sales budget 8 Number of rooms sold 9 Number of meals/guests served 10 Sales Rooms $ 11 Sales Restaurant $ 12 Total sales 13 14 # of required staff for rooms 15 # of required staff for restaurant 16 Housekeeping Cost 17 Restaurant Servers 18 variable OH expenses 19 Total variable costs 20 21 Fixed Overbead: Cover page Read this first Input Static Budget Actuals Flexible budget Var Analysis - Static and Flex Sales 21 Fixed Overhead: 22 Manager & supervisor salaries 23 Receptionist & Front office staff 24 Marketing & Promotional expenses 25 Depreciation on fixed assets 26 Property taxes and insurance expenses 27 28 Total Fixed Cost 29 30 Total 31 Cover page Read this first Input Static Budget Actuals Flexible budget Var Analysis - Static and Flex Sales Ready A 1 2. B C Crown Hotel Operating Budget for Quarter ending on September 30, 2020 Quarters July Aug Sep Q3 Total 3 4 5 6 7 Sales budget 8 Number of rooms sold 9 Number of meals/guests served 10 Sales Rooms $ 11 Sales Restaurant $ 12 Total sales 13 14 # of required staff for rooms 15 # of required staff for restaurant 16 Housekeeping Cost 17 Restaurant Servers 18 variable OH expenses 19 Total variable costs 20 Sa 1 Fixed Overhead: ant I actuals Flexible budget Var Analysis - Static and Flex A 1 B C D E Crown Hotel Operating Budget for Quarter ending on September 30, 2020 2 3 4 5 16 Housekeeping Cost 17 Restaurant Servers 18 variable OH expenses 19 Total variable costs Quarters Aug July Sep Q3 Total 20 21 Fixed Overhead: 22 Manager & supervisor salaries 23 Receptionist & Front office staff 24 Marketing & Promotional expenses 25 Depreciation on fixed assets 26 Property taxes and insurance expenses 27 Office Supplies 28 Total Fixed Cost 29 30 Tota 31 Cover page Read this first Input Static Budget Actuals Flexible budget Var Analysis - Static and Flex Sal Ready B D 1 2 Crown Hotel Operating Budget for Quarter ending on September 30, 2020 3 4. Aug Sep 5 6 7 Sales Rooms: Days Available Rooms available # Occupancy Rate (%) Parameters - Budget July 31 31 125 125 100% 95% 30 125 8 85% 9 10 Sales Restaurant: Days Available Seats Available Turnover Rate 31 31 30 70 70 70 1.20 1.20 0.85 11 12 13 14 15 16 17 Selling price ( $/hr): Average Daily Rate (ADR) $ - Rooms Average Check $ - Restaurant 118 118 118 18 18 18 18 15 15 15 Housekeeping: Hourly Wage rae (S/hr): 1 housekeeper /occupancy Hours per shift 20 20 20 8 8 8 19 20 21 22 23 24 25 26 27 20 20 20 Restaurant Servers: 1 Server per guests Hourly wage rate ($/hr) Hours per shift Cover page 15 15 15 8 Read this first Input 8 8 Static Budget Actuals Flexible budget Var Analysi Ready D E 16 B Average Daily Rate (ADR) $ - Rooms Average Check $ - Restaurant 118 118 118 - 17 18 18 18 18 19 20 Housekeeping: Hourly Wage rae (S/hr): 1 housekeeper /occupancy Hours per shift 15 15 15 20 20 20 8 8 8 20 20 20 Restaurant Servers: 1 Server per guests Hourly wage rate ($/hr) Hours per shift variable OH expenses -$/room 15 15 15 8 8 8 11 11 11 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 65000 Fixed overhead: Manager & supervisor salaries Receptionist & Front office staff * Marketing & Promotional expenses *Depreciation on fixed assets Property taxes and insurance expenses Office supplies 65000 9000 4000 9000 4500 65000 9000 4000 4000 8000 2500 5500 4000 8000 2500 8000 2500 *Increase in marketing expense in Sept because Hotel taking part in Hospitality Marketing Show *Depreciation increased in Sept due to purchase of additional asset 40 41 42 For Food purchase budget Cover page Read this first Input Static Budget Actuals Flexible bud LA B C D E F 30 Fixed overhead: 31 Manager & supervisor salaries 65000 65000 65000 32 Receptionist & Front office staff 9000 9000 9000 33 * Marketing & Promotional expenses 4000 4000 4500 34 *Depreciation on fixed assets 4000 4000 5500 35 Property taxes and insurance expenses 8000 8000 8000 36 Office supplies 2500 2500 2500 37 38 39 *Increase in marketing expense in Sept because Hotel taking part in Hospitality Marketing Show 40 * Depreciation increased in Sept due to purchase of additional asset 41 42 For Food purchase budget 43 1 Cost of sales amounts assumed to be 30% of sales from the restaurant budgetted sales 44 2 Beginning inventory is $3,500 and Forecasted food sales for October is $55,000 45 3 Hotel Crown's standard is 20% of next month's requirements as a desired ending inventory. 46 47 Cash Collection Budget 48 1 Accounts receivable, beginning balance on July is 15000 49 2 60% of Crown's Restaurant sales charged to customers' room to be paid when they check out 50 3 40% of restaurant sales paid immediately by credit card 51 4 60% of room revenue will be paid by credit card at the time of check out 52 5 40% of room revenue comes from corporate customers, hotel invoice them to pay later (credit sales) 53 of Credit sales, 25% will be collected in same month in which sales is made 54 of Credit sales, 50% will be collected one month after sales were made 55 of Credit sales, 25% will be collected 2 months after sales were made 56 Cover page Read this first Input Static Budget Actuals Flexible budget Ready K M N O Crown Hotel Actuals forQuarter ending on September 30, 2020 03 Total Sales Rooms: Days Available Rooms available # Occupancy Rate (%) Parameters - Actual July Aug 31 31 125 125 100% 95% Sep 30 125 80% 31 31 30 Sales Restaurant: Days Available Seats Available Turnover Rate 70 70 70 1.05 1.00 0.85 Selling price ( $/hr): Average Daily Rate (ADR) S - Rooms Average Check $ Restaurant 120 120 120 19 19 18 16 16 15 Housekeeping: Hourly wage rae ( $/hr): 1 housekeeper /occupancy Hours per shift 20 20 20 8 8 8 20 20 20 14 13 13 Restaurant Servers: 1 Server per guests Hourly wage rate ($/hr) Hours per shift variances Rubric 8 8 8 +- 10096 03:07 AM Average Check $ - Restaurant M N 19 19 18 Housekeeping: Hourly wage rae (S/hr): 1 housekeeper /occupancy Hours per shift 16 16 15 20 20 20 8 8 8 20 Restaurant Servers: 1 Server per guests Hourly wage rate (S/hr) Hours per shift variable OH expenses $/room 20 20 13 14 13 8 8 8 10 10 10 60000 60000 60000 11000 11000 Fixed overhead: Manager & supervisor salaries Receptionist & Front office staff *Marketing & Promotional expenses * Depreciation on fixed assets Property taxes and insurance expenses Office supplies 10000 6000 4000 4500 5000 5500 5000 8000 2000 8000 8000 2000 2000 *Increase in marketing expense in Sept expense increased as hotel decided from Silver to Platimum package in Marketing Show ariances Rubric A 1 B D Crown Hotel Operating Budget for Quarter ending on September 30, 2020 N 3 Quarters Aug July Sep Q3 Total 4 5 6 7 Sales budget 8 Number of rooms sold 9 Number of meals/guests served 10 Sales Rooms $ 11 Sales Restaurant $ 12 Total sales 13 14 # of required staff for rooms 15 # of required staff for restaurant 16 Total housekeeping cost 17 Total restaurant servers cost 18 variable OH expenses 19 Total variable costs 20 21 Fixed Overhead: Cover page Read this first Sale Input Static Budget Actuals Flexible budget Var Analysis - Static and Flex 1 B C D E Crown Hotel Operating Budget for Quarter ending on September 30, 2020 2 3 4 Quarters Aug July Sep Q3 Total 5 16 Total housekeeping cost 17 Total restaurant servers cost 18 variable OH expenses 19 Total variable costs 20 21 Fixed Overhead: 22 Manager & supervisor salaries 23 Receptionist & Front office staff 24 Marketing & Promotional expenses 25 Depreciation on fixed assets 26 Property taxes and insurance expenses 27 Office Supplies 28 Total Fixed Cost 29 30 Total 31 Cover page Read this first Input Static Budget Actuals Flexible budget Var Analysis - Static and Flex Sales Ready A 1 B C D E Crown Hotel Operating Budget for Quarter ending on September 30, 2020 Quarters Aug July Sep Q3 Total 2 3 4 5 6 7 Sales budget 8 Number of rooms sold 9 Number of meals/guests served 10 Sales Rooms $ 11 Sales Restaurant $ 12 Total sales 13 14 # of required staff for rooms 15 # of required staff for restaurant 16 Housekeeping Cost 17 Restaurant Servers 18 variable OH expenses 19 Total variable costs 20 21 Fixed Overbead: Cover page Read this first Input Static Budget Actuals Flexible budget Var Analysis - Static and Flex Sales 21 Fixed Overhead: 22 Manager & supervisor salaries 23 Receptionist & Front office staff 24 Marketing & Promotional expenses 25 Depreciation on fixed assets 26 Property taxes and insurance expenses 27 28 Total Fixed Cost 29 30 Total 31 Cover page Read this first Input Static Budget Actuals Flexible budget Var Analysis - Static and Flex Sales Ready A 1 2. B C Crown Hotel Operating Budget for Quarter ending on September 30, 2020 Quarters July Aug Sep Q3 Total 3 4 5 6 7 Sales budget 8 Number of rooms sold 9 Number of meals/guests served 10 Sales Rooms $ 11 Sales Restaurant $ 12 Total sales 13 14 # of required staff for rooms 15 # of required staff for restaurant 16 Housekeeping Cost 17 Restaurant Servers 18 variable OH expenses 19 Total variable costs 20 Sa 1 Fixed Overhead: ant I actuals Flexible budget Var Analysis - Static and Flex A 1 B C D E Crown Hotel Operating Budget for Quarter ending on September 30, 2020 2 3 4 5 16 Housekeeping Cost 17 Restaurant Servers 18 variable OH expenses 19 Total variable costs Quarters Aug July Sep Q3 Total 20 21 Fixed Overhead: 22 Manager & supervisor salaries 23 Receptionist & Front office staff 24 Marketing & Promotional expenses 25 Depreciation on fixed assets 26 Property taxes and insurance expenses 27 Office Supplies 28 Total Fixed Cost 29 30 Tota 31 Cover page Read this first Input Static Budget Actuals Flexible budget Var Analysis - Static and Flex Sal Ready