Question: please solve using excel Supply Planning Item 1234 has the following characteristics: Average Weekly demand of 160 units Standard Deviation of Weekly demand of 100

please solve using excel please solve using excel Supply Planning Item

Supply Planning Item 1234 has the following characteristics: Average Weekly demand of 160 units Standard Deviation of Weekly demand of 100 units Replenishment lead time of 6 weeks Cost of Holding Inventory is 20% Unit Cost is $10 Order Cost is $5 Safety Stock Questions Q1. How much safety stock is required to achieve a service level of 95%? 98%? 99%? Q2. What is the safety stock in terms of weeks of coverage? Economic Order Quantity Questions Q3. Based on the information above, what is the EOQ for item 1234? Q5. What is the average inventory of the cycle stock? Q6. What are the weeks of coverage of the EOQ? Reorder Point Q7. What is the Reorder Point level for this product, using the safety stock for 95% service, the calculated EOQ and other information provided

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!

Show the answers through Excel please!( please do not copy what is already posted in Chegg!!Thank you! Item 1234 has the following characteristics: Average Weekly demand of 160 units Standard...

Please answer in an excel sheet. Item 1234 has the following characteristics: Average Weekly demand of 160 units; Standard Deviation of Weekly demand of 100 units; Replenishment lead time of 6 weeks;...

Item 1234 has the following characteristics: Average Weekly demand of 160 units Standard Deviation of Weekly demand of 100 units Replenishment lead time of 6 weeks Cost of Holding Inventory is 20%...

Item 1 2 3 4 has the following characteristics: Average Weekly demand of 1 6 0 units Standard Deviation of Weekly demand of 1 0 0 units Replenishment lead time of 6 weeks Cost of Holding Inventory is...

Please show work and complete in excel or a chart if possible. Given this information: Average weekly demand =100 units. Standard deviation =10 units. Lead time =6 weeks . Acceptable stockout risk...

Item XYZ has the following characteristics: Average Weekly demand of 160 units Standard Deviation of Weekly demand of 100 units Replenishment lead time of 6 weeks Cost of Holding Inventory is 20%...

12-2. BASIC EPQ QUESTION: A company is about to begin production of a new product. The manager of the department that will produce one of the components for the product wants to know how often the...

A 10-kg block on a horizontal frictionless surface is attached to a light spring (force constant = 1.2 kN/m). The block is initially at rest at its equilibrium position when a force (magnitude P )...

Under the perpetual inventory system, two journal entries are used to record the sale of merchandise. One entry records the Sales Revenue and another entry records the Cost of Goods Sold. True of...

Maria is a single taxpayer who files on a calendar - year basis. By April 1 5 , 2 0 2 5 , she estimates that she owes $ 2 , 0 0 0 in federal income tax for the 2 0 2 4 tax year. Although she Isn't...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...