College chums Hannah Baltzan and Tyler Phillips are working on opening a third espresso drive-through stand in Highlands Ranch, Colorado, called Brewed Awakening. Their original drive-through stand, Jitters, and their second espresso stand, Bean Scene, have done well in their current locations in Englewood, Colorado, five miles away. Since Hannah and Tyler want to start with low overhead, they need assistance analyzing the data from the past year on the different types of coffee and the amounts that they sold from both stands. Hannah and Tyler would like a recommendation of the four top sellers to start offering when Brewed Awakening opens. They have provided you with the data file T3_JittersCoffee_Data.xls for you to perform the analysis that will support your recommendation. Key Jitters = North Bean Scene = South Product Month Store Revenue Regular January North 4320 Regular February North 4500 Regular March North 3528 Regular April North 3960 Regular May North 3996 Regular June North 3960 Regular July North 3960 Regular August North 4230 Regular September North 4230 Regular October North 4275 Regular November North 4365 Regular December North 4455 Regular January South 3960 Regular February South 4230 Regular March South 4230 Regular April South 4275 Regular May South 4365 Regular June South 4455 Regular July South 4128 Regular August South 4176 Regular September South 3936 Regular October South 4090 Regular November South 3936 Regular December South 4350 Decaf January North 4350 Decaf February North 4350 Decaf March North 4350 Decaf April North 3610 Decaf May North 3640 Decaf June North 3610 Decaf July North 2210 Decaf August North 2430 Decaf September North 2430 Decaf October North 2460 Decaf November North 2540 Decaf December North 2310 Decaf January South 2620 Decaf February South 2450 Decaf March South 2430 Decaf April South 2480 Decaf May South 2540 Decaf June South 2610 Decaf July South 2340 Decaf August South 2380 Decaf September South 2540 Decaf October South 2310 Decaf November South 2400 Decaf December South 2320 French Roast January North 2290 French Roast February North 5290 French Roast March North 4320 French Roast April North 4500 French Roast May North 3528 French Roast June North 3960 French Roast July North 3996 French Roast August North 3960 French Roast September North 3960 French Roast October North 4230 French Roast November North 4230 French Roast December North 4275 French Roast January South 4365 French Roast February South 4455 French Roast March South 3960 French Roast April South 4230 French Roast May South 4230 French Roast June South 4275 French Roast July South 4365 French Roast August South 4455 French Roast September South 4128 French Roast October South 4176 French Roast November South 3936 French Roast December South 4090 Vanilla January North 3936 Vanilla February North 4350 Vanilla March North 4350 Vanilla April North 4350 Vanilla May North 4350 Vanilla June North 3610 Vanilla July North 3640 Vanilla August North 3610 Vanilla September North 2210 Vanilla October North 2430 Vanilla November North 2430 Vanilla December North 2460 Vanilla January South 2540 Vanilla February South 2310 Vanilla March South 2620 Vanilla April South 2450 Vanilla May South 2430 Vanilla June South 2480 Vanilla July South 2540 Vanilla August South 2610 Vanilla September South 2340 Vanilla October South 2380 Vanilla November South 2540 Vanilla December South 2310 Irish Cream January North 2400 Irish Cream February North 2320 Irish Cream March North 2290 Irish Cream April North 5290 Irish Cream May North 4350 Irish Cream June North 4350 Irish Cream July North 4350 Irish Cream August North 4350 Irish Cream September North 3610 Irish Cream October North 3640 Irish Cream November North 3610 Irish Cream December North 2210 Irish Cream January South 2430 Irish Cream February South 2430 Irish Cream March South 2460 Irish Cream April South 2540 Irish Cream May South 2310 Irish Cream June South 2620 Irish Cream July South 2450 Irish Cream August South 2430 Irish Cream September South 2480 Irish Cream October South 2540 Irish Cream November South 2610 Irish Cream December South 4350 Hazelnut January North 3610 Hazelnut February North 3640 Hazelnut March North 3610 Hazelnut April North 2210 Hazelnut May North 2430 Hazelnut June North 2430 Hazelnut July North 2460 Hazelnut August North 2540 Hazelnut September North 2310 Hazelnut October North 2620 Hazelnut November North 2450 Hazelnut December North 2430 Hazelnut January South 2480 Hazelnut February South 2540 Hazelnut March South 2610 Hazelnut April South 2340 Hazelnut May South 2380 Hazelnut June South 2540 Hazelnut July South 2310 Hazelnut August South 2400 Hazelnut September South 2320 Hazelnut October South 2290 Hazelnut November South 5290 Hazelnut December South 4320

