Question 1An electronic component manufacturer has two facilities producing a range ofresistors. Facility 1 costs €2000 per day to operate. Facility 2 costs €2500 per day tooperate. The production capacities per day are as follows:Facility 1Facility 2Orders25,000Resistors 1% tolerance:400300Resistors 5% tolerance30040027,000Resistors 10% tolerance20050030,000How many days should the manufacturer operate each facility in order to minimiseits costs and still produce sufficient resistors to meet its orders?a. Formulate the problem as a linear programming model (hint: let X1 representthe number of days that Facility 1 should operate and X2 represent the numberof days that Facility 2 should operate).b. Solve the problem using graphical linear programming (corner point)techniques.Question 2Solve question 1 above using Excel. The graph and minimum cost result shouldautomatically update if any of the constraints or objective function change.

Since you have asked multiple questions, we will solve the first question for you. If you want any…

Answered: An electronic component manufacturer…

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

Volumetric Glassware: Utility and Calibration (Dry Lab) Table B1: Calculation of a 100-mL Volumetric Flask. temperature of the Distilled H2O (°C) 27 density of distilled H2O at calibration temperature mass (g) of volumetric flask + distilled H₂O Trial 1 198.5893 Trial 2 198.6114 Trial 3 mass (g) of dry volumetric flask 98.6563 98.7503 198.6001 98.7145 mass (g) of distilled H₂O m true g calculated volume of water dispensed, cm³ corrected volume, V20 °c, cm³ average corrected volume, V20 °C, cm³ standard deviation (4 sig figs) %RSD (2 sig figs)
Self-test 3 Boysen produces enamel and acrylic paint from two particular raw materials M1 and M2. The following data provides the data regarding the production restrictions. Tons of Raw Materials per Maximum daily availability (in tons) ton of: Enamel Acrylic Paint Paint Raw Material, M1 6 4 24. Raw Material, M2 1 2 6 Profit per ton (in millions of Php) 5 4 If the maximum daily demand for enamel paint is at 2 tons, determine the production output that would maximize the profit. Find the optimal solution using the simplex method.
Problem 10-6 (Static) A medical facility does MRIs for sports Injuries. Occasionally, a test yields inconclusive results and must be repeated. Using the following sample data and n = 200. Number of retests 1 2 1 2 UCL LCL 3 2 b. Is the process in control? 4 The process is in control. O The process is not in control. 0 5 2 SAMPLE 6 7 1 2 Click here for the Excel Data File a. Determine the upper and lower control limits for the fraction of retests using two-sigma limits. (Do not round intermediate calculations. Round your final answers to 4 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) 8 9 10 11 12 13 2 7 3 2 1
42. A large national producer of appliances has traced customer experience with a popular toaster oven. A survey of 5,000 customers who purchased the oven early in 2000 has revealed the following: nd ity Number of Year Breakdowns 2000 188 2001 58 2002 63 2003 72 2004 54 2005 71 a. Using these data, estimate på = the probability that a toaster oven fails in its kth year of operation, for k = 1, . . . , 6. b. What is the likelihood that a toaster oven will last at least six years without failure based on these data? c. The discrete failure rate function has the form r; = Pr/Rp–1, where Rỵ is the prob- ability that a unit survives through period k. Determine the failure rate function for the first five years of operation from the given data. d. Suppose that you purchased a toaster oven at the beginning of 2004 and it is still operating at the end of 2007. If the reliability has not changed appreciably from 2000 to 2007, use the results of part (c) to obtain the probability that it will…
5.S1. Sensitivity Analysis at Stickley Furniture Stickley Furniture is a manufacturer of fine hand-crafted fur- niture. During the next production period (the eight-hour shift tomorrow), managcment is considcring producing dining room tables, dining room chairs, and/or bookcases. The time required for each item to go thmugh the two stages of production (assem- bly and finishing), the amount of wood required (fine cherry wood), and the corresponding unit profits are given in the fol- lowing table, along with the amount of each resource available in the upcoming production period. Tables Chairs Bookcases Available Assembly (minutes) 80 40 50 8,100 30 20 4,500 Finishing) (minutes) 30 Wood 80 10 50 9,000 (pounds) Unit profit $360 $125 $300 After formulating a linear programming model to determine the production levels that would maximize profit, the solved model and the corresponding sensitivity report are shown below.
17. Services differ from manufactured products in four ways. Intangibility, Inseparability, Perishability and ? A. Homogeneity B. Heterogeneity C. Intractability D. Invisibility E. None of the above 18. The implications of low volume production include the following except a) Low unit cost b) Less systematization c) Low repetition d) Each staff performs more of jobs e) None of the above
QUESTION 15 Which company developed the Six Sigma approach? Motorola А. Dow Chemical В. General Electric D. Amazon QUESTION 16 W Edwards Deming's 14 points are a quality plan of action he proposed for Management A. Suppliers В. QC inspectors С. D. Customer Service
11. Select a fusible disconnect and the fuses for the application below. CNC Grinding Station Machine Operating Voltage - 600 VAC, 3-phase Spindle Motor FLA = 25 Amps Table Motor FLA = 10 Amps Fusible Disconnect Voltage Rating Fusible Disconnect Current Rating Number of Poles Fuse Voltage Rating Fuse Current Rating (VAC) (Amps) (VAC) (Amps)
PRACTICE PROBLEM -- NOT GRADED
What are the expected number of yearly breakdownsfor the power generator at Orlando Utilities that has exhibited thefollowing data over the past 20 years?
36. This risk stems from the unavailability of raw materials, IT, skilled labor, facilities, or other resources that threaten the organization's ability and capacity to continue operations. Group of answer choices None of the choices Product or service failure risk Availability risk Business interruption risk Commerce risk
Question 3 A frequency distribution is given below: Class A B с D Frequency 7 9 9 Calculate the probability of class C occurring using the Relative Frequency method. Express your answer as an decimal rounded to two (2) decimal places.

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