Question: For dollar amount, answer in two ( 2 ) decimal points ( e . g . 2 4 . 2 1 ) . For hour
For dollar amount, answer in two decimal points eg For hours answer in whole number eg 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 hours, Huntington Beach location will need hours, San Clemente location will need hours and Chula Vista location will need 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. PfinalLPpng Los Angeles location has employees who work hours per week. Orange County location has employees who work hours per week and San Diego location has employees who also work 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 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 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 righthandside. g If the company must request the staffing company to increase their resources, the staffing location Mango&Pear should avoid is the
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
