Question: it will be solved with the matgematical model and the LP solution in Excel 4. The demand for an item over the next four quarters

it will be solved with the matgematical model and the LP solution in Excel

4. The demand for an item over the next four quarters is 300, 400, 450 and 250 units, respectively. The price per unit starts at $ 20 in the first quarter and increases by $ 2 each quarter thereafter. The supplier can provide no more than 400 units in any one quarter. Although we can take advantage of lower prices in early quarters, a storage cost of $ 3.5 is incurred per unit per quarter. In addition, the maximum number of units that can be held over from one quarter to the next cannot exceed 100. Develop the model to find the optimum schedule for purchasing the item to meet the demand

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!

ISYE 251- Operations Research I- Spring 2022 Semester Project and Instructions Notes: 1. Formulate the LP models carefully, considering all the information provided 2. The implementation of the model...

The solution of all the questions below should definitely be with the excel solver. You can also share photos of the actions you have done in the excel solver. A)Tooleo has contracted with AutoMate...

3 Use the Big M method and the two-phase method to nd the optimal solution to the following LP: max z 5x1 x2 s.t. 2x1 x2 6 s.t. x1 x2 4 s.t. x1 2x2 5 x1, x2 0 4 Use the simplex algorithm to nd the...

IE 311 Operations Research I, Summer 2020 Assignment 1 Due on 20 July 2020, Monday, 23:59 (thr KHAS Learn) YOU SHOULD ATTEMPT TO SOLVE ALL QUESTIONS TO RECEIVE A PASS (100%) or IT IS A FAIL (0%),...

operation researches Background: Poseidon Corporation is a sailboat producing company. The company needs to establish a plan for production for the next four quarters. The sailboat demand for the...

Background: Poseidon Corporation is a sailboat producing company. The company needs to establish a plan for production for the next four quarters. The sailboat demand for the first, second, third,...

This assignment is a Group work (use your project groups). Each group should submit only one soft copy which must be handwritten, using the cover page and template shared in the Moodle, otherwise...

Background: Poseidon Corporation is a sailboat producing company. The company needs to establish a plan for production for the next four quarters. The sailboat demand for the first second, third, and...

could you help please ?1-3 3 Saudi Air Navigat x Saudi Air NavigatX HW62-192 - 192 * Bb Microsoft Word X D esmos Scient...

11. (5 points) If the company is looking to increase the capacity of regular production for one of the quarters by 20 boats, which quarter do you recommend? Explain the reason. 12. (10 points) The...

What is the overhead flexible-budget variance?

Oak Grove Inc. has a petty cash fund of $1,500. (a) Since the petty cash fund is only $1,500, should Oak Grove Inc. implement controls over petty cash? (b) What controls, if any, could be used for...

The international capital market affects money markets in a number of different ways. Which below wh result of the international capital market? Reduced risk for lenders Expanded money supply for...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...