Use the information below to answer parts A. - D. Frankovich's Fried Foods will be selling...

 

Transcribed Image Text:

Use the information below to answer parts A. - D. Frankovich's Fried Foods will be selling a limited number of their most popular items at the upcoming state fair. The company has decided that they would like to offer deep-fried Oreos, deep-fried ice cream, corn dogs, French Fries, and Funnel Cake. A data analytics student working at Frankovich's Fried Foods created a linear program to determine what product mix they should produce, in order to maximize their profit. The sensitivity output of that linear program is shown below. Variable Cells Final Reduced Objective Allowable Allowable Cell Value Coefficient Increase Decrease Name $C$3 Optimal solution Fried Oreos $D$3 Optimal solution Fried lce Cream SE$3 Optimal solution Corn Dogs $F$3 Optimal solution French Fries $G$3 Optimal solution Funnel Cake Cost 200 3.5 2 1E+30 350 2.75 1E+30 1 100 1.5 1.25 1E+30 500 0.5 1E+30 0.5 50 1 7.25 1E+30 Constraints Final Shadow Constraint Allowable Allowable R.H. Side Increase Decrease Cell $H$10 French Fries Demand LHS SH$11 Max Batter (Cups) LHS SH$12 Max Potatos LHS SH$11 Max Batter (Cups) LHS Name Value Price 500 0.5 500 2000 500 250 250 1E+30 50 250 1E+30 200 250 11 250 50 SH$12 Max Potatos LHS 50 250 1E+30 200 SH$6 Oreo Demand LHS 200 -2 200 100 200 SH$7 Ice Cream Demand LHS 350 150 200 1E+30 SH$8 Corn Dog Demand LHS SH$9 Funnel Cake Demand LHS 100 50 100 -1.25 100 200 50 -7.25 50 66.667 A.) If the optimal solution was implemented, how much profit would Frankovich's Fried Foods earn from deep-fried ice cream? [ Select ] B.) If the demand for Corn Dogs were to increase to 250, what would the effect on the objective function value be? [ Select ] C.) What would be the effect on the objective function value if the profit on Corn Dogs were to increase to $3.00? [ Select] D.) What would be the effect on the objective function value if a constraint was added to ensure that the amount of French Fries sold by Frankovich's Fried Foods was at least twice the amount they sold of Fried Oreos? [ Select ] Use the information below to answer parts A. - D. Frankovich's Fried Foods will be selling a limited number of their most popular items at the upcoming state fair. The company has decided that they would like to offer deep-fried Oreos, deep-fried ice cream, corn dogs, French Fries, and Funnel Cake. A data analytics student working at Frankovich's Fried Foods created a linear program to determine what product mix they should produce, in order to maximize their profit. The sensitivity output of that linear program is shown below. Variable Cells Final Reduced Objective Allowable Allowable Cell Value Coefficient Increase Decrease Name $C$3 Optimal solution Fried Oreos $D$3 Optimal solution Fried lce Cream SE$3 Optimal solution Corn Dogs $F$3 Optimal solution French Fries $G$3 Optimal solution Funnel Cake Cost 200 3.5 2 1E+30 350 2.75 1E+30 1 100 1.5 1.25 1E+30 500 0.5 1E+30 0.5 50 1 7.25 1E+30 Constraints Final Shadow Constraint Allowable Allowable R.H. Side Increase Decrease Cell $H$10 French Fries Demand LHS SH$11 Max Batter (Cups) LHS SH$12 Max Potatos LHS SH$11 Max Batter (Cups) LHS Name Value Price 500 0.5 500 2000 500 250 250 1E+30 50 250 1E+30 200 250 11 250 50 SH$12 Max Potatos LHS 50 250 1E+30 200 SH$6 Oreo Demand LHS 200 -2 200 100 200 SH$7 Ice Cream Demand LHS 350 150 200 1E+30 SH$8 Corn Dog Demand LHS SH$9 Funnel Cake Demand LHS 100 50 100 -1.25 100 200 50 -7.25 50 66.667 A.) If the optimal solution was implemented, how much profit would Frankovich's Fried Foods earn from deep-fried ice cream? [ Select ] B.) If the demand for Corn Dogs were to increase to 250, what would the effect on the objective function value be? [ Select ] C.) What would be the effect on the objective function value if the profit on Corn Dogs were to increase to $3.00? [ Select] D.) What would be the effect on the objective function value if a constraint was added to ensure that the amount of French Fries sold by Frankovich's Fried Foods was at least twice the amount they sold of Fried Oreos? [ Select ]

Answer rating: 100% (QA)

A Optimal Profit Final Value Objective coefficient Optimal Profit 20035 350225 10015 50005 501 Optim... View the full answer