Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave
Case Study: Linear Programming, Reorder Point, and Inventory Management
Answered

Task Description

Task:

Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are as follows: Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northwest Gas, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per unit (in thousands of dollars) are as follows:

a.Develop a network representation of this problem.
b.Develop a linear programming model that can be used to determine the plan that will minimize total distribution costs.
c.Describe the distribution plan and show the total distribution cost.
d.Recent residential and industrial growth in Butler County has the potential for increasing demand by as much as 100 units. Which supplier should Tri-County contract with to supply the additional capacity?

Premier Consulting’s two consultants, Avery and Baker, can be scheduled to work for clients up to a maximum of 160 hours each over the next four weeks. A third consultant, Campbell, has some administrative assignments already planned and is available for clients up to a maximum of 140 hours over the next four weeks. The company has four clients with projects in process. The estimated hourly requirements for each of the clients over the four-week period are as follows:

Hourly rates vary for the consultant–client combination and are based on several factors, including project type and the consultant’s experience. The rates (dollars per hour) for each consultant–client combination are as follows:

a.Develop a network representation of the problem.
b.Formulate the problem as a linear program, with the optimal solution providing the hours each consultant should be scheduled for each client to maximize the consulting firm’s billings. What is the schedule and what is the total billing?
c.New information shows that Avery doesn’t have the experience to be scheduled for client B. If this consulting assignment is not permitted, what impact does it have on total billings? What is the revised schedule?

The reorder point [see equation (14.6)] is defined as the lead-time demand for an item. In cases of long lead times, the lead-time demand and thus the reorder point may exceed the economic order quantity Q*. In such cases, the inventory position will not equal the inventory on hand when an order is placed, and the reorder point may be expressed in terms of either the inventory position or the inventory on hand. Consider the economic order quantity model with D = 5000, Co = $32, Ch = $2, and 250 working days per year. Identify the reorder point in terms of the inventory position and in terms of the inventory on hand for each of the following lead times:

a.5 days
b.15 days
c.25 days
d.45 days

The Metropolitan Bus Company (MBC) purchases diesel fuel from American Petroleum Supply. In addition to the fuel cost, American Petroleum Supply charges MBC $250 per order to cover the expenses of delivering and transferring the fuel to MBC’s storage tanks. The lead time for a new shipment from American Petroleum is 10 days; the cost of holding a gallon of fuel in the storage tanks is $0.04 per month, or $0.48 per year; and annual fuel usage is 150,000 gallons. MBC buses operate 300 days a year.

a.What is the optimal order quantity for MBC?
b.How frequently should MBC order to replenish the gasoline supply?
c.The MBC storage tanks have a capacity of 15,000 gallons. Should MBC consider expanding the capacity of its storage tanks?
d.What is the reorder point?

support
Whatsapp
callback
sales
sales chat
Whatsapp
callback
sales chat
close