Question: in excel 2 . Weekly demand for a product is 2 5 0 units with a standard deviation of 6 0 units ( assume 5

in excel 2. Weekly demand for a product is 250 units with a standard deviation of 60 units (assume 52 weeks per year). Lead-time is 3 weeks. Calculate the safety stock and the reorder point for 98 percent service level.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

BOTT-UTE Inc. sells an awesome product. Their supplier requires 6 weeks for delivery. The product costs 4TL per unit. Fixed costs of ordering is 75TL and holding one unit for a year costs 0.8 TL per...

Q:

BOTT-UTE Inc. sells an awesome product. Their supplier requires 6 weeks for delivery. The product costs 4TL per unit. Fixed costs of ordering is 75TL and holding one unit for a year costs 0.8 TL per...

Q:

BOTT-UTE Inc. sells an awesome product. Their supplier requires 6 weeks for delivery. The product costs 4TL per unit. Fixed costs of ordering is 75TL and holding one unit for a year costs 0.8 TL per...

Q:

this is about production system. Topic is inventory managment under uncertainty. BOTT-UTE Inc. sells an awesome product. Their supplier requires 6 weeks for delivery. The product costs 4TL per unit....

Q:

A store has collected the following information on one of its products:Demand = 4 5 0 0 units / yearStandard deviation of weekly demand = 1 2 unitsOrdering costs = $ 4 0 / orderHolding costs = $ 3 /...

Q:

Answer the following. Assignment 10 . LIM MAPS . . Suppose Sam's Club, Operates 500 stores Sells Garmin GPS at $100 at each store Assume cost of Garmin GPS is $100 Uses continuous review policy...

Q:

The chair of the operations management department at Quality University wants to construct a control-chart for determining whether the four faculty teaching the basic OM course are in control with...

Q:

Component Commonality (Demand Aggregation) Product 1: weekly demand is normally distributed with: - Mean = 60 units per week Standard deviation = 40 units per week Product 2: weekly demand is...

Q:

only answer q2 and q3 Component Commonality (Demand Aggregation) Product 1: weekly demand is normally distributed with: - Mean = 60 units per week Standard deviation = 40 units per week Product 2:...

Q:

Please put in EXCEL format 1. Apply ABC analysis for the following items: Item Number Item Cost (5) 4.0 1.5 0.25 2.0 A111 B111 C111 D111 E111 F111 G111 H111 I111 J111 K111 L111 Annual Usage (Unit)...

Q:

The power company must generate 100 kW in order to supply an industrial load with 94 kW through a transmission line with 0.09  resistance. If the load power factor is 0.83 lagging, find the...

Q:

What are the four financial objectives? What do they mean?

Q:

E 3 - 2 5 ( Algo ) Recording Manufacturing Costs in Process Costing [ LO 3 - S 1 ] Sereno Company makes pi atas for children s birthday parties. Information for Sereno s last six months of operation...

Q:

If gross profit is 25% of sales, the COGS is 45,000. The administrative expenses are 3000, selling and distribution expenses are 2000, interest 5000 and tax rate is 30%. What will be the amount of...