For dollar amount, answer in two $(2)$ decimal points $($e$.$g$.24\mathrm{.}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.

Pfinal$-$LP$-3.$png

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:

b$.$ The number of staffing hours provided by Los Angeles staffing location to the Huntington Beach hotel is:

c$.$ The number of staffing hours provided by Orange staffing location to the San Clemente hotel is:

d$.$ The number of staffing hours provided by Orange staffing location to the Huntington Beach hotel is:

e$.$ The number of staffing hours provided by San Diego staffing location to the Santa Monica hotel is:

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

hotel. This is because the selected hotel location has the

shadow price. The

dollar amount that it would cost the company is

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