Question

In: Statistics and Probability

Mr. Beautiful, an organization that sells weight training sets, has an ordering cost of $40 for...

Mr. Beautiful, an organization that sells weight training sets, has an ordering cost of $40 for the BB-1 set (BB-1 stands for Body Beautiful Number 1). The carrying cost for BB-1 is $5 per set per year. To meet demand, Mr. Beautiful orders large quantities of BB-1 4 times a year. The stockout cost for BB-1 is estimated to be $10 per set. Over the past several years, Mr. Beautiful has observed the following demand during the lead time for BB-1:

Demand During Lead Time Probability
40 .1
50 .2
60 .2

70

.2
80 .2
90 .1

The reorder point for BB-1 is 60 sets. What level of safety stock should be maintained for BB-1?

The optimal quantity of safety stock which minimizes expected total cost is ____sets (enter your response as a whole number).

Solutions

Expert Solution

Ordering cost = $40 per set

Carrying cost = $5 per set per year

Stockout cost = $10er set

Number of orders per year = 4times

Formula to calculate Total cost = Stock out cost + Additional cost

Stockout cost = Number of units short*probability*stockout cost*number of request per year

Additional cost = number of units short * carrying cost per set

Reorder point = 60 sets

Here safety stock is zero

so the stockout cost = (10*0.2*10*4) + (20*0.2*10*4) + (30*0.1*10*4) = 80 + 160 + 120 = $360

Additional cost = no shortage units * $5 = $0

So total cost = $360 + $0 = $360

Safety stock at 10 sets short where these safety stock is added to ROP gives = 60+10 = 70 sets

Stockout cost = (10*0.2*10*4) + (20*0.1*10*4) = 80 + 80 = $160

Additional cost = 10 sets * $5 = $50

Total cost = $160 + $50 = $210

Safety stock at 20 sets short where safety stock is added to ROP gives = 60 + 20 = 80 sets

Stockout cost = (10*0.1*10*4) = $40

Additional cost = 20 sets * $5 = $100

Total cost = $40 + $100 = $140

Safety stock at 30 sets short where safety stock is added to ROP gives = 60 + 30 = 90 sets

Stockout cost = No shy of sets = $0

Additional cost = 30 sets * $5 = $150

Total cost = $0 + $150 = $150

From the above analysis the optimal quantity of safety stock which limits expected total cost is 80 sets.


Related Solutions

An organization has a goal to prevent the ordering of inventory quantities in excess of its...
An organization has a goal to prevent the ordering of inventory quantities in excess of its needs. One individual in the organization wants to design a control that requires a review of all purchase requisitions by a supervisor in the user department prior to submitting them to the purchasing department. Another individual wants to institute a policy requiring agreement of the receiving report and packing slip before storage of new inventory receipts. Which of these controls is (are) relevant in...
A company manufactures and sells x television sets per month. The monthly cost equation is?(?)=??,???+???and the...
A company manufactures and sells x television sets per month. The monthly cost equation is?(?)=??,???+???and the monthly demand−price equation is ?=???−???Use thisinformation to answerquestions below. 1.a.What is the maximum monthly revenue? b.What price should the company charge for each television set? 2.a.How many television sets should be produced to realize the maximum monthly profit? b.What is the maximum monthly profit
Rocky Mountain Tire Center sells 6,000 ​go-cart tires per year. The ordering cost for each order...
Rocky Mountain Tire Center sells 6,000 ​go-cart tires per year. The ordering cost for each order is ​$35​, and the holding cost is 40​% of the purchase price of the tires per year. The purchase price is ​$23 per tire if fewer than 200 tires are​ ordered, ​$17 per tire if 200 or​ more, but fewer than 5,000​, tires are​ ordered, and ​$14 per tire if 5,000 or more tires are ordered. ​ a) How many tires should Rocky Mountain...
Rocky Mountain Tire Center sells 14,000 ?go-cart tires per year. The ordering cost for each order...
Rocky Mountain Tire Center sells 14,000 ?go-cart tires per year. The ordering cost for each order is?$35 ?,and the holding cost is 50 ?% of the purchase price of the tires per year. The purchase price is ?$19 per tire if fewer than 200 tires are? ordered, ?$16 per tire if 200 or? more, but fewer than 5,000 ?,tires are? ordered, and ?$14per tire if 5,000 ?a) How many tires should Rocky Mountain order each time it places an? order?...
Rocky Mountain Tire Center sells 8,000 go-cart tires per year. The ordering cost for each order...
Rocky Mountain Tire Center sells 8,000 go-cart tires per year. The ordering cost for each order is $35, and the holding cost is 50% of the purchase price of the tires per year. The purchase price is $24 per tire if fewer than 200 tires are ordered, $19 per tire if 200 or more, but fewer than 5,000 tires are ordered, and $13 per tire if 5,000 or more tires are ordered. a. How many tires should Rocky Mountain order...
Rocky Mountain Tire Center sells 22,000 go-cart tires per year. The ordering cost for each order...
Rocky Mountain Tire Center sells 22,000 go-cart tires per year. The ordering cost for each order is $45, and the holding cost is 20% of the purchase price of the tires per year. The purchase price is $25 per tire if fewer than 500 tires are ordered, $20 per tire if 500 or more—but fewer than 1,000—tires are ordered, and $18 per tire if 1,000 or more tires are ordered. a. How many tires should Rocky Mountain order each time...
Rocky Mountain Tire Center sells 13,000 ?go-cart tires per year. The ordering cost for each order...
Rocky Mountain Tire Center sells 13,000 ?go-cart tires per year. The ordering cost for each order is ?$35?, and the holding cost is 30?% of the purchase price of the tires per year. The purchase price is ?$21 per tire if fewer than 200 tires are? ordered, ?$16 per tire if 200 or? more, but fewer than 5 comma 000?, tires are? ordered, and ?$14 per tire if 5,000 or more tires are ordered. ? a) How many tires should...
Rocky Mountain Tire Center sells 13,000 ?go-cart tires per year. The ordering cost for each order...
Rocky Mountain Tire Center sells 13,000 ?go-cart tires per year. The ordering cost for each order is ?$35?, and the holding cost is 30?% of the purchase price of the tires per year. The purchase price is ?$21 per tire if fewer than 200 tires are? ordered, ?$16 per tire if 200 or? more, but fewer than 5,000?, tires are? ordered, and ?$14 per tire if 5,000 or more tires are ordered. ?Rocky? Mountain's optimal order quantity is 5000 units...
Rocky Mountain Tire Center sells 13 comma 000 go-cart tires per year. The ordering cost for...
Rocky Mountain Tire Center sells 13 comma 000 go-cart tires per year. The ordering cost for each order is $35 , and the holding cost is 40 % of the purchase price of the tires per year. The purchase price is $22 per tire if fewer than 200 tires are ordered, $18 per tire if 200 or more, but fewer than 5 comma 000 , tires are ordered, and $16 per tire if 5 comma 000 or more tires are...
Archer Industries sells three different sets of sportswear. Sleek sells for $30 and has variable costs...
Archer Industries sells three different sets of sportswear. Sleek sells for $30 and has variable costs of $18; Smooth sells for $50 and has variable costs of $30; Potent sells for $70 and has variable costs of $45. The sales mix of the three sets is: Sleek, 50%; Smooth, 30%; and Potent, 20%.Instructionsa) What is the weighted-average unit contribution margin? b) The company’s total fixed costs are $1,700,000 per year, what is the total number of units that the company...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT