7. A producer has three products, A, B, and C, which are composed from many of the sameraw materials and subassemblies by the same skilled workforce. Each unit of product Auses 15 units of raw material X, a single purge system subassembly, a case, a power cord,three labor hours in the assembly department, and one labor hour in the finishingdepartment. Each unit of product B uses 10 units of raw material X, five units of rawmaterial Y, two purge system subassemblies, a case, a power cord, five labor hours in theassembly department, and 90 minutes in the finishing department. Each unit of product Cuses five units of raw material X, 25 units of raw material Y, two purge systemsubassemblies, a case, a power cord, seven labor hours in the assembly department, andthree labor hours in the finishing department. Labor between the assembly and finishingdepartments is not transferable, but workers within each department work on any of thethree products. There are three full-time (40 hours/week) workers in the assemblydepartment and one full-time and one half-time (20 hours/week) worker in the finishingdepartment. At the start of this week, the company has 300 units of raw material X, 400units of raw material Y, 60 purge system subassemblies, 40 cases, and 50 power cords ininventory. No additional deliveries of raw materials are expected this week. There is a$90 profit on product A, a $120 profit on product B, and a $150 profit on product C. Theoperations manager doesn't have any firm orders, but would like to make at least five ofeach product so he can have the products on the shelf in case a customer wanders in offthe street.Formulate the above problem in MS Excel, and solve using MS Solver.

The Simplex method is like a master problem solver for linear programming. It's a step-by-step…

Answered: $90 profit on product A, a $120 profit…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 111P

See similar textbooks

Similar questions

Tuff-Rider, Inc., manufactures touring bikes and mountainbikes in a variety of frame sizes, colors, and component com-binations. Identical bicycles are produced in lots of 100. Theprojected demand, lot size, and time standards are shown inthe following table: Item Touring MountainDemand forecast 5,000 units/year 10,000 units/yearLot size 100 units 100 unitsStandard processing time .25 hour/unit .50 hour/unitStandard setup time 2 hours/lot 3 hours/lot The shop currently works 8 hours a day, 5 days a week,50 weeks a year. It operates five workstations, each producingone bicycle in the time shown in the table. The shop main-tains a 15 percent capacity cushion. How many workstationswill be required next year to meet expected demand withoutusing overtime and without decreasing the firm’s currentcapacity cushion?
21 A process where goods are manufactured according to confirmed orders: Select one: a. Demand push b. Continuous inventory c. Just in Time d. Product pull
31 - Which of the following is a production method in which a wide variety of inputs in batches pass through multi-purpose flexible processing units and turn into a wide variety of outputs? a) Workshop (Task) Type Production System B) Fluent Production System NS) Multivariable Production System D) Project Production System TO) Univariate Production System
Suppose a final assembly is produced by assembling two components. THE The first component, A, is produced internally and goes through three process steps, which are stamping, forging and machining, with scrap estimates of 10%, 15% and 25%, respectively. For every three produced units of component A, two are used in the final assembly and one is separate to meet spare parts needs. The second component, B, which is used exclusively in final assembly, is purchased from a supplier external and inspected on arrival; 2% do not pass inspection. A unit of the component purchased is required for each final assembly. The final assembly process produces 5% of scraps. Spare parts demands for component A and final Su assembly match to 1,000 and 5,000 units, respectively. How many input units are needed for produce component A, and how many units of component B should the firm buy?
The Chineke Group of Company manufactures two products, namely product B and product P, and provides you with the following information: Prod. B Prod. P Selling price per unit 80.00 50.00 Less cost of sales: Direct material A @ R5.00 per kg 15.00 10.00 Direct material B @ R4.00 per kg 8.00 12.00 Direct labour @ R6.00 per hour 12.00 6.00 Variable manufacturing overhead @ R5.00 per labour hour 10.00 5.00 Fixed manufacturing overhead per unit 5.00 5.00 Gross profit 30.00 12.00 Less sales & administrative costs: Variable 6.00 4.00 Fixed 10.00 5.00 Net profit per unit 14.00 3.00 Take note of the following constraints: Material A available 360 kg Material B available 360 kg Labour hours available…
Assume that Product Z is made of two units of A and four units of B. A is made of three units of C and four of D. D is made of two units of E. B is made of three units of E. If 50 units of Z is required to make, then how many units of D do they need? Group of answer choices 250 400 300 150 550
Which of the following is a fixed cost? a) Direct materials b ) Direct labor c) Rent on factory building d) Variable manufacturing overhead
Bruce Corporation makes four products in a single facility. These products have the following unit product costs: Products Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Unit product cost Additional data concerning these products are listed below. A B C $15.30 $ 11.20 $12.00 20.40 28.40 34.60 3.70 3.60 4.20 35.80 27.60 38.20 $79.10 $ 77.80 $ 95.40 5.30 27.50 $ 68.50 Multiple Choice A 4.80 $77.10 $ 3.20 5,000 D $11.60 41.40 Products C D 4.40 5.30 $88.40 $ 105.20 $ 4.30 $ 2.60 4,000 3,000 Grinding minutes per unit B 6.30 $ 94.50 $ 2.20 Selling price per unit Variable selling cost per unit Monthly demand in units 5,000 The grinding machines are potentially the constraint in the production facility. A total of 89,600 minutes are available per month on these machines. Direct labor is a variable cost in this company. Up to how much should the company be willing to pay for one additional minute of grinding machine time if the company has made the…
Which of the following statements are correct about services and service design? Select ALL which are true. 1) Services can be more easily automated and transported than products. ) 2) The service delivery system should be designed primarily around the employees in the system. ) 3) Low-contact services can usually be made more efficient than high-contact services. 4) A service is produced and consumed simultaneously (at the same time).
Bhatti Company produces plastic photo frames. Two departments, molding and finishing, are involved in the manufacturing. The molding department fills the molds with hot liquid plastic that is left to cool and then opens them. The finishing department removes the plastic frame from the mold and strips the edges of the frames of extra plastic. The following information is available for the month of January: January 1 Quantity (pounds) January 31 Quantity (pounds) Work-in-Process Inventory Cost Cost Molding department Finishing department None None 5,000 $ 15,000 2,000 The WIP Inventory in the finishing department is estimated to be 40% complete for conversion both at the beginning and end of January. Costs of production for January follow: Direct Costs of Production Materials Conversion Molding department Finishing department $ 450,000 $ 90,000 80,290 The molding department started 50,000 pounds of product in January. The firm uses the FIFO method of process costing. Required: 1. Prepare…
The process through which inputs are converted into outputs is referred to as: a. Transformation process. b. Materials handling process c. Servicing process. d. Maintenance process.
#4- The mean number of air conditioning units assembled per month by Freeze, Inc. is 750 and the standard deviation is 100 units. a. If the number of air conditioning units assembled per month follows a normal distribution, calculate the probability of Freeze, Inc to assemble a quantity of air conditioning units greater than the monthly break-even point calculated in problem 3-a. b. An improved assembling process is proposed to Freeze, Inc. to reduce the variable cost from $500 per unit to $400 per unit., increase the mean number of air conditioning units assembled per month from 750 to 850 and reduce the standard deviation to 90 units. As a result of the improvements, monthly fixed costs would go up from $250,000 to $300,000. Once these improvements are implemented, calculate the new number of air conditioning units that Freeze Inc. must sell every month to break-even, discuss and justify if you would recommend the process improvement initiative. c. If the number of air conditioning…

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