Computers and Technology, 09.04.2021 04:20 Vanessar3143

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%

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 10:40

Nims is applicable to all stakeholders with incident related responsibilities. true or false

Answers: 1

Answer

Computers and Technology, 22.06.2019 14:40

You are working with a professional edition organization. they wish to install the expense tracker which requires the use of 4 custom tabs, 3 custom objects, and one custom app. if the company is already using 4 applications, 36 custom objects, and 7 custom tabs, what will happen when they try to install expense tracker?

Answers: 1

Answer

Computers and Technology, 22.06.2019 20:10

Assume that minutes is an int variable whose value is 0 or positive. write an expression whose value is "undercooked" or "soft-boiled" or "medium-boiled" or "hard-boiled" or "overcooked" based on the value of minutes. in particular: if the value of minutes is less than 2 the expression's value is "undercooked"; 2-4 would be a "soft-boiled", 5-7 would be "medium-boiled", 8-11 would be "hard-boiled" and 12 or more would be a "overcooked".

Answers: 1

Answer

Computers and Technology, 22.06.2019 23:30

For her science class, elaine is creating a presentation on weather in the united states. she wants to make the presentation beautiful and interesting by drawing simple cloud or wave shapes. which is the best way for elaine to draw these shapes?

Answers: 1

Answer

You know the right answer?

1) Using Solver, minimize the Payroll/Week for the resort by changing the values in cells D5:D11. Re...

Questions