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

See similar textbooks

Similar questions

Satomi w eks in a research facility that provides statistical results for the bioengineering firm TechCure. She is one of four interns expected to go through hendreds of samples per day. At her first week on the job, ber supervisor informs her that all blood sammples are to be completely anonymous. No testing can be done if personal information is revealed-meaning, the samples must be properly disposed of if opened, or veturned to the plysicians if unopened to be re- Aonymized. For the first five weeks, most of the new interns follow procedwes to check that samples were anonymized before testing occurred. However, one of the interns, Max, failed to verify whether the samples were anonymized. Halfway through the testing, Satomi discovers the non-anonymized samples. She considers whether they should tell their supervisor, but the other interns ask ber not to speak up so that they won't pet in trouble. of the interas argues that as long as they remove the information from the…
B& Co. is a large manufacturer if an electronic product (NM65). It is the market leader in the particular product segment. The market size is increasing due to increasing popularity of its product. B& Co. has received an offer from a manufacturer of electronic products to produce NM 65 on half of B& Co. and directly supply to the customers of the Northern region. The billing on the customer will done by B& Co. The offer is economically attractive. Required: Write a note on what qualitative factors should be considered before deciding in favour or against accepting the offer.
Tribal Systems, Inc., is opening a new plant and has yet todecide on the type of process to employ. A labor-intensiveprocess would cost $10,000 for tools and equipment and $14 for labor and materials per item produced. A more au-tomated process costs $50,000 in plant and equipment but has a labor/material cost of $8 per item produced. A fullyautomated process costs $300,000 for plant and equipmentand $2 per item produced. If process selection were basedsolely on lowest cost, for what range of production wouldeach process be chosen?
A company makes two products (A and B). Each product requires time on two machines 1 and 2. the specifications for each product are as follows Product A Product B Processing time on machine 1 (hrs/unit) Processing time on machine 2 (hrs/unit) Material and labor cost (Sh./ unit) Selling price (Sh./ unit) Maximum possible sale (units) 2 1 2 14 15 16 18 130 150 The amount of time available on machine 1 is 360 hrs and on machine 2 is 260 hrs. Using simplex method determine the number of product A and B, which should be sold in order to maximize total contribution for the company.
Cablesplice, Inc.'s manufacturing process consists of five steps: making con- ductors, adding insulation, adding sheathing, irradiation, and printing and coil cuttingUnits are measured in meters. In 970,000 meters of cable, 700 defects were found in the conductors, and 75,000 defects were found in the insulation. In 440,000 meters of cable, 8,930 defects were found in the sheathing, and no defects were found in the remaining two steps. (a) Find DPU and the dpmo, and (b) the sigma level for each process step.
What is the average number of tennis balls does Skousen maintain?
Harold Grey owns a small farm in the Salinas Valley that grows apricots. The apricots are dried on the premises and sold to a number of large supermarket chains.Based on past experience and committed contracts, he estimates that sales over thenext five years in thousands of packages will be as follows:Forecasted DemandYear (thousands of packages)1 3002 1203 2004 1105 135Assume that each worker stays on the job for at least one year, and that Greycurrently has three workers on the payroll. He estimates that he will have 20,000packages on hand at the end of the current year. Assume that, on the average, eachworker is paid $25,000 per year and is responsible for producing 30,000 packages. Inventory costs have been estimated to be 4 cents per package per year, andshortages are not allowed.Based on the effort of interviewing and training new workers, Farmer Greyestimates that it costs $500 for each worker hired. Severance pay amounts to$1,000 per worker.a. Assuming that shortages are not…
14. Digital Controls, Inc. (DCI) manufactures two models of a radar gun used by police to mon- itor the speed of automobiles. Model A has an accuracy of plus or minus 1 mile per hour, whereas the smaller model B has an accuracy of plus or minus 3 miles per hour. For the next week, the company has orders for 100 units of model A and 150 units of model B. Although DCI purchases all the electronic components used in both models, the plastic cases for both models are manufactured at a DCI plant in Newark, New Jersey. Each model A case re- quires 4 minutes of injection-molding time and 6 minutes of assembly time. Each model B case requires 3 minutes of injection-molding time and 8 minutes of assembly time. For next week the Newark plant has 600 minutes of injection-molding time available and 1080 min- utes of assembly time available. The manufacturing cost is $10 per case for model A and $6 per case for model B. Depending upon demand and the time available at the Newark plant, DCI…
A company makes two products (1 and 2). Each product requires time on two machines A and B. The specifications for each product are as follows; Product 1 Product 2 Processing time on machine A (hrs/unit) 2 2 Processing time on machine B (hrs/unit) 1 2 Material and labor cost (Sh./unit) 14 15 Selling price (Sh./unit) 16 18 Maximum possible sale (units) 130 150 The amount of time available on machine A is 360 hrs and on machine B is 260 hrs. Formulate the LP problem, which when solved, would indicate the number of product 1 and 2, which should be sold in order to maximize total…
Northern Engineering is analyzing a mining project. Annual production, unit costs, and unit revenues are in the table. The first cost of the mine setup is $6 million. If MARR is 15%, what is the PW? Year Annual Production (tons) 90,000 120,000 120,000 100,000 80,000 60,000 40,000 Cost per ton $25 Price per ton $35 1 20 36 22 37 24 38 26 39 6. 28 40 7 30 41
The manager of Roth Corporation, wants to determine whether or not the type of work schedule for her employees has any effect on their productivity. She has selected 15 production employees at random and then randomly assigned 5 employees to each of the 3 proposed work schedules. The following table shows the units of production (per week) under each of the work schedules. Work Schedule (Treatments) Schedule 1 50 60 70 40 45 Compute MSTR MSTR- 95 94.68 128.166 3.8856 Schedule 2 60 65 65 58 57 Schedule 3 75 75 55 40 55
22.28 A learn.uph.edu 9-8. A marketing firm is planning to conduct a survey of a seg- ment of the potential product audience for one of its cus- tomers. The planning process for preparing to conduct the survey consists of six activities with procedure relation- ships and activity time estimates as follows: Time Activity Estimates Activity Description Predecessor (days) Determine survey objectives Select and hire personnel a 3 a 3 Design questionnaire Train personnel a 5 d b, c 4 Select target audience Make personnel assignments e 3 d, e a. Determine all paths through the network from node a to node f and the duration of each, and indicate the critical path. b. Determine the earliest and latest activity start and finish times. c. Determine the slack for each activity. 2.