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 APRIL МAY JUNE JULY 1,170 1,070 A 770 570 770 570 670 870 670 470 670 820 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. 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 APRIL МAY JUNE JULY Regular time Overtime 1,470 1,300 1,770 1,950 670 620 870 990 Calculate the objective value using Excel Solver. (Do not round intermediate calculations.) Objective value

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 APRIL МAY JUNE JULY 1,170 1,070 A 770 570 770 570 670 870 670 470 670 820 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. 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 APRIL МAY JUNE JULY Regular time Overtime 1,470 1,300 1,770 1,950 670 620 870 990 Calculate the objective value using Excel Solver. (Do not round intermediate calculations.) Objective value

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

True or false when telephoning a patient about a deliquent account you may leave a detailed message on answering machine at patients residence
A company handbook states that employees will be given warnings for three instances of arriving late for work, after which they will be fired. An employee is fired after being late for the first time. Which of the exceptions to at-will employment could apply?
Identify and describe a queueing system of interest
Answer C only. Tim Woods, a recent GMU MBA grad and serial entrepreneur, has opened Pets-R-awesOMe, an online pet store. He and his team are experimenting with call center staffing. A. The current call center format has two lines: one for customers who want to place an order and one for customers who want to report a problem. Each line is served by one specialized customer service representative. The call center is staffed so that at any given time, there is one representative taking customer orders and one representative addressing customer problems. On average, there is a new customer who wants to place an order every two minutes, exponentially distributed. Similarly, there is a new customer needing to address a problem every two minutes, exponentially distributed. The call center staffers are fast and can on average complete one call of either type in 75 seconds, with a standard deviation of 30 seconds. Each call center staff member is paid $15 per hour. The estimated cost of a…
What is the role of the front desk office department in a hotel
Consider your most recent unpleasant waiting experience. What went wrong andhow could it have been improved?
Why do low-cost airline companies have waiting issues ?
List at least three major goals identified by the leadership in a Cigna call center
Only need (H) answered.
Employee Wanda Trews was working in the manufacturing facility at Coves Industrial. The employees of Coves Industrial manufacture diesel engines for the airline industry. Wanda works on Line 3 in the facility and from time-to-time works on Line 7 as a relief worker to cover employee breaks. Wanda was asked to leave Line 3 and provide break coverage on Line 7 for 2 hours on September 19, 2021. Earlier that day, there had been a mechanical difficulty with the stamping machine on Line 7. The maintenance team was able to get the machine working again but they call the manufacturer of the stamping machine as the machine doesn’t sound right and it clearly needs further maintenance. When Wanda arrived at Line 7 to provide break coverage, she checks in with Line 7 supervisor Raoul Steves. Raoul advises that Wanda needs to manufacture 200 components during her 2 hours on Line 7 and to let him know if she needs any help. Raoul does not mention the earlier mechanical issue with…