Using Solver on excel, Create three scenarios and a summary. Set the objective cell to J5, value of 60%. Solve for No minimum weight of vegetables by changing variable cells to the range C4:C6. Solve for Minimum 5 pounds of vegetables by using the constraints cell C5, >=, and 5. Solve for Twice as many vegetables as greens by using the constraints cell C5, =, C6*2. Create a Scenario Summary. On all sheets, insert the file name in the footer in the left section. Set the orientation to Landscape, width to 1 page, and center horizontally.
Using Solver on excel, Create three scenarios and a summary. Set the objective cell to J5, value of 60%. Solve for No minimum weight of vegetables by changing variable cells to the range C4:C6. Solve for Minimum 5 pounds of vegetables by using the constraints cell C5, >=, and 5. Solve for Twice as many vegetables as greens by using the constraints cell C5, =, C6*2. Create a Scenario Summary. On all sheets, insert the file name in the footer in the left section. Set the orientation to Landscape, width to 1 page, and center horizontally. Add appropriate information to the document properties including the tag Ahi salad and submit as directed by your instructor. Ahi Tuna Vegetables Field Greens Fixed Cost Ingredients Preparation Costs Total Cost of Salad Cost Per Quantity in Pound Pounds $ 25.00 5.00 4.00 Quantity Made (ounces) 275 Cost of Ingredients per ounce $ 1.307 10.0 4.5 3.0 17.50 Ahi Salad Costs Cost to Make $250.00 22.50 12.00 35.00 40.00 $ 359.50 Serving Size 10 oz plate Cost per Serving $ Price to Profit per Customer Serving 13.07 $ 18.95 $ 5.88 Percent Profit 31%.
Please use the directions and detail information from excel to solve problem.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
