Homework Help is Here – Start Your Trial Now!
Math
Calculus
Transshipment - Grandma's Cheese Shed X A-1-5 X A-2-5 X A-2-6 X A-3-6 X A-4-6 XA-4-12 XA-4-13 X A-5-6 X A-5-7 X A-5-8 X A-5-9 X A-6-5 XA-6-10 XA-6-11 XA-6-12 X A-6-13 X B-1-5 X B-2-5 X B-2-6 X B-3-6 X B-4-6 X B-4-12 X B-4-13 X B-5-6 X B-5-7 X B-5-8 X B-5-9 X B-6-5 X B-6-10 X B-6-11 X B-6-12 X B-6-13 Optimal solution 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Min $0.15 $0.12 $0.25 $0.30 $0.35 $0.20 $0.25 $0.25 $0.25 $0.10 $0.05 $0.25 $0.05 $0.15 $0.25 $0.30 $0.15 $0.12 $0.25 $0.30 $0.35 $0.20 $0.25 $0.25 $0.25 $0.10 $0.05 $0.25 $0.05 $0.15 $0.25 $0.30 $0.00 LHS Constriant Production table constr (factory) Demand table constr (shed) Warehouse constr 15%B constr 1 1 Additional constr every decision variable is integar, >=0, <=2000 -0.15 -0.15 -1 -1 -1 -1 -1 -1 -0.15 -0.15 -0.15 -0.15 -0.15 -1 -0.15 -1 -0.15 0.85 0.85 RHS 0 1615 0 s 2635 0 S 1530 0 S 0 0 S 85 0 S 465 0 s 170 0 s 220 ΟΙ 380 0 s 1200 0 S 380 0 S 1160 0 460 0 S 1000 -1 -1 -1 -1 0 E 0 -1 -1 -1 -1 0 = 0 0.85 0.85 0.85 0.85 0.85 0.85 0.85 ΟΙ = 0

Transshipment - Grandma's Cheese Shed X A-1-5 X A-2-5 X A-2-6 X A-3-6 X A-4-6 XA-4-12 XA-4-13 X A-5-6 X A-5-7 X A-5-8 X A-5-9 X A-6-5 XA-6-10 XA-6-11 XA-6-12 X A-6-13 X B-1-5 X B-2-5 X B-2-6 X B-3-6 X B-4-6 X B-4-12 X B-4-13 X B-5-6 X B-5-7 X B-5-8 X B-5-9 X B-6-5 X B-6-10 X B-6-11 X B-6-12 X B-6-13 Optimal solution 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Min $0.15 $0.12 $0.25 $0.30 $0.35 $0.20 $0.25 $0.25 $0.25 $0.10 $0.05 $0.25 $0.05 $0.15 $0.25 $0.30 $0.15 $0.12 $0.25 $0.30 $0.35 $0.20 $0.25 $0.25 $0.25 $0.10 $0.05 $0.25 $0.05 $0.15 $0.25 $0.30 $0.00 LHS Constriant Production table constr (factory) Demand table constr (shed) Warehouse constr 15%B constr 1 1 Additional constr every decision variable is integar, >=0, <=2000 -0.15 -0.15 -1 -1 -1 -1 -1 -1 -0.15 -0.15 -0.15 -0.15 -0.15 -1 -0.15 -1 -0.15 0.85 0.85 RHS 0 1615 0 s 2635 0 S 1530 0 S 0 0 S 85 0 S 465 0 s 170 0 s 220 ΟΙ 380 0 s 1200 0 S 380 0 S 1160 0 460 0 S 1000 -1 -1 -1 -1 0 E 0 -1 -1 -1 -1 0 = 0 0.85 0.85 0.85 0.85 0.85 0.85 0.85 ΟΙ = 0

Calculus: Early Transcendentals
Calculus: Early Transcendentals
8th Edition
ISBN:9781285741550
Author:James Stewart
Publisher:James Stewart
Chapter1: Functions And Models
Section: Chapter Questions
Problem 1RCC: (a) What is a function? What are its domain and range? (b) What is the graph of a function? (c) How...
See similar textbooks
icon
Related questions
Question
Problem 4 - Transshipment - Grandma's Cheese Shed (15%) Your team has recently accepted a consulting role at Grandma's Cheese Shed and has been tasked with helping their logistics department. Recently, Grandma's Cheese Shed has added two new cheeses as part of their "Grandmas Pack'n HEAT" line of spicy foods, these two cheeses are 'Carolina Reaper' Cheddar and 'Heat is Real' Muenster. These new cheese varieties have been so popular, Grandma's Cheese Shed has been struggling to keep them in stock. Your team is tasked with producing a transportation model to find the lowest possible daily cost of shipping these new spicy cheeses to the many cheese sheds scattered across Ohio. The head of the logistics department has provided you with some information to help your team build the transportation model. First, you are informed that while there are no capacity constraints associated with the company's two warehouses in Columbus and Canton, the connections between the various cheese factories, warehouses, and cheese sheds do have a limited capacity. The refrigerated trucks that will be used to ship the spicy cheeses must share space with other products and therefore, each truck can only carry 1000 blocks of spicy cheese at a time. You are also told that each facility connection has one truck assigned to it that runs twice a day, with two deliveries being made. Second, you are informed about an agreement that exists between Grandma's Cheese Shed and Trader Terry's, a large grocery store chain in the Midwest. This agreement allows Grandma to sell her products in Trader Terry's if Grandma delivers the products to Trader Terry's Distribution center. For each block of cheese delivered to Trader Terry's Distribution Center, Grandma's Cheese Shed will earn 50 cents. Furthermore, you are informed that 15% of total spicy cheese sales are for the 'Heat is Real' Muenster. Lastly, its not possible for Grandma to sell a partial block of cheese! Be sure to make this an integer program. In the template, the following variables represent the respective cheeses: �= 'Carolina Reaper' Cheddar �= 'Heat is Real' Muenster The decision variable will work like so: X 'product type' - 'start node' - 'end node' USE SOLVER AND EXCEL FORMULAS TO COMPLETE THE TABLE.
 
