A Mercedes dealer must pay $20,000 for each carpurchased. The annual holding cost is estimated to be 25%of the dollar value of inventory. The dealer sells an averageof 500 cars per year. He believes that demand is backloggedbut estimates that if he is short one car for one year he willlose $20,000 worth of future profits. Each time the dealerplaces an order for cars, ordering cost amounts to $10,000.Determine the Mercedes dealer’s optimal ordering policy.What is the maximum shortage that will occur?

A Mercedes dealer must pay $20,000 for each carpurchased. The annual holding cost is estimated to be 25%of the dollar value of inventory. The dealer sells an averageof 500 cars per year. He believes that demand is backloggedbut estimates that if he is short one car for one year he willlose $20,000 worth of future profits. Each time the dealerplaces an order for cars, ordering cost amounts to $10,000.Determine the Mercedes dealer’s optimal ordering policy.What is the maximum shortage that will occur?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.4: Simulation With Built-in Excel Tools

Problem 14P

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
A retired couple supplement their income by making fruit pies, which they sell to a local grocery store. During the month of September, they produce apple and grape pies. The apple pies are sold for $10.00 to the grocer, and the grape pies are sold for $8.00. The couple is able to sell all of the pies they produce owing to their high quality. They use fresh ingredients. Flour and sugar are purchased once each month. For the month of September, they have 1,500 cups of sugar and 2,400 cups of flour. Each apple pie requires 1½ cups of sugar and 3 cups of flour, and each grape pie requires 2 cups of sugar and 3 cups of flour. a. Determine the number of grape and the number of apple pies that will maximize revenues if the couple working together can make an apple pie in 6 minutes and a grape pie in 3 minutes. They plan to work no more than 60 hours. (Round your answers to nearest whole number.) b. Determine the amounts of sugar, flour, and time that will be unused. (Leave no cells blank -…
A retired couple supplement their income by making fruit pies, which they sell to a local grocery store. During the month of September, they produce apple and grape pies. The apple pies are sold for 2.00 to the grocer, and the grape pies are sold for 4.00. The couple is able to sell all of the pies they produce owing to their high quality. They use fresh ingredients. Flour and sugar are purchased once each month. For the month of September, they have 2100 cups of sugar and 3000 cups of flour. Each apple pie requires 1 1/2 cups of sugar and 3 cups of flour, and each grape pie requires 2 cups of sugar and 3 cups of flour. a. determine the number of grape and the number of apple pies that will maximize revenues if the couple working together can make and apple pie in 6 minutes and a grape pie in 3 minutes.…
ABC firm uses roughly 3,400 pounds of chemical dye a year. Currently, the firm purchases 300 pounds per order and pays P120.00 per pound. The supplier has just announced that orders of 1,000 pounds or more will be filled at a price of P80.00 per pound. The manufacturing firm incurs a cost of P4,000.00 each time it submits an order and assigns an annual holding cost of 17% of the purchase price per pound. a. Determine the order size that will minimize the total cost.b. If the supplier offered the discount at 1,500 pounds instead of 1,000 pounds, what order size would minimize total cost?
A hot dog vendor at Wrigley Field sells hot dogs for$1.50 each. He buys them for $1.20 each. All the hot dogshe fails to sell at Wrigley Field during the afternoon can besold that evening at Comiskey Park for $1 each. The dailydemand for hot dogs at Wrigley Field is normally distributedwith a mean of 40 and a standard deviation of 10.a If the vendor buys hot dogs once a day, how manyshould he buy?b If he buys 52 hot dogs, what is the probability that hewill meet all of the day’s demand for hot dogs at Wrigley?
The campus store at a large Midwestern university sells writing tablets to students, faculty, and staff. They sell more tablets near exam time. During a typical 10-week quarter,the pattern of sales is 2,280, 1,120, 360, 3,340, 1,230, 860, 675, 1,350, 4,600, 1,210.Thepads cost the store $1.20 each, and holding costs are based on a 30 percent annual interest rate. The cost of employee time, paperwork, and handling amounts to $30 per order.Assume 50 weeks per year.b. The bookstore manager has decided that it would be more economical if thedemand were the same each week. In order to even out the demand he limits weeklysales (to the annoyance of his clientele). Hence, assume that the total demand forthe 10-week quarter is still the same, but the sales are constant from week to week.Determine the optimal order policy in this case and compare the total holding andordering cost over the 10 weeks to the answer you obtained in part (a). (You may assume continuous time for the purposes of your…
The campus store at a large Midwestern university sells writing tablets to students, faculty, and staff. They sell more tablets near exam time. During a typical 10-week quarter,the pattern of sales is 2,280, 1,120, 360, 3,340, 1,230, 860, 675, 1,350, 4,600, 1,210.Thepads cost the store $1.20 each, and holding costs are based on a 30 percent annual interest rate. The cost of employee time, paperwork, and handling amounts to $30 per order.Assume 50 weeks per year.a. What is the optimal order policy during the 10-week quarter based on theSilver–Meal heuristic? Using this policy, what are the total holding and orderingcosts incurred over the 10-week period?
A hospital orders its thermometers from a hospitalsupply firm. The cost per thermometer depends on the ordersize q, as shown in Table 6. The annual holding cost is 25%of the purchasing cost. Let EOQ80 be the EOQ if the costper thermometer is 80¢, and let EOQ79 be the EOQ if thecost per thermometer is 79¢.a Explain why EOQ79 will be larger than EOQ80. b Explain why the optimal order quantity must be ei-ther EOQ79, EOQ80, or 100. c If EOQ80 100, show that the optimal order quan-tity must be EOQ79. d If EOQ80 100 and EOQ79 100, show that theoptimal order quantity must be either EOQ80 or 100.e If EOQ80 100 and EOQ79 100, show that the optimal order quantity must be EOQ79.
The annual demand for a product of XYZ company is 12.000. The cost of ordering this product is CU25 and the holding cost is CU0.5/(piece year). The company in question wishes to follow the "Pending Order" stock policy and the holding cost is CU5/(piece year). The lead time for this product is 2 days and it is worked for 300 days a year. In this case, calculate the economic order quantity, the highest pending order quantity and the highest stock level
The catering manager of LaVista Hotel, Lisa Ferguson, is disturbed by the amount of silverware she is losing every week. Last Friday night, when her crew tried to set up for a banquet for 500 people, they did not have enough knives. She decides she needs to order some more silverware, but wants to take advantage of any quantity discounts her vendor will offer. ≻For a small order (2,000 pieces or less) her vendor quotes a price of $1.80/piece. ≻If she orders 2,001 to 5,000 pieces, the price drops to $1.60/piece. ≻5,001 to 10,000 pieces brings the price to $1.40/piece, and ≻10,001 and above reduces the price to $1.25/piece. Lisa's order costs are $205 per order, her annual holding costs are 5%, and the annual demand is 45,100 pieces. For the best option (the best option is the price level that results in an EOQ within the acceptable range): Part 2 a) What is the optimum ordering quantity? enter your response here units (round your response to the…
The catering manager of LaVista Hotel, Lisa Ferguson, is disturbed by the amount of silverware she is losing every week. Last Friday night, when her crew tried to set up for a banquet for 500 people, they did not have enough knives. She decides she needs to order some more silverware, but wants to take advantage of any quantity discounts her vendor will offer. ≻For a small order (2,000 pieces or less) her vendor quotes a price of $1.80/piece. ≻If she orders 2,001 to 5,000 pieces, the price drops to $1.60/piece. ≻5,001 to 10,000 pieces brings the price to $1.40/piece, and ≻10,001 and above reduces the price to $1.25/piece. Lisa's order costs are $200.00 per order, her annual holding costs are 5%, and the annual demand is 15,000 pieces. For the best option (the best option is the price level that results in an EOQ within the acceptable range): Part 2 a) What is the optimum ordering quantity? ________ units (round your response to the nearest whole…
The lead time demand for bathing suits is governed bythe discrete random variable shown in Table 11. Thecompany sells an average of 10,400 suits per year. The costof placing an order for bathing suits is $30, and the cost ofholding one bathing suit in inventory for a year is $3. Thestockout cost is $3 per bathing suit. Use marginal analysisto determine the optimal order quantity and the reorderpoint.Lead TimeDemand Probability180 .30190 .30200 .15210 .10220 .15