Answered You can hire a professional tutor to get the answer.
I know how to do this I just need help with the Excel Solver, I can't get the report to come up and I'm not understanding how to set it up. A small
I know how to do this I just need help with the Excel Solver, I can't get the report to come up and I'm not understanding how to set it up.A small winery manufactures two types of wine results in profit of $4 per quart has profit of $5 per quart. Each worker puts in a 9 hour day. The quantity of alcohol than can be used to fortify the wine is limited to 24 ounces daily. Six ounces of alcohol are added to each quart of Burbo's Better and 3 ounces are added to Burbo's Best. Give the LP Model and use both the graphical method and Excel to find the optimal solution.
Situation1Decision VariablesValuesObjective FunctionCoefficients Constraintsworkeralcohol x y Max Profit 1.5 5 4 5 Coefficients2363 31.00 LHS RHS1824 <=<= 1824