Transshipment - Grandma's Cheese Shed X A-1-5 X A-2-5 X A-2-6 X A-3-6 X A-4-6 XA-4-12 XA-4-13 X A-5-6 X A-5-7 X A-5-8 X A-5-9 X A-6-5 XA-6-10 XA-6-11 XA-6-12 X A-6-13 X B-1-5 X B-2-5 X B-2-6 X B-3-6 X B-4-6 X B-4-12 X B-4-13 X B-5-6 X B-5-7 X B-5-8 X B-5-9 X B-6-5 X B-6-10 X B-6-11 X B-6-12 X B-6-13 Optimal solution 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Min $0.15 $0.12 $0.25 $0.30 $0.35 $0.20 $0.25 $0.25 $0.25 $0.10 $0.05 $0.25 $0.05 $0.15 $0.25 $0.30 $0.15 $0.12 $0.25 $0.30 $0.35 $0.20 $0.25 $0.25 $0.25 $0.10 $0.05 $0.25 $0.05 $0.15 $0.25 $0.30 $0.00 LHS Constriant Production table constr (factory) Demand table constr (shed) Warehouse constr 15%B constr 1 1 Additional constr every decision variable is integar, >=0, <=2000 -0.15 -0.15 -1 -1 -1 -1 -1 -1 -0.15 -0.15 -0.15 -0.15 -0.15 -1 -0.15 -1 -0.15 0.85 0.85 RHS 0 1615 0 s 2635 0 S 1530 0 S 0 0 S 85 0 S 465 0 s 170 0 s 220 ΟΙ 380 0 s 1200 0 S 380 0 S 1160 0 460 0 S 1000 -1 -1 -1 -1 0 E 0 -1 -1 -1 -1 0 = 0 0.85 0.85 0.85 0.85 0.85 0.85 0.85 ΟΙ = 0
Transcribed Image Text:Transshipment - Grandma's Cheese Shed X A-1-5 X A-2-5 X A-2-6 X A-3-6 X A-4-6 XA-4-12 XA-4-13 X A-5-6 X A-5-7 X A-5-8 X A-5-9 X A-6-5 XA-6-10 XA-6-11 XA-6-12 X A-6-13 X B-1-5 X B-2-5 X B-2-6 X B-3-6 X B-4-6 X B-4-12 X B-4-13 X B-5-6 X B-5-7 X B-5-8 X B-5-9 X B-6-5 X B-6-10 X B-6-11 X B-6-12 X B-6-13 Optimal solution 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Min $0.15 $0.12 $0.25 $0.30 $0.35 $0.20 $0.25 $0.25 $0.25 $0.10 $0.05 $0.25 $0.05 $0.15 $0.25 $0.30 $0.15 $0.12 $0.25 $0.30 $0.35 $0.20 $0.25 $0.25 $0.25 $0.10 $0.05 $0.25 $0.05 $0.15 $0.25 $0.30 $0.00 LHS Constriant Production table constr (factory) Demand table constr (shed) Warehouse constr 15%B constr 1 1 Additional constr every decision variable is integar, >=0, <=2000 -0.15 -0.15 -1 -1 -1 -1 -1 -1 -0.15 -0.15 -0.15 -0.15 -0.15 -1 -0.15 -1 -0.15 0.85 0.85 RHS 0 1615 0 s 2635 0 S 1530 0 S 0 0 S 85 0 S 465 0 s 170 0 s 220 ΟΙ 380 0 s 1200 0 S 380 0 S 1160 0 460 0 S 1000 -1 -1 -1 -1 0 E 0 -1 -1 -1 -1 0 = 0 0.85 0.85 0.85 0.85 0.85 0.85 0.85 ΟΙ = 0
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Calculus: Early Transcendentals
Calculus: Early Transcendentals
Calculus
ISBN:
9781285741550
Author:
James Stewart
Publisher:
Cengage Learning
Thomas' Calculus (14th Edition)
Thomas' Calculus (14th Edition)
Calculus
ISBN:
9780134438986
Author:
Joel R. Hass, Christopher E. Heil, Maurice D. Weir
Publisher:
PEARSON
Calculus: Early Transcendentals (3rd Edition)
Calculus: Early Transcendentals (3rd Edition)
Calculus
ISBN:
9780134763644
Author:
William L. Briggs, Lyle Cochran, Bernard Gillett, Eric Schulz
Publisher:
PEARSON
Calculus: Early Transcendentals
Calculus: Early Transcendentals
Calculus
ISBN:
9781319050740
Author:
Jon Rogawski, Colin Adams, Robert Franzosa
Publisher:
W. H. Freeman
Precalculus
Precalculus
Calculus
ISBN:
9780135189405
Author:
Michael Sullivan
Publisher:
PEARSON
Calculus: Early Transcendental Functions
Calculus: Early Transcendental Functions
Calculus
ISBN:
9781337552516
Author:
Ron Larson, Bruce H. Edwards
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS