Formulate the problem as a linear programming problem

Assignment Help Operation Management

Reference no: EM13967092

Union Airways is adding more flights to and from its hub airport and so needs to hire additional customer service agents. • The five authorized eight-hour shifts and staffing costs per agent are Shift 1: 6am to 2pm $170 per agent Shift 2: 8am to 4pm $160 per agent Shift 3: 12pm to 8pm $175 per agent Shift 4: 4pm to 12am $180 per agent Shift 5: 10pm to 6am $195 per agent 2 • The volume of calls varies throughout the 24-hour day. The requirements in agents for every 2-hour interval (based on past data) are summarized as 6-8 8-10 10-12 12-2 2-4 4-6 6-8 8-10 10-12 12-6 48 79 65 87 64 73 82 43 52 15 • Formulate the problem as a Linear Programming problem. • How many agents should Union Airways assign to each shift to achieve least cost? (solve using excel).

Please provide excel sheet using solver.

Reference no: EM13967092

Questions Cloud

Can we effectively treat patient whose trust we do not have : Describe elements that contribute to this population's distrust of the health care system and/or medical treatments. Why is trust important? Can we effectively treat a patient whose trust we do not have? Why?

Determining the elasticity : The demand for personal computers can be characterized by the following point elasticities: price elasticity = -5, cross-price elasticity with software = -4, and income elasticity = 2.5. Indicate whether each of the following statements is true or..

Why are hacking groups such a concern : Why are hacking groups such a concern? Why are international hacking groups a problem? Discuss what makes Russian hacking significant? Are there any organized hacker groups from any other country that we need to be concerned with?

Price structure is supplier offering for fixed ordering cost : Whole Foods Operations has selected a shortlist of local suppliers for important produce items for a new store. Discuss how WF will proceed making this decision. Think, for example, inventory standpoint in making such a decision. For example, what pr..

Formulate the problem as a linear programming problem : Union Airways is adding more flights to and from its hub airport and so needs to hire additional customer service agents. The five authorized eight-hour shifts and staffing costs per agent are Shift 1: 6am to 2pm $170 per agent Shift 2: 8am to 4pm $1..

Safety stocks be considered a form of insurance : Why should safety stocks be considered a form of "insurance?" Why does a transporter think in terms of keeping equipment moving?

Respectively to achieve the minimum operating cost : UPS wants to deliver 400 packages in downtown Miami today. There are 11 large trucks available with capacity 40 packages each, and 10 small trucks with capacity 25 packages each. Solve the problem using excel; in other words, find the number of drive..

Problem to maximize the revenue as a linear program : Bond aroma co. sells two products: cologne and perfume. Cologne sells for $3 per ounce; each ounce requires 2 grams of fragrance, and 6 grams of intensifier. Perfume sells for $8 per ounce; each ounce requires 4 grams of fragrance, 2 grams of intensi..

Annual demand-find the optimal order quantity : ABC Company has annual demand of 3000 units, the setup or ordering cost is $15; and the holding cost per unit per year is $0.75. Find the Optimal order quantity. (Show all your calculations. If you can’t find the square root sign, you can simply type..

User Account

All Pages