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 09:40

It is vital to research each of the services you plan to disable before implementing any change, especially on critical machines such as the: a. servers in the test environment. b. domain controller and other infrastructure servers. c. desktops that have previously been attacked. d. desktops used by upper-level management.

Answers: 2

Answer

Computers and Technology, 22.06.2019 11:40

Design a pos circuit that displays the letters a through j on a seven-segment indicator. the circuit has four inputs w, x, y, and z which represent the last 4 bits of the uppercase ascii code for the letter to be displayed. thus, if wxyz = 0001 then "a" will be displayed. (any answer with 22 or fewer gates and inverters, not counting any for the inputs, is acceptable)

Answers: 2

Answer

Computers and Technology, 23.06.2019 11:00

What are the possible consequences of computer hacking? what is computer piracy? describe some examples. what are the effects of computer piracy? what are the possible consequences of computer piracy? what is intentional virus setting? describe some examples. what are the effects of intentional virus setting? what are the possible consequences of intentional virus setting? what is invasion of privacy? describe some examples. what are the effects of invasion of privacy? what are the possible consequences of invasion of privacy? what is an acceptable use policy and what is the purpose of the acceptable use policy what is intellectual property and how can you use it?

Answers: 1

Answer

Computers and Technology, 23.06.2019 21:30

To move a file or folder in microsoft windows, you can click and hold down the left mouse button while moving your mouse pointer to the location you want the file or folder to be, which is also known as.

Answers: 3

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