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.

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

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell An operations manager must purchase new equipment has developed a table of conditional values for the various alternatives (equipment options) and states of nature (demand market conditions). states of nature (market conditions) Alternatives Good Average Poor X800 $38,000 $21,000 -$18,000 Y900 $33,000 $16,000 -$12,000 Z1000 $29,000 $19,000 $6,000 If the probabilities associated with the states of nature are 0.40 for a good market, 0.40 for an average market, and 0.20 for a poor market, determine: 2. the expected value of perfect information (EVPI)
Please no hand written solution what is the correct answer; a, b, c, or d?
You work for the Brad's Nailer Company which manufactures two types of nailers: a pneumatic model and a cordless model. You have contracted to supply a national retail chain with both pneumatic nailers and cordless nailers. However, Brad's nailer production capability is limited in three departments: production, testing, and packaging. Your answer will be the production hours needed to execute a production plan that minimizes costs-rounded to the nearest whole hour. (The number of nailers may not be a whole number, which is acceptable in this chapter) Use Scenario 2 Pneum. Cost Pneum. Prod Hrs Pneum. Test Hrs Pneum. Pkg Hrs Pneum. Sales Cordless Cost Cordless Prod Hrs Cordless Test Hrs Cordless Pkg Hrs Cordless Sales Prod Hrs max Testing Hrs max Pkg Hrs max Scenario 1 2 52 0.2 0.3 0.1 22,000 67 0.3 0.4 0.1 15,500 10,000 15.000 4.800 Scenario 2 55.50 0.4 0.3 0.1 24,500 69.75 0.3 0.5 0.1 15,500 20,000 18,000 4,200 Scenario 3 38.50 0.25 0.4 0.1 18.000 44 0.4 0.4 0.2 14,000 20,000 18,000…
Problem S11. More Info The food items listed storage location for e best Click the icon to Click the icon to ITEM TRIPS PER VOYAGE AREA NEEDED (BLOCKS) A 6 В 24 Fill in the table below 40 D 10 E 13 F 12 30 More Info 1 3 7 11 13 15 17 Kitchen Aisle 6. 8. 10 12 14 16 18 Enter Print Done part Cloor A|| Chook Apowor N O N 21 23
This is just a follow-up question for the Operation Research Problem Solving, ANSWER question D and E only.
I need some help on the following problem. Please use solver as this problem requires the solver function on excel. Thank you
- Once answered correctly will UPVOTE!!
The following information relates to the performance of a manager in 2020. Benchmark weight Return on the benchmark Actual returnActual Weight Equity Bonds Cash 7.28% 0.6 0.5 6.00% 3.20% 0.90% 3.60% 0.90% 0.2 0.3 0.2 0.2 Details of investments in different sectors of the equity market are as follows: Sector Beginning of month weights S&P 500 Sector return Basic material 1.96 6.30 6.9 Business services 5.80 7.10 7.0 Capital goods 1.91 8.80 4.1 Consumer cyclical 8.47 12.50 8.8 Consumer non-cyclical 40.37 19.40 10.0 Credit sensitive 24.01 20.80 5.0 Energy Technology 13.53 13.20 2.6 3.95 11.90 0.6
Buskin’s Donuts can make donuts for $0.25 each with their current equipment. They could purchase a different fryer for $12,000 which would reduce their costs to $0.20 each. Or, they could buy a bigger fryer for $42,000 and decrease their cost to $0.17 each. Find the break-even points and graph your solution. Over what output range would each option be preferred?
You work for the Brad's Nailer Company which manufactures two types of nailers: a pneumatic model and a cordless model. You have contracted to supply a national retail chain with both pneumatic nailers and cordless nailers. However, Brad's nailer production capability is limited in three departments: production, testing, and packaging. Your answer will be the production hours needed to execute a production plan that minimizes costs - rounded to the nearest whole hour. (The number of nailers may not be a whole number, which is acceptable in this chapter.) Use Scenario 2 Pneum. Cost Pneum. Prod Hrs Pneum. Test Hrs Pneum. Pkg Hrs Pneum. Sales Cordless Cost Cordless Prod Hrs Cordless Test Hrs Cordless Pkg Hrs Cordless Sales Prod Hrs max Testing Hrs max Pkg Hrs max Scenario 1 Scenario 2 Scenario 3 52 0.2 0.3 0.1 22,000 67 0.3 0.4 0.1 15,500 10,000 15,000 4,800 55.50 0.4 0.3 0.1 24,500 69.75 0.3 0.5 0.1 15,500 20,000 18,000 4,200 38.50 0.25 0.4 0.1 18,000 44 0.4 0.4 0.2 14,000 20,000 18,000…
Formulate the situation in matrix form. Be sure to indicate the meaning of your rows and columns. Find the requested quantities using the appropriate matrix arithmetic. A car dealer sells sedans, station wagons, vans, and pickup trucks at sales lots in Oakdale and Roanoke. The "dealer markup" is the difference between the sticker price and the dealer invoice price. The dealer invoice prices at both locations are the same: $15,000 per sedan, $19,000 per wagon, $24,000 per van, and $26,000 per pickup. The sticker prices at the Oakdale lot are $18,900 per sedan, $23,900 per wagon, $28,900 per van, and $28,900 per pickup, while at the Roanoke lot the sticker prices are $17,900 per sedan, $22,900 per wagon, $26,900 per van, and $30,900 per pickup. Represent these prices as a dealer invoice matrix D and a sticker price matrix S. Use these matrices to find the dealer markup matrix M for these vehicles at these sales lots. (Let row 1 represent the dealer in Oakdale and row 2 represent the…
It is summertime and your winter coat factory is trying to decide its production schedule and staffing level for the next season. You are forecasting a demand of 5000 coats in October, 8000 coats in November, 8000 coats in December, 12000 coats in January, 12000 coats in February, and 9000 coats in March. You want to manufacture these coats at the lowest cost possible/ The first decision you need to make is how many people to hire. Each employee will cost $2500 a month. You don’t want to hire or fire any employees mid-season in order to minimize disruptions in your factory floor. You can have employees idle if there isn’t sufficient work for them to do. Employees still need to be paid even if they are idle. An employee works 20 business days a month and takes half a day to produce one coat. The employees can also be asked to work overtime, in which case you need to pay them $70 per coat they produce. You don’t need to assume there is any capacity constraint on the number of overtime…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS