Here is my solution.
TechHub Training 2 Excel.xlsx (12.7 KB)
1 Like
Here’s what I got. Definitely need to shake off some rust before moving on to the higher difficulty stuff.
It was a great Excel practice. Here is my solution.
Challenge2b_Dataset_Little_Chicken.xlsx (12.9 KB)
Fun challenge to review topics. Thank you!!
I found that his business should keep giving away free drinks! While it isn’t a huge margin of difference in net income because costs are higher, it is driving chicken sales up, and the margin per sale is higher. My solution is posted below
0207_Fehlberg_02LittleChicken.xlsx (13.4 KB)
y
Here is my solutuion. The mini-fridge is effective as Tom has a higher net income with the fridge than without it. However, Tom should limit the number of free drinks each customer takes. This would increase his total net income.
Jacob_Smith_Dataset_Little_Chicken.xlsx (12.8 KB)
Challenge2b_Dataset_Little_Chicken.xlsx (12.4 KB)
They were more profitable with the mini fridge so I do think that it is effective.
Challenge2b_Dataset_Little_Chicken solution.xlsx (12.6 KB)
Here’s my solution, I do think the mini fridge was profitable as it increased his Net Income, but I think it is something that could easily be taken advantage of by customers and increase his costs substantially.
Here is the solution I got
Challenge 2.xlsx (13.9 KB)
It was a nice refresher on some basics.
Challenge2b_Dataset_Little_Chicken.xlsx (12.5 KB)
This was a simple exercise practicing some basic excel formulas. I concluded that the purchase of the mini-fridge is helping Tom’s business. Here is my solution:
Ben_Shaw_Little_Chicken.xlsx (12.8 KB)
Challenge2b_Dataset_Little_Chicken.xlsx (13.3 KB)
Here’s my solution! It looks like offering the drinks is both increasing his revenues and expenses. However, his net income is slightly higher when offering the drinks than it was when he wasn’t.
Challenge2b_Dataset_Little_Chicken_Tingey.xlsx (12.5 KB)
Great refresher for excel!
0406_Young_ExcelProblem1.xlsx (12.6 KB)
Here is my solution! I would say the mini fridge strategy is effective but I think that he should limit the amount of free drinks that he gives out.
Excel Challege- Chicken- 230916.xlsx (12.6 KB)
Here is my solution! He is more profitable with the new mini fridge, but would benefit from charging a small amount for the drinks.
Based off of the data given it does make more since to keep using the mini fridge to increase sales.