2|EXCEL – Little Chicken

[Allyson_Smith]

Challenge2b_Dataset_Little_Chicken.xlsx (12.4 KB)

[Chloe_Warren]

Challenge2b_Dataset_Little_Chicken_Attempt1.xlsx (12.4 KB)

[Brielle_Bowden]

Challenge2b_Dataset_Little_Chicken_Brielle_Bowden.xlsx (12.9 KB)

[sadie.gassaway]

Here is my solution!

[Yitong_Liu]

Fun easy practice that helps me to build my confidence!

[David_Aslin]

Challenge2b_Dataset_Little_Chicken.xlsx (12.5 KB)
This was a fun challenge, and in the end the mini-fridge was worth it.

[Jared_Merrill]

The Gain is small after adding the minifridge, but it is still there so in time it is a good change.

The drinks seem a bit expensive he should try and find cheaper drinks or buy from the manufacturer rather than a retailer.

[Brayden_Cook]

Challenge2b_Dataset_Little_Chicken.xlsx (12.5 KB)

My solution

[Tyler_Coburn]

Challenge2b_Dataset_Little_Chicken.xlsx (12.5 KB)
It seems that it is better for profits to offer drinks

[Juliette_Sorensen]

This does seem to be an effective strategy as the net income did increase!
Challenge2b_Dataset_Little_Chicken.xlsx (12.6 KB)

[Ali_McFadden]

Tom’s mini fridge strategy is effective; his net income increased after the purchase. To increase net income further, he could try limiting the amount of free drinks per customer to 1 or 2.

[Christopher_Douglas]

Challenge2_Little_Chicken.xlsx (19.9 KB)

The mini fridge works! Net income and total sales increase. In order to continue to increase profits, it would be wise to implement a limit per customer. Or, a “buy at least $30 of food, get 2 drinks free”, and slowly increase that price limit.

[Sean_May]

Little Chicken’s new mini fridge strategy is effective - net income increased after Tom introduced free drinks to his customers. If Tom were to charge for drinks, even for a large discount, his net income would further increase!

[Dallin_England]

Challenge2b_Dataset_Little_Chicken.xlsx (12.5 KB)
enjoyable challenge!

[Liza_Hladek]

0404_Hladek_LittleChickenDataSet.xlsx (13.0 KB)
Tom should keep giving away drinks because it increased his total sales and net income.

[Pearce_Nally]

Challenge2b_Dataset_Little_Chicken.xlsx (12.8 KB)

Here is my response to this challenge

[Rande_Ritz]

I got $957 before and $991.86 after. The drinks bring in an extra $34.86 in profit, so it just depends on if you think the required upkeep is worth the money

[Faith_Call]

This is my solutions! The Response to Toms strategy is in the file.
Challenge2b_Dataset_Little_Chicken_FaithCall.xlsx (16.1 KB)

[Michael_Aguiar]

Using this information, I believe that the mini-fridge strategy has been effective. The change I would make would be to limit the amount of drinks a customer can take to 1.

[Nich458]