Question

In: Operations Management

In the planning of the monthly production for the next four months, in each month a...

In the planning of the monthly production for the next four months, in each month a company must operate either a normal shift or an extended shift (but not both) if it produces. It may choose not to produce in a month. A normal shift costs $100,000 per month and can produce up to 5,000 units per month. An extended shift costs $140,000 per month and can produce up to 7,500 units per month.

The cost of holding inventory is estimated to be $2 per unit per month (based on the average inventory held during each month) and the initial inventory is 3,000 units (i.e., inventory at the beginning of Month 1). The inventory at the end of month 4 should be at least 2,000 units. The demand for the company's product in each of the next four months is estimated to be as shown below:

Month

1

2

3

4

Demand

6000

6500

7500

7000

Production constraints are such that if the company produces anything in a particular month it must produce at least 2,000 units. The company wants a production plan for the next four months to meet its demands. Formulate an integer programming model to solve the problem at minimum cost.

Solutions

Expert Solution

Let,
xt = 1 if we operate a normal shift in month t (t=1,2,...,4)

   = 0 otherwise

yt = 1 if we operate an extended shift in month t (t=1,2,...,4)

   = 0 otherwise

Pt (>= 2000) be the amount produced in month t (t=1,2,...,4)

It be the closing inventory (amount of stock left) at the end

   of month t (t=1,2,...,4)

Constraints:

We can operate either normal or extended shift but not both

xt + yt <= 1    t=1,2,...,4

Constraint fro production limit

Pt <= 5000xt + 7500yt    t=1,2,...,4

No stockouts constraint

It >= 0    t=1,2,...,4

We know,

Closing stock = opening stock + production - demand

I0 = 3000. Assuming Dt = demand for the month t (t=1,2,...,4),

Assuming

  • opening stock in period t = closing stock in period t-1
  • production in period t is available to meet demand in period t

we get

It = It-1 + Pt - Dt t=1,2,...,4

inventory level at the end of month 4 should be at least 2000 units which gives

I4 >= 2000

Objective funtion:

Minimize (100000xt + 140000yt + 2It)


Related Solutions

Question 4 (25 marks):In the planning of the monthly production for the next four months, in...
Question 4 :In the planning of the monthly production for the next four months, in each month a company must operate either a normal shift or an extended shift (but not both) if it produces. It may choose not to produce in a month. A normal shift costs $100,000 per month and can produce up to 5,000 units per month. An extended shift costs $140,000 per month and can produce up to 7,500 units per month. The cost of holding...
A manufacturer of integrated circuits is planning production for the next four months. The forecast demand...
A manufacturer of integrated circuits is planning production for the next four months. The forecast demand for the circuits is shown in the following table. Circuit September October November December IC341 650 875 790 1100 IC256 900 350 1200 1300 At the beginning of September, the warehouse is expected to be completely empty. There is room for no more than 1,800 integrated circuits to be stored. Holding costs for both types is $0.05 per unit per month. Because workers are...
QDM Question 4 (25 marks): In the planning of the monthly production for the next four...
QDM Question 4 : In the planning of the monthly production for the next four months, in each month a company must operate either a normal shift or an extended shift (but not both) if it produces. It may choose not to produce in a month. A normal shift costs $100,000 per month and can produce up to 5,000 units per month. An extended shift costs $140,000 per month and can produce up to 7,500 units per month. The cost...
A stock price is currently $30. During each two-month period for the next four months it...
A stock price is currently $30. During each two-month period for the next four months it will increase by 8% or decrease by 10%. The risk-free interest rate is 4%. Use a two-step tree to calculate the value of a derivative that pays off [max(30-ST, 0)]2, where ST is the stock price in four months. If the derivative is American-style, should it be exercised early?
A company is planning its production schedule over the next six months (it is currently the...
A company is planning its production schedule over the next six months (it is currently the end of month 2). The demand (in units) for its product over that timescale is as shown below: Month 3 4 5 6 7 8 Demand 5000 6000 6500 7000 8000 9500 The company currently has in stock: 1000 units which were produced in month 2; 2000 units which were produced in month 1; 500 units which were produced in month 0. The company...
1) A) Marlow Company produces hand tools. A production budget for the next four months is...
1) A) Marlow Company produces hand tools. A production budget for the next four months is as follows: March 10,900 units, April 14,065, May 16,800, and June 21,200. Marlow Company’s ending finished goods inventory policy is 15% of the following month’s sales. Marlow plans to sell 16,700 units in May. What is budgeted ending inventory for March? 2,110 1,635 2,520 2,040 B) Jared Inc. produces leather handbags. The sales budget for the next four months is: July 5,500 units, August...
A stock price is currently $30. Each month for the next two months it is expected...
A stock price is currently $30. Each month for the next two months it is expected to increase by 8% or reduce by 10%. The risk-free interest rate is 5%. Use a two-step tree to calculate the value of a derivative that pays off [max(30 − ST ; 0)]2, where ST is the stock price in two months? If the derivative is American-style, should it be exercised early?
Ramos Co. provides the following sales forecast and production budget for the next four months. April...
Ramos Co. provides the following sales forecast and production budget for the next four months. April May June July Sales (units) 530 610 560 630 Budgeted production (units) 470 600 570 570 The company plans for finished goods inventory of 150 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 30% of next month’s production needs. Beginning direct...
Lubriderm Corporation has budgeted the following unit sales for the next four months: ​Month​​​ Unit Sales...
Lubriderm Corporation has budgeted the following unit sales for the next four months: ​Month​​​ Unit Sales ​ July​​​ 120,000 ​August​ ​​210,000 ​September​​ 150,000 ​October​​ 180,000 ​ Plans are to have an ending inventory of finished products that equals 20% of the unit sales for the next month. Five pounds of materials are required for each finished unit produced, and each pound of material costs $8. The desired ending inventory level for materials is equal to 30% of the materials needs...
Zira Co. reports the following production budget for the next four months. April May June July...
Zira Co. reports the following production budget for the next four months. April May June July Production (units) 654 695 687 667 Each finished unit requires five pounds of raw materials and the company wants to end each month with raw materials inventory equal to 30% of next month’s production needs. Beginning raw materials inventory for April was 981 pounds. Assume direct materials cost $3 per pound. Prepare a direct materials budget for April, May, and June. (Round your intermediate...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT