2|EXCEL – Little Chicken

[Jae]

BYU Student Author: @Jae
Reviewers: @Nate, @klayton, @TylerBooth
Estimated Time to Solve: 5 minutes

We provide the solution to this challenge using:

• Excel
• Go here to perform this challenge in Alteryx
• Go here to perform this challenge in Python

Need a program? Click here.

Overview
Little Chicken is a local fried chicken stand owned by your friend, Tom. Tom knows a lot about fried chicken, but not so much about business. In an attempt to boost his sales, Tom recently purchased a mini fridge. The refrigerator is consistently stocked with various beverages for his customers to take free of charge. Tom does not like to be controlling, so he allows his customers to take as many beverages as they need. Since purchasing the mini fridge, Tom has noticed a considerable increase in fried chicken sales but is concerned at how often he also restocks drinks.

Tom would like to evaluate the current state of his sales. He has been keeping an eye on how many drinks customers take each time they buy some chicken, recording the number of bottles alongside the quantity of chicken in their order. Tom is also interested in knowing whether his mini fridge decision has been more profitable for his stand. He has provided you with data on chicken order quantities before and after the purchase of the minifridge for comparison.

Tom purchases and sells his chicken for $0.99 and $3.99 per piece, respectively, and spends an average of $1.59 per bottle on drinks.

Instructions
Using the datafile linked below, compute the information Tom needs to evaluate the current state of his stand. Tom will need to know the following:

• Total Sales for both periods (Before/After the purchase of the mini fridge)
• Total Expenses for both periods, and
• Total Net Income (Profitability) for both periods

Do you think the mini fridge strategy is effective? What changes would you like Tom to make?

Data Files

• Challenge2_Data.xlsx

Suggestions and Hints

• Net Income = Sales - Expenses
• Since Tom didn’t own a mini fridge at the time of some chicken sales, you can assume that the drink expenses for this period were zero.

Solution

Challenge2_Solution.xlsx
Solution Video: Challenge 2|EXCEL – Little Chicken

[TylerBooth]

I liked doing this challenge in Excel better than in Alteryx just because of the size of the dataset. However, if this was a task that needed to be repeated on thousands of rows of data with some frequency, Alteryx would be my preferred technology! In this case, creating some quick formulas did the trick in answering the questions!

[Mimi_Haddock]

This is the answer I got!

[Katie_Morgan]

Here is my solution! He definitely should not give away free drinks!

[Emily_Johns]

Here is the solution I got
Challenge 2.xlsx (12.7 KB)

[Canyon_Esplin]

Canyon_Esplin_Little_Chicken.xlsx (12.7 KB)
Here is the solution I got.

[Jay_Davis]

This was a simple exercise to practice some excel formulas. Though doing this exercise I concluded that it is helping his business to offer drinks to his customers because his overall profitability is higher and his sales increased every though his expenses increased too.
Copy of Challenge2b_Dataset_Little_Chicken.xlsx (12.5 KB)

[Alan_Zhong]

Here is my solution!
Challenge2b_Dataset_Little_Chicken.xlsx (19.9 KB)

[Melissa_Fales]

Super easy and fun! Below is the result I got.

Challenge2b_Dataset_Little_Chicken.xlsx (12.5 KB)

[Matthew_Inkley]

Matthew_Inkley_Little_Chicken.xlsx (12.8 KB)
Here is my solution! The mini fridge drinks are effective at bringing in more business however his expenses are very high. At the least he should limit each customer to 1 free drink. This would increase net income by a couple hundred dollars.

[Hannah_Wright]

Challenge2b_Dataset_Little_Chicken Hannah Wright’s Solution.xlsx (13.6 KB)
Here’s my solution!

[mdharley]

Very fun intro to Excel

[Reece_Clark]

Challenge2b_Dataset_Little_Chicken.xlsx (13.1 KB)
This was fun! I think even if he charges for the drinks, people will buy a lot of chicken!!

[Jack_Nelson]

Great challenge! Fun and easy

[Reece_Clark]

Nice work!

[Jack_Nelson]

Thanks Reece

[Tyler_Hughes]

Challenge2b_Dataset_Little_Chicken.xlsx (12.7 KB)
Here are my solutions

[Mishelle_g]

This was fun!
Little Chicken.xlsx (17.1 KB)

[Maddy_Bunn]

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

[Joshua_Barlow]

Thank you for the challenge. I felt like this one was pretty straightforward - thanks!
Challenge2b_Dataset_Little_Chicken_JoshBarlow.xlsx (12.6 KB)