Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the same production equipment, and the objective is to meet the demands for the three products using overtime where necessary. The deman forecast for the next four months, in hours required to make each product is: PRODUCT B APRIL 860 660 760 MAY 660 760 560 Objective value JUNE 860 960 760 Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is mad and carried in Inventory to meet future demand. Each hour's production carried into future months costs $3 per production hour for A $4 for B, and $5 for C. APRIL 1,560 760 Production can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A, $5 for B, and $6 for C. The overtime premium is 50 percent of the regular time cost per hour. The number of production hours available for regular time and overtime is JULY 1,260 1,060 910 MAY 1,370 710 Regular time Overtime JULY 2,000 950 Calculate the objective value using Excel Solver. (Do not round Intermediate calculations.) JUNE 1,860 1,050
Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the same production equipment, and the objective is to meet the demands for the three products using overtime where necessary. The deman forecast for the next four months, in hours required to make each product is: PRODUCT B APRIL 860 660 760 MAY 660 760 560 Objective value JUNE 860 960 760 Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is mad and carried in Inventory to meet future demand. Each hour's production carried into future months costs $3 per production hour for A $4 for B, and $5 for C. APRIL 1,560 760 Production can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A, $5 for B, and $6 for C. The overtime premium is 50 percent of the regular time cost per hour. The number of production hours available for regular time and overtime is JULY 1,260 1,060 910 MAY 1,370 710 Regular time Overtime JULY 2,000 950 Calculate the objective value using Excel Solver. (Do not round Intermediate calculations.) JUNE 1,860 1,050
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter12: Queueing Models
Section: Chapter Questions
Problem 59P
Related questions
Question
![Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the same
production equipment, and the objective is to meet the demands for the three products using overtime where necessary. The demand
forecast for the next four months, in hours required to make each product is:
PRODUCT
A
B
с
APRIL
860
660
760
Objective value
MAY
660
760
560
JUNE
860
960
760
Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is made
and carried in Inventory to meet future demand. Each hour's production carried into future months costs $3 per production hour for A,
$4 for B, and $5 for C.
APRIL
1,560
760
Production can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A, $5
for B, and $6 for C. The overtime premium is 50 percent of the regular time cost per hour.
The number of production hours available for regular time and overtime is
JULY
1,260
1,060
910
MAY
1,370
710
JUNE
1,860
1,050
Regular time
Overtime
JULY
2,000
950
Calculate the objective value using Excel Solver. (Do not round intermediate calculations.)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6fbe9e81-722f-4ad4-9005-d8a79ebc5cae%2Fba752cd1-6e59-4b3d-89c8-b3cfde0afe6e%2Fxll1ldp_processed.png&w=3840&q=75)
Transcribed Image Text:Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the same
production equipment, and the objective is to meet the demands for the three products using overtime where necessary. The demand
forecast for the next four months, in hours required to make each product is:
PRODUCT
A
B
с
APRIL
860
660
760
Objective value
MAY
660
760
560
JUNE
860
960
760
Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is made
and carried in Inventory to meet future demand. Each hour's production carried into future months costs $3 per production hour for A,
$4 for B, and $5 for C.
APRIL
1,560
760
Production can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A, $5
for B, and $6 for C. The overtime premium is 50 percent of the regular time cost per hour.
The number of production hours available for regular time and overtime is
JULY
1,260
1,060
910
MAY
1,370
710
JUNE
1,860
1,050
Regular time
Overtime
JULY
2,000
950
Calculate the objective value using Excel Solver. (Do not round intermediate calculations.)
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,