Please do not use Excel for any part of this
Green Wave Electronics is selling computer parts for self-assembly to Tulane students. This year, one of its supplier, Angry Tide Co., is planning to release a new hard drive, the SSD2020. Each SSD2020 will cost Green Wave Electronics $340 and will be sold to Tulane students for $500 from September to December of 2020. Given the long lead time and short life cycle of this product, Green Wave Electronics will only get to place a single order for the SSD2020. Using previous sales for similar products, the marketing team forecasts total demand to be 1,000 units. However, historical A/F ratios for those similar items show an overall mean of 1.05 and overall standard deviation of 0.60. It is assumed that, in January 2021, all remaining inventory for the SSD2020 will be sold to Tulane students at a very attractive price of $200.
(a) Using the historical A/F ratios and assuming a Normal distribution for the SSD2020 demand, what do you expect its mean and standard deviation to be?
For all remaining questions, use the demand distribution that you found in a.
(b) What are the underage and overage costs for the SSD2020?
(c) What is the profit-maximizing order quantity for the SSD2020?
(d) What would be the in-stock probability if Green Wave Electronics ordered the profit-maximizing quantity as found in question c?
(e) How many lost sales would be expected if Green Wave Electronics ordered the profit-maximizing quantity as found in question c?
(a)
(b)
Cu = cost of underage = Selling price - Purchase cost = 500 -
340 = $160
Co = cost of overage = Purchase cost - Salvage value = 340 - 200 =
$140
(c)
Critical ratio, CR = Cu / (Co+Cu) = 160 / (160+140) = 0.533
For optimal order quantity, F(z) = CR = 0.533, So, z = NORM.S.INV(0.533) = 0.084
So, optimal order quantity = Mean demand + 0.084 * SD = 1050 + 0.084*600 = 1,100 units
(d)
The in-stock probability is the critical ratio i.e. 53.33%
(e)
The loss function corresponding to the z value is L(z) = 0.358
So, expected lost sales = 0.358*SD = 0.358*600 = 215 units.
Please do not use Excel for any part of this Green Wave Electronics is selling computer parts for...
Please do not use Excel for any part of this Green Wave Electronics is selling computer parts for self-assembly to Tulane students. This year, one of its supplier, Angry Tide Co., is planning to release a new hard drive, the SSD2020. Each SSD2020 will cost Green Wave Electronics $340 and will be sold to Tulane students for $500 from September to December of 2020. Given the long lead time and short life cycle of this product, Green Wave Electronics will...
Please help! especially part c,d,e. part a answer: Excel = Norm.Inv (0.889, 2500, 400) = 2989 part b answer: Excel = Norm.inv (0.95, 2500, 400) = 3158 ABC Sportswear company designs and sells wetsuits to the U.S. market. The designs of the wetsuits are updated each year. The process for updating the design typically starts in January the year before the designs are to be released. At this time, the purchasing, design, and sales departments have a two-day meeting to...
Please help! especially part c,d,e. I have found the answer for part a and b, so please help me part c,d, and especially part e! part a answer: Excel = Norm.Inv (0.889, 2500, 400) = 2989 part b answer: Excel = Norm.inv (0.95, 2500, 400) = 3158 ABC Sportswear company designs and sells wetsuits to the U.S. market. The designs of the wetsuits are updated each year. The process for updating the design typically starts in January the year before...
Please read the article and answer about questions. You and the Law Business and law are inseparable. For B-Money, the two predictably merged when he was negotiat- ing a deal for his tracks. At other times, the merger is unpredictable, like when your business faces an unexpected auto accident, product recall, or government regulation change. In either type of situation, when business owners know the law, they can better protect themselves and sometimes even avoid the problems completely. This chapter...