I need either an answer using one of the three methods Solver methods (GRG, Evolutionary, Simplex). Please show your excel spreadsheet and a copy of the method used (with values).

General Instructions Put each problem on its own tab in your Excel file. You will turn this in as backup. For your primary submission, turn in a well-formatted Word document that shows your spreadsheet setup, your mization setup, and your solution (screenshots). For each question, identify the type of algorithm used to solve the problem, and why that algorithm is the most appropriate for that problem. If using Solver, expain any default settings you change or ensure are correct to your situation. Comment on any observations you make Part 1 You own small bakery capable of making three types of bread: white sandwich bread, gluten-free bread, and sourdough. The requirements and sale price for a batch (10 loaves) of cach type of bread are below. You can only make complete batches of each (no fractional batches) | Prep time (mns)price | Selling All- ,'' | Gluten-free l Yeast (07) purposeFlour Flour cups Bread (cups) White Gluten-Free 0 Sourdough50 20 20 15 20 25 15 $40 $50 30 The unit cost of each of the requirements are below All-purpose flour Gluten-free flour Yeast Prep time $012 per cup 0.20 per cup $0:25 per oz $0.40 per minute Arrange the data in an easy-to-read, orderly spreadsheet Have separate blocks of the spreadsheet showing solutions for cach of the three scenarios below (which are independent of one another). The solutions will indicate batches of each type needed to maximize profit. Athoughtful discussion of your approach is required for full credit. Scenario 1: Your prep is done by an employee who can only work for 40 hours (2400 minutes) per week. Scenario 2: Your delivery van can only fit 800 loaves (80 batches) of bread, and you can only make one irp Scenario 3: Your supplier will only sell you 2000 cups of each toype of flour