2|EXCEL – Little Chicken

[Keilani_Hess]

This is my solution to the problem. Although the expenses increased so did the overall net , showing the free drinks are somewhat effective.

[Lauren_Taylor]

Challenge2b_Dataset_Little_Chicken (1).xlsx (12.5 KB)
Solution! Thanks for the problem and practice

[Elise_Snow]

Challenge2b_Dataset_Little_Chicken.xlsx (12.6 KB)
He is benefiting from offering free soda.

[Skyler_Lucas]

Challenge2b_Dataset_Little_Chicken.xlsx (11.5 KB)
The free drinks are somewhat working.

[sally_kang]

[Michelle_Semadeni]

Here’s my solution!
Challenge2b_Dataset_Little_Chicken.xlsx (12.9 KB)

[Abigail_Armstrong]

Challenge2b_Solution.xlsx (12.8 KB)
While the mini fridge is slightly more profitable, I would recommend Tom have a minimum chicken purchase requirement to take a free drink. For example promoting a “free drinks with the purchase of two pieces of chicken” something like that. When only one piece of chicken is purchased Tom makes little to no money on the sale if a drink is taken along with it.

[Lydia_Karlson]

Here is my solution. The strategy is effective.

[Tanner_Harris]

I think that it is an effective strategy. If he were to do a further business analysis, I would recommend weighing two options. Either raise the price of purchasing chicken (to recover lost profit) or limit the amount of free drinks to be taken.

Here’s my solution:
Challenge2b_Dataset_Little_Chicken.xlsx (12.8 KB)

[Parker_Reynolds1]

Thanks for making this simple problem. It was very good to get back into using excel. Here is my solution:
Challenge2b_Dataset_Little_Chicken.xlsx

[Xinyu_Harper_Zhang]

This is my answer. I think it is effective. My suggestions: He can charge a little bit of money like 2 dollars for all can drink. that will be more effective.

Tech Hub Excel 2 Little chicken .xlsx (12.7 KB)

[Ella_Wilson]

Challenge2b_Dataset_Little_Chicken.xlsx (13.1 KB)

[Halle_Hawkins]

9-16-23 Tech Hub 1- homework.xlsx (13.3 KB)
Here is my solution. The mini fridge brings helps generate more sales, although it increases expenses.

[Madeline_Westover]

I think that the mini fridge strategy is profitable and effective. However, I would recommend trying to enforce a limit on the amount of drinks a customer can take to further increase profits.

[Jared_Sanchez]

Challenge2b_Dataset_Little_Chicken.xlsx (13.1 KB)
Here is my solution. It is a fun exercise! The data confirms that the mini fridge strategy is effective for his business. One change I would make to his current business plan is to put a limit on the amount of drinks a single customer can take.

[Izaac_McCann]

Challenge2b_Dataset_Little_Chicken.xlsx (13.9 KB)

[Nicole_Humpherys]

Here is my solution for the class assignment due on 9/20/23. Although he is making a small of $34.86, Tom needs to determine whether it is worth the work he has to put into providing the drinks (purchasing and unloading the drinks and constantly refilling the mini-fridge. He could also make more of a profit if he only allowed one drink per purchase rather than an unlimited quantity.
EXCEL - Dataset Little Chicken.xlsx (12.6 KB)

[Alec_Carter]

Challenge2b_Dataset_Little_Chicken.xlsx (13.7 KB)

Here is my solution to the assignment due on 9/18/23 for Professor Summers’s class

[Spencer_Palmer]

Here is my solution!
Tom definitely made more profit. It was not a whole lot more however considering all the additional effort of keeping his fridge stocked. I think the best solution would be to have some kind of a promotion in which the customer would get a free drink for every 3 pieces of chicken purchased.

[Caleb_McKay]

My solution shows that Tom’s net income increases $34.86 with the addition of free drinks. He should continue giving away free drinks.
Challenge2b_Dataset_Little_Chicken.xlsx (13.6 KB)