Retrieved from https://studentshare.org/information-technology/1650673-itec-assignment
https://studentshare.org/information-technology/1650673-itec-assignment.
Item Quantity ordered Safety stock Expected profit Expected lost sales Expected Leftover Inventory Expected fill rate In-stock probability: P(DQ)Out-of-stock probability: P(D>Q)124652.43652.41059806.688.65E-1414370.210.93470.0652230151.46151.42170599.292.87E-149830.260.92310.077321608.7608.7269892.66015600.370.87710.1229437446.65446.6351998.042.55E-1418900.410.8230.174156371.46871.4647785.953.06E-1612340.630.89540.333561072391223.942895.61.30E-2310900.690.9310.06971240971240.9719855.528.28E-249800.720.75750.
0244582298.64198.6422986.44.38E-429100.730.59980.0493342.14442.1463467.232.17E-178700.820.69080.3092106076.7576.7127549.931.21E-347900.920.9130.087TOTAL36328420412.914176837.31.41E-1311744N/AN/AN/ATable-1. Order quantities and inventory performance with current service level of 90% The manager should not use the same optimal service level for all products because: the products have different purchasing prices, the products have different standard deviations, the products are used by different kind of people, the products have different salvage values, products have different, sales prices, products have different seasons like those of summer while others do not have.
The products have different types therefore cannot have the same critical ratio.Big Girl winter boots should be the first product to be ordered. The second s to be ordered is the second to be ordered should be big boy winter boots as they are ranked second in profit expected. Toddler girl boot should be third as they fall under number three in profit generation.Toddler boy winter should follow because the product also yield is more profitable than toddler winter Girl. The next on ordering should be toddler winter girl because it has a high demand.
Toddler summer boy sandals should be ordered least as it is not profitable. Because it generates a lot of loss than other products.Based on my analysis, some products that can less ordered. This enables the firm to incur less holding cost. This also helps to reduce the risk of selling the products at salvage value, which may lead to losses to the firm. The ordering of fewer products also helps to reduce the ordering cost. Less order make it possible to sell them out easily and this can enable the firm to order once ordering level reaches.
Since the probability of the business incurring loss increases downwards, it is of great importance for the firm to place few orders.Newsvendor model is appropriate when buying seasonal products that can be out of stock after a short period like a day, week, or a month. It is more appropriate when overbooking customers such as newspapers on daily basis.Newsvendor model is useful at a time of selecting the best capacity for a machine of a factoryIt’s of more importance when setting stock levels for instance when the level is too high there is overstocking and when the level is too low then there is under stockingNewsvendor model is useful when making a last decision of a product in its life cycle.
This enables the manufacturers to buy in bulk of which when the stock is too large then they sell at salvage value.The newsvendor has a number of limitations:Under ordering and over ordering occur the decision makers instead of being wise, they end up being biased in ordering. Newsvendor model is therefore a building block that pools inventory.The model brings many conflicts between the retailers and wholesalers where by the retailers incur a lot of expense by paying a high fixed price.The manager wants to deviate from newsvendor simply because the products are seasonal, as they cannot last for long.
The products under news vender are at high risk of losing market and hence be sold vat salvage value. The products loose demand, as there is no brand loyal. The probability of the products under newsvendor is never constant; therefore, one cannot predict the future sales of the product.The products become obsolete after a very short time. This means that one can never find a more fashion product that can last.It is difficult to find an optimal quantity of a product under the model because of fluctuations.
There is a risk of buying more than demand at one selling period incurring over cost and buying sell than demand during selling period hence leading to under cost The demand of the products is not uniformly distributed this makes it hard for the manager to make future decision making for the business.ReferenceTrietsch, Dan. Optimal Feeding Buffers for Projects or Batch Supply Chains by an Exact Generalization of the Newsvendor Model. Auckland, N.Z: Dept. of Information Systems and Operations Management, University of Auckland, 2004. Print.
Read More