1) Using Solver, minimize the Payroll/Week for the resort by changing the values in cells D5:D11. Remember these points as you complete the Solver Parameters dialog box: The number of employee work days in the range F13:L13 must be greater than or equal to the demand (range F15:L15), so there are enough people working for that day’s needs. The number of employees scheduled in D5:D11 must be >=1. 2) Solve this model using the Simplex LP method and keep the Solver solution.
3) In the Partafime Expenses sheet, insert into cell E8 a formula to calculate the total annual part-time e pense. The Benefit % is an estimate in the form of a percentage of total wages and needs to be added to the cost of wages based on the average part-time hours multiplied by the average hourly rate.
Schedule Days off Employees Sun Mon Tue Wed Thr Fri Sat
A Sunday, Monday 5 0 0 1 1 1 1 1
B Monday, Tuesday 1 0 0 1 1 1 1 1
C Tuesday, Wednesday 5 1 1 0 0 1 1 1
D Wednesday, Thursday5 1 1 1 0 0 1 1
E Thursaday, Friday 5 1 1 1 1 0 0 1
F Friday, Saturday 4 1 1 1 1 1 0 0
G Saturday, Sunday 5 0 1 1 1 1 1 0
Schedule Total 22 24 24 22 22 23 23
Total Needed 22 15 13 18 15 20 24
Total shifts schedule 160
Pay/Employee Day 5105.00
Payroll/Week Schedule $16.800.00
Expenses
Average Part-time hours 2250000
Average Hourly Rate $11.50
Benefit% 30.00%

When creating a budget, log fixed expenses before income. after income. after savings. at the top.

[java] create an application called registrar that has the following classes: a. a student class that minimally stores the following data fields for a student: - name - student id number - number of credits - total grade points earned and this class should also be provides the following methods: - a constructor that initializes the name and id fields - a method that returns the student name field - a method that returns the student id field - methods to set and retrieve the total number of credits - methods to set and retrieve the total number of grade points earned. - a method that returns the gpa (grade points divided by credits) b. an instructor class that minimally stores the following data fields for an instructor: - name - faculty id number - department the following methods should be provided: - a constructor that initializes the name and id fields - methods to set and retrieve the instructor’s department. c. a course class that minimally stores the following data for a course: - name of the course- course registration code- maximum number of 35 students- instructor- number of students- students registered in the course (an array)the following methods should also be provided: - a constructor that initializes the name, registration code, and maximum number of students- methods to set and retrieve the instructor- a method to search for a student in the course; the search should be based on an id number.- a method to add a student to the course. if the course is hill, then an exception with an appropriate message should be raised (try creating your own exception class for this). also, be sure that the student is not already registered in the course. the list of students should be in the order that they registered.- a method to remove a student from the course. if the student is not found, then an exception with an appropriate message should be raised (use the same exception class mentioned a method that will allow course objects to be output to a file using object serialization- a method that will allow course objects to be read in from a file created with object serializationyou will note that the student and instructor classes described above have some commonality. create aperson class that captures this commonality and uses it as a base class for student and instructor. this class should be responsible for the name and id fields and also provide atostring method that returns a string of the form name, id. this will be the inheritedtostring method for the student and instructor classes.1. draw a uml diagram for diss application.2. implement the previous classes in java. write a main program that can serve as a test class that tests all of the methods created and demonstrates that they are working

Which finger presses the h key on the keyboard? index finger on the left hand pinky finger on the right hand index finger on the right hand thumb on the left hand