Time to Complete 10 Minutes
Difficulty Easy
Challenge2b_Dataset_Little_Chicken.xlsx (12.5 KB)
Time to Complete: 10 minutes
Difficulty: Beginner
Challenge2b_Dataset_Little_Chicken.xlsx (12.7 KB)
Time to complete: 7 mins
Difficulty: Easy
Solution:
Challenge2b_Dataset_Little_Chicken.xlsx (12.7 KB)
Challenge2b_Dataset_Little_Chicken.xlsx (11.5 KB)
1 Like
Time to Complete: 10 minutes
Difficulty: Beginner
Solution:
Challenge2b_Dataset_Little_Chicken.xlsx (12.5 KB)
time spent: 5 min
Answer: the mini fridge strategy is effective. But limited one cup per customer will be more cost effective
1 Like
Challenge2b_Dataset_Little_Chicken.xlsx (20.6 KB)
Here is the solution l got.
Time to complete: 10
Rating: Beginner
ACC407_excelpractice_littlechicken.xlsx (13.1 KB)
Time to complete: 7 minutes
Challenge2b_Dataset_Little_Chicken.xlsx (12.5 KB)
Time to complete: 5 minutes
Rating: Beginner
Comment: Not a bad little exercise!
Solution: The fridge strategy is slightly more profitable.
Time to Complete : 5 Minutes
Rating: Easy
Solution: Keep on giving out drinks (see excel file)
Challenge2b_Dataset_Little_Chicken.xlsx (12.5 KB)
Challenge2b_Dataset_Little_Chicken complete.xlsx (13.3 KB)
Time to Complete: 10
Rating: beginner
Great practice of the sumif function and I was able to learn how to use that when reviewing another row for null values or if it was filled in.
He is making a slightly larger profit now with the fridge but that doesn’t include the time he has to spend filling the fridge now. I think it would be beneficial to sell the drinks at a loss to allow him to compensate for that time. Even if he sells the drinks for a quarter it would be beneficial in the long run.