Excel File Edit View Insert Format Tools: Data Window Help AutoSave OFF Copy of Assignment-08 Fall 2022-1 Home Insert Draw Page Layout Formulas Data Review View Tell me 24 Clear v Reapply Get Data (Power Query) Data from Picture Refresh All Stocks Currencies Sort Filter Advanced Text to Columns What-if Outlim Analysis xfx B D E F N34 1 Use Excel SOLVER to maximize the revenue (place answer in Cell E18) by varying manufacturing variables in the yellow highlighted range (D6:F8) G H K L 3 Lawn Mower Manufacturing Data 4 5 6 7 B 9 10 Basic Riding Rechargeable Total Production 11 Suggested Selling Price Data 12 13 14 15 16 17 Mower Type Constraints Mower Construction Materia Plastic Steel Aluminum Mower Type Total Highest Market For Sales Estimate 0 Basic 4000 0 Riding 3000 0 Rechargeable 1000 0 0 0 Plastic Steel Aluminum Basic Riding Rechargeable $400 $500 $ $600 $700 $ $800 $900 $ 600 800 1,000 18 Total Revenue From Selling Mowers 19 20 21 22 23 24 25 26 27 28 Material Availability For Production Estimate Plastic Steel 3000 2000 Aluminum 200