Question: instead of using simplex method use the excel method Acompanymanufacturestwomodelsofaproduct,whichwecallthe regularmodelandtheenhancedmodel. Tworesources, AandB, areneededforthe manufacturing of units of this product, and the detailed resource requirements

instead of using simplex method use the excel method

Acompanymanufacturestwomodelsofaproduct,whichwecallthe regularmodelandtheenhancedmodel. Tworesources, AandB, areneededforthe manufacturing of units of this product, and the detailed resource requirements are given in the followingtable Regular Model Enhanced Model Resource A 3 Resource B 2 3 Thismeans forexample, 3unitsofResourceAand2unitsofResourceBare consumedinthemanufacturingofeachunitoftheregularmodel . Theresources couldrepresenthoursoflabor amountsoftawmaterial, availableelectricalpower, and soon. Supposefurtherthatthecompanyhas650unitsofResourceAand 500unitsof ResourceBavailableperweek, andthatthenetprofitsforsellingunitsofthe regularmodelandtheenhancedmodelaregiventespectivelyas$5and$7perunit. Thequestionofinterestisthat,thecompanywantstoknowtheoptimalweekly productionlevelsforthesetwomodels? a) Use the Excel method to solve the problem (10marks) b) From the Excel method solution, what should be the optimal weekly production for the two models? (Smarks) c) Area!Iconstraintsbinding?Ifyesgivereasonforyouranswer(10marks)

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!

ELE VATE t h e three disciplines o f advanced strate g i c th i nk ing R I C H H O R WAT H NEW YORK Times Be s ts ellin g A u thor O n s trateg y Contents Introduction 1 Elevate\t1 Importance of...

please answer all the questions immediately thankyou 5. Given below is the Linear Programming Model for manufacturing two types of products: Product A and Product B. There are two constraints...

QUESTION TWO (a) A factory has decided to diversify its activities. The data collected for the sales and production departments are summarized below: Potential demand exists for two products A and B....

1. Consider the following Linear Programming Problem (LPP). [16 points@8pts for each method] A) Convert LPP into its standard form using Simplex Method and create the initial simplex table. B)...

Problem: A farmer is raising pigs for market, and he wishes to determine the quantities of the available types of feed that should be given to each pig to meet certain nutritional requirements at a...

Problem: A certain corporation has three branch plants with excess production capacity. All three plants have the capability for producing a certain product, and management has decided to use some of...

please answer all the questions immediately thankyou 11. Given below is the Linear Programming Model for manufacturing two types of products: Product A and Product B. There are two constraints...

which ones are correct The information in the following table is for a simplex method of linear programming. $10 $12 SO SO RHS Product Mix Product A Product B Slack (welding) Slack (painting) SO...

You have two investment portfolios with uncertain cash flows and a discount rate of 10%. State A and B will occur next period with probability 0.5. Show the Expected NPV and Coefficient of Variation...

A horizontal metal strip 1.0 mm thick and 20 mm wide carries a 21-A current along its length, and both the length and the width are perpendicular to a uniform magnetic field of magnitude 2.0 T that...

2 uestion 9 e four basic sources of long - term funds for the business firm are current liabilities, long - term debt, common stock, and preferred stock. urrent liabilities, long - term debt, common...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...