14 Arial > General ' ' V Paste BIU a. Av $ % 9 13 A B D E G H 1 2 Raktida is the manager a popular Italian Restaurant on Mott Street. She wants to predict her guest counts for 3 the first week of November so that she can estimate an accurate number of servers to schedule. Business is 4 very good, but her sales history from last month indicates that fewer guests are served during the first few 5 days of the week compared to last year, whereas more guests per day are served in the later part of the 6 week. Raktida has entered the guest counts from last year and the estimated percentage change in guest 7 counts for this year in the chart below. Because good service is so important to her, she wants to ensure that 8 enough servers are scheduled to work each day. One server can provide excellent service to 50 guests. Help 9 Raktida calculate how many servers to schedule each day by completing the following chart. Note: Raktida 10 always rounds the number of servers required up to the next whole number to ensure the best service 11 possible for her guests! (Spreadsheet hint: Use ROUNDDOWN to 0 decimal places in the Estimated Guest 12 Count This Year column and ROUNDUP in the Number of Servers Needed This Year columns.) 13 14 15 10 Show all work to WHOLE NUMBERS. Raktida's Guest Forecast and Server Scheduling Worksheet for the 17 First Week of November Guest Count Estimated Estimated Number of Last Year Change This Guest Count Servers Year This Year Needed This Year 19 Sunday 650 -5.00% 20 Monday 775 -5.00% 21 Tuesday 850 0.00% 22 Wednesday 875 5.00% z Thursday 800 5.00% 24 Friday 1,275 10.00% 25 Saturday 1,425 10.00% 26 27 Would Raktida's server scheduling efforts this year be affected if last year she had recorded only her weekly (not daily) guest 20 counts? 30 31 32 Q1 Q2 03 Q4 Q5 06 Q7 Q8 + 28