A Mercedes dealer purchases vehicles for $20,000. 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 believes that demand is backlogged, but estimates that if he is short one car for one year, he will lose $20,000 in future profits. Each time the dealer places an order for cars, the ordering cost amounts to $10,000. What is the (s, Q) ordering policy that results in a 90% CSL?

A Mercedes dealer purchases vehicles for $20,000. 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 believes that demand is backlogged, but estimates that if he is short one car for one year, he will lose $20,000 in future profits. Each time the dealer places an order for cars, the ordering cost amounts to $10,000. What is the (s, Q) ordering policy that results in a 90% CSL?

Name: A Mercedes dealer purchases vehicles for $20,000. The annual holding c
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: A Mercedes dealer purchases vehicles for $20,000. 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 believes that demand is backlogged, but estimates that if he is sh

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

An electronics retailer sells laptops at a steady rate of 7,500 per quarter. It costs the manufacturer $350 tomake each laptop, and they charge $400/laptop to the retailer. The manufacturer produces the laptop at asteady rate that matches demand, and incurs a fixed cost of $2,800 to fulfill each retail order. Both theretailer and the manufacturer have an annual holding cost percentage of 20%. The retailer places 10orders with the laptop manufacturer each quarter (which it determined from an EOQ calculation). Whatare the retailer’s and manufacturer’s costs under this current setup, as well as the total supply chain cost?
An electronics retailer sells laptops at a steady rate of 7,500 per quarter. It costs the manufacturer $350 tomake each laptop, and they charge $400/laptop to the retailer. The manufacturer produces the laptop at asteady rate that matches demand, and incurs a fixed cost of $2,800 to fulfill each retail order. Both theretailer and the manufacturer have an annual holding cost percentage of 20%. The retailer places 10orders with the laptop manufacturer each quarter (which it determined from an EOQ calculation). Whatare the retailer’s and manufacturer’s costs under this current setup, as well as the total supply chain cost?What quantity discount should the manufacturer offer the retailer in order to minimize the total supplychain costs? Under this quantity discount, what are the new retailer and manufacturer costs? Does theretailer choose to use the quantity discount? PLEASE SHOW ALL CALUCALTIONS/EXCEL MODEL
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 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?
The home appliance department of a large department store is using inventory models to controlthe replenishment of a particular model of Microwave ovens. The daily demand follows anormal distribution with a mean of 150 units and standard deviation of 16 units. The store pays$100 for each oven. Fixed costs of replenishment are $28. The accounting departmentrecommends a 20% annual holding cost rate. Assume that the average lead time is 5 days with astandard deviation of 1 day. Assume 365 days a year.Part A: What is the EOQ?Part B: What is the reorder point if the maximum chance of 5% of stock out (i.e. 95% servicelevel) is desired?Part C: What is the reorder point if a fill rate of 99% is required?Part D: Suppose management wants to simplify the process by setting the reorder point to“1000” units. Based on this policy, what is the implied chance of stock out?
Please do not give solution in image format thanku Deltic sells this component for 55 per unit with a 4-month delivery lead time. Assume Deltic covers all transportation and related processing until delivery. TCX’s demand forecast for the upcoming selling season (12 months) is a normal distribution with mean 13500 and standard deviation 3736,4 . TCX sells each unit, after integrating their proprietary software, for 135. Assume that TCX uses a holding cost rate of 25 %, and any leftover units can be sold for 30 on average. Due to the long lead time and high minimum order quantity required, TCX is planning on a single order from Deltic to meet their needs in the next year. How many of these components should TCX order? Calculate the resulting expected annual profits for TCX.
Parasol Systems sells motherboards for personal computers. For quantities upthrough 25, the firm charges $350 per board; for quantities between 26 and 50,it charges $315 for each board purchased beyond 25; and it charges $285 eachfor the additional quantities over 50. A large communications firm expects torequire these motherboards for the next 10 years at a rate of at least 140 peryear. Order setup costs are $30 and holding costs are based on an 18 percentannual interest rate. What should be the size of the standing order?
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?
A distributor of computer monitors purchases the monitors from an overseas supplier under a continuous review system. The average demand for a popular computer monitor is normally distributed with a mean of 50 units a day and a standard deviation of 10 units a day. It costs $75 to process each order and there is a 16 day lead time. The holding cost for each monitor is $20 per year and the distributor wishes to maintain a 90% service level. The distributor operates 300 days in a year. The distributor would like to use a periodic review inventory system to manage their inventory. Use the information in Scenario 9.15. What is the target inventory level needed to achieve a 90% service level? greater than 1250 units but less than or equal to 1500 units less than or equal to 1000 units greater than 1000 units but less than or equal to 1250 units greater than 1500 units
Under the last-in, first-out (LIFO) inventory valuation method, a price index for inventory must be established for tax purposes. The quantity weights are based on year-ending inventory levels. Unit Price ($) Product EndingInventory Beginning Ending A 500 0.15 0.19 B 50 1.40 1.80 C 100 4.50 4.20 D 60 12.00 13.60 Use the beginning-of-the-year price per unit as the base-period price and develop a weighted aggregate index for the total inventory value at the end of the year. (Round your answer to the nearest integer.) I = ?? What type of weighted aggregate price index must be developed for the LIFO inventory valuation? -Paasche index -Laspeyres Index
The Rahway, New Jersey, plant of Metalcase, a manufacturer of office furniture, produces metaldesks at a rate of 200 per month. Each desk requires 40 Phillips head metal screws purchasedfrom a supplier in North Carolina. The screws cost 3 cents each. Fixed delivery charges and costsof receiving and storing shipments of the screws amount to about $100 per shipment, independently of the size of the shipment. The firm uses a 25 percent interest rate to determineholding costs. Metalcase would like to establish a standing order with the supplier and is considering several alternatives. What standing order size should they use?
1. David and Beth Sheba run a health food store. Their top selling item is called Heavenly Kelp. The annual demand for this is 3200 units, and demand is constant throughout the year. The cost of placing an order is $100, while the holding cost per unit per year is $4. How many orders per year should be placed if they wish to minimize their total cost ? If you want to be eligible for partial credit, give an idea as to how you arrived at that number?