Question: MEM 2211: INTRODUCTION TO MANUFACTURING SYSTEMS Problem Sheer #1: Graphical Solutions, Excel Solutions, Sensitivity Analysis L. S. Thakur Graphical Solution und 2 graphically te the

MEM 2211: INTRODUCTION TO MANUFACTURING SYSTEMS Problem Sheer #1: Graphical Solutions, Excel Solutions, Sensitivity Analysis L. S. Thakur Graphical Solution und 2 graphically te the optimal solution by so curves, optimalen set II: (@ al objective way 1. Solve the following problems 1 and 2 graphically: I: showing constraints, feasible region, two level curves, optimal direction: indicate the optimal point by an arrow on the graph for each case and then get II: (a) the exact optimal solution by solving intersecting constraints at the optimal and (b) optimal objective value. The Foundry Problem: There is idle capacity in a foundry: 1000 hrs/week in the casting department, 600 hrs/week in the machining department. To utilize this capacity the foundry is considering production of a new auto part and a new bike part. An auto part requires 10 hrs of casting and 5 hrs of machining, the bike part needs 6 hrs of casting and 4 hrs of machining. A unit of auto part generates a contribution of $30 and a bike part $20. In addition, the EPA adds to your total, 10 pollution-index points for every auto part you make and subtracts 10 points for each bike part. The Foundry is allowed a maximum of 200 pollution-index points. What should they do to best utilize the idle capacity? Give the optimal number of auto and bike parts (the production plan) for the new products they are introducing by solving this LP graphically. 2. The Foundry Cases: Determine the optimal solution graphically and comment on it, if the contribution from Auto part and bike part in the Foundry Problem 1 are changed as follows: a) Auto part contribution: $20, Bike part contribution: $30, b) Auto part contribution: $30, Bike part contribution: $10. Solutions by EXCEL-- 3. Formulate and solve the above Foundry Problem 1 by Excel as given in detail on section "Help on Solving Linear Programs by Excel" included in this Course Notes (see Course Notes cover page for section page numbers). Sensitivity Information and Interpretation from Excel output in Answer and Sensitivity Report

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

MEM 2211: INTRODUCTION TO MANUFACTURING SYSTEMS Assignment Models: Problem Sheet #3 L. S. Thakur Formulate the following problems as Assignment Models Q1. Computer Center. A computing center has four...

MEM 2211: INTRODUCTION TO MANUFACTURING SYSTEMS L. S. Thakur Forecasting Quantitative Models Problem Sheet: # 5 Problem 1 (Moving Average) Given the following data, develop a three-year moving...

CHAPTER 10 INTRODUCTION TO MANUFACTURING BUSINESS CHAPTER 10 -TEST 9 INTRODUCTION TO MANUFACTURING BUSINESS Name Date Score Course and Section Love Company has the following cost and expense data for...

Write a two-pages paper of overview including important key take-away. IEEE ENGINEERING MANAGEMENT REVIEW, VOL. 47.NO 1. FIRST QUARTER, MARCH 2019 How to Make Lean Cellular Manufacturing Work?...

2. Obviously, to verify whether the loan is feasible or not, you need to project the financial statements based on the business strategy you discussed with the company. So, mention the assumptions...

The Business Plan: Mary Ann and Nana are ready to expand their successful business Crepes a la Nana, from one food truck to a whole fleet. To achieve this goal, they need money to purchase new trucks...

1. Introduction to Manufacturing Management 2 Forecasting 3. Facilities Layout 4. Capacity Planning 5. Aggregate Planning 6. Material Requirement Planning 7. Just inTime 8 Production Scheduling 9...

make sure to add the code lines please Problem 2. Kaizer Plastics produces a variety of customized plastic items for packaging and distribution. Items are produced in batches, but each batch might...

Automotive Supplier Park 30 Helium Road Rosslyn X2, South Africa Private Bag X36 0200 Rosslyn Tel: +27 (12) 564 5300 Fax: +27 (12) 564 5301 E-mail: aidc@aidc.co.za Reg. Nr. 2000/028678/07 Project...

Spring Stone Manufacturing: Cost and Ethical Analysis INTRODUCTION Blaze Manufacturing is a small, closely-held textile manufacturing operation located in upstate New York. They make textile products...

How might computing the cost driver rate by using the planned level of the cost driver lead to a death spiral?

Give notes for Scheduling Algorithms in Operating System.

2. Which of the following calculates the average of the values stored in a numeric field named Population? a. Dim dblAvg As Double = Aggregate city In CitiesDataSet.tblCities Select city.Population...

The results from a survey of 100 high school students finds that 19 like Science but don't like Math, 17 like Math but don't like Science, 10 like both Science and Math, and the remainder do not like...