Question: Operations/Supply Chain Management Question If using Excel, please show the formulas used, as well as any other tools/add-ons. 3. Develop the inventory profile of EOQ

Operations/Supply Chain Management Question

If using Excel, please show the formulas used, as well as any other tools/add-ons.

3. Develop the inventory profile of EOQ model for 12 days where lead time 3 days, usage rate 80 units/day and EOQ is 400 units. What is ROP and inventory on day 12 ? A) Draw the EPQ diagram with run time is 5 days and cycle time is 8 days. Find the maximum inventory if the production rate is 80 units and usage rate is 50 units. B) How much you can save if you use EOQ instead of any other quantity? Explain it with the diagram. Assume all the necessary values

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!

Could you please solve using EXCEL and show the formulas. Case Study Smartphone Production at QuickTronics Rudy Hartono, general manager at QuickTronics, a contract manufacturer for consumer...

Please provide detailed explainations for methods, Analysis and results and recommendations and conslusions. Thank you. VF Brands: Global Supply Chain Strategy It was August 2009. Chris Fraser,...

Please provide detailed explanations for introduction, background, methods, analyis and results and recommendations and conclusions. VF Brands: Global Supply Chain Strategy It was August 2009. Chris...

Please help me to answer the following file ............................................................................................... INVESTMENT AND PORTFOLIO MANAGEMENT COURSE ASSESSMENT 1...

please if you can do it thru excel and show the formulas you used to get it the answers Home Baseball card emporium students temples Compatibility Mode] Insert Page Layout Formules Data Review View...

Seven years ago, after 15 years in public accounting, Stanley Booker, CPA, resigned his position as manager of cost systems for Davis, Cohen, and O'Brien Public Accountants and started Track...

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

Hello tutor Please find the attached instruction file and use the template for solving this question. If you have any question about the problem please contact me. Thanks Your Course Project...

The instructions are attached in the Division Performance Evaluation Division Performance Evaluation Project Using Excel In this assignment you will analyze the performance of PepsiCo or Marriott's...

Lila Harrison's is the sole employee of ABC Grocers. Her gross pay for the week was $400. She had deductions of $50 for federal income tax, $25 for social security tax, and $5.80 for Medicare tax....

Give two reasons audit work on cash is likely to be more extensive than might appear to be justified by the relative amount of the balance sheet figure for cash.

Question 4 2 1 . 7 pts What are the three basic sales tasks? order closing, order operine, and sales promoting. order - taking missionary selline, and onder evettine order - takine, onder - managins,...

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...