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

Globe Industries is a multinational tech company specializing in e-commerce, cloud computing and artificial intelligence. GLOBE INDUSTRIES has an online shopping website/app where persons globally can purchase a variety of new and used goods, including computers, vehicles, music and books. Consumers are not using Globe Industries' e-commerce website/app because it lacks certain functions or features that make their online shopping experience easier. Issue The issue of customer retention has been the topic of discussion among the management team for months at Globe Industries. They have noted several complaints and concerns regarding the predicaments that the company is experiencing, which has negatively affected the company’s profits. The number one complaint noted was; the outdated approach to the company’s operations. This problem is stemming from the lack of access to information by its users from their own personal accounts. It was noted that in order for a transaction to be…
What are the duties and responsibilities of a FLIGHT ATTENDANT?
You were informed that, customers start to shop elsewhere because of your company’s quality of tech support decreases, and customer-help phone wait times has been increased dramatically. What would be the solution to improve the tech support?
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 ?
Comment on the tension between cost management and customer satisfaction management in a call center situation.
Electronics Company has received a much greater number of queries in recent months. DVD players for which the company received several complaints and returns manufacturers. When a DVD is inserted into the loader system, it may become entangled, making its removal difficult. Available now on DVD. Users will attempt to remove the DVD drawer unavoidably. Use only their fingertips or by trying it open with any implement such as a utilizing a bladed tool such as a knife, pencil, or screwdriver, TV or deliberately harming oneself. When comparing the different.Quality and the possible costs associated with quality assurance are both quite important associated with this matter of poor quality?
List at least three major goals identified by the leadership in a Cigna call center
Only need (H) answered.
Explain how waiting-line models can be used to make managerial decisions.
How does message queuing and asynchronous communication play a role in building responsive and resilient services?