Question: pls show step by step how to get in excel with screenshots and many details as possible A company manufactures a product at its plants

pls show step by step how to get in excel with screenshots and many details as possible

A company manufactures a product at its plants in C and D; then ships the product to its four distribution centers in K, L, M, and N. The transportation costs per unit (in dollars per unit) are as follows: from C to K, L, M, and N: 10. 9,5, and 20. from D to K, L, M, and N: 2. 20, 8, and 10. The monthly demand from K, L, M, and N are: 3300, 1400, 4400, and 2600 units. respectively On the other hand, the monthly capacity at plants C and D are: 7200 and 4900 units, respectively Develop a linear programming model that can be used to determine the distribution plan that will minimize total monthly transportation cost. Use Excel Solver to find the optimal solution The optimal solution shows that the total monthly transportation cost is dollars

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!

please show step by step how to get solution in excel , as many details as possible A company manufactures a product at its plants in C and D; then ships the product to its four distribution centers...

I need help with the Final Project presentation. (The last part) I attached my previous presentations to it as well Milestones 1, 2, 3 and the interview research. Please help, and please cite all...

3 A Exercise 1 - Resource Allocation Inputs Resources Needed Per Unit of Product Product Product Product Product Available Resource 1 2 3 4 Resources Plastic (ounces) 8 8 8 320 Electrical components...

If the cost of decorations can be reduced by 60% via buying supplies in bulk for 6 months at a time, does that increase the attractiveness of hand-based calligraphy or computer calligraphy? What...

How to do this problem in excel? 1 Exercise 2: Transportation Problem 2 3 INPUTS 4 5 Your company manufactures product at three different plants (1, 2 and 3) and ship them to four different Customers...

Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 12 A" A ab Wrap Text v General Insert v "APO. Ex Delete v I v Paste BIUV OvAv Merge & Center $ ~ % "...

NNNN Company manufactures Product Stina using three different raw materials. The product details are as follows: Selling price per unit is R 2 5 0 0 . 0 0 Material A 3 kg R 3 5 per kg Material B 2 kg...

The Wilson Brothers Limited Case You have recently been hired as the HR manager responsible for two separate Ontario locations belonging to Wilson Brothers Limited. You have been asked by the HR...

Please provide detailed explainations for both the intorruction and the background. Thank you. VF Brands: Global Supply Chain Strategy It was August 2009. Chris Fraser, President, Supply Chain...

The steps in the sales/collection and acquisition/payment processes are listed below, but they are out of order. Put the statements in the proper order based on how they occur in organizations. a. An...

The accounting equation is out of balance when a. ending cash does not equal ending net income. b. total assets do not equal the total liabilities plus stockholders' equity. c. ending retained...

The Zens v . Quinlan case stands for the proposition that: When a taxpayer uses a chrulbow approach in an attempt to aroid the tax consequences that would have attended the direct diabribution of the...

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...