TopOil, a refiner in Indiana, serves three customers near Nashville, Tennessee and maintains consignment inventory (owned by TopOil) at each location. Currently, TopOil uses TL transportation to deliver separately to each customer. Each truck costs $800 plus $250 per stop. Thus delivering to each customer separately costs $1050 per truck. TopOil is considering aggregating deliveries to Nashville on a single truck. Demand at the large customer is 60 tons per year, demand at the medium customer is 24 tons per year, and demand at the small customer is 8 tons per year. Product cost for TopOil is $10,000 per ton and they are using a holding cost of 25 percent. Truck capacity is 12 tons. What is the optimal order quantity to each customer assuming TopOil aggregates shipments to each of the three customers on every truck that goes to Nashville?

TopOil, a refiner in Indiana, serves three customers near Nashville, Tennessee and maintains consignment inventory (owned by TopOil) at each location. Currently, TopOil uses TL transportation to deliver separately to each customer. Each truck costs $800 plus $250 per stop. Thus delivering to each customer separately costs $1050 per truck. TopOil is considering aggregating deliveries to Nashville on a single truck. Demand at the large customer is 60 tons per year, demand at the medium customer is 24 tons per year, and demand at the small customer is 8 tons per year. Product cost for TopOil is $10,000 per ton and they are using a holding cost of 25 percent. Truck capacity is 12 tons. What is the optimal order quantity to each customer assuming TopOil aggregates shipments to each of the three customers on every truck that goes to Nashville?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 107P

See similar textbooks

Similar questions

Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?
opOil, a refiner in Indiana, serves three customers near Nashville, Tennessee and maintains consignment inventory (owned by TopOil) at each location. Currently, TopOil uses TL transportation to deliver separately to each customer. Each truck costs $800 plus $250 per stop. Thus delivering to each customer separately costs $1050 per truck. TopOil is considering aggregating deliveries to Nashville on a single truck. Demand at the large customer is 60 tons per year, demand at the medium customer is 24 tons per year, and demand at the small customer is 8 tons per year. Product cost for TopOil is $10,000 per ton and they are using a holding cost of 25 percent. Truck capacity is 12 tons. What is the optimal order quantity to each customer assuming TopOil develops a tailored aggregation policy?
The town of Lexington purchases gasoline from three vendors to fuel its fleet of municipal vehicles. Each vendor delivers gasoline in 6,000 gallon quantities. Since vendors must deliver the fuel, a transportation fee (based on the distance the vendor must travel) is added to each delivery. The number of deliveries required by each location, the cost of supplying a truckload of gasoline to each location from each vendor, and the number of truckloads each vendor can deliver are provided below: PoliceStation FireStation BusDepot PublicWorksGarage Deliveries(truckloads)available Vendor A Vendor B Vendor C Deliveries(truckloads)required $500 $350 $400 12 $525 $425 $375 2 $550 $450 $625 18 $600 $575 $475 6 20 14 10 Assuming that the price per gallon of fuel is the same for each vendor, develop a linear programming model that minimizes the total transportation fee that Lexington must pay for supplying all of its facilities’ fuel needs.
TopOil, a refiner in Indiana, serves three customers near Nashville, Tennessee and maintains consignment inventory (owned by TopOil) at each location. Currently, TopOil uses TL transportation to deliver separately to each customer. Each truck costs $800 plus $250 per stop. Thus delivering to each customer separately costs $1050 per truck. TopOil is considering aggregating deliveries to Nashville on a single truck. Demand at the large customer is 60 tons per year, demand at the medium customer is 24 tons per year, and demand at the small customer is 8 tons per year. Product cost for TopOil is $10,000 per ton and they are using a holding cost of 25 percent. Truck capacity is 12 tons. a) What is the annual transportation and holding cost if TopOil ships a full truckoad each time a customer is running out of stock? How many days of inventory is carried at each customer under this policy.
. A refiner in city Q serves four customers near city W and maintains consignment inventory (owned by the refiner) at each location. Currently, the refiner uses TL (truckload) transportation to deliver separately to each customer. Each truck costs $(759) plus $(309) per stop. The refiner is considering aggregating deliveries to city W on a single truck. The demand of the first customer is 75 tons a year, the demand of the second customer is 30 tons per year, and the demand of the third and fourth customers is 10 tons per year. The product cost is $8,000 per ton, and it uses a holding cost of (24)%. The truck capacity is 20 tons. a. What is the optimal delivery policy to each customer if the refiner ships separately to each of them? What is the annual total inventory-related cost? b. What is the optimal delivery policy to each customer if the refiner aggregates shipments to each of the four customers on every truck that goes to city W? What is the annual total inventory-related cost?…
Federated Oil has refineries in Los Angeles and Chicago. The Los Angeles refinery can refine up to two million barrels of oil per year, and the Chicago refinery up to three million. After the oil is refined, it is shippedto two distribution points, Houston and New York City. Federated Oil estimates that each distribution point can sell up to five million barrelsper year. Because of differences in shipping and refining costs, the profit earned (in dollars) per million barrels of oil shipped depends on where the oil was refined and on the point of distribution. This information is listed in the file P04_69.xlsx. The company is considering expanding the capacity of each refinery.Each million barrels of annual refining capacity that isadded will cost $120,000 for the Los Angeles refinery and $150,000 for the Chicago refinery. Determine how Federated Oil can maximize its profit (including expansion costs) over a 10-year period.
A steel production plant manufactures bands and coils which sell at a profit of $25 and $30 per ton,respectively. The production rate of the plant for bands is 200 tons/hr, and that for coils is 140 tons/hr.Based on the market analysis, it has been identified that the weekly demand is at most 6000 tons and4000 tons for bands and coils, respectively . The plant operates for a maximum of 40 hours per week. 1. In Microsoft Excel, formulate a linear programming model instance for this problem, then solve. 2. Assume that the products need to be painted after manufacturing, and the painting departmentcan paint at a rate of 600 tons per hour for bands and 400 tons per hour for coils. The paintingdepartment works only for 20 hours. Update the linear programming model instance to accom-modate this requirement, and re-solve the problem. 3. The plant is planning to introduce another product “rods” to its production mix with the followingparameters:•Profit/ton = $40•Production volume = 150…
A beverage producer needs to minimize shipping costs from its two primary plants in Hamilton and Waterloo. All wholesale orders within the city are shipped from one of these plants. An outlet in Toronto orders 200 cases of soft drinks, on the same day an order for 240 cases comes from London. The plant in Hamilton has 300 cases ready to ship and the plant in Waterloo has 200 cases. The cost of shipping each case to Toronto is $0.50 from Hamilton, and $0.70 from Waterloo. The cost of shipping each case to London is $0.60 from Hamilton, and $0.65 from Waterloo. How many cases should be shipped from each warehouse to minimize costs?
Jim Jones manufactures inexpensive set-it-up-yourself furniture for students. He currently makes two products – bookcases and tables. Each bookcase contributes $24 to profit, and each table, $20. Each product passes through two manufacturing points, cutting and finishing. Bookcases take 4 hours a unit in cutting and 4 hours in finishing. Tables require 3 hours a unit in cutting and 5 in finishing. There are currently 40 hours available in cutting and 50 in finishing. Determine the optimum solution. Use graphic linear programming to find the product mix that produces the maximum profit for Jim.
A company supplies goods to three customers, who eachrequire 30 units. The company has two warehouses.Warehouse 1 has 40 units available, and warehouse 2 has 30units available. The costs of shipping 1 unit from warehouseto customer are shown in Table 7. There is a penalty for eachunmet customer unit of demand: With customer 1, a penaltycost of $90 is incurred; with customer 2, $80; and withcustomer 3, $110. Formulate a balanced transportationproblem to minimize the sum of shortage and shipping costs.
Food Goblin Supermarkets use both cashiers and baggers to serve customers at check out. During the peak hours, 8 cashiers and 6 baggers serve approximately 75 customers per hour. On average, a cashier spends 6 minutes at checkout and a bagger spends 4 minutes at bagging to serve a customer. Calculate the utilization of cashiers and their capacity cushion during a peak hour. Calculate the utilization of baggers and their capacity cushion during a peak hour. Calculate the overall average utilization of cashiers and baggers during a peak hour.
Brookside Tailors sells suits to three segments: Executive Custom, Signature, and Brookside One. Last year they had 6,000 Executive Custom, 15,550 Signature, and 38,200 Brookside One clients. The revenue they make annually from the three segments are as follows: $3500,$1800, and $600. The cost to serve these customers is as follows: $1000,$400, and $120, respectively. The retention rate for segments are 80%,76%, and 85%. Assuming an annual discount rate of 5%, please calculate the following: a. CLV for each segment. What is the total value of each segment? [6] b. Suppose the company decides that it would like to invest $2,500,000 next year on loyalty programs to increase the retention rate. How much would the retention rate need to increase to for each segment if the whole sum were spent in that segment? [6] c. Instead of spending on retention, let us say they are going to spend it to acquire more of customers. If they spend that amount of money, they anticipate targeting 2,000, 5000,…