Challenge2b_Dataset_Little_Chicken.xlsx (14.6 KB)
This is my solution. I needed to brush up some of my Excel skills and this was the perfect practice problem!
Challenge2b_Dataset_Little_Chicken.xlsx (13.7 KB)
1 Like
Easy and fun, thanks!
Challenge2 Excel Little Chicken.xlsx (12.7 KB)
Great intro in Excel!
Great challenge!
Challenge2b_Dataset_Little_Chicken.xlsx (12.5 KB)
The mini fridge strategy is effective for increasing sales, but not effective for increasing net profit. One way Tom could increase sales is to install a free soda fountain, which is a cheaper form of providing soda. Tom could hand out cups for each chicken order, and request no refills. He would control the amount of soda being consumed this way and decrease the cut into his profit.
techhub challenge #1.xlsx (12.7 KB)
Challenge2b_Dataset_Little_Chicken.xlsx (12.5 KB)
I feel like the mini fridge idea is effective, but definitely has more potential to bring in greater profitability. Net income increased after the purchase of the mini fridge, but not by much. I would like Tom to consider the idea of charging at least 0.50 cents per drink that way he can continue to enjoy greater profitability without losing out on customers. Fun challenge!
Fun challenge! Good refresher on basic excel functions
Challenge2b_Dataset_Little_Chicken.xlsx (12.7 KB)
Thanks for the challenge! Rachael Miles
Little Chicken Problem.xlsx (12.4 KB)
The mini fridge strategy is effective!
0207_Zullo_Excelproblems1.xlsx (13.9 KB)
Challenge2b_Dataset_Little_Chicken.xlsx (12.4 KB)
Straightforward and helpful. Thank you!
Here’s my solution! The mini fridge did increase the amount of sales, but the expense of having unlimited drinks is high. He could limit the drinks to one per customer.
Challenge2b_Dataset_Little_Chicken.xlsx (12.5 KB)
1 Like
ChickenLittle_9-15-2023.xlsx (12.5 KB)
This was great warmup for for someone who hasn’t used excel in awhile! Check out how I did it!
MasonLewis_Challenge2b_Dataset_Little_Chicken.xlsx (12.7 KB)
Thank you! The mini fridge strategy appears to be effective, maybe encourage Tom to try and purchase his drinks at a lower price.
Challenge2b_Dataset_Little_Chicken.xlsx (12.3 KB)
Here’s my solution, good thinking Tom! Just tweak it a little bit
Challenge2b_Dataset_Little_Chicken.xlsx (11.5 KB)
Here is my solution to the loss he occurs. I saw the other solutions but the before and after sales of the mini fridge were assumed rather than specified. Because of this, a different profit is calculated. There is no way to distinguish between before and after sales because it is not listed in the initial data set.