Question: 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

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 2019. The sale price/unit for each product is listed below:

Product A	Product B	Product C	Product D
$220	$50	$5	$3

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. How should Jason classify the ABC products? 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, he found the lead time of orders has a variation for all these 4 products. Which ROP model should Jason implement? What are the reorder points for each of these 4 products for the first week of 2019?

ORDER HISTORY 2018 Order Received Date Week Date of Placing Order Product A Product B Product C Product D 1 1/2/2018 1/5/18 1 14/4/18 4/4/18 4/11/18 4/11/18 4/17/18 4/25/18 5/3/18 5/8/18 4/3/2018 4/8/18 4/10/2018 4/15/18 4/17/2018 4/22/18 4/24/2018 4/ 27 7/3/18 7/12/18 7/18/18 7/25/18 8/2/18 7/3/18 7/12/18 7/18/18 7/25/18 8/2/18 8/9/18 8/9/18 7/3/2018 7/10/18 7/10/2018 7/13/ 10/2/2018 10/8/18 10/9/2018 10/12/18 10/16/2018 10/22/18 10/23/2018 10/25/18 10/30/2018 11/4/18 11/6/2018 11/7/18 11/13/2018

ORDER HISTORY 2018 Order Received Date Week Date of Placing OrderProduct A Product B Product C Product D 1 1/2/2018 1/5/18 1/5/18 1/4/18 1/4/18 1/9/2018 1/15/18 1/11/18 1/11/18 1/11/18 3 1/16/2018 1/17/18 1/19/18 1/16/18 1/16/18 4 1/23/2018 1/25/18 1/25/18 1/24/18 1/24/18 1/30/2018 2/5/18 2/2/18 1/30/18 1/30/18 6. 2/6/2018 2/11/18 2/10/18 2/8/18 2/8/18 7 2/13/2018 2/17/18 2/17/18 2/13/18 2/13/18 2/20/2018 2/25/18 2/23/18 2/23/18 2/23/18 9. 2/27/2018 3/3/18 3/1/18 2/28/18 2/28/18 10 3/6/2018 3/11/18 3/9/18 3/8/18 3/8/18 11 3/13/2018 3/16/18 3/15/18 3/15/18 3/15/18 12 3/20/2018 3/26/18 3/23/18 3/21/18 3/21/18 13 3/27/2018 4/2/18 3/30/18 3/28/18 3/28/18

Step by Step Solution

★★★★★

3.39 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Ans Forecasting Here we choose Simple Moving Average 4month Model as lot of historical data is avail... View full answer

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 Accounting Questions!

The cast-iron bell-crank lever depicted in the figure is acted upon by forces F1 of 250 lbf and F2 of 333 lbf. The section A-A at the central pivot has a curved inner surface with a radius of ri = 1...

We do have standard procedures and rules and regulations. The underlying principle is to keep them to a minimum, and its about questioning why we need them. If theres a business reason why that is...

On October 1, 2010 Mardy Corporation issued 5%, 10-year bonds with a face value of $1,000,000 at 108 (a 4% yield). Interest is paid on October 1 and April 1, with any premiums or discounts amortized...

Carl, the president of the company acquired by RPZ Marketing, has agreed to be interviewed by the business columnist of the local newspaper on the topic of the decision to sell the company to RPZ....

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 2022. The sale price/unit for...

Mary is the manager of Alpha company in grocery industry. The major role of Alpha Company is working a grocery distributor though the company also produces some products. There are 4 products A, B, C...

I am having troubles doing this comparison of two companies. Im over thinking the work and need to get it simplified. I did most of the work just need you to check it over. Go to the Course Resources...

CURRENT ASSETS Refer to the notes to the financial statements. The first note, "Summary of Significant Accounting Policies," should provide information about the company's accounts receivables,...

The questions are provided in the document attached; the relevant files are attached as well. a. For 2015, was cash provided by, or used in, Operations? b. For 2015, is Kohl's net Cash Flow from...

I'm trying to develop Pro Forma financial statements (Balance Sheet and Income Statement) for the next two fiscal years, assuming a 10% growth rate in sales and Cost of Goods Sold (COGS) for each of...

Attached are both the full project description and the General Motors SEC report. 2-3pagesinglepagepaper,1inchmargins,12pt.font...

1. Describe the etiology of cancer development. 2

Bhaskar Ltd. forfeited 10 shares of Rs. 10 each, (Rs. 6 called up) issued at a discount of 10% to Dibendu on which he had paid Rs. 2 per share. Out of these, 8 shares were re- issued to Neeraj as Rs....

A compaty purchaved equiptent for $ 3 7 6 0 0 . The company paid $ 6 . 3 0 0 cauh and signed a nots payable for $ 3 1 0 0 0 . Prepare the comeound joursal entery to record this transaction. Journal...

Bernadette Rosen, a longtime client of yours, is an architect and the president of the local Rotary chapter. To keep up to date with the latest developments in her profession, she attends continuing...

1. Use descriptive statistics to summarize the data from this study. What are your preliminary conclusions about the independence of the response (Yes or No) and party affiliation for each of the...

A U.S. multinational corporation has divided its operations into several operating segments and has provided the following data for each segment: It is important to note that all purchases of goods...

Cyberdyne Systems and Virtucon are competitors focusing on the latest technologies, Selected financial data is provided below: Required: 1. Calculate the return on assets for both companies. 2....

Portions of the financial statements for Peach Computer are provided below. Required: Prepare the operating activities section of the statement of cash flows for Peach Computer using the indirect...

The ADDIE framework ensures that training programs: Question 2Answer a. Emphasize scheduling efficiency above content integrity b. Reflect only the personal learning styles of participants c....

Please Help! 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...

I need help on the Boulder Public School Case Study . There are three questions asked at the end of the case study. HBSP Product Number TCG239. Rev. Oct. 2015 THE CRIMSON PRESS CURRICULUM CENTER THE...

please help! Steps please so I can understand! 2. After building a scientific way for demand forecasting, Mary hoped Jason can propose the optimal inventory/ordering policies for these 4 products for...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Download the most recent financial statements of Medtronic and Boston Scientific.From the attached ratio sheet pick 6 relevant ratios and compare the two companies.Then from the ratios you selected...

what is the answer Cadbury smashed its campaign targets and enhanced engagement by being half its digital on Snapchat With pressure on a budgets, deciding where to spend your marketing dollars is as...