Question: Using excel solver, solve the following LP problem. X number of tables to be made X= number of chairs to be made X3 number

Using excel solver, solve the following LP problem. X number of tables to be made X= number of chairs to be made X3 number of TV stands to be made Min cost (Z) = 40 x +20 x +15 X3 (currency used is in dollars) Subject to 7x1+3x2+2x3 35 Min wood 2x1 + 4x2 + 1x3 50 Min fiber X2 22 Min demand chairs X3 = 4 Exact TV stands X1, X2, X3 20 (Non-negativity constraint) 1.what is the reduced cost of tables? Calculate this value from the outputs. Show your calculation. 2.Cost of the table can be increased to by and decreased 3. What is the new cost if the cost of the table is decreased by $ 5 and the chair is decreased by $5? Show all your steps and explanation. 4. What is the new cost if you add 2 units wood and add 2 units of fiber? 5.Given that the supplier charges $2 less for each unit of wood and $1 less for each unit of fiber from their respective current prices. In this case, what is the new cost if 2 units of wood and 2 units of fiber are added to the current stocks?

Step by Step Solution

★★★★★

3.63 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To solve the LP problem using Excel Solver we need to set up the problem in a spreadsheet format with the objective function and constraints Step 1 Set up the spreadsheet The first step is to set up t... View full answer

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 Accounting Questions!

Solve the following LP problem using level curves. MAX: 4X1 + 5X2 Subject to: 2X1 + 3X2 120 4X1 + 3X2 140 X1 + X2 80 X1, X2 0

Solve the following LP problem graphically using level curves. MAX: 2X1 + 5X2 Subject to: 6X1 + 5X2 60 2X1 + 3X2 24 3X1 + 6X2 48 X1, X2 0

22 Question (1 point) Give the IUPAC name for the following molecule. HC- CI CH3

KINDLY USE THE DATA PROVIDED ABOVE TO SOLVE Q7&8 (PLEASE SHOW ME STEP BY STEP SO I CAN UNDERSTAND HOW TO DO IT NEXT TIME) 7. What is the new cost if you add 2 units wood and add 2 units of fiber? 8....

The Doppler equation presented in the text is valid when the motion between the observer and the source occurs on a straight line, so that the source and observer are moving either directly toward or...

The following beginning-of-month (BOM) and end of month (EOM) amounts are to be deposited in a savings account that pays interest at 9% compounded monthly: Today (BOM 1) $400 EOM2 270 EOM6 100 EOM7...

Using the present value tables, solve the following problems: Required 1. What is the present value on January 1, 2007 of $30,000 due on January 1, 2012 and discounted at 12% compounded annually? 2....

Solve the requirements of Problem 11.5 for the year ended December 27, 2008. Required: Prepare a common size balance sheet at December 29, 2007, using the following captions: Total current assets...

As of the end of June, the job cost sheets at Racing Wheels, Inc., show the following total costs accumulated on three custom jobs. Job 102 was started in production in May and the following costs...

Montreal Electronics Company manufactures two large-screen television models: the Nova, which has been produced for 10 years and sells for $900, and the Royal, a new model introduced in early 20x0,...

Part 6: As you perform your computations, you find an apartment which has a residual of -100. What is the best way to interpret this residual? The actual distance of the apartment is 100 km less than...

HR managers develop strategies to systematically monitor the major factors influencing their organization to identify trends that might affect the formulation and implementation of both...

Assess each strategy based on cost, beneficial long-term effects, & moral outcomes. Thoroughly, apply a minimum of four ethical theories to assess options. Ensure evaluation is in-depth, insightful,...

Refer to Step 5.1. Calculate the weights of VBTLX and VFIAX that achieve a portfolio allocation that represents an "optimal risky portfolio" on the efficient frontier, as of the end of December 2015....

Pun Poon Phya is the managing director of PPP Food Products, a recently established manufacturing company based in Kuala Lumpur. He recently approached your firm, ACT Partners, Chartered Accountants,...

When Martin, a BCBA, meets with his supervisee, he will typically explain a concept, and model how to perform the related skill. However, Martin finds role plays awkward, so he is considering...

Assume the zero - coupon yields on default - free securities are as summarized in the following table: ( Click on the following icon in order to copy its contents into a spreadsheet. ) What is the...

What are the 5 Cs of marketing channel structure?

A local bank has a single drive-through window with arrival times and service times that follow the distributions from the following table: Simulate the arrival of 200 customers to compute each of...

Get Connected, Inc., operates several Internet kiosks in Atlanta, Georgia. Customers can access the Web at these kiosks, paying $2 for 30 minutes or a fraction thereof. The kiosks are typically open...

Use Solver to create the Sensitivity Report for this LP problem. Use this report to answer the following questions. Each question is independent of the others.

What are four principles of effective post project reviews?

The article What Readers Say about Marijuana (Parade, July 31, 1994, p. 16) reported More than 75% of the readers who took part in an informal PARADE telephone poll say marijuana should be as legal...

Kripke et al. (2002) claim that persons who sleep 8 or more hours per night have a higher mortality risk than persons who sleep 6 or 7 hours. They analyzed data from the 1982 Cancer Prevention Study...