please answer within 30 minutes. Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the sameproduction equipment, and the objective is to meet the demands for the three products using overtime where necessary. The demandforecast for the next four months, in hours required to make each product is:PRODUCTAPRILМAYJUNEJULYA7705707701,170B5706708701,070670470670820Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is madeand 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, $5for 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 isAPRILМAYJUNEJULYRegular timeOvertime1,4701,3001,7701,950670620870990Calculate the objective value using Excel Solver. (Do not round intermediate calculations.)Objective value

Formulate a spreadsheet s shown below to get the answer. note: to make sure that each month demands…

Answered: Alan Industries is expanding its…

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

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.
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.
17-36 Weighted-average method. Larsen Company manufactures car seats in its San Antonio plant. Each car seat passes through the assembly department and the testing department. This problem focuses on the assembly department. The process-costing system at Larsen Company has a single direct-cost cat- egory (direct materials) and a single indirect-cost category (conversion costs). Direct materials are added at the beginning of the process. Conversion costs are added evenly during the process. When the assembly department finishes work on each car seat, it is immediately transferred to testing. Larsen Company uses the weighted-average method of process costing. Data for the assembly depart- ment for October 2017 are as follows: Physical Units (Car Seats) Direct Conversion Materials $1,250,000 Costs $ 402,750 Work in process, October 1 Started during October 2017 Completed during October 2017 Work in process, October 31b Total costs added during October 2017 5,000 20,000 22,500 2,500…
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.
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…
Maximize P = x + 4y − 2z subject to 3x + y − z ≤ 40 2x + y − z ≤ 20 −x + y + z ≤ 40 x ≥ 0, y ≥ 0, z ≥ 0
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…
SIMPLEX METHOD: Min C = 3X1 + 7X2 + 5X3 Subject to: X1 + X2 + X3 > 50 2X1 + 3X2 + X3 > 100 Based on the initial tableau, answer questions no. 1-5 What is the value of X3 on the Cj row? What is the value of S2 on the right-hand side/quantity column? What is the value of Zj on the right-hand side/quantity column? What is the value of X3 on the Cj – Zj row? What is the entering variable?
4. The Spencer Optics Company produces an inexpensive line of sunglasses. The manufacturing process consists of assembling two plastic lenses (produced by the firm's plastic molding depart- ment) into a finished frame (purchased from an outside supplier). The company is interested in using material requirements planning to schedule its operations and has asked you to prepare an example to illustrate the technique. The firm's sales manager has prepared a 10-week sales forecast for one of the more popular sunglasses (the Classic model) for your example. The forecast is 100 units per week. Spencer has customer orders of 110 units, 80 units, 50 units, and 20 units in weeks 1, 2, 3, and 4, respectively. The sunglasses are assembled in batches of 300 units. Presently, three such batches are sched- uled: one in week 2, one in week 5, and one in week 8. Complete the following time-phased record: Week hand 1 2 3 4 5 6 7 8 9 10 Classic Model On MPS Record Forecast Orders Projected available…
XYZ Leather Company manufactures and sells two products, wallets and belts, in its two-department plant. Operating data pertaining to the two products are as follows:                                                                                         Wallets                       Belts                 Selling price per unit                                   P30                             P50                 Cost per unit:                  Variable manufacturing costs                   P8                               P15                 Variable marketing costs                           P2                               P3                 Fixed manufacturing costs                        P5                               P5                 Fixed marketing costs                                P6                               P1                                                                                                           Cutting                       Finishing…
Tica (Pty) Limited manufactures and sells combined fax and telephone answering machines. In order to tender for a specific contract, the technical team of the company has developed a new model called FINO. To date, two units of FINO have been manufactured and are being used as demonstration models. The following information is available: Direct labour hours taken to manufacture the first two units: Hours First unit                                60             Second unit                           48 The following average direct variable costs relate to the manufacture of the first two units of FINO: R/unit Material                                              620 Labour                                                440Variable overheads                         324 1384 ·         Since the first two units were manufactured, material costs have increased by 10% and labour costs by 5%. ·         Variable overheads – variable per…
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…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS