need help on this question's requirments please i'm really really stuck

Amazing Valley Luxury Resorts has been evaluating how it might expand its sustainability efforts in its hotels (Click the icon to view additional information.) Read the requirements To evaluate these options, management has gathered data for the past year for its laundry costs and housekeeping costs. The costs and occupancy data include: Click the icon to view the costs and occupancy data) * Requirements - X he number of room 1. Using the high-low method, calculate the cost per guest of laundry per day (The volume should be the number of room days, which you will have to calculate for each month) 2. Using the high-low method, calculate the cost per guest of housekeeping per day (Again, the volume should be the number of room days, which you would have calculated for Requirement 1.) 3. Using the high-low method, evaluate the proposal to give guests a $1.10 per day credit for reusing their room linens. Does it appear to be cost effective to offer this program 4. Using the high-low method, evaluate the proposal to give guests a $1.00 per day credit for skipping housekeeping services. Does it appear to be cost effective to offer this program? 5. Using regression analysis, calculate the cost per guest of laundry per day (Again, the volume should be the number of room days, which you would have calculated for Requirement 1.) 6. Using regression analysis, calculate the cost per guest of housekeeping per day (Again, the volume should be the number of room days, which you would have calculated for Requirement 1.) 7. Using regression analysis, evaluate the proposal to give guests a $1 10 per day credit for reusing their room linens. Does it appear to be cost effective to offer this program? 8. Using regression analysis, evaluate the proposal to give guests a $1.00 per day credit for skipping housekeeping services Does it appear to be cost effective to offer this program? 9. Regarding the two programs, what is your recommendation to management about which program(s) to implement? Provide rationale for your recommendation, Print Done O BE a 9 54 Amazing Valley Luxury Resorts has been evaluating how it might expand its sustainability efforts in its hotels (Click the icon to view additional information.) To evaluate these options, management has gathered past year for its laundry costs and housekeeping costs. occupancy data include: (Click the icon to view the costs and occupancy dat Read the requirements. * More Info - X Je number In any given month, an average of 54,750 room days are available in total (this total capacity figure is roughly estimated by taking the total number of hotel rooms in the hotels owned by Amazing Valley and multiplying by 30 days per month.) Management is currently targeting two areas for sustainability projects: laundry and housekeeping Laundry Currently, in each hotel room, a small sign is placed beside the bed that informs the hotel guest that the environment will benefit if the guest reuses the linens. The company has experienced some success with the signs, the cost of laundry has decreased slightly over the past several years that the program has been in place. Management is now considering the possibility of giving guests a $1.10 credit on their hotel bill for each day of the stay that the linens in the room are reused rather than laundered Housekeeping Management is also evaluating the possibility of expanding sustainability efforts in housekeeping by providing an incentive of a $1.00 credit on the hotel bill for each day the guest opts to skip a daily room cleaning Print Done Enter any number in the edit fields and then continue to the next question. a 54 athered zing Valle nd its sug Click the Data Table ing costs. pancy dat. the real le number Month uirement s, which yo in by calc January February March Monthly Occupancy Percentage 74 % 88 % 66 % 54 % April May 42 % nuary bruary arch pril June Total Housekeeping Costs $ 73,820 $ 85,400 S 72,490 $ 58,330 $ 46,100 $ 50,040 $ 51,960 $ 49,670 $ 45,980 $ 46,800 $ 50,070 S 60,720 Total Laundry Costs $ 28,540 $ 33,700 $ 25,920 $ 21,310 $ 18,250 $ 17,880 $ 21,090 $ 20,510 $ 17,932 $ 18,500 $ 19,700 $ 22,260 46 % 52 % ay 50 % July August September October une 40 % 44 % uly ugust November 48 % Feptember December 56 % October November To satisfy investors, management only wants to implement programs which are cost effective, that is the benefits of the program must exceed the costs of the programs Sustainability projects are expected to be cost effective nter any nur Print Done o a 54 Amazing Valley Luxury Resorts has been evaluating how it might expand its sustainability efforts in its hotels (Click the icon to view additional information) To evaluate these options, management has gathered data for the past year for its laundry costs and housekeeping costs. The costs and occupancy data include: Click the icon to view the costs and occupancy data) Read the requirements Requirement 1. Using the high-low method calculate the cost per guest of laundry per day (The volume should be the number of room days, which you will have to calculate for each month.) Begin by calculating the number of room days for each month. # of room days January February March April May June July August September October November Enter any number in the edit fields and then continue to the next question. o te a 54 MO Amazing Valley Luxury Resorts has been evaluating how it might expand its sustainability efforts in its hotels (Click the icon to view additional information.) Read the requirements To evaluate these options, management has gathered data for the past year for its laundry costs and housekeeping costs. The costs and occupancy data include: Click the icon to view the costs and occupancy data) The variable cost per guest of laundry per day is $ Requirement 2. Using the high-low method, calculate the cost per guest of housekeeping per day (Again, the volume should be the number of room days, which you would have calculated for Requirement 1) (Round your answer to the nearest cent.) The variable cost per guest of housekeeping per day is $ Requirement 3. Using the high-low method, evaluate the proposal to give guests a $1 10 per day credit for reusing their room linens. Does it appear to be cost effective to offer this program? appear to be a cost effective program as the credit for reusing room linens is than the variable cost of laundering This the linens This Requirement 4. Using the high-low method, evaluate the proposal to give guests a $1.00 per day credit for skipping housekeeping services. Does it appear to be cost effective to offer this program? appear to be a cost effective program as the credit for skipping housekeeping services is than the variable cost of laundering the linens Requirement 6. Using regression analysis, calculate the cost per guest of laundry per day (Again, the volume should be the number of room days, which you would have calculated for Requirement 1) (Round your answer to the nearest cent) Enter any number in the edit fields and then continue to the next question ? o e a This Amazing Valley Luxury Resorts has been evaluating how it might To evaluate these options, management has gathered data for the expand its sustainability efforts in its hotels past year for its laundry costs and housekeeping costs. The costs and (Click the icon to view additional information.) occupancy data include: Click the icon to view the costs and occupancy data) Read the requirements Requirement 6. Using regression analysis, calculate the cost per guest of housekeeping per day (Again, the volume should be the number of room days, which you would have calculated for Requirement 1) (Round your answer to the nearest cent) The variable cost per guest of housekeeping per day is $ Requirement 7. Using regression analysis, evaluate the proposal to give guests a $1 10 per day credit for reusing their room linens. Does it appear to be cost effective to offer this program? appear to be a cost effective program as the credit for reusing room linens is than the variable cost of laundering the linens Requirement 8. Using regression analysis, evaluate the proposal to give guests a $1.00 per day credit for skipping housekeeping services. Doos it appear to be cost effective to offer this program? appear to be a cost effective program as the credit for skipping housekeeping services is than the variable cost of laundering the linens Requirement 9. Rogarding the two programs, what is your recommendation to management about which program(s) to implement? Provide rationale for your recommendation credit program(s) should be implemented, environmentally conscious program(s) that stakeholders are likely to appreciate Enter any number in the edit fields and then continue to the next question. This cost effective and O e a 8