NO EXCEL SOLVER PLEASE (6) A frozen vegetable supplier makes two brands of mixed
ID: 3064031 • Letter: N
Question
NO EXCEL SOLVER PLEASE
(6) A frozen vegetable supplier makes two brands of mixed vegetables. Brand A contains 20% beans, 25% carrots, 25% peas and 30% sweet corn and yields a profit of $5 per kilo sold. Brand B contains 20% beans, 42% carrots, 28% peas and 10% sweet corn and sells giving a profit of S3 per kilo. Today, the supplier has available 120 kilos of beans, 160 kilos of carrots, 250 kilos of peas, and 166 kilos of sweet corn. Using Solver, he found that today he should produce 531.88 kilos of brand A and 64.36 kilos of brand B to maximize the profit. Are these brands containing some other vegetables besides beans, carrots, peas, and sweet corn? Explain your answer. What is his maximal profit today? Show the calculation. What is the inventory for every vegetable at the end of the day? Show the calculation. a. b. c. Variable Cells Final Value 531.88 64.36 Reduced Objective Coefficient Allwable Allowable Cost 0 0 Cell Name Increase SC$12 brand A SD$12 brand B Constraints Decrease 3.21 1.33 5.4 Final Value 119.25 160 150.99 Shadow Constraint Allowable Allowable Price 0 3.96 0 R.H. Side 120 160 250 Cell Name beans carrots peas Increase Decrease 0.75 21.67 99.01 SF$6 SF$7 1.9Explanation / Answer
a) These brands can contain some other vegitables also. We are considering the things where resources are a constraint.
b)
Maximum profit is
5* 531.88+ 3*64.36 = 2852.48
c)
Veg Final Value Constraint RH Side Inventory beans 119.25 120 0.75 carrots 160 160 0 peas 150.99 250 99.01 sweet corn 166 166 0Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.