A French car company ships 120,000 cars annually to the United Kingdom. The current method of shipment uses ferries to cross the English Channel and averages 10 days. The firm is considering shipping by rail through the Chunnel (the tunnel that goes through the English Channel) instead. That transport method would average approximately 2 days. Shipping through the Chunnel costs $80 more per vehicle. The firm has a holding cost of 25% per year. The average value of each car shipped is $20,000. Which transportation method should be selected?

A French car company ships 120,000 cars annually to the United Kingdom. The current method of shipment uses ferries to cross the English Channel and averages 10 days. The firm is considering shipping by rail through the Chunnel (the tunnel that goes through the English Channel) instead. That transport method would average approximately 2 days. Shipping through the Chunnel costs $80 more per vehicle. The firm has a holding cost of 25% per year. The average value of each car shipped is $20,000. Which transportation method should be selected?

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

An automotive warehouse stocks a variety of parts that are sold at neighborhoodstores. One particular part, a popular brand of oil filter, is purchased by thewarehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based on warehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based ona 28 percent annual interest rate.The monthly demand for the filter follows a normal distribution with mean280 and standard deviation 77. Order lead time is assumed to be five months.Assume that if a filter is demanded when the warehouse is out of stock, then thedemand is back-ordered, and the cost assessed for each back-ordered demand is$12.80. Determine the following quantities:a. The optimal values of the order quantity and the reorder level.b. The average annual cost of holding, setup, and stock-out associated…
A firm faces a demand of 40,000 units per month for one of its lines of stock. The firm’s cost of holding stock is £2 per unit of average stock per month, and it costs the firm a total of £100 every time it orders and acquires a new shipment of stock. The firm is willing to face stock-outs and the cost of such is £6 per unit of average stock-out per month. Assuming the firm attempts to minimise overall inventory-related costs, how large (approximately) will the firm allow its stock-outs to become before each new stock delivery arrives? A. 782 units B. 577 units C. 904 units D. 981 units * Explain in full detail
A fish restaurant sells fish for 50$ per kg and buys it from the suppliers for 10$ per kg. Fish that were not sold during the day go bad. A manager has estimated that daily demand for fish is normally distributed with a mean of 20kg and a standard deviation of 5 kg. The manager has to decide how much fish to order per day. Find a profit-maximizing order.
Flanger is an industrial distributor that sources from hundreds of suppliers. The two modes of transportation available for inbound shipping are LTL (less than truck- load) and TL (truckload). LTL shipping costs $1 per unit, whereas TL shipping costs $500 per truck. Each truck can carry up to 1,000 units. Flanger wants a rule assigning products to shipping mode (TL or LTL) based on annual demand. Each unit costs $50, and Flanger uses a holding cost of 22 percent. Flanger incurs a fixed cost of $150 for each order placed with a supplier. a. Determine a threshold for annual demand above which TL is preferred and below which LTL is preferred. b. How does the threshold change [relative to part (a)] if unit cost is $150 (instead of $50 ) with all other data unchanged? Which mode becomes preferable as unit cost grows? c. How does the threshold change [relative to part (a)] if the LTL cost comes down to $0.8 per unit (instead of $1 per unit)?
One of the products stocked at Weiss’s paint store, mentioned in Problem 14, is a certain type of highly volatile paint thinner that, due to chemical changes in the product,has a shelf life of exactly one year. Al Weiss purchases the paint thinner for $20 a galloncan and sells it for $50 a can. The supplier buys back cans not sold during the yearfor $8 for reprocessing. The demand for this thinner generally varies from 20 to 70cans a year. Al assumes a holding cost for unsold cans at a 30 percent annual interestrate.a. Assuming that all values of the demand from 20 to 70 are equally likely, what is theoptimal number of cans of paint thinner for Al to buy each year?b. More accurate analysis of the demand shows that a normal distribution gives abetter fit of the data. The distribution mean is identical to that used in part (a), andthe standard deviation estimator turns out to be 7. What policy do you nowobtain?
Vetox sells industrial chemicals. One of their inputs can be purchased in either jugs orbarrels. A jug contains one gallon, while a barrel contains 55 gallons. The price pergallon is the same with either container. Vetox is charged a fixed amount per orderwhether it purchases jugs or barrels. The inventory holding cost per gallon per monthis the same with either jugs or barrels. Vetox chooses an order quantity to minimizeordering and holding costs per year. Would Vetox purchase a greater number of gallonswith each order if it purchased with jugs or with barrels?a. They would order a greater number of gallons with barrels.b. They would order the same number of gallons with either container.c. They would order a greater number of gallons with jugs.d. They might order a greater number of gallons with jugs or with barrels, depending onvarious factors like the demand rate, ordering cost, and holding cost.
You run a food bar in UCLA Ackerman, and you sell chocolate croissants for breakfast. Your daily demand for chocolate croissants is on average 50, with a standard deviation of 8. The unit cost of a croissant is $0.70, and you sell at a unit price of $3.00. The refrigerated chocolate croissant must be consumed within 7days (one week) after purchased from your supplier, so you dispose leftover inventory and purchase fresh croissants once every week. Assume the demand in each of the seven days is independently distributed. (The z-table for normal distribution is attached.) (a) What is the optimal weekly purchase quantity for the chocolate croissant? What is average inventory? A student leader, Mark, came to you one day and told you that Anderson School would hold a special event next Thursday morning, and there would be additional demand for the chocolate croissant on that day. Mark wants to reserve a certain amount of croissant from you and sell in the special event at the regular price.…
Long last Appliance Store has a demand of 1300 units per month for one of its fast selling portable smoothie machine (model G), it incurs a fixed order placement, transportation and receiving cost of $3000 each time an order is delivered. Each machine cost the company $550 and the company has a holding cost of 12%. The company has two other models of the smoothie machine which are also popular with consumers. Evaluate the company’s inventory management policy if lots for each model are ordered and delivered independently by determining the following: The optimal order size The cycle inventory The number of orders per year The annual ordering and holding cost The total cost of the inventory Briefly state rationale for the approach used for (a-e)
A tire store orders its stock for a popular winter tire once every year. The cost of a tire for the store is $120. The store sells a tire for $140 at the regular price. The regular demand per year is 1,000 tires, which is normally distributed with a standard deviation of 70 tires. Customers do not prefer to buy from an older stock; hence the store does not keep the tires for the next year. The store is able to sell the excess stock at a reduced price of $80 per tire. How many tires the store should order each year?
There are at present 40 solar energy construction firmsin the state of Indiana. An average of 20 solar energy construction firms open each year in the state. The averagefirm stays in business for 10 years. If present trends continue,what is the expected number of solar energy constructionfirms that will be found in Indiana? If the time between theentries of firms into the industry is exponentially distributed,what is the probability that (in the steady state) there willbe more than 300 solar energy firms in business? (Hint: Forlarge l, the Poisson distribution can be approximated by anormal distribution.)
Goop Inc needs to order a raw material to make a special polymer. The demand for the polymer is forecasted to be Normally distributed with a mean of 250 gallons and a standard deviation of 125 gallons. Goop sells the polymer for $25 per gallon. Goop’s purchases raw material for $10 per gallon and Goop must spend $5 per gallon to dispose of all unused raw material due to government regulations. If demand is more than Goop can make, then Goop sells only what they made and the rest of demand is lost. Suppose Goop wants to ensure that there is a 92% probability that they will be able to satisfy the customer's entire demand. How many gallons of the raw material should they purchase? *Use Table in image and round your answer to the nearest integer.
A car dealer must pay $20,000 for each car purchased. The annual holding cost is estimated to be 25% of the dollar value of inventory. The dealer sells an average of 500 cars per year. He is willing to backlog some demand but estimates that if he is short one car for one year, he will lose $20,000 worth of future profits. Each time the dealer places an order for cars, the ordering cost is $10,000. Determine the dealer’s optimal ordering policy. What is the maximum shortage that will occur? Assume it costs $5000 to store a car for a year