# 2|EXCEL – Little Chicken

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

We provide the solution to this challenge using:

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

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

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!

3 Likes

This is the answer I got!

2 Likes

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

1 Like

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

1 Like

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

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)

2 Likes

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

1 Like

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

1 Like

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.

1 Like

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

1 Like

Very fun intro to Excel

1 Like

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!!

Great challenge! Fun and easy

2 Likes

Nice work!

Thanks Reece

Challenge2b_Dataset_Little_Chicken.xlsx (12.7 KB)
Here are my solutions

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

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

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

1 Like