QUESTION 5 LA local firm is planning its workforce and production levels over the next year. The firm makes a variety of microprocessors and uses sales dollars as its aggregate production unit. Based on orders received and sales forecasts provided by the marketing department, the estimate of dollar sales for the next year by month is as follows: Predicted Predicted Demand Production Demand Production Month Days (in $10,000) | Month Days (in $10,000) January February 22 340 July August September 24 375 16 380 12 310 March 21 220 19 175 April May 19 100 October 22 145 23 490 November 20 120 June 20 625 December 16 165 Inventory holding costs are based on a 25% annual interest charge. It is anticipated that there will be 675 workers on the payroll at the end of the current year and inventories will amount to $120,000. The firm would like to have at least $100,000 of inventory at the end of December next year. It is estimated that each worker accounts for an average of $60,000 of production per year (assume that one year consists of 250 working days). The cost of hiring a new worker is $200, and the cost of laying off a worker is $400. a. Assuming that shortages are not allowed, determine the minimum constant workforce that the company will need over the next year. b. Evaluate the total cost of the constant workforce plan found in part (a). c. Formulate this problem as a linear program. d. Solve the problem. Round the variables in the resulting solution and determine the cost of the plan you obtain.
QUESTION 5 LA local firm is planning its workforce and production levels over the next year. The firm makes a variety of microprocessors and uses sales dollars as its aggregate production unit. Based on orders received and sales forecasts provided by the marketing department, the estimate of dollar sales for the next year by month is as follows: Predicted Predicted Demand Production Demand Production Month Days (in $10,000) | Month Days (in $10,000) January February 22 340 July August September 24 375 16 380 12 310 March 21 220 19 175 April May 19 100 October 22 145 23 490 November 20 120 June 20 625 December 16 165 Inventory holding costs are based on a 25% annual interest charge. It is anticipated that there will be 675 workers on the payroll at the end of the current year and inventories will amount to $120,000. The firm would like to have at least $100,000 of inventory at the end of December next year. It is estimated that each worker accounts for an average of $60,000 of production per year (assume that one year consists of 250 working days). The cost of hiring a new worker is $200, and the cost of laying off a worker is $400. a. Assuming that shortages are not allowed, determine the minimum constant workforce that the company will need over the next year. b. Evaluate the total cost of the constant workforce plan found in part (a). c. Formulate this problem as a linear program. d. Solve the problem. Round the variables in the resulting solution and determine the cost of the plan you obtain.
Elements Of Electromagnetics
7th Edition
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Sadiku, Matthew N. O.
ChapterMA: Math Assessment
Section: Chapter Questions
Problem 1.1MA
Related questions
Question
Q5

Transcribed Image Text:C.
QUESTION 5
A local firm is planning its workforce and production levels over the next year. The firm makes a
variety of microprocessors and uses sales dollars as its aggregate production unit. Based on
orders received and sales forecasts provided by the marketing department, the estimate of dollar
sales for the next year by month is as follows:
Predicted
Predicted
Demand
(in $10,000) | Month
Production
Production
Demand
Month
Days
Days
(in $10,000)
January
22
340
July
24
375
February
16
380
August
12
310
March
21
220
September
19
175
April
19
100
October
22
145
May
23
490
November
20
120
June
20
625
December
16
165
Inventory holding costs are based on a 25% annual interest charge. It is anticipated that there will
be 675 workers on the payroll at the end of the current year and inventories will amount to
$120,000. The firm would like to have at least $100,000 of inventory at the end of December
next year. It is estimated that each worker accounts for an average of $60,000 of production per
year (assume that one year consists of 250 working days). The cost of hiring a new worker is
$200, and the cost of laying off a worker is $400.
a. Assuming that shortages are not allowed, determine the minimum constant workforce that the
company will need over the next year.
b. Evaluate the total cost of the constant workforce plan found in part (a).
c. Formulate this problem as a linear program.
d. Solve the problem. Round the variables in the resulting solution and determine the cost of the
plan you obtain.
Expert Solution

Step 1
Solution:
Prepare the table as shown below:
Month | Number of Working days | Demand Forecasting | Units per worker | Cumulative units per worker | Cumulative net demand | Minimum workers | Monthly production | Cumulative production | Inventory |
January | 22 | 340 | 0.528 | 0.528 | 328 | 622 | 410.256 | 410.256 | 82.256 |
February | 16 | 380 | 0.384 | 0.912 | 708 | 777 | 298.368 | 708.624 | 0.624 |
March | 21 | 220 | 0.504 | 1.416 | 928 | 656 | 391.608 | 1100.232 | 172.232 |
April | 19 | 100 | 0.456 | 1.872 | 1028 | 550 | 354.312 | 1454.544 | 426.544 |
May | 23 | 490 | 0.552 | 2.424 | 1518 | 627 | 428.904 | 1883.448 | 365.448 |
June | 20 | 625 | 0.48 | 2.904 | 2143 | 738 | 372.96 | 2256.408 | 113.408 |
July | 24 | 375 | 0.576 | 3.48 | 2518 | 724 | 447.552 | 2703.96 | 185.96 |
August | 12 | 310 | 0.288 | 3.768 | 2828 | 751 | 223.776 | 2927.736 | 99.736 |
September | 19 | 175 | 0.456 | 4.224 | 3003 | 711 | 354.312 | 3282.048 | 279.048 |
October | 22 | 145 | 0.528 | 4.752 | 3148 | 663 | 410.256 | 3692.304 | 544.304 |
November | 20 | 120 | 0.48 | 5.232 | 3268 | 625 | 372.96 | 4065.264 | 797.264 |
December | 16 | 165 | 0.384 | 5.616 | 3443 | 614 | 298.368 | 4363.632 | 920.632 |
Trending now
This is a popular solution!
Step by step
Solved in 4 steps

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, mechanical-engineering and related others by exploring similar questions and additional content below.Recommended textbooks for you

Elements Of Electromagnetics
Mechanical Engineering
ISBN:
9780190698614
Author:
Sadiku, Matthew N. O.
Publisher:
Oxford University Press

Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:
9780134319650
Author:
Russell C. Hibbeler
Publisher:
PEARSON

Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:
9781259822674
Author:
Yunus A. Cengel Dr., Michael A. Boles
Publisher:
McGraw-Hill Education

Elements Of Electromagnetics
Mechanical Engineering
ISBN:
9780190698614
Author:
Sadiku, Matthew N. O.
Publisher:
Oxford University Press

Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:
9780134319650
Author:
Russell C. Hibbeler
Publisher:
PEARSON

Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:
9781259822674
Author:
Yunus A. Cengel Dr., Michael A. Boles
Publisher:
McGraw-Hill Education

Control Systems Engineering
Mechanical Engineering
ISBN:
9781118170519
Author:
Norman S. Nise
Publisher:
WILEY

Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:
9781337093347
Author:
Barry J. Goodno, James M. Gere
Publisher:
Cengage Learning

Engineering Mechanics: Statics
Mechanical Engineering
ISBN:
9781118807330
Author:
James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:
WILEY