Question: 12. (***) (Microsoft Excel problem). Consider the following information: a. Write out the assignment problem by hand, using Equations 12-4 through 12-7 and Example 12-7

12. (***) (Microsoft Excel problem). Consider the following information:

PLANT CAPACITY STORE DEMAND AB 400 X 200 B 500 Y 250

C 100 Z 300 Total: 1000 Total: 750

a. Write out the assignment problem by hand, using Equations 12-4 through 12-7 and Example 12-7 as a guide.

b. Develop an Excel spreadsheet that uses the Solver function to find the optimal shipping patterns between the plants and the stores. (Hint: The objective function for the optimal solution is $2200.) Interpret your answer. Is there any plant that is underutilized? If so, why do you think this is the case? How might you use this information in any future decision to expand plant capacities?

PLANT CAPACITY STORE DEMAND AB 400 X 200 B 500 Y 250 C 100 Z 300 Total: 1000 Total: 750

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 Supply Chain Management Questions!

Hello, Can you help me with this assignment? the instruction for this assignment is in the attachment below CIS 1220 Final Exam Problem Statement Fashion Impressions is a designer clothing...

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

12. (***) (Microsoft Excel problem) Consider the following information: PLANT B Total CAPACITY 400 500 100 1.000 STORE X Y z Total DEMAND 200 250 300 750 Cost to shop from plant to store (per unit of...

(***) (Microsoft Excel problem) Consider the following information: PLANT CAPACITY STORE DEMAND A 400 X 200 B 500 Y 250 C 100 Z 300 Total: 1,000 Total: 750 Cost to shop from plant to store (per unit...

Directions for Problem #4 in Excel The goal of this problem is to have you: Use Excel to generate the future value of each of the various investments made over the course of the 25 years. Use Excel...

Math 1172 Project #2 Financial Applications of Geometric Series Due: Tuesday, October 11 Name(s): - - - - - - - - - - - - - - - - - - - - Description - - - - - - - - - - - - - - - - - - - Most people...

Section 1. Another utilization of cash flow analysis is setting the bid price on a project. To calculate the bid price, we set the project NPV equal to zero and find the required price. Thus, the bid...

Over the past few weeks we have discussed different types of portfolio management (i.e., selection of which projects to implement). This is not an easy problem for organizations with scarce and...

I need a little bit of help with the following: (Data Analytics) Identify the various aspects of the organizational problems for each client . Although you may not be able to identify every aspect of...

On June 1, 2014, Weller Corp. issued $2,000,000, 9%, 5-year bonds at face value. The bonds were dated June 1, 2014 and pay interest semiannually on June 1 and December 1. Financial statements are...

Interrelation of composition variables in mixtures (a) Using the basic definitions in Eqs. (A) to (G) of Table 17.7-1, verify the algebraic relations in Eqs. (H) to (O). (b) Verify that, in Table...

You can create new users on a windows 1 0 machine by using the users login to which of the following Outlook.com Skype Xbox All of these options

In the citation Schusters Express, Inc., 66 T.C. 588 (1976), affd 562 F.2d 39 (CA2, 1977), nonacq., to what do the 66, 39, and nonacq. refer?