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...

:1 (03) Find the equation of the Line passing through (2,1) and (9,5) CS (@) y+ = = = = = (x+) 4 2) (1) Y+ = = (x-2) () y-1 = 2/7 (x-2) (1) 3-1 = $(x-2)

Classify the accounts below: A, L, OE, R, E, COE, or CA. Account Title Classification Financial Statement Capital Advertising Expense Debit Credit Fees Earned Prepaid Rent Equipment Accumulated...

The sales level at which total sales equal total costs, resulting in zero income, is called: Multiple Choice Retevant range. Margin of safety. Step whe variable level. Break - even poirt....

Note: This problem is for the 2018 tax year. Daniel B. Butler and Freida C. Butler, husband and wife, file a joint return. The Butlers live at 625 Oak Street in Corbin, KY 40701. Dan's Social...