Homework for Chapter $6$

$10$ points

Skipped

eBook

References

The Move$-$lt Company has two plants building 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 each truck is shown below for each combination of plant and distribution center.

$\backslash$table$[[,$Distribution Center$],[$Unit Cost,$1,2,3],[$Plant A$,$$$800,$$$700,$$$400],[$Plant B$,$$$600,$$$800,$$$500]]$

Click here for the Excel Data File

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.

Formulate and solve a spreadsheet model for this problem.

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

Note: Enter $"0"$ if nothing is shipped.

$\backslash$table$[[,\backslash$table$[[$Distribution$],[$Center $1]],\backslash$table$[[$Distribution$],[$Center $2]],\backslash$table$[[$Distribution$],[$Center $3]]],[$Plant A$,,,],[$Plant B$,,,]]$

Total cost