b. Solve these equations using the Excel Solver. (Leave no cells blank - be certain toenter "0" wherever required. Round your answers to the nearest whole number.)Decision for X1Decision for X2Decision for X3Total profitMillingLathesGrindersSales$SlackVariablesS1S2S3S4ResourcesUsedHours1,1408706802,580c. How much of each constraint or resource is unused? (Leave no cells blank - becertain to enter "0" wherever required. Round your answers to the nearest wholenumber.)90702,1800256000d-1. Would the machines work at capacity? A manufacturing firm has discontinued production of a certain unprofitable product line.Considerable excess production capacity was created as a result. Management isconsidering devoting this excess capacity to one or more of three products: X1, X2, andX3.Machine hours required per unit areMACHINE TYPEMilling machineLatheGrinderMilling machinesLathesGrindersThe available time in machine hours per week isX1X2X3X1660The salespeople estimate they can sell all the units of X₁ and X2 that can be made.But the sales potential of X3 is 90 units per week maximum.UNITPROFITSPRODUCTX2X346052 4Unit profits for the three products are$9128s.tMaximize Z =MACHINE HOURSPER WEEK730460260a. Set up the equations that can be solved to maximize the profit per week. (Leave nocells blank - be certain to enter "0" wherever required.)9 X1 +12 X2 +8 X3

Here, First, LP model formulation would be created, there are multiple sub-parts in this question,…

Answered: b. Solve these equations using the…

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 try to solve it within 1 hour
5/Do not solve it in excel, please.
I need solution of 2.34 as possible as please
7:17 PM O A D Å ןה.ןא 288 I31) B/s Reserve Board interest-rate increases. Create a spreadsheet to compare the difference in monthly payments for a K552,451 loan having 60 monthly payments for a select number of interest rates. Use 3% as the base APR and go as high as an APR of 12%. Required: Make your spreadsheet flexible enough to be able to look at the impact of the different interest rates for different loan amounts and different repayment periods. Question Two (Evaluating Projects/probabilistic analysis) Malama's Cafe, Inc., is considering investment in two alternative capital budgeting projects. Project A is an investment of ZMK75000 to replace working but obsolete refrigeration equipment. Project B is an investment of ZMK 150000 to expand dining room facilities. Relevant cash flow data for the two projects over their expected 2-year lives are as follows: PROJECT A YEAR ONE YEAR TWO Probability Cash Flow Probability Cash Flow 0.18 ZMK O 0.08 ZMK O ZMK 50,000 ZMK 100, 000 0.64 0.84…
The percent defective from an incoming lot is 3%. AnOC curve showed the probability of acceptance to be 0.55. Given a lot size of 2,000 and a sample of 100, determine the average out-going quality in percent defective.
1 ton of material 1 ton of material 2, and 11/13 3 10 The Kashif Corporation blends three raw materials to produce two products: a fuel additive and a solvent base. Each ton of fuel additive is a mixture of ton of material 1 and 3 ton of material 3. A ton of solvent base is a mixture of // Kashif's production is constrained by a limited availability of the three raw materials. For the current production period, Kashif has the following quantities of each raw material: material 1, 20 tons; material 2, 5 tons; material 3, 21 tons. Management wants to achieve the following P, priority level goals. Goal 1: Produce at least 30 tons of fuel additive. Goal 2: Produce at least 15 tons of solvent base. Assume there are no other goals. (a) Is it possible for management to achieve both P₁ level goals given the constraints on the amounts of each material available? If not, which constraint is the limiting factor? O Yes. It is possible to satisfy both P₁ level goals. O No. There is an insufficient…
Please use attached Excel format to solve if possible, I appreciate you
Problem 13-3 Determining the Time Value of Money [LO13-1] Complete the following table. Use Exhibit 1-A, Exhibit 1-B, Exhibit 1-C, Exhibit 1-D. Note: Use appropriate factor(s) from the tables provided. Round time value factors to 3 decimal pla nearest whole number. Annual Deposit Rate of Number of Return Years Investment Value at the End of Time Period Total Amount of Investment $ 3,000 4 % 9 $ 3,000 8% 9 $ 3,000 4 % 18 $ 3,000 8% 18 Total Amount of Interest or Earnings
Zack Pop has been a producing plant production manager for the last 10 years. One produce item, zucchini, is sold in cases, with daily sales averaging 400 cases. Daily sales are also assumed to be normally distributed. Furthermore, 85% of the time sales are between 350 and 450 cases. Each case is purchased for $10 wholesale and sells for $15 retail. All cases that are not sold must be discarded. 1) Estimate the standard deviation of the sales distribution. 2) Using the standard deviation found in part a, determine how many cases of zucchini Zach should stock.
10/Do not solve it in excel , please.

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