Wingman Distributing Company is expanding its supply chain to include a new distribution hub in South Bend. A key decision involves the number of trucks for the facility. The particular model of truck Wingman is considering can be used 8,000 miles a month and will cost $1,500 a month in capital costs. In addition, each mile a truck is used costs $0.90 for maintenance. A local truck rental firm will rent trucks at a cost of $1.40 per mile. Given the distribution of likely requirements for trucks, management has come up with three alternatives to consider as shown in the table: Monthly requirements (miles) 40,000 80,000 120,000 Probability 0.30 0.40 0.30 Fleet size (trucks) 5 10 15 Which fleet size will yield the lowest expected monthly costs for Wingman?

Wingman Distributing Company is expanding its supply chain to include a new distribution hub in South Bend. A key decision involves the number of trucks for the facility. The particular model of truck Wingman is considering can be used 8,000 miles a month and will cost $1,500 a month in capital costs. In addition, each mile a truck is used costs $0.90 for maintenance. A local truck rental firm will rent trucks at a cost of $1.40 per mile. Given the distribution of likely requirements for trucks, management has come up with three alternatives to consider as shown in the table: Monthly requirements (miles) 40,000 80,000 120,000 Probability 0.30 0.40 0.30 Fleet size (trucks) 5 10 15 Which fleet size will yield the lowest expected monthly costs for Wingman?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
We run a fresh produce stand at farmer’s market where we sell avocados and artichokes. Each morning, a supplier drops off bags of these products. We can buy up to 200 bags of avocados and up to 175 bags of artichokes each morning. We resell the bags to customers throughout the day. The contribution margin of avocados is $15/bag; the contribution margin of artichokes is $20/bag. We sell at least twice as many bags of avocados as we do artichokes. We have found that our normal daily demand is between 140 and 350 total bags what are the constaints
Arts N Crafts Industries manufacturers high-end light fixtures, which it sells internationally. The company is responsible for paying for shipping its product to a distributor located in Atlanta, Georgia. Due to the high cost of shipping, the company is considering shipping its products unassembled, but will include detailed assembly instructions in each package. By shipping unassembled products, Arts N Crafts will be able to shrink the size of its cartons and thereby increase the number of products per pallet from 16 (4 rows of 4) to 25 (5 rows of 5). Note that this change will not appreciably increase each product’s 8-pound shipping weight. Furthermore, since individual fixtures will be packed more tightly, they will be less susceptible to damage and easier to handle. Thus, the company expects the freight class to decrease from 85 to 70. Currently the company ships 400 units per week.a. Using Table, assess the impact of the proposed change in packaging on weekly shipping cost.b. How…
Western Chassis produces high-quality polished steel and aluminum sheeting and two lines ofindustrial chassis for the rack mounting of Internet routers, modems, and other telecommunicationsequipment. The contribution margin (contribution toward profit) for steel sheeting is $0.40 per poundand for aluminum sheeting is $0.60 per pound. Western earns $12 contribution on the sale of aStandard chassis rack and $15 contribution on a Deluxe chassis rack. During the next productioncycle, Western can buy and use up to 25,800 pounds of raw unfinished steel either in sheeting or inchassis. Similarly, 20,400 pounds of aluminum are available. One standard chassis rack requires 16pounds of steel and 8 pounds of aluminum. A Deluxe chassis rack requires 12 pounds of each metal.The output of metal sheeting is restricted only by the capacity of the polisher. For the next productioncycle, the polisher can handle any mix of the two metals up to 4,000 pounds of metal sheeting. Chassismanufacture can be…
Ruby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 30 units and is valued at $60 per unit. Inbound shipments from vendor 1 will average 330 units with an average lead time (including ordering delays and transit time) of 4 weeks. Inbound shipments from vendor 2 will average 450 units with an average lead time of 3 weeks. Ruby-Star operates 52 weeks per year; it carries a 4-week supply of inventory as safety stock and no anticipation inventory. A. the average aggregate inventory value of the product if ruby star used vendor 1 exclusively is $_____ (enter your response as a whole number) B. the average aggregate inventory value of the product if ruby sta used vendor 2 exclusively is $______ (enter your response as a whole number) C. how would your analysis change if average weekly demand increased to 140 units per week? the average aggregate inventory value of the product if ruby star used vendor 1…
. The Newcoat Painting Company has for some time been experiencing high demand for its automobile repainting service. Because it has had to turn away business, management is concerned that the limited space available to store cars awaiting painting has cost them in lost revenue. A small vacant lot next to the painting facility has recently been made available for rental on a long-term basis at a cost of $10 per day. Management believes that each lost customer costs $20 in profit. Current demand is estimated to be 21 cars per day with exponential interarrival times (including those turned away), and the facility can service at an exponential rate of 24 cars per day. Cars are processed on a FCFS basis. Waiting space is now limited to 9 cars but can be increased to 20 cars with the lease of the vacant lot.Newcoat wants to determine whether the vacant lot should be leased. Management also wants to know the expected daily lost profit due to turning away customers if the lot is leased. Only…
She must travel to Kenya to check on quality and transportation. The trip will cost $2,500. The cost of the handbag is $10 and shipping to the United States can occur through the postal system for $2 per handbag or through a freight company which will ship a container that can hold up to 1,000 handbags at a cost of $1,000. The freight company charges $1,000 even if less than 1,000 handbags are shipped. Leslie will sell the handbags to retailers for $20. Assume there are no other costs and benefits. what is the output level that both shipping methods yield same profit? Ho
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…
Ruby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 50 units and is valued at $75 per unit. Inbound shipments from vendor 1 will average 350 units with an average lead time (including ordering delays and transit time) of 2 weeks. Inbound shipments from vendor 2 will average 500 units with an average lead time of 1 week. Ruby-Star operates 52 weeks per year; it carries a 2-week supply of inventory as safety stock and no anticipation inventory.a. What would be the average aggregate inventory value of this product if Ruby-Star used vendor 1 exclusively?b. What would be the average aggregate inventory value of this product if Ruby-Star used vendor 2 exclusively?c. How would your analysis change if average weekly demand increased to 100 units per week?
HERO Corporation is considering three options for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of pesos) depends on demand as follows: Demand Demand Demand Staffing Options High Medium Low Own staff 352 325 300 Outsider vendor 450 300 150 Combination 400 325 250 If the decision maker knows nothing about the probabilities of the four states of nature, what is the recommended decision using:i. the optimistic approach and the conservative approach iii. the minimax regret approach iv. the Laplace method
Ruby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 30 units and is valued at $100 per unit. Inbound shipments from vendor 1 will average 300 units with an average lead time (including ordering delays and transit time) of 4 weeks. Inbound shipments from vendor 2 will average 490 units with an average lead time of 1 week. Ruby-Star operates 52 weeks per year; it carries a 4-week supply of inventory as safety stock and no anticipation inventory. a. The average aggregate inventory value of the product if Ruby-Star used vendor 1 exclusively is $39,000. (Enter your response as a whole number.) b. The average aggregate inventory value of the product if Ruby-Star used vendor 2 exclusively is $ (Enter your response as a whole number.)
The Robot Company franchises combination gas and car wash stations throughout the United States. Robot gives a free car wash for a gasoline fill-up is about the same as far a wash alone, charges $0.50. Past expericnce shows that the number of customers that have car washes following fill-ups is about the same as for a wash alone. The average profit on a gasoline fill-up is about $0.70, and the cost of the car wash to Robot is $0.10 Robot stays open 14 hours per day. Robot has three power units and drive assemblies, and a franchisee must select the unit prefered Unit I can wash cans at the rate of one every five minutes and is leased for $12 per day. Unit I, a larger unit, can wash cars at the rate of one every four minutes but costs $16 per day. Unit II, the largest, costs $22 per day and can wash a car in three minutes. The franchisee estimates that customers will not wait in line more than five minutes for a car wash. A longer time will cause Robot to lose the gasoline sales as well…