Answered step by step
Verified Expert Solution
Question
1 Approved Answer
18. In B1, use a function to enter today's date. Date only. 19. In the range K4:K10, use functions to determine the total sales for
18. In B1, use a function to enter today's date. Date only. 19. In the range K4:K10, use functions to determine the total sales for each Hula Hut location. 20. In the Tier column, use a function to assign the tier of each Hula Hut location based on the range J4:J10. 1 Date: 2 3 Site Tier Menu Item - June July August Total Location Tier Total Sales 4 Atlanta 5 Birmingham Burrito Burrito 6 Fayetteville Burrito 7 Jackson Burrito 8 Montgomery Burrito 9 Nashville Burrito 10 Opelika 11 Atlanta 12 Birmingham Burrito. Chicken Chicken 13 Fayetteville Chicken 14 Jackson Chicken 15 Montgomery Chicken 16 Nashville 17 Opelika Chicken Chicken 18 Atlanta Salad 19 Birmingham Salad 20 Fayetteville Salad 21 Jackson Salad 22 Montgomery 23 Nashville Salad Salad 24 Opelika Salad 25 Atlanta 26 Birmingham Sandwich Sandwich 27 Fayetteville Sandwich 28 Jackson Sandwich 29 Montgomery Sandwich 30 Nashville Sandwich 31 Opelika Sandwich 32 Atlanta Steak 33 Birmingham Steak 34 Fayetteville Steak 35 Jackson Steak 36 Montgomery Steak 37 Nashville Steak 38 Opelika Steak 39 Atlanta Vegan 40 Birmingham Vegan $11,923.00 $ 12,197.00 $12,343.00 $ $ 17,659.00 $18,065.00 $ 18,282.00 $ $ 8,456.00 $ 8,650.00 $ 8,754.00 $ $ 4,563.00 $ 4,668.00 $ 4,724.00 $ $ 9,389.00 $ 9,605.00 $9,720.00 $ $ 15,690.00 $ 16,051.00 $16,244.00 $ $ 10,980.00 $ 11,233.00 $11,368.00 $ $ 13,456.00 $13,765.00 $ 13,930.00 $ $ 24,560.00 $25,125.00 $25,427.00 $ $ 12,000.00 $ 12,276.00 $ 12,423.00 $ $ 22,908.00 $ 23,435.00 $23,716.00 $ $ 17,890.00 $ 18,301.00 $ 18,521.00 $ $ 32,450.00 $ 33,196.00 $ 33,594.00 $ $ 16,540.00 $16,920.00 $ 17,123.00 $ $ 8,930.00 $ 9,135.00 $ 9,245.00 $ $ 10,320.00 $ 10,557.00 $ 10,684.00 $ $ 2,240.00 $ 2,292.00 $ 2,320.00 $ $ 6,540.00 $ 6,690.00 $ 6,770.00 $ $ 3,460.00 $ 3,540.00 $ 3,582.00 $ $ 12,345.00 $ 12,629.00 $ 12,781.00 $ $ 5,460.00 $ 5,586.00 $ 5,653.00 $ $ 10,850.00 $ 11,100.00 $ 11,233.00 $ $ 14,520.00 $14,854.00 $ 15,032.00 $ $ 5,478.00 $ 5,604.00 $ 5,671.00 $ $ 2,350.00 $ 2,404.00 $ 2,433.00 $ $ 9,450.00 $ 9,667.00 $ 9,783.00 $ $ 15,760.00 $ 16,122.00 $ 16,315.00 $ $ 9,870.00 $ 10,097.00 $ 21,340.00 $ 21,831.00 $ 17,439.00 $ 17,840.00 $ 12,940.00 $ 13,238.00 $ 13,450.00 $13,759.00 $ 17,750.00 $ 18,158.00 $27,980.00 $ 28,624.00 $ 28,967.00 $ $ 22,340.00 $ 22,854.00 $ 23,128.00 $ $ 11,940.00 $12,215.00 $12,362.00 $ $ 8,548.00 $ 8,745.00 $ 8,850.00 $ 36,463.00 Opelika 2 54,006.00 25,860.00 13,955.00 Atlanta 1 Birmingham 1 Fayetteville 3 28,714.00 Montgomery 2. 47,985.00 33,581.00 41,151.00 75,112.00 36,699.00 70,059.00 54,712.00 99,240.00 50,583.00 27,310.00 31,561.00 6,852.00 20,000.00 10,582.00 37,755.00 16,699.00 33,183.00 44,406.00 16,753.00 7,187.00 Jackson 3 Nashville 1 28,900.00 48,197.00 $ 10,218.00 $ 30,185.00 $ 22,093.00 $18,054.00 $ $13,397.00 $ $ 13,924.00 $ $18,376.00 $ $ 65,264.00 53,333.00 39,575.00 41,133.00 54,284.00 85,571.00 68,322.00 36,517.00 26,143.00 esan no e
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started