8D Charlotte Staffing Excel Spreadsheet Problem PDF

Preview

Summary

Assignment for the 8D Charlotte Staffing Excel Spreadsheet Problem...

Description

Scenario Summary Current Values:

Option 1

Option 2

Changing Cells: Sun_Mon 2 2 4 Mon_Tue 8 8 6 Tue_Wed 6 6 7 Wed_Thu 7 7 7 Thu_Fri 3 3 4 Sat_Sun 3 3 2 Result Cells: 29 29 30 $C$15 $8,170.75 $8,170.75 $8,452.50 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray.

2b5a6d44abde5a6c23edf2326483b4b9.docx

Option 3

2 8 6 7 3 6 32 $9,016.00

E v e n in g S h ift S e rv e r S ch e d u le Sch ed u l e B A C D E F

Da ys o f

Emp l o yees

M Su o nn , ,MTu o en Tu e, W ed W ed , Th u Th u , Fri Sa t, Su n Sch ed u l e To ta l s:

82 6 7 3 3 29

To ta l Dema n d : W eekl y P Waayro g el P l er ExpServer: en se: $ 8 ,2187 01 . 7 55

Su n 10 1 1 1 0 24 24

Mon 00 1 1 1 1 19 19

Tu e

W ed

01 0 1 1 1 15 15

Th u

11 0 0 1 1 16 16

Fri

11 1 0 0 1 19 19

Sa t 11 1 1 0 1 26 26

11 1 1 1 0 26 2 6

25254

Sale s by Se rve r - We e k of April 2 1 -2 8 Day Sun

Sh i f Evening

Sun

Day

Sun

Evening

Sun Sun Sun

Evening Eay D vening Evening

Se rve r Krist ina Krist ina Manda

1, 630. 65

1, 635. 30

1, 501. 93

Melanie

1, 407. 33

Day

Mon Mon

Eay D vening

Andre AManda ndre

1, 367. 92

Mon Mon Tue

Evening D Eay vening Day

Tue

Day Evening

Tue Tue Tue

E Dveni ay ng Day Evening

Carrie KMel enniat ni he Ricki Manda Manda Scot Leroy t Nelly Nelly

Tue

Day

K Manda rist ina

Tue

Day

Scot t

Tue Tue Tue Wed

Evening E Dveni ay ng Evening Day

Wed

E Dveni ay ng

Wed

Day

Wed Wed Wed

Day Day Evening

Wed

Evening

Wed

Evening

Wed Wed

Evening Evening

Wed

Evening

Wed Thu

D Eay vening

Thu Thu Thu Thu

Day Evening D Eay vening Day

Scot t Rob Lyle Lyle Krist ina KA rindre st ina Rob Sarah Alex R Sob arah Alex Nelly A Sndre cot t Leroy Leroy AleN xelly Rob Rob Sarah Sarah Andre

Thu

Evening

Andre

Thu

Evening

K Manda rist ina

Thu

Day

Manda

Thu

Evening

Scot t

Thu

Evening

Nelly

Fri

D Eay veni ng

Fri

Day

Fri

Eveni ng

Fri Fri Fri

D Eay veni ng Day

Rob Rob Sarah

Fri Fri Fri Fri Fri Fri Sat Sat

Eveni ng D Eay veni ng Eveni ng Day

Kendra KriK sri t sintaina Manda Andre

Eveni ng

Leroy Nel Klyrist ina

Evening Day Evening Day

Sat Sat Sat

E Dveni ay ng Evening Day

Krist ina Leroy N Manda elly Nelly Kennit h KA enni lext h Alex Sarah

742. 644.05 35

1, 238. 59 773. 916. 0574 710. 21 583. 87 1,1,253. 386.8140 1, 148. 61 1, 076. 25 1, 424. 59 1, 329. 419. 62 01 1, 203. 92 805. 70 1, 372. 604. 44 80 1, 405. 01 1, 325. 92 891. 846.07 73 690. 33 567. 52 1,1,347. 218.58 70 1, 116. 45 1, 046. 12 1,1,786. 384.50 70 1, 719. 04 1, 693. 45 1, 649. 25 1,783. 170.14 21 587. 87

823. 02 866. 13 551. 671. 6300 1, 184. 58 1, 309. 85 1,1,421. 991.29 20 1, 826. 04 1, 965. 61 1, 891. 18 1,2, 805. 067. 1197 2, 142. 40 2, 261. 04 2, 1, 298. 273. 26 17 1, 935. 45 1, 381. 49 1, 774. 1, 910. 91 58 1, 838. 23 1, 754. 57

SA arah ndre

2, 2, 010. 082. 0642

Andre

2, 197. 73

Scot t Leroy

To tal

Ricki

1, 367. 92

2, 233. 91 2, 055. 62

###

Average if Shif t = Evening and Nh igt ly Sales > $2, 000

$ 2, 150. 13

4

Se3rve -5 rShM i fso r T El i gi b l e Alex

4

1Err: 511

Andre

1

Anil 2

1,552 310

Eve n i n g $ 2, 692 Eve n i n g $ 6, 604 Eve n i n g $ 8, 939 Eve n i n g $ 2, 170 Eve n i n g $ 5, 139 Eve n i n g $ Eve n i n g $ 8, 159 Eve n i n g $ Eve n i n g $ 3, 6, 543 021 Eve n i n g $ 7, 280

Donny Kendra Kennit h

Melanie Nelly

0

Err: 511 Err: 511 Err: 511 Err: 511 Err: Err:511 511 Err: 511 Err: 511

Scot t

Err: 511 Err: 511

1Err: 511

Err: 511

0Err: 511 0 Err: 511

Ricki R Sob arah

5

1Err: 511 0Err: 511

Manda 0

4

0 Err: 511

1Err: 511

Leroy Lyle

4

0E 0E rr: rr:511 511 0Err: 511

Krist ina 5

2

6

1 Err: 511 0Err: 511

Carrie

11 2 4

Melanie

Scot t

856. 03

Employe e s of the We e k

Nu mb e r o f Sh i fs

Carrie

Leroy Manda Nelly SR arah ob

1,1,465. 459.63 88

E Dveni ay ng Evening

Se rve r Eve n i n g To tal Eve n i n g $ 5, 222 Eve n i n g $ 4, 677 Eve n i n g $ 1, 508 Eve n i n g $ 2, 741

Andre

Donny Kendra Eve Even ni ni gn g $ $ Kennit h

Lyle 773

1, 003 8, 648

1, 009. 56

Evening Evening

Alex Anil

Krist ina

9, 583 12, 621

10, 6, 552 659

625. 74

Sat Sat

2, 741 5, 347

4, 552

$

742. 05

Sat Sat

2, 876 1, 223 2, 494 12, 713

12, 470 $ $$

916. 773. 7405

1,1,288. 365.79 67

Kendra

DE ay veni ng Evening

Sat Sat Sat

1, 238. 59

1, 334. 01

Mike Donny Donny

12, 184

$

$

A ve rage ni gh tl y sal e s fo rse rve rs o n th e Eve n i n g sh i ft wh o h ave sal e s o ve r $ 2 , 0 0 0 i s $ 2 , 1 5 0 . 1 3

1, 002. 58

AleA xlex Mike

D Eay veni ng Day

9, 923

$

$ $ $

Ricki RS ob arah Scot t

1, 107. 26

Sarah

Eveni ng

Fri Fri

Sat

1, 186. 35 1, 181. 69

Se rve r Sale s - Eve ning Shif

W e e kl y Sal e s $

$ $ $

Melanie Nelly

956. 06

1,1,459. 465.88 63

Anil

$ $

Manda

795. 32 943. 15 1, 379. 828. 42 12

Lyl Lyl ee

Tue

Kennit h Krist ina Leroy Lyle

1, 274. 28

Manda Nelly Nelly

$

Carrie Donny Kendra

1, 507. 85

Kennit h Ricki Ricki

Evening Day Evening D Eay vening Day

Se rve r Andre Anil

1, 753. 24

Anil Carrie

Evening Day Day Evening

Mon

Mon Mon

Mon

Alex

1, 681. 82 1, 616. 69 1, 1, 215. 052. 1454

Evening Evening

Sun Sun Sun Sun Mon

Total Sale s Pe r Se rve r

Ni gh tl y Sal e s

Scot t NelLyl ly e Lyle

Sun Sun

Err: 511

Err: 511

0Err: 511 11E Err: rr:511 511 1 Err: 511

Err: 511 E Err: rr: 511 511 Err: 511

25254

Total Sales Per Server Server Alex Andre Anil Carrie Donny Kendra Kennith Kristina Leroy Lyle Manda Melanie Nelly Ricki Rob Sarah Scott

Weekly Sales $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

14,923 12,184 2,876 2,741 1,223 2,494 5,347 16,025 9,583 7,358 14,238 2,180 13,685 2,741 6,552 10,659 10,284

Cash Bonus $75 '' '' '' '' '' '' $100 '' '' $75 '' $75 '' '' '' ''

2b5a6d44abde5a6c23edf2326483b4b9.docx...