Purchase Solution

TILLERMAN'S TEA TASK - Determine target and constraint cells

Not what you're looking for?

Ask Custom Question

Attached is the file see tabs with solver answer and tab with tables and formulas

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

Attachments
Purchase this Solution
Solution Summary

Solution guide provided for you in Excel.

Purchase this Solution
Free BrainMass Quizzes
Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

View More Free Quizzes
Related BrainMass Solutions

  • Product-Mix Decision Model-Professor Tillerman's Tonic Tea

    127709 Decision Models: Professor Tillerman's Tonic Tea produces its three blends in the manner outlined below.

  • Budget Constraint

    321882 Budget Constraint for Coffee Bought Mrs. Hotdrinks enjoys coffee (C) and tea (T) according to the function U(C.T)= 3C + 4T. Her drinks budget is $5 per day, the price of a cup of coffee is $1, and the price of a cup of tea is $1.

  • Quantitative Analysis: Linear programming..

    AB then wants to analyze the results to determine the best place to add additional capacity. 1. Create the spreadsheet model for this case and use Solver to optimize. Include an Answer Report and a Sensitivity Report. 2.

  • Linear programming:Primal and Dual problem

    Following is the answer report from excel solver: Target Cell (Max) Cell Name Original Value Final Value $E$11 Total profit 30 6000 Adjustable Cells Cell Name Original Value Final Value $B$11 x1 0.25 50 $C$11 x2 0 0 $D$11

  • Integer goal programming model

    Thus sandwiches and tea may be ordered together, Thus for a level of sandwiches there must be a corresponding level of tea sold.

  • Peets Coffee and Tea

    Market price of stake in Peet's Coffee and Tea is exemplified.

  • "communication plan"

    Further, our target audience will also be health conscious people who will switch to coffee and tea if healthy options are provided.

  • Tea Party Movement

    438463 Tea Party and Religious Right Movements Could you please inform me on the following topic: Right now there are two major, quite active, groups within the Republican party, the Tea Party movement and the Religious Right.

  • Weaknesses are defined as constraints

    Step Two: Determine the Most Efficient Utilization of Each Constraint Step Three: Maximize the Flow Through the Constraint Step Four: Increase Capacity on the Constrained Resource Step Five: Redesign the Manufacturing Process for Flexibility and

View More Related Solutions