step by step with pictures please

You are the business manager for Hamilton Classic Timepieces, an independent jewelry maker that specializes in timepieces Your company has three full-time and five pan-time employees Your store is currently open 40 hours per week, and based on demand, you require 200 weekly labor hours Full-time employees work between 30 and 50 hours per week. Pan-time employees work between 1 and20 hours per week. You want to use Solver to help determine the work schedule for the week. Your goal is to schedule all 200 labor hours while minimizjng the wages paid You will create name ranges where appropriate and create an answer repol to document your results Steps to Perform: Step Instructions Stan Excel Download and open the file named Grader has automatically addedyour last name to the beginning of the filename Create range names based on the values in the range 110:111 Edit the range name Gross_Earnings so it displays as Gross Apply the Gross and Total_Wages_Paid range names to the formula in cell 112 using the Apply Range name method Load the Solver add-in if it is not available Set the objective cell to Min Total Wages Paid (cell F13) Assign Hours Worked (range E5:E12) as the Changing Variables Cells Set a constraint to ensure hours scheduled per employee are whole numbers Set constraints (two required) to ensure full time employees work between 30 and 50 hours per week. Set constraints (two required) to ensure pan time employees work between O and 20 hours Set a constraint to ensure exactly 200 hours are scheduled for the week. Solve the model and create an Answer Repon to outline your findings Create a new worksheet named RangeNames and paste a list of the range names created for the analysis staling in cell A1 Save and close Exp22_Excel_Ch06_ML2_Wages.xlsx Exit Excel Submit the file as directed