Two plants producing forklift trucks

Assignment Help Management Theories
Reference no: EM131100512

The Move-It Company has two plants producing forklift trucks that then are shipped to three distribution centers. The production costs are the same at the two plants, and the cost of shipping for each truck is shown for each combination of plant and distribution center:

A total of 60 forklift trucks are produced and shipped per week. Each plant can produce and ship any amount up to a maximum of 50 trucks per week, so there is considerable flexibility on how to divide the total production between the two plants so as to reduce shipping costs. However, each distribution center must receive exactly 20 trucks per week. Management's objective is to determine how many forklift trucks should be produced at each plant, and then what the overall shipping pattern should be to minimize total shipping cost.

(a) Formulate this problem as a transportation problem by constructing the appropriate parameter table.

(b) Display the transportation problem on an Excel spreadsheet.

(c) Use the Excel Solver to obtain an optimal solution.

Reference no: EM131100512

Questions Cloud

Reflect on your motivation to complete your degree : Reflect on your motivation to complete your degree. Identify which model of motivation aligns with your reasons - review the web article "A Theory of Human Motivation." Focus on the different factors that increase motivation.
Find the future values of fv of $400 and annuities described : Find the future values of the following ordinary annuities: a. FV of $400 each 6 months for 5 years at a nominal rate of 12 percent, compounded semiannually. b. FV of $200 each 3 months for 5 years at a nominal rate of 12 percent, compounded quarterl..
Draw a gate diagram implementing the sop using nand gates : For the function F(w, x, y, z) = Σ(0, 1, 4, 5, 7, 10, 11, 13, 14, 15), Simplify the function using a K-map to form a sum of products. Draw a gate diagram implementing the SOP using NAND gates
Equation that represents relation and solve : The amount of money they spend on the first day plus the amount of money they spend on the second day equals 2.3 times the amount they spent on the third day. Write an equation that represents this relation, and solve.
Two plants producing forklift trucks : The Move-It Company has two plants producing forklift trucks that then are shipped to three distribution centers. The production costs are the same at the two plants, and the cost of shipping for each truck is shown for each combination of plant ..
Disadvantaged or underprivileged groups of society : How social research should be used to aid the disadvantaged or underprivileged groups of society - project Camelot is an example of how social research can be used to suppress the already disadvantaged.
Find the present value of $500 due in the future : Find the present value of $500 due in the future under each of the following conditions: a. 12 percent nominal rate, semiannual compounding, discounted back 5 years. b. 12 percent nominal rate, quarterly compounding, discounted back 5 years. c. 12 pe..
Fluid ounces of purple paint : She adds 3/10 of a fluid ounce of red to 11/15 of a fluid ounce of blue to make 1 1/30 fluid ounce of purple. How many ounces of of red paint will she need to make 3 fluid ounces of purple paint?
What does the coase theorem suggest will take place : What does the Coase theorem suggest will take place?

Reviews

Write a Review

Management Theories Questions & Answers

  Learning in action

Learning contract proposal that will form the basis of your learning contract report.

  Change is the only constant

"Change is the only constant " Evaluate the different types of change that have occurred in Sony.

  How do advertisers try to use group influence

How do advertisers try to use group influence?  Will you find any specific examples and explain the relevant theory of group behavior and influence?

  Case study:saving sony

You have been appointed by Sony as a consultant on change management. Advise Sony on how they could implement the change by using the various theories of change you have learnt.

  How the stock market works

The purpose of this project is to help you to gain an understanding of how the stock market works and of the relationship between theory and practice.

  Find the optimal production quantities

Find not only the optimal production quantities, but also the optimal total cost.

  Describe the management process

Describe the management process and identify the skills required to manage business organizations.

  Case study : bert''s bonsai and aquatic sport museum

Case Study : Bert's Bonsai and Aquatic Sport Museum Prepare a knowledge management system.

  Knowledge management techniques

Demonstrate understanding of the many-sided nature of knowledge management

  Theory of transtheoretical model

Demonstrate understanding of the many-sided nature of knowledge management

  Write a paper on historical trends of management

Write a paper on Historical Trends of Management.

  Theory of reasoned action

Theory of Planned Behavior and Integrated Behaviors Model

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd