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

  Ebay sellers affected the creation of value

How has the change in the nature of eBay sellers affected the creation of value

  Questions1- what elements of project portfolio management

questions1- what elements of project portfolio management are currently in place in the process to develop new products

  Distinguish moral value judgments from value judgments

Distinguish moral value judgments from value judgments. Provide examples

  Quality management and continuous improvement

Quality management and continuous improvement

  Conduct a program of research to find best test population

MBA8000 ASSIGNMENT: Research Design. You are to write a bid to conduct a program of research to find the best test population.In your bid you need to outline the research design you would recommend and what data collection and statistical tests

  Important for managers to have a working knowledge

Why is it important for managers to have a working knowledge of perception and attribution?

  What is corporate planning

What is corporate Planning

  Outline of preliminary research with two scholarly reference

Once you choose topic, submit an outline of preliminary research with two scholarly references.  Within outline, discuss why you chose topic, possible subtopics for focus (two), possible research questions you could investigate and the relevan..

  How can the accounting function better serve the needs

How can the accounting function better serve the needs of our value stream teams and manufacturing cells in their efforts to optimize performance?

  What value do you believe a manager has to a business

What value do you believe a manager has to a business?

  Shared practice-cost-profit-and investment centers

Companies are often organized into departments by functions, such as operations, marketing, sales, corporate headquarters, etc. Typically, each one of these departments is then assigned specific responsibilities and referred to as either a cost ce..

  Use the model developed in this chapter to determine

Suppose that workers were available 24 hours per day but the total number of hours worked per day could not increase. That is, there would be 2/3rds of the number of workers determine above would work each shift.

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