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..

Reviews

Write a Review

Operation Management Questions & Answers

  Explain the first step in the human resource management

Explain the first step in the Human Resource Management Process. What is the "Decruitment", and how might it relate to this first step?

  Leadership and crisis management skills

The purpose of this assignment is to develop your leadership and crisis management skills by using a real-life case study example.

  Outline best practices for project team selection

In addition to the one to two (1-2) pages required, a title page is to be included. The title page is to contain the title of the assignment, your name, the instructor's name, the course title, and the date.

  How much carrying costs by using the eoq

Currently the manager orders once a month. How much could the firm save annually in ordering and carrying costs by using the EOQ?

  Completing the venture opportunity screening exercises

Completing the Venture Opportunity Screening Exercises is designed to clear up the uncertainties and risks associated with that venture concept.

  What are four products that company makes

A company makes four products that have the following characteristics. The processing requirements for each product on each of the four machines are explain how in the table.

  Effect is often blame for the boom-and-bust cycles

The bullwhip effect is often blame for the boom-and-bust cycles in our national economy

  Implementation that part of corporate strategy

Describe Wal-Mart's use of vertical integration as they have grown both domestically and internationally. Given the text’s advantages and disadvantages of vertical integration, evaluate Wal-Mart's overall implementation that part of corporate strateg..

  Describe some of the trade- offs that are encountered

Describe some of the trade- offs that are encountered in product and service design. Who needs to be involved in the design of products and services? How has technology had an impact on product and service design?

  Write a linear program that minimizes cost

M&D wants to sell the remaining pounds of the catalytic agent at a price of $100. How much money will be generated from the sell?

  How well did the legal system work

Who is responsible for the Bhopal accident? How should blame be apportioned among parties in¬volved, including Union Carbide Corporation, UCIL, plant workers, governments in India, or others?

  What is the standard task time for the operation

A time study indicates that a worker takes 430 seconds to perform an operation. The worker is known to be quite skilled and the supervisor estimates before the timing that her performance will be about 10% above average. During a 7-day workday, vario..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd