this is material for solution

you to solve this sheets

B H 1 D E F Crown Hotel Operating Budget for Quarter ending on September 30, 2020 M N Crown Hotel Actuals forQuarter ending on September 30, Sep Parameters - Budget July Aug 31 31 125 125 100% 95% 03 Total Sep 30 # 30 125 85% Parameters - Actual July Aug 31 31 125 100% 95% Sales Rooms: Days Available Rooms available # Occupancy Rate (%) (%) 125 125 80% 31 30 31 31 30 31 70 1.20 70 Sales Restaurant: Days Available Seats Available Turnover Rate 70 70 70 70 1.20 0.85 1.00 1.05 0.85 hr): te (ADR) $ - Rooms - Restaurant 118 118 Selling price ( $/hr): Average Daily Rate (ADR) $ - Rooms Average Check $ - Restaurant 120 120 118 18 120 18 18 19 19 18 15 15 15 16 16 15 ($/hr): occupancy Housekeeping: Hourly Wage rae (S/hr): 1 housekeeper /occupancy Hours per shift 20 20 20 20 20 20 8 8 8 8 8 8 20 20 20 ers: ts ($/hr) 20 20 Restaurant Servers: 1 Server per guests Hourly wage rate ($/hr) Hours per shift Sales variances Rubric + 13 13 20 15 8 Flexible budget 14 8 8 8 15 15 8 8 Static Budget Read this first age Input Var Analysis - Static and Flex Actuals 1150 PM B. G H M N 20 20 rer per guests wage rate (S/hr) 20 15 20 15 15 Restaurant Servers: 1 Server per guests Hourly wage rate (S/hr) Hours per shift variable OH expenses S/room 20 14 20 13 13 per shift 8 8 8 8 le OH expenses S/room 8 11 11 11 8 10 10 10 65000 60000 65000 9000 9000 overhead: ser & supervisor salaries tionist & Front office staff eting & Promotional expenses eciation on fixed assets Ty taxes and insurance expenses supplies 65000 9000 4500 5500 4000 Fixed overhead: Manager & supervisor salaries Receptionist & Front office staff *Marketing & Promotional expenses *Depreciation on fixed assets Property taxes and insurance expenses office supplies 60000 11000 4500 5000 4000 60000 10000 6000 5500 8000 2000 11000 4000 5000 8000 2000 4000 4000 8000 8000 8000 8000 2500 2500 2500 2000 ase in marketing expense in Sept because Hotel taking part in Hospitality Marketing Show ciation increased in Sept due to purchase of additional asset "Increase in marketing expense in Sept expense increased as hotel decided from Sily Platimum package in Marketing Show od purchase budget sales amounts assumed to be 30% of sales from the restaurant budgetted sales ng inventory is $3,500 and Forecasted food sales for October is $55,000 rown's standard is 20% of next month's requirements as a desired ending inventory. ollection Budget as receivable, beginning balance on July is 15000 Crown's Restaurant sales charged to customers' room to be paid when they check out Testaurant sales paid immediately by credit card Cover page Read this first Input Flexible budget Static Budget Actuals Rubric Sales variances + Var Analysis - Static and Flex 51 E 3. 65000 65000 65000 32 33 9000 9000 Manager & supervisor salaries Receptionist & Front office staff "Marketing & Promotional expenses *Depreciation on fixed assets Property taxes and insurance expenses Office supplies 9000 4000 4000 4500 34 4000 4000 5500 35 8000 8000 8000 36 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 Read this first Input Static Budget Actuals Flexible budget Cover page Var Analysis - Static and Fle 1 F B C E Crown Hotel Operating Budget for Quarter ending on September 30, 2020 2 3 4 July Quarters Aug Sep Q3 Total 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 6 Total housekeeping cost 7 Total restaurant servers cost 8 variable OH expenses 9 Total variable costs 1 Fixed Overhead: Cover page Read this first Input Static Budget Actuals Sales Flexible budget Var Analysis - Static and Flex Quarters Aug July Sep Q3 Total 4 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 Tot 31 Input Actuals Cover page Read this first Static Budget Flexible budget Sa Var Analysis - Static and Flex Ready 1 F C D E Crown Hotel Operating Budget for Quarter ending on September 30, 2020 2 3 4 5 Quarters Aug July Sep Q3 Total 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 Cidhod. 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 To Sa Cover page Read this first Input Actuals Static Budget Flexible budget Var Analysis - Static and Flex Crown Hotel Operating Budget for Quarter ending on September 30, 2020 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 Housekeeping Cost 17 Restaurant Servers 18 variable OH expenses 19 Total variable costs 20 21 Fixed Overhead: Cover page Actuals Flexible budget S Var Analysis - Static and Flex Static Budget Input Read this first 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 Tota 31 Actuals Input Sal Flexible budget Cover page Static Budget Var Analysis - Static and Flex Read this first Ready Type here to search B H 1 D E F Crown Hotel Operating Budget for Quarter ending on September 30, 2020 M N Crown Hotel Actuals forQuarter ending on September 30, Sep Parameters - Budget July Aug 31 31 125 125 100% 95% 03 Total Sep 30 # 30 125 85% Parameters - Actual July Aug 31 31 125 100% 95% Sales Rooms: Days Available Rooms available # Occupancy Rate (%) (%) 125 125 80% 31 30 31 31 30 31 70 1.20 70 Sales Restaurant: Days Available Seats Available Turnover Rate 70 70 70 70 1.20 0.85 1.00 1.05 0.85 hr): te (ADR) $ - Rooms - Restaurant 118 118 Selling price ( $/hr): Average Daily Rate (ADR) $ - Rooms Average Check $ - Restaurant 120 120 118 18 120 18 18 19 19 18 15 15 15 16 16 15 ($/hr): occupancy Housekeeping: Hourly Wage rae (S/hr): 1 housekeeper /occupancy Hours per shift 20 20 20 20 20 20 8 8 8 8 8 8 20 20 20 ers: ts ($/hr) 20 20 Restaurant Servers: 1 Server per guests Hourly wage rate ($/hr) Hours per shift Sales variances Rubric + 13 13 20 15 8 Flexible budget 14 8 8 8 15 15 8 8 Static Budget Read this first age Input Var Analysis - Static and Flex Actuals 1150 PM B. G H M N 20 20 rer per guests wage rate (S/hr) 20 15 20 15 15 Restaurant Servers: 1 Server per guests Hourly wage rate (S/hr) Hours per shift variable OH expenses S/room 20 14 20 13 13 per shift 8 8 8 8 le OH expenses S/room 8 11 11 11 8 10 10 10 65000 60000 65000 9000 9000 overhead: ser & supervisor salaries tionist & Front office staff eting & Promotional expenses eciation on fixed assets Ty taxes and insurance expenses supplies 65000 9000 4500 5500 4000 Fixed overhead: Manager & supervisor salaries Receptionist & Front office staff *Marketing & Promotional expenses *Depreciation on fixed assets Property taxes and insurance expenses office supplies 60000 11000 4500 5000 4000 60000 10000 6000 5500 8000 2000 11000 4000 5000 8000 2000 4000 4000 8000 8000 8000 8000 2500 2500 2500 2000 ase in marketing expense in Sept because Hotel taking part in Hospitality Marketing Show ciation increased in Sept due to purchase of additional asset "Increase in marketing expense in Sept expense increased as hotel decided from Sily Platimum package in Marketing Show od purchase budget sales amounts assumed to be 30% of sales from the restaurant budgetted sales ng inventory is $3,500 and Forecasted food sales for October is $55,000 rown's standard is 20% of next month's requirements as a desired ending inventory. ollection Budget as receivable, beginning balance on July is 15000 Crown's Restaurant sales charged to customers' room to be paid when they check out Testaurant sales paid immediately by credit card Cover page Read this first Input Flexible budget Static Budget Actuals Rubric Sales variances + Var Analysis - Static and Flex 51 E 3. 65000 65000 65000 32 33 9000 9000 Manager & supervisor salaries Receptionist & Front office staff "Marketing & Promotional expenses *Depreciation on fixed assets Property taxes and insurance expenses Office supplies 9000 4000 4000 4500 34 4000 4000 5500 35 8000 8000 8000 36 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 Read this first Input Static Budget Actuals Flexible budget Cover page Var Analysis - Static and Fle 1 F B C E Crown Hotel Operating Budget for Quarter ending on September 30, 2020 2 3 4 July Quarters Aug Sep Q3 Total 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 6 Total housekeeping cost 7 Total restaurant servers cost 8 variable OH expenses 9 Total variable costs 1 Fixed Overhead: Cover page Read this first Input Static Budget Actuals Sales Flexible budget Var Analysis - Static and Flex Quarters Aug July Sep Q3 Total 4 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 Tot 31 Input Actuals Cover page Read this first Static Budget Flexible budget Sa Var Analysis - Static and Flex Ready 1 F C D E Crown Hotel Operating Budget for Quarter ending on September 30, 2020 2 3 4 5 Quarters Aug July Sep Q3 Total 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 Cidhod. 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 To Sa Cover page Read this first Input Actuals Static Budget Flexible budget Var Analysis - Static and Flex Crown Hotel Operating Budget for Quarter ending on September 30, 2020 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 Housekeeping Cost 17 Restaurant Servers 18 variable OH expenses 19 Total variable costs 20 21 Fixed Overhead: Cover page Actuals Flexible budget S Var Analysis - Static and Flex Static Budget Input Read this first 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 Tota 31 Actuals Input Sal Flexible budget Cover page Static Budget Var Analysis - Static and Flex Read this first Ready Type here to search