Essay About Amount Of A Grade Tomatoes And Amount Of B Grade Tomatoes

Red Brand Canners
Essay Preview: Red Brand Canners
Report this essay
Red Brand Canners
Problem 1:
Using 3,000,000 tomatoes for production (without extra tomatoes)
Decision variables
a1 = Amount of A grade tomatoes in Whole tomatoes
b1 = = Amount of B grade tomatoes in Whole tomatoes
a2 = Amount of A grade tomatoes in tomatoes juice
b2 = Amount of B grade tomatoes in tomatoes juice
b3 = Amount of B grade tomatoes in tomato paste
Resource Constraints:
a1-3b1
3a2-b2
a1+b1
14400000
a2+b2
1000000
2000000
a1+a2
600000
b1+b2+b3
2400000
a1, a2, b1, b2, b3 >= 0
Objective Function:
Z = 0.0822 a1 + 0.0822 b1 + 0.066 a2 + 0.066 b2 + 0.074 b3
Maximize Z
Objective Cell ()
Original Value
Final Value
$O$13
225340
225340
525000
175000
75000
225000
2000000
Problem 2:
Using 3,000,000 tomatoes for production and also purchase extra tomatoes
Decision variables
a1 = Amount of A grade tomatoes in Whole tomatoes
b1 = = Amount of B grade tomatoes in Whole tomatoes
a2 = Amount of A grade tomatoes in tomatoes juice
b2 = Amount of B grade tomatoes in tomatoes juice
b3 = Amount of B grade tomatoes in tomato paste
Resource Constraints:
a1-3b1
3a2-b2
a1+b1
14400000
a2+b2
1000000
2000000
a1+a2
680000
b1+b2+b3
2400000
a1, a2, b1, b2, b3 >= 0
Objective Function:
Z = -0.028 a1 + 0.0822 b1 – 0.019 a2 + 0.066 b2 + 0.074 b3 + 51000 -180000
Maximize Z
Z= 46875.5
525000
175000
75000
225000
2000000
esource Constraints:
a1-3b1
3a2-b2
a1+b1
14400000
a2+b2
1000000
2000000
a1+a2
600000
b1+b2+b3
2400000
esource Constraints:
a1-3b1