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

  Under the accrual basis of accounting

Under the accrual basis of accounting, the discount on notes receivable should be reported as interest revenue

  List the elements of the sexual harassment case

List the elements of a disparate impact case and apply them to this case? Will Janet prevail on this charge? List the elements of the sexual harassment case and apply them to this case? Can the plant establish an affirmative defense

  Distribute a copy of the article to your classmates

During our last class you will be asked to present an article from the business press that directly relates to any of the topics covered in class. You need to a) distribute a copy of the article to your classmates and myself, b) submit a copy of your..

  Development of the protocols and documentation

What mistakes did Novedad and the Steering Committee make in the initial development of the protocols and documentation and early implementation stage and what were the early indications that the system was not working as planned, and why weren't ..

  Effective communication is the most important factor

Some experts say that effective communication is the most important factor in successfully leading change. Do you agree, and can you cite examples that support your view?

  Finance improvements to the water distribution system

On January 1, 2012, Central City issued a 20-year serial bond to finance improvements to the water distribution system. A total of $80,000,000 face value of bonds were issued with coupon and maturity rates as follows:

  Article nearshoring in latin america

Based on the article Nearshoring in Latin America, what are the short- and long-term implications of nearshoring given the current economic conditions?

  Turbulent business environment

In today's turbulent business environment, how can the integration of authentic leadership and fostering collaboration be used to increase organizational success and employee satisfaction?

  Question looking at the table below for the johnson company

question looking at the table below for the johnson company what is the total annual cost of maintaining the components

  An interdependent network of employees

Today's health care organizations rely on an interdependent network of employees

  The discussion board (db) is part of the core of online

The Discussion Board (DB) is part of the core of online learning. Classroom discussion in an online environment requires the active participation of students and the instructor to create robust interaction and dialogue. Every student is expected to c..

  Use the internet to shop for various goods

Shopbots are Internet sites for finding the best prices on goods you need. No shopbot searches the entire Internet, so it's a good idea to use more than one to get the best deals. Furthermore, not all shopbots quote shipping and handling costs. He..

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