Identify Yourself Fill in cells B1, B2 and B3. Your section number will be a number between 1 and 12. Staffing Guide Java Juice Staffing Guide - Hours Worked by Job Title Breakfast Lunch Dinner Daily Total Customers per hour Hours per period 79 60 44 960 Pay Wages Percent of In $ Rate Wages 5 Hours 5 6 Hours 6 5 Hours 5 16 Hours 16 Cashier/Hostess Drink Preparers Food Preparers Clean up Crew Total $0.00 In the B11:013 range, enter values for the number of hours you will assign people to work in each occupation. The staffing hours will probably include more than one person working in some of the groups. The number of hours is up to you to decide. 1. Enter SUM functions in the E10:E13 range to show the total hours in each row. In the F10:F13 range, enter values for the rate of pay for each occupation. The rate of pay is up to you to decide, but the minimum wage is $10 per hour. 2. In the G10:G13 range, enter formulas to calculate the total wages in dollars. 3. The total wages must be in the range of $1200-$1600. If you are too high or too low, adjust the number of hours and or the pay rates until you reach the goal range. 4. In the H10:H13 range, enter formulas to show the wages in each row as a percentage of the total wages. Use a fixed cell reference referring to cell G14 as the denominator in these formulas. 6 Java Juice Staffing Guide - Hours Worked by Job Title Breakfast Lunch Dinner Daily Total 79 60 44 960 5 Hours 6 Hours 5 Hours 16 Hours 5 6 5 16 Pay Wages Percent In $ of Wages 9 Rate 7 8 Customers per hour Hours per period 10 Cashier/Hostess 11 Drink Preparers 12 Food Preparers 13 Clean up Crew 14 Total $0.00 Identify Yourself Fill in cells B1, B2 and B3. Your section number will be a number between 1 and 12. Staffing Guide Java Juice Staffing Guide - Hours Worked by Job Title Breakfast Lunch Dinner Daily Total Customers per hour Hours per period 79 60 44 960 Pay Wages Percent of In $ Rate Wages 5 Hours 5 6 Hours 6 5 Hours 5 16 Hours 16 Cashier/Hostess Drink Preparers Food Preparers Clean up Crew Total $0.00 In the B11:013 range, enter values for the number of hours you will assign people to work in each occupation. The staffing hours will probably include more than one person working in some of the groups. The number of hours is up to you to decide. 1. Enter SUM functions in the E10:E13 range to show the total hours in each row. In the F10:F13 range, enter values for the rate of pay for each occupation. The rate of pay is up to you to decide, but the minimum wage is $10 per hour. 2. In the G10:G13 range, enter formulas to calculate the total wages in dollars. 3. The total wages must be in the range of $1200-$1600. If you are too high or too low, adjust the number of hours and or the pay rates until you reach the goal range. 4. In the H10:H13 range, enter formulas to show the wages in each row as a percentage of the total wages. Use a fixed cell reference referring to cell G14 as the denominator in these formulas. 6 Java Juice Staffing Guide - Hours Worked by Job Title Breakfast Lunch Dinner Daily Total 79 60 44 960 5 Hours 6 Hours 5 Hours 16 Hours 5 6 5 16 Pay Wages Percent In $ of Wages 9 Rate 7 8 Customers per hour Hours per period 10 Cashier/Hostess 11 Drink Preparers 12 Food Preparers 13 Clean up Crew 14 Total $0.00