Order ready-to-submit essays. No Plagiarism Guarantee!
Note: All our papers are written from scratch by human writers to ensure authenticity and originality.
Attached is the file see tabs with solver answer and tab with tables and formulas
Verify your essay before you submit. Get an Official Turnitin Report for Just $8.99!
Check your paper with the same Turnitin report your professor uses. AI detection + similarity score without storing your work. Pay once, no subscription
Check My Assignment!TILLERMAN’S TEA TASK
PROBLEM: Production costs, including shipping are to high
OBJECTIVE: Lower the cost
Brewing Facilities Bottle Suppliers
1- Des Moines 1- Biggs Bottles, St. Louis
2- St. Louis 2- Mighty Miss Glass Co., Davenport
3- St. Paul 3- Downstate Glass Corp., Springfield, Ill
4- Chicago 4- Kansas Bottles, Kansas City Kansas
i=brewing facilities 5- Haffle Glass Co., Cedar Rapids
j=bottle suppliers
OBJECTIVE FUNCTION OBJECTIVE FUNCTION FORMULA
Bottle and shipping costs per case lots of 100’s cases to brewer from supplier MIN: c11x11 + c12x12 + c13x13 + c14x14 + c15x15+ …
(in $)
x = # bottles received from the supplier to the brewer plant
cij 1 2 3 4 TARGET CELL
1 $960 $444 $1,272 $1,104 311969.88 Formula
2 $672 $1,272 $1,632 $1,032
3 $1,380 $816 $1,464 $1,176
4 $960 $960 $1,200 $1,320
5 $828 $1,668 $1,548 $1,428
total $23,136
CONSTRAINTS # bottles received = demand
bottles shipped ≤ amount available at supplier
All ≥ 0
Weekly demand from plants in case lots CONSTRAINTS FORMULA
Supplier 1 2 3 4 total demand total availability
1 6.95 62.82 33.31 80.92 184 184
2 0 0 0 37 37 37 DEMAND
3 15.71 0 0 0 15.7 46 X11 + X12+X13+X14+X15=DEMAND 1= 59.66 …
4 0 0 46 0 46 46
5 37 0 0 0 37 37 AVAILABILITY
total 59.66 62.82 79.31 117.92 319.7 350 x11+x21+x31+x41 ≤ available 1 184 …
© BrainMass Inc. brainmass.com March 21, 2019, 12:56 pm ad1c9bdddf
https://brainmass.com/business/business-management/tillerman-s-tea-task-determine-target-and-constraint-cells-84461
Attachments
apontesandraTillermantask1.xls