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.

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

Year Month Actual Orders/Demands 2020 Apr 120 May 90 Jun 100 Jul 75 Aug 110 Sep 50 Oct 75 Nov 130 Dec 110 2021 Jan 90 Feb
b6 need urgent in 15 minutes
snip
In past 4 weeks, AOC (Arab oil company) started producing and distributing national engine oil to substitute French Total and Esso brands. Production reported to be in thousands: 2, 4, 3, 5 TG Thousand Gallons). AOC production will be calculated after 5 more weeks.
Assume an initial starting Ft of 200 units, a trend (Tt ) of 8 units, an alpha of 0.30, and a delta of 0.40. If actual demand turned out to be 288, calculate the forecast including trend for the next period.
give details calculation
The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: Week Actual No. of Patients 1 65 68 77 59 66 75 23456 2 5 6 Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.500 on the present period, 0.250 one period ago, 0.125 two periods ago, and 0.125 three periods ago. a) What is the value of your forecast? The value of the forecast is patients (round your response to two decimal places). b) If instead the weights were 40, 20, 10, and 10, respectively, how would the forecast change? OA. The value of the forecast will decrease. B. The value of the forecast will remain the same. C. The value of the forecast will increase. c) What if the weights were 0.40, 0.30, 0.20, and 0.10, respectively? Now what is the forecast for week 7?…
Tom Glass forecasts electrical demand for the FlatlandsPublic Power District (FPPD). The FPPD wants to take itsComstock power plant out of service for maintenance whendemand is expected to be low. After shutdown, performingmaintenance and getting the plant back on line takes two weeks. The utility has enough other generating capacity tosatisfy 1,550 megawatts (MW) of demand while Comstockis out of service. Table 8.5 shows weekly peak demands(in MW) for the past several autumns. When next in year 6should the Comstock plant be scheduled for maintenance?
Please include an excel sheet showing calculations
Design capacity is the ability of the company to produce the quantity of goods and services within a particular period of time when the company have best condition to produce and when the company have unlimited resources. These resource's includes- Men, Machinery, Material etc. It shows the maximum capacity of the company to produce. Effective capacity refers to the ability of the company to produce maximum quantity within a particular period of time to achieve in current production condition and current resources. It shows the real outcome capacity of the firm when the company produce within their own current condition of their production. Question Why is the capacity design important?