Question: Please use Excel and show how to solve it step by step on excel and also show Decision Variables, Objective Function Equation, and Constraints Equations.

Please use Excel and show how to solve it step by step on excel and also show Decision Variables, Objective Function Equation, and Constraints Equations.

Also please solve it through algebra as well thanks

Penny Chairs has two plants that manufacture and ship chair parts to other manufacturers. Penny Chairs

sells and ships to four manufacturers. The cost of shipping one chair from a plant to a customer is given

in the following table.

The plant in Bruderheim has a capacity of

3000

cases per week, and the Cardston plant can produce

3600

cases per week.

.

Derive the minimum cost shipping plan.

.

Mesquite Furniture is experiencing some financial problems. If Mesquite were to reduce its

order to

1000

cases, how would the minimum cost shipping plan change?

Please use Excel and show how to solve it step by

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 1) (20 points) Consider a pottery workshop that produces bowls, mugs, and plates . The number of labor hours and amount of clay needed to produce a unit of these products is presented in...

Product-Mix Problem of BlubberMaid, Inc., Revisited Recall that BlubberMaid, Inc., manufactures three rubber-based products: Airtex, Extendex, and Resistex. The number of ounces of each ingredient...

Problem 1 (100 points): Supply chain transportation - Multicommodity Problem Transportation plays a significant role in a supply chain and its efficiency. In particular, reducing the transportation...

Question 1 Many of today's digital or electronic devices and equipment cannot function without the use of highly complex interconnected network of generally microscopic electronic components. Nano...

Non linear programming. Specify decision variables, objective function and constraints. Solve in Excel using solver very clearly and give optimal ordering plan 2) A manufacturer stocks four items,...

operation researches Background: Poseidon Corporation is a sailboat producing company. The company needs to establish a plan for production for the next four quarters. The sailboat demand for the...

Background: Poseidon Corporation is a sailboat producing company. The company needs to establish a plan for production for the next four quarters. The sailboat demand for the first, second, third,...

Background: Poseidon Corporation is a sailboat producing company. The company needs to establish a plan for production for the next four quarters. The sailboat demand for the first second, third, and...

PLEASE WRITE CONSTRAINTS IN STANDARD FORMAT. M4.2. The fabrication department for an automobile component plant is scheduling its work for next month. The plant produces the following four...

INSTRUCTIONS: For the mathematical models either use Word Equations, or write down the formulas on a paper, take a photo you MUST upload the word file and an Excel Workbook. For the optimization...

Why do you think social media sites such as Face book and Twitter are becoming so popular in countries around the world? Discuss the importance of social media sites in the IMC programs of...

In developing a flexible budget within a relevant range of activity, a) it is necessary to prepare a budget at 1,000 unit increments. O b) variable and fixed costs are combined and are reported as a...

Determine each partner's share given a first-year net loss of $23,800. Allocation of Partnership Income Ramer Knox Total Net Income (loss) $(23,800) Salary allowances 0 Balance of income (loss) 0...

The business organization that has at least one general partner and other investors who have limited liability is a: corporation general partnership limited partnership limited liability company...

Are you telling a story, or have you got a lot of disconnected pages?

Have you looked carefully at the risks, assumptions and dependencies and documented them?

Have you got a one page summary that you are happy with?