College chums Hannah Baltzan and Tyler Phillips are working on opening a third espresso drive-through stand in Highlands Ranch, Colorado, called Brewed Awakening. Their original drive-through stand, Jitters, and their second espresso stand, Bean Scene, have done well in their current locations in Englewood, Colorado, five miles away. Since Hannah and Tyler want to start with low overhead, they need assistance analyzing the data from the past year on the different types of coffee and the amounts that they sold from both stands. Hannah and Tyler would like a recommendation of the four top sellers to start offering when Brewed Awakening opens. They have provided you with the data file T3_JittersCoffee_Data.xls for you to perform the analysis that will support your recommendation. Key Jitters = North Bean Scene = South Product Month Store Revenue Regular January North 4320 Regular February North 4500 Regular March North 3528 Regular April North 3960 Regular May North 3996 Regular June North 3960 Regular July North 3960 Regular August North 4230 Regular September North 4230 Regular October North 4275 Regular November North 4365 Regular December North 4455 Regular January South 3960 Regular February South 4230 Regular March South 4230 Regular April South 4275 Regular May South 4365 Regular June South 4455 Regular July South 4128 Regular August South 4176 Regular September South 3936 Regular October South 4090 Regular November South 3936 Regular December South 4350 Decaf January North 4350 Decaf February North 4350 Decaf March North 4350 Decaf April North 3610 Decaf May North 3640 Decaf June North 3610 Decaf July North 2210 Decaf August North 2430 Decaf September North 2430 Decaf October North 2460 Decaf November North 2540 Decaf December North 2310 Decaf January South 2620 Decaf February South 2450 Decaf March South 2430 Decaf April South 2480 Decaf May South 2540 Decaf June South 2610 Decaf July South 2340 Decaf August South 2380 Decaf September South 2540 Decaf October South 2310 Decaf November South 2400 Decaf December South 2320 French Roast January North 2290 French Roast February North 5290 French Roast March North 4320 French Roast April North 4500 French Roast May North 3528 French Roast June North 3960 French Roast July North 3996 French Roast August North 3960 French Roast September North 3960 French Roast October North 4230 French Roast November North 4230 French Roast December North 4275 French Roast January South 4365 French Roast February South 4455 French Roast March South 3960 French Roast April South 4230 French Roast May South 4230 French Roast June South 4275 French Roast July South 4365 French Roast August South 4455 French Roast September South 4128 French Roast October South 4176 French Roast November South 3936 French Roast December South 4090 Vanilla January North 3936 Vanilla February North 4350 Vanilla March North 4350 Vanilla April North 4350 Vanilla May North 4350 Vanilla June North 3610 Vanilla July North 3640 Vanilla August North 3610 Vanilla September North 2210 Vanilla October North 2430 Vanilla November North 2430 Vanilla December North 2460 Vanilla January South 2540 Vanilla February South 2310 Vanilla March South 2620 Vanilla April South 2450 Vanilla May South 2430 Vanilla June South 2480 Vanilla July South 2540 Vanilla August South 2610 Vanilla September South 2340 Vanilla October South 2380 Vanilla November South 2540 Vanilla December South 2310 Irish Cream January North 2400 Irish Cream February North 2320 Irish Cream March North 2290 Irish Cream April North 5290 Irish Cream May North 4350 Irish Cream June North 4350 Irish Cream July North 4350 Irish Cream August North 4350 Irish Cream September North 3610 Irish Cream October North 3640 Irish Cream November North 3610 Irish Cream December North 2210 Irish Cream January South 2430 Irish Cream February South 2430 Irish Cream March South 2460 Irish Cream April South 2540 Irish Cream May South 2310 Irish Cream June South 2620 Irish Cream July South 2450 Irish Cream August South 2430 Irish Cream September South 2480 Irish Cream October South 2540 Irish Cream November South 2610 Irish Cream December South 4350 Hazelnut January North 3610 Hazelnut February North 3640 Hazelnut March North 3610 Hazelnut April North 2210 Hazelnut May North 2430 Hazelnut June North 2430 Hazelnut July North 2460 Hazelnut August North 2540 Hazelnut September North 2310 Hazelnut October North 2620 Hazelnut November North 2450 Hazelnut December North 2430 Hazelnut January South 2480 Hazelnut February South 2540 Hazelnut March South 2610 Hazelnut April South 2340 Hazelnut May South 2380 Hazelnut June South 2540 Hazelnut July South 2310 Hazelnut August South 2400 Hazelnut September South 2320 Hazelnut October South 2290 Hazelnut November South 5290 Hazelnut December South 4320

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 111P

See similar textbooks

Related questions

Question

Key
Jitters = North
Bean Scene = South

