For dollar amount, answer in two (2) decimal points (e.g. 24.21). For hour(s), answer in whole number (e.g. 1234). Mango&Pear hotel chain operates in Southern California. The company has four hotels located in Santa Monica, Huntington Beach, San Clemente and Chula Vista. The hotels offer fine dining, luxury spa, golf course and other exquisite services. As the holiday season approaches, the management makes a forecast of the demand in staffing and housekeeping services. It determines that each week, the Santa Monica location will need 930 hours, Huntington Beach location will need 1480 hours, San Clemente location will need 1370 hours and Chula Vista location will need 950 hours. The company has been proud of its excellent customer service so the needed hours must be met. However, due to costs, the management does not want to schedule more staff resources than what the company needs. Three staffing agencies in Los Angeles, Orange and San Diego counties have been providing staffing resources for the hotel. Below is wages table for each location. Wage per Hour Los Angeles Orange San Diego Santa Monica S 19.85 23.45 $ 26.95 Huntington Beach 23.85 $ 17.45 23.95 San Clemente 24.85 $ 21.95 Chula Vista 27.85 5 21.45 5 18.95 Los Angeles location has 95 employees who work 22 hours per week. Orange County location has 70 employees who work 20 hours per week and San Diego location has 62 employees who also work 20 hours per week. There are a couple of restrictions that Mango& Pear must take into consideration. Due to a condition set in their contract, Santa Monica hotel must receive at least 120 hours from Orange County staffing location. Also, at most, the total hours provided to the San Clemente hotel by Los Angeles staffing cannot be more than 50 percent of the total hours supplied by Los Angeles staffing location to all hotels. Develop and solve a linear programming model using Excel Solver to find the weekly staffing cost, and answer the following statements. a. The total staffing cost is: type your answer. b. The number of staffing hours provided by Los Angeles staffing location to the Huntington Beach hotel is: type your answer.. C. The number of staffing hours provided by Orange staffing location to the San Clemente hotel is: |type your answer. d. The number of staffing hours provided by Orange staffing location to the Huntington Beach hotel is: |type your answer. e. The number of staffing hours provided by San Diego staffing location to the Santa Monica hotel is: | type your answer... f. If the company must increase the resource needed in the four hotel locations, in terms of its contribution to the total cost, they should increase the staffing resource in choose your answer.. hotel. This is because the selected hotel location has the choose your answer. shadow price. The dollar amount that it would cost the company is type your answer.. for every additional hour added to the right-hand-side. g. If the company must request the staffing company to increase their resources, the staffing location Mango&Pear should avoid is the choose your answer... location. This is because the selected staffing location has the choose your answer... cost