Pringles is entering a new market. They are trying to decide which of 96 different (real) flavors
No answer yet for this question.
Ask a Tutor
Question:
- Pringles is entering a new market. They are trying to decide which of 96 different (real) flavors to produce to maximize profits. The profit margin for each flavor is listed in pringles.xlsx, as well as the seconds needed per can for 3 different production processes: Flavoring, Packaging, and Quality Check.
The local Pringles factory can devote 100 hours to Flavoring, 120 hours to Packaging, and 80 hours to Quality Checking. Management wants to supply a variety of Pringles to draw in more customers, so they've decided to limit production of any single flavor to 5000 cans.
What should Pringles produce for the new market?
Flavor | Profit Margin | Flavoring | Packaging | Quality Check |
Bacon & Cheese Potato | $0.51 | 3 | 10 | 1 |
Bacon Caesar Salad | $0.83 | 8 | 8 | 3 |
Bacon Ranch | $0.15 | 6 | 10 | 8 |
Bangkok Grill Chicken Wing | $0.22 | 8 | 9 | 9 |
Barbecue | $0.05 | 10 | 4 | 10 |
Beef Kabab | $0.82 | 8 | 6 | 1 |
Blazin' Buffalo Wing | $0.25 | 4 | 9 | 2 |
Blueberry & Hazelnut | $0.83 | 2 | 1 | 5 |
Bruschetta | $0.83 | 3 | 6 | 9 |
Cajun | $0.49 | 5 | 3 | 4 |
Cheddar BBQ | $0.37 | 10 | 2 | 4 |
Cheddar Cheese | $0.01 | 9 | 2 | 7 |
Cheese and Onion | $0.79 | 8 | 1 | 6 |
Cheese Carnival | $0.71 | 3 | 9 | 1 |
Cheeseburger | $0.21 | 6 | 3 | 1 |
Cheesy Fries | $0.96 | 2 | 8 | 5 |
Cheesy Quesadilla | $0.77 | 9 | 9 | 4 |
Cheez Ums | $0.10 | 6 | 4 | 8 |
Chili Cheese Dog | $0.23 | 10 | 8 | 9 |
Chili Cheese | $0.57 | 6 | 7 | 3 |
Cinnamon Sweet Potato | $0.70 | 8 | 7 | 9 |
Corn Pringles | $0.91 | 1 | 1 | 1 |
Crunchy Dill | $0.66 | 10 | 3 | 6 |
Crushed Pepper | $0.90 | 9 | 6 | 3 |
Curry | $0.06 | 7 | 2 | 7 |
Fat Free Barbecue | $0.04 | 9 | 9 | 4 |
Fiery Hot | $0.93 | 1 | 9 | 5 |
Finger Lickin' Braised Pork | $0.78 | 3 | 10 | 6 |
French Consume | $0.37 | 7 | 9 | 5 |
Fun Picnic | $0.07 | 7 | 8 | 5 |
Garlic Seafood | $0.99 | 3 | 9 | 9 |
Grand Canyon French Fries | $0.15 | 6 | 7 | 3 |
Grilled Shrimp | $0.49 | 8 | 9 | 6 |
Honey Mustard | $0.66 | 3 | 1 | 5 |
Hot & Spicy Wonton | $0.15 | 7 | 3 | 7 |
Indonesian Satay | $0.96 | 5 | 1 | 9 |
Jalapeno | $0.03 | 5 | 1 | 9 |
Jalapeno Cheddar | $0.28 | 4 | 3 | 7 |
Jalapeno Ranch | $0.72 | 8 | 1 | 7 |
Keema Curry | $0.77 | 2 | 8 | 8 |
Ketchup | $0.05 | 6 | 7 | 4 |
Kickin' Cheddar | $0.90 | 10 | 1 | 6 |
Lemon | $0.43 | 7 | 5 | 4 |
Lemon & Sesame | $0.88 | 4 | 4 | 3 |
Loaded Baked Potato | $0.90 | 6 | 1 | 1 |
LA Street BBQ Chicken | $0.63 | 7 | 7 | 3 |
Mayo Potato | $0.82 | 3 | 7 | 4 |
Mexican Layered Dip | $0.30 | 3 | 1 | 9 |
Mozzarella Sticks & Marinara | $0.58 | 3 | 7 | 7 |
Multi Grain Cheesy Cheddar | $0.33 | 4 | 7 | 9 |
Multi Grain Creamy Ranch | $0.55 | 1 | 1 | 2 |
Multi Grain Truly Original | $0.09 | 8 | 6 | 6 |
New York Street Cheese Dog | $0.80 | 5 | 1 | 10 |
Night Club | $0.55 | 5 | 10 | 1 |
Night Star | $0.95 | 3 | 1 | 4 |
Old American Circus Mustard | $0.99 | 1 | 8 | 9 |
Onion Blossom | $0.89 | 5 | 4 | 8 |
Original | $0.78 | 2 | 4 | 10 |
Paprika | $0.80 | 2 | 8 | 3 |
Parmesan Garlic | $0.27 | 4 | 3 | 9 |
Philly Cheesesteak | $0.75 | 1 | 3 | 8 |
Pizza-licious | $0.05 | 1 | 4 | 4 |
Potato Cheddar Jack | $0.63 | 5 | 1 | 9 |
Prawn Cocktail | $0.32 | 5 | 4 | 1 |
Ranch-Rageous | $0.38 | 6 | 10 | 4 |
Reduced Fat Original | $0.77 | 7 | 4 | 9 |
Ridges Original | $0.34 | 10 | 1 | 9 |
Rock the Floor | $0.76 | 1 | 10 | 9 |
Salsa | $0.37 | 2 | 6 | 10 |
Salsa Verde | $0.38 | 2 | 2 | 9 |
Salt and Vinegar | $0.18 | 2 | 4 | 3 |
Screamin' Dill Pickle | $0.76 | 2 | 9 | 7 |
Seaweed | $0.38 | 7 | 9 | 5 |
Slow Cooked BBQ | $0.31 | 10 | 1 | 1 |
Smoked Salami | $0.31 | 1 | 7 | 7 |
Smokey Bacon | $0.09 | 6 | 2 | 1 |
Smokey BBQ | $0.87 | 3 | 7 | 10 |
Smokin' Hot Ranch | $0.44 | 7 | 7 | 3 |
Soft-Shelled Crab | $0.33 | 4 | 5 | 3 |
Sour Cream and Onion | $0.01 | 7 | 9 | 2 |
Southwestern Barbecue | $0.04 | 7 | 10 | 2 |
Spanish Salsa Pizza | $0.24 | 5 | 3 | 5 |
Spicy Cajun | $0.74 | 7 | 9 | 5 |
Spicy Chicken | $0.02 | 6 | 4 | 8 |
Spicy Guacamole | $0.91 | 2 | 6 | 9 |
Sun Dried Tomato | $0.75 | 1 | 3 | 7 |
Sweet Mesquite BBQ | $0.76 | 2 | 9 | 5 |
Sweet Potato Chipotle BBQ | $0.18 | 1 | 9 | 7 |
Szechuan BBQ Rice Crisps | $0.86 | 9 | 4 | 5 |
Taco Night | $0.17 | 4 | 5 | 7 |
Texas BBQ Sauce | $0.82 | 10 | 4 | 4 |
White Cheddar | $0.72 | 3 | 1 | 2 |
Wild Consume | $0.67 | 4 | 8 | 10 |
Wisconsin White Cheddar | $0.22 | 5 | 9 | 10 |
Zesty Lime and Chili | $0.38 | 2 | 10 | 2 |
Zesty Queso | $0.91 | 7 | 8 | 1 |
Posted Date: