Question: I already have the moving average forecast I do not need that I need questions 1-3 to be answered through excel 2. After building a

I already have the moving average forecast I do not need that I need questions 1-3 to be answered through excel

I already have the moving average forecast I do not need that

I need questions 1-3 to be answered through excel 2. After building

a scientific way for demand forecasting, Mary hoped Jason can propose the

optimal inventory/ordering policies for these 4 products for the first week of 2020. The sale price/unit for each product is listed below: Jason decided to use ABC rule to classify these 4 products. ' A ' category product(s) will have the target service level of 95%. ' B ' product(s) will have the target service level 90% and ' C

2. After building a scientific way for demand forecasting, Mary hoped Jason can propose the optimal inventory/ordering policies for these 4 products for the first week of 2020. The sale price/unit for each product is listed below: Jason decided to use ABC rule to classify these 4 products. ' A ' category product(s) will have the target service level of 95%. ' B ' product(s) will have the target service level 90% and ' C ' products(s) will have the target service level 85%. After setting the appropriate service level, Jason will use the service level information to calculate the safety stock level for each product a) How should Jason classify the ABC products? (10 points) b) After classifying these 4 products, Jason wanted to use the ROP model for inventory/ordering management. He believed he would get an accurate demand forecasting for the first week of 2019. But based on the historical data. The attached spreadsheet document includes the order information for 2019. The company places the order of all products on each Wednesday. Jason found the lead time of orders has variations for all these 4 products. Which ROP model should Jason implement? (5 points) a) How should Jason classify the ABC products? (10 points) b) After classifying these 4 products, Jason wanted to use the ROP model for inventory/ordering management. He believed he would get an accurate demand forecasting for the first week of 2019. But based on the historical data. The attached spreadsheet document includes the order information for 2019. The company places the order of all products on each Wednesday. Jason found the lead time of orders has variations for all these 4 products. Which ROP model should Jason implement? (5 points) c) What are the reorder points for each of these 4 products for the first week of 2020? (30 points) Weekof2022123456789101112131415161718192021222324252627282930ProductWProductXProductYProductZ383738384042404345474649525151545152565454615860616363676564595458585861595956606158665660546860665961707261726869696667255256253253252262252255253252246247251244245251245249246242250243245243243236243240240238208207212205205213206208211208210210206209210211208211210210212209210217209218211213214210 303132333435363738394041424344454647484950515264637061696372746875717975828084838079838991836769657469757275687375707771787879767580818680238237235235232236233234233234232230229231221230227229228227229228223210216209212215216217210214212211217217212213214216218214216222219221 Rata at Dapaisionathan hedar 282930313233343536373839404142434445464748495051527/10/20227/17/20227/24/20227/31/20228/7/20228/14/20228/21/20228/28/20229/4/20229/11/20229/18/20229/25/202210/2/202210/9/202210/16/202210/23/202210/30/202211/6/202211/13/202211/20/202211/27/202212/4/202212/11/202212/18/202212/25/20227/13/20227/19/20227/27/20228/8/20228/13/20228/17/20228/26/20229/4/20229/9/20229/18/20229/23/20229/28/202210/8/202210/12/202210/22/202210/25/202211/4/202211/7/202211/19/202211/21/202212/1/202212/9/202212/13/202212/23/202212/28/20227/11/20227/19/20227/26/20228/2/20228/10/20228/16/20228/23/20229/1/20229/8/20229/14/20229/20/20229/29/202210/5/202210/13/202210/17/202210/25/202211/2/202211/8/202211/15/202211/23/202211/29/202212/7/202212/13/202212/21/202212/28/20227/12/20227/18/20227/25/20228/2/20228/9/20228/15/20228/23/20228/30/20229/5/20229/12/20229/19/20229/26/202210/2/202210/11/202210/18/202210/23/202210/30/202211/6/202211/15/202211/21/202211/29/202212/5/202212/12/202212/19/202212/27/20227/12/20227/18/20227/24/20228/2/20228/9/20228/15/20228/23/20228/30/20229/5/20229/12/20229/19/20229/26/202210/2/202210/11/202210/18/202210/23/202210/30/202211/6/202211/15/202211/21/202211/29/202212/5/202212/12/202212/19/202212/27/2022 Sales infromation of the new product E Weekof2022123456789101112131415161718192021222324252627282930SalesofProductEN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A1544159716611713 232425262728293031323334353637383940414243444546474849505152N/AN/AN/AN/A15441597166117031746180218501902195020032043209721602202224622952349239724502499255026032648269127542808

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!

Moving Average Forecasting Use the area below to draw a line chart for the three-period moving average Periods in moving average 3 . Error Error2 Formulas Time Period 1 2 3 4 5 F Demand Forecast 83...

This is all that is provided for the question MGTS352 Formative Assignment 2 ER Visits A regional hospital is interested in learning more about the pattern of visits to the ER. They have special...

Discussion Board Week 3 "Managing in the Global Economy and Outsourcing Offshore" Using Techniques to Forecast Variables of Interest to Business and Foreign Exchange During the Weekly Scenarios Herb...

Question: Evaluate the two forecasting models described in the case for predicting daily check-in volume. What are the strengths and weaknesses of each one? Do you find any of the results surprising?...

Updated question: A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to...

Discussion Board 4 Production Economics and Decisions...

MBA 6300 online Homework Assignment #4 Forecasting Models Instructions: After the student calculates the answers to this homework he/she must submit the answers by placing them in the Assignment # _...

Question 1 Answer saved Marked out of 5 Flag question Question text Which of the following is not correct about demand forecasting? Select one: a. Helps in the managerial decision making b. Predicts...

Instructions Respond to the following questions, and provide as much detail as possible. You will submit this assignment as a Microsoft Excel report. The first title tab must include your name and...

Save Submit Assignment for Grading Problem 9:39 Algo Statistical Forecasting Models) Question of Hint(s) Check My Work Spreadsheet A restaurant wants to forecast its weekly scales. Miestonical data...

Dr. Amara has twins who would be going to college in the next 8 years. She hopes to save enough in order to be able to pay for her kids' college expenses. It is estimated that she would need $1...

Explain how featherbedding and other restrictive work practices can reduce labor productivity. Why might strikes reduce the economys output less than the loss of production by the struck firms?

Which of the following are NOT considered contingencies in the Residential Purchase Agreement ( RPA ) ? Group of answer choices Obtaining the down payment All answers are correct Obtaining the...

2. The force of interest 8 is a function of time and at any time t, measured in years, is given by the formula: 8(t) = 0.02 +0.0020 8(t) = 0.03 +0.005t Osts5 5 st s 10 a) Calculate the discount...