Respectively to achieve the minimum operating cost

Assignment Help Operation Management

Reference no: EM13967090

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. There are only 13 drivers available. The daily cost for operating a large truck is $200 and $120 for the small truck. 1. Formulate the above problem as a Linear Programming problem. 2. Solve the problem using excel; in other words, find the number of drivers which are driving small trucks and large trucks respectively to achieve the minimum operating cost.

Please provide excel sheet using solver.

Reference no: EM13967090

Questions Cloud

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

Research on link between happiness and health demonstrates : Lottery winners are no happier than anyone else a year after their big win. Similarly, people who have experienced serious physical injuries seem to "get over it" fairly well across time and return to their pre-injury level of happiness. These findin..

Find the number of kilometres that the car could travel : Explain how you could use your graph to ?nd the number of kilometres that the car could travel on average for £12. Construct a formula for the cost in pounds, C, of travelling x kilometres.

User Account

All Pages