Product	Month	Store	Revenue
Regular	January	North	4320
Regular	February	North	4500
Regular	March	North	3528
Regular	April	North	3960
Regular	May	North	3996
Regular	June	North	3960
Regular	July	North	3960
Regular	August	North	4230
Regular	September	North	4230
Regular	October	North	4275
Regular	November	North	4365
Regular	December	North	4455
Regular	January	South	3960
Regular	February	South	4230
Regular	March	South	4230
Regular	April	South	4275
Regular	May	South	4365
Regular	June	South	4455
Regular	July	South	4128
Regular	August	South	4176
Regular	September	South	3936
Regular	October	South	4090
Regular	November	South	3936
Regular	December	South	4350
Decaf	January	North	4350
Decaf	February	North	4350
Decaf	March	North	4350
Decaf	April	North	3610
Decaf	May	North	3640
Decaf	June	North	3610
Decaf	July	North	2210
Decaf	August	North	2430
Decaf	September	North	2430
Decaf	October	North	2460
Decaf	November	North	2540
Decaf	December	North	2310
Decaf	January	South	2620
Decaf	February	South	2450
Decaf	March	South	2430
Decaf	April	South	2480
Decaf	May	South	2540
Decaf	June	South	2610
Decaf	July	South	2340
Decaf	August	South	2380
Decaf	September	South	2540
Decaf	October	South	2310
Decaf	November	South	2400
Decaf	December	South	2320
French Roast	January	North	2290
French Roast	February	North	5290
French Roast	March	North	4320
French Roast	April	North	4500
French Roast	May	North	3528
French Roast	June	North	3960
French Roast	July	North	3996
French Roast	August	North	3960
French Roast	September	North	3960
French Roast	October	North	4230
French Roast	November	North	4230
French Roast	December	North	4275
French Roast	January	South	4365
French Roast	February	South	4455
French Roast	March	South	3960
French Roast	April	South	4230
French Roast	May	South	4230
French Roast	June	South	4275
French Roast	July	South	4365
French Roast	August	South	4455
French Roast	September	South	4128
French Roast	October	South	4176
French Roast	November	South	3936
French Roast	December	South	4090
Vanilla	January	North	3936
Vanilla	February	North	4350
Vanilla	March	North	4350
Vanilla	April	North	4350
Vanilla	May	North	4350
Vanilla	June	North	3610
Vanilla	July	North	3640
Vanilla	August	North	3610
Vanilla	September	North	2210
Vanilla	October	North	2430
Vanilla	November	North	2430
Vanilla	December	North	2460
Vanilla	January	South	2540
Vanilla	February	South	2310
Vanilla	March	South	2620
Vanilla	April	South	2450
Vanilla	May	South	2430
Vanilla	June	South	2480
Vanilla	July	South	2540
Vanilla	August	South	2610
Vanilla	September	South	2340
Vanilla	October	South	2380
Vanilla	November	South	2540
Vanilla	December	South	2310
Irish Cream	January	North	2400
Irish Cream	February	North	2320
Irish Cream	March	North	2290
Irish Cream	April	North	5290
Irish Cream	May	North	4350
Irish Cream	June	North	4350
Irish Cream	July	North	4350
Irish Cream	August	North	4350
Irish Cream	September	North	3610
Irish Cream	October	North	3640
Irish Cream	November	North	3610
Irish Cream	December	North	2210
Irish Cream	January	South	2430
Irish Cream	February	South	2430
Irish Cream	March	South	2460
Irish Cream	April	South	2540
Irish Cream	May	South	2310
Irish Cream	June	South	2620
Irish Cream	July	South	2450
Irish Cream	August	South	2430
Irish Cream	September	South	2480
Irish Cream	October	South	2540
Irish Cream	November	South	2610
Irish Cream	December	South	4350
Hazelnut	January	North	3610
Hazelnut	February	North	3640
Hazelnut	March	North	3610
Hazelnut	April	North	2210
Hazelnut	May	North	2430
Hazelnut	June	North	2430
Hazelnut	July	North	2460
Hazelnut	August	North	2540
Hazelnut	September	North	2310
Hazelnut	October	North	2620
Hazelnut	November	North	2450
Hazelnut	December	North	2430
Hazelnut	January	South	2480
Hazelnut	February	South	2540
Hazelnut	March	South	2610
Hazelnut	April	South	2340
Hazelnut	May	South	2380
Hazelnut	June	South	2540
Hazelnut	July	South	2310
Hazelnut	August	South	2400
Hazelnut	September	South	2320
Hazelnut	October	South	2290
Hazelnut	November	South	5290
Hazelnut	December	South	4320

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 4 images

SEE SOLUTION Check out a sample Q&A here