I have an excel project that I'm stuck with. I'm including screen shots of the project. One screen shot includes all the instructions to follow on the project. The second screen shot includes the excel file needed for it. I have been able (I think) to complete instructions a-f but i'm stuck on g. Can you please help? ### Schedule Tab (Spreadsheet 1)#### Painted Paradise Resort & Spa**Work Schedule Overview:**- **Schedule Details:** - **Techs:** A, B, C, D, E, F - **Days Off:** - A: Monday, Monday - B: Tuesday, Tuesday - C: Tuesday, Wednesday - D: Wednesday, Thursday - E: Thursday, Friday - F: Saturday, Sunday - **Weekly Shifts:** - **Shifts per Employee:** - A: Sun (1), Mon (0), Tue (0), Wed (1), Thu (1), Fri (1), Sat (1) - B: Sun (1), Mon (1), Tue (0), Wed (0), Thu (1), Fri (1), Sat (1) - C: Sun (1), Mon (1), Tue (1), Wed (0), Thu (0), Fri (1), Sat (1) - D: Sun (1), Mon (1), Tue (1), Wed (1), Thu (0), Fri (0), Sat (1) - E: Sun (1), Mon (1), Tue (1), Wed (1), Thu (1), Fri (0), Sat (0) - F: Sun (0), Mon (1), Tue (1), Wed (1), Thu (1), Fri (1), Sat (0)**Summary:**- **Schedule Total:** - Sunday: 24 - Monday: 24 - Tuesday: 22 - Wednesday: 24 - Thursday: 20 - Friday: 22 - Saturday: 24- **Total Weekly Shifts:** 160- **Pay Per Employee Per Day:** $80.00- **Total Pay Per Week:**---### Part-Time Expenses Tab (Spreadsheet 2)#### Painted Paradise Resort & Spa**Expenses Overview:**- **Average Part-Time Hours:** 210600- **Average Hourly Rate:** $10.30- **Benefit Percentage:** 28.00%**Wage Calculation:**- **Total Part-Time Wage Expense:** (not filled in the spreadsheet) This spreadsheet is designed to help manage scheduling and calculate part-time employee expenses efficiently at Painted Paradise Resort & Spa. **Problem Solve 1 – Page 581****Student Data File Needed**: `e05Ch10Schedule.xlsx`. You will save your file as: `e05Ch10Schedule_LastFirst.xlsx`**Scheduling Employees**The Painted Paradise Resort & Spa is working on managing expenditures on part-time labor. Management sees potential to reduce costs in some areas. One requirement is a five-day schedule with two days off. They aim to create an optimal schedule considering the impact of raises and benefits increases due to regulations.**Steps:**a. Open the Excel file, `e05Ch10Schedule`. Save your file as `e05Ch10Schedule_LastFirst` using your last and first name. If necessary, enable content.b. The Schedule worksheet shows employee work schedules (rows 6–12). 1s represent working days, and 0s represent days off (e.g., 2 consecutive days off). The range D6:D12 shows the number of employees assigned to the schedule. Adjust this range to meet scheduling needs.c. In cell F14, calculate the total number of employees scheduled for Sunday for all schedules A-G. Multiply the number of employees for schedule A in cell D6 by the value (1 or 0) in F6 to see if employees work that day. Use absolute cell references in your formula for easy copying to other rows. Do the same for schedule B, adding numbers for all Sunday schedules.d. Copy the formula to L14.e. In cell D19, calculate the total number of scheduled shifts using the range F14:L14.f. In cell D21, calculate the weekly payroll by multiplying the number of shifts by the cost per employee per day.g. Use Solver to minimize Payroll/Week by finding the optimal number of employees for each schedule, considering:- The number of people in F14:L14 must meet demand (range F16:L16).- Employees scheduled in D6:D12 must be greater than zero.- Use Simplex LP in Solver.- Keep Solver's solution and create an Answer Report.h. In the Part-Time Expenses sheet, enter a formula in cell E8 to calculate total annual part-time wages, including Benefits% as an estimate.i. Develop scenarios based on the Part-Time Expenses for management's next year planning:- The first three scenarios vary the expected hours by 3%. Expected hours are 210,600. Create scenarios for average, minimum,

The, answer has given below:To calculate the payroll, 1 month = 30 days 1 week = 7 days, 1 week can be calculated, Now according to question, f, the total shift & cost per employee per day can be calculated as = 14 In the excel use the formula, = D19/D20*7