Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This question will have you calculating 2 EOQ and ROP values and interpreting the results. For both EOQ and ROP, give your final answer in

This question will have you calculating 2 EOQ and ROP values and interpreting the results.  For both EOQ and ROP, give your final answer in full sock sets (ROUND UP to the next whole number).  The specific questions to answer are based in parts a-c.  Tips to solve the EOQ and ROP are given below in bullet points.

A). Calculate EOQ and ROP for FY2017 based on the FY2017 forecast value, using the forecast method you selected in Q2 (Use exponential smooth)

B). Calculate the EOQ and ROP based upon actual demand for FY2017

C). Using the responses from parts a & b, indicate what the implications are for inventory management costs in FY2017.  In other words, compare the total costs for both EOQ values and analyze what it shows you.

See additional tips below:

-Use a service level of 95% (z=1.65) when calculating the ROP

-Calculate average weekly demand () by dividing the forecast by 50 weeks

-For the variance in weekly demand, use the data provided in the table on page 2 of the case with the FY2017 forecast for all approaches.

-Remember that there is a difference between variance and standard deviation and how you apply these values in the ROP formula

-Annual Inventory management costs will include the following: Annual Holding Costs, Annual Ordering Costs, and Purchase Cost.

Year

Demand

Weighed Moving Average Forecast

Exponential Forecast

2016

20,000

17,000

17,200

2017

23,000

19,500

19,720

2018

22,400

22,672

(0.8 x 23,000) + (0.2 x 20,000) = 22,400

(0.9 x 23,000) + [(1 - 0.9) x  19,720] = 22,672

*Cost per order = $350 * Holding cost per order= $5

Step by Step Solution

3.42 Rating (152 Votes )

There are 3 Steps involved in it

Step: 1

Lead time L 7 weeks Standard Deviation of lead time sigmaL 1 week Order cost S 350 Holding Cost H 5 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Systems analysis and design

Authors: kenneth e. kendall, julie e. kendall

8th Edition

135094909, 013608916X, 9780135094907, 978-0136089162

More Books

Students also viewed these Mathematics questions

Question

Define tangible costs and benefits. Give an example of each one.

Answered: 1 week ago

Question

Define the term critical path.

Answered: 1 week ago