Question

In order to effectively address the seasonal variation appearing in the annual demand of its products,a...

In order to effectively address the seasonal variation appearing in the annual demand of its products,a bicycle manufacturer starts an aggregate planning.A planning hori- zon of 6 months is used. The (aggregate) demand forecast for the next six months along the number of working days are given below:

Month Demand Forcast Number of Working Days
Jan 1800 22
Feb 1500 19
Mar 1100 21
apr 900 21
may 1100 22
june 1600 20

If the manufacturer operates 300 days a year with 50 workers, the annual output is 30000 bicycles.Production costs are fixed over the coming planning horizon and thus can be ig- nored. Inventory holding cost is $5 per unit.At the beginning of each month, workers can be hired or fired. Hiring cost is $350 per worker and firing cost is $500 per worker.Wages of worker is $20 per hour per worker eight hours per day for regular workers.Overtime cost is $30 per worker per hour. The number of units a worker can produce in overtime is same as the number he produces in regular time.At the beginning of January, the number of workers is 40 and the inventory in hand is 560.Formulate a linear programming problem to minimize the total cost for the company for the next 6 months.

Homework Answers

Answer #1

Productivity per worker per day = Annual output / (Number of workers * Number of days per year) = 30000/(50*300) = 2 units per worker per day

Considering 8 hours per day, it takes 4 hours to produce per unit. Regular production cost per unit = 20*4 = 80

Overtime cost per unit = 30*4 = 120

______________________________

LP model is following

Let Hi, Fi, and Wi be the number of workers hired, fired and working in month i

Oi be the number of units produced in overtime in month i

Vi be the inventory in month i

Min 350(H1+H2+H3+H4+H5+H6)+500(F1+F2+F3+F4+F5+F6)+5(V1+V2+V3+V4+V5+V6)+20*8*(22W1+19W2+21W3+21W4+22W5+20W6)+30*4*(O1+O2+O3+4+O5+O6)

s.t.

W1-H1+F1 = 40

W2-W1-H2+F2 = 0

W3-W2-H3+F3 = 0

W4-W3-H4+F4 = 0

W5-W4-H5+F5 = 0

W6-W5-H6+F6 = 0

22*2*W1+O1-V1 = 1800-560

19*2*W2+O2-V2+V1 = 1500

21*2*W3+O3-V3+V2 = 1100

21*2*W4+O4-V4+V3 = 900

22*2*W5+O5-V5+V4 = 1100

20*2*W6+O6-V6+V5 = 1600

O1 <= 22*2*W1

O2 <= 19*2*W2

O3 <= 21*2*W3

O4 <= 21*2*W4

O5 <= 22*2*W5

O6 <= 20*2*W6

All variables >= 0

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
QUESTION 2: Kafue Steel has recorded the monthly forecast for one of its products, mild steel...
QUESTION 2: Kafue Steel has recorded the monthly forecast for one of its products, mild steel grade AISI 1023 rods, for January, February, March and April as 1000, 1500, 1200, and 1400, respectively. Safety stock policy recommends that half of the forecast for that month be defined as safety stock. There are 22 working days in January, 19 in February, 21 in March and 21 in April. Beginning inventory is 500 units. Manufacturing cost is K1,000,000 per unit, storage cost...
Suppose you have been given responsibility for developing the six-month aggregate production plan at Soda Galore,...
Suppose you have been given responsibility for developing the six-month aggregate production plan at Soda Galore, a manufacturer of soft drinks. Your company makes three types of soft drinks: regular, diet, and super-caffeinated. Fortunately, all three types are made using the same production process, and the costs related to switching between the three types are so minimal that they can be ignored. Thus, you can treat your problem as an aggregate planning exercise where the planning unit is cases of...
Develop a production plan and calculate the annual cost for a firm whose demand forecast is...
Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 10,000; winter, 8,000; spring, 7,000; summer, 12,000. Inventory at the beginning of fall is 500 units. At the beginning of fall, you have 30 workers. It is not possible to hire any additional workers until next Summer, at which time temporary workers will be hired at the beginning of Summer and laid off at the end of Summer. Therefore, no hiring or laying...
Trexoid Inc. makes a popular video game console. Demand varies each month, with highest demand coming...
Trexoid Inc. makes a popular video game console. Demand varies each month, with highest demand coming in the last quarter of the year. Regular production costs are $250 per unit and inventory carrying cost is $3 per unit per quarter. Overtime production cost is $280 per unit. Assume that the 20 current Trexoid employees can produce a total of 30,000 units per quarter in regular production and can work enough overtime hours to produce the amount required if a chase...
Neal Industries manufactures blue jeans for the teen market. The S&OP team has agreed upon a...
Neal Industries manufactures blue jeans for the teen market. The S&OP team has agreed upon a demand forecast for the following year, as shown below. The company begins with 1,800,000 jeans in safety stock and desires to maintain this level consistently (and end with this level), assume that the overtime production wage rate is $24 per hour. Quarter Demand 1 7,500,000 2 8,300,000 3 15,000,000 4 12,500,000 Current workforce 300 workers Average output per worker 25,000 jeans per quarter Inventory...
Develop a production schedule to produce the exact production requirements by varying the workforce size for...
Develop a production schedule to produce the exact production requirements by varying the workforce size for the following problem. The monthly forecasts for Product X for January, February, and March are 950, 1,510, and 1,220, respectively. Safety stock policy recommends that half of the forecast for that month be defined as safety stock. There are 22 working days in January, 19 in February, and 21 in March. Beginning inventory is 550 units. Storage cost is $4 per unit per month...
Aggregate Planning A key hospital supplier, IVs Plus (IVP) located in Salina, KS sells IV tubing...
Aggregate Planning A key hospital supplier, IVs Plus (IVP) located in Salina, KS sells IV tubing and stands to hospitals and clinics. Sales have picked up ever since they introduced their newest “Squeaky Clean” IV stand, which eliminates all oils and germs left behind by users. Though IVP sells these stands all year long, they sell the most during the summer months, when end-of-fiscal year purchases are at a peak. The demand over the next 12 months is shown in...
Question 4: Aggregate Planning Plan production for a four month period: June through to September. For...
Question 4: Aggregate Planning Plan production for a four month period: June through to September. For June and July you should produce to exact demand forecast. For August and September you should use overtime and inventory with a stable workforce. Stable means the number of workers needed for July will be held constant through September. However the Ministry of Labour regulations put a maximum of 5000 hours of overtime labour per month in August and September (Zero overtime in June...
Plan production for a four-month period: February through May. For February and March, you should produce...
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders...
Plan production for a four-month period: February through May. For February and March, you should produce...
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders...