Question: PLEASE EXPLAIN ONLY USING EXCEL WITH FORMULAS AND SHOW THE EXCEL SHEET PLEASE! A product is ordered once each year, and the reorder point without

PLEASE EXPLAIN ONLY USING EXCEL WITH FORMULAS AND SHOW THE EXCEL SHEET PLEASE!

A product is ordered once each year, and the reorder point without safety stock (dL) is 100 units. Inventory carrying cost is $10 per unit per year, and the cost of a stockout is $50 per year. Given the following demand probabilities during the reorder period, how much safety stock should be carried?

DEMAND DURING REORDER PERIOD	PROBABILITY
0	.1
50	.2
ROP 100	.4
150	.2
200	.1

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!

PLEASE EXPLAIN ONLY USING EXCEL WITH FORMULAS AND SHOW THE EXCEL SHEET PLEASE! A product is ordered once each year, and the reorder point without safety stock (dL) is 100 units. Inventory carrying...

PLEASE EXPLAIN ONLY USING EXCEL WITH FORMULAS AND SHOW THE EXCEL SHEET PLEASE! Barbara Brown is the purchasing agent for Central Valve Company, which sells industrial valves and fluid-control...

need a solution to this question please 2. A product is ordered once each year, and the reorder point without safety stock (dL) is 100 units. Inventory carrying cost is $10 per unit per year, and the...

Hickory Manufacturing Company forecasts the following demand for a product ( in thousands of units ) over the next five years. Currently the manufacturer has seven machines that operate on a two -...

Please show the necessary steps in Excel. 1 A product is ordered once each year, and the reorder point without safety stock (dL) is 100 units. Inventory carrying cost is $10 per unit per year, and...

Authentic Thai rattan chairs are delivered to Gary schwartz's chain of retail stores, called the Kathmandu Shop, three times a year. The reorder point, without safety stock, is 200 chairs. Carrying...

2. What is the EOQ and reorder point with safety stock for Strike Disinfectant given your answer to question 1? 3. Compute the total order and inventory-holding costs for a fixed-quantity system...

Winner Apparel Case Study ( please refer Excel file: Winner Apparel Case Shell.xlsx ) , build the decision model and answer the following questions: a ) What is the expected order size in cycle 2 for...

Background ABC Electronics is a well - established company specializing in the production and distribution of high - quality electronic devices. As the company expands, it faces new challenges in...

A house wall consists of an outer layer of common brick 10 cm thick (k = 0.69 W/m0C), followed by a 1.25 cm layer of Celotex sheathing (k = 0.048 W/m-C). A 1.25 cm layer of sheetrock (k = 0.744...

A pollution control agency is considering the following regulatory policies: (i) Taxing the use of one input that increases pollution. (Other inputs affect pollution too, both increasing and...

Sarah, Sue, and AS Incorporated formed a partnership on May 1 , 2 0 0 9 9 , called SSAS. LP . Now that the partnership is formed, they must determine is appropriate year - end Sarah has a 3 0 percent...

Premise: Using a dictionary and list, create a set of key / value pairs that consists of a musical database. The key / value pairs should consist of Artist Name: Song Names pattern. For example, EACH...