Question: (b) Create a spreadsheet model for this problem and solve it using Solver. What is the optimal solution? (Round your answers to the nearest integer.)

(b) Create a spreadsheet model for this problem and solve it

(b) Create a spreadsheet model for this problem and solve it using Solver. What is the optimal solution? (Round your answers to the nearest integer.)

(X₁, X₂) = (___)

Thanks in advance!!!

A furniture manufacturer produces two types of tables (country and contemporary) using three types of machines. The time required to produce the tables on each machine is given in the following table. Country tables sell for $350 and contemporary tables sell for $450. Management has determined that at least 20% of the tables made should be country and at least 30% should be contemporary. How many of each type of table should the company produce if it wants to maximize it revenue? (Let X1 be the number of country tables to produce and X2 the number of contemporary tables to produce.)

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!

Question 2: [20 points] Maintenance at a major theme park in central Florida is an ongoing process that occurs 24 hours a day. Because it is a long drive from most residential areas to the park,...

please answer on question 3 Question 3: [25 points] Revisit Question 1 (Acme Manufacturing). You are asked to solve the same problem using a network modeling approach. In so doing, assume that the...

You are asked to solve the same problem using a network modeling approach. In so doing, assume that the $1.5 carrying cost is applied to inventory at the end of each month. a. Draw a network flow...

Please solve this using and showing excel procedure Question 2: [20 points] Riverside Oil Company in eastern Kentucky produces regular and supreme gasoline. Each barrel of regular sells for \$21 and...

a. Formulat in Y model tor thes preles. enployes needed in exah 4 hour time period. minimuls ataline requirements. 1. formulate an tip modei for this procilem monk. 4. Draw a netwon flow medel for...

You are designing a diet plan for a meal. There are six different foods: bread, milk, cheese, potato, fish, and yogurt. The cost and nutrition values per unit are shown below. The objective is to...

The Clarkson Coffee Company produces two grades of coffee, the Superb blend and the Run-of-the-Mill blend. Three types of coffee beans are combined to produce these blends. The availability and cost...

Question 4: [15 points] The U.S. Department of Transportation (DOT) is planning to build a new interstate to run from Detroit to Charleston. A number of different routes have been proposed and are...

Problem 5 The number of generators to produce The number of alternators to produce = The maximum profit submit Excel spreadsheet 5. Which of the following constraints are not linear or cannot be...

Heat conduction to skin, suppose 200 W of heat flows by conduction from the blood capillaries beneath the skin to the bodys surface area of 1.5m2. If the temperature difference is 0.50Co, estimate...

In 2005 the supreme court of the United states decided in Kelo v New London by a narrow margin of 5-4 that city's taking of private property to sell for private development qualified as a public use...

State the methods of valuation of goodwill.

Consider the following information: Rate of Return If State Occurs Stock A Stock B Stock C State of Economy Boom Good Poor Probability of State of Economy .15 .60 .20 .05 35 19 -03 -13 45 .16 -06 -31...