Info project 4
danya.alsinan
INFO1010Project4Winter2018.docxINFO 1010 Project 4
Due Friday, March 16 at 5:00 pm
HEAVENLY SPICES SPICE SHOP
Heavenly Spices makes a variety of Spice Mixes with a variety of ingredients. They maintain a supply of various ingredients, some of which are costlier than others. Each day, Heavenly Spices mixes the appropriate ingredients for the varieties of spice mixes they wish to make and packages the spice mixes in their factory.
Some of their best-selling Spice Mixes are as shown in Table 1, along with the chief ingredients for each spice mixes and the amount of each ingredient.
|
Spice Mix Name |
Ingredients (in grams) per spice mix box |
|
Good Spice |
5 gr Basil (BL) 17 gr Parsley (PA) 7 gr Thyme (TH) 8 gr Garlic Powder (GP) 4 gr Sage (SG) 2 gr Cloves (CL) |
|
Market Pantry |
18 gr Oregano (OR) 10 gr Basil (BL) 8 gr Sage (SG) 12 gr Thyme (TH) |
|
Clear Your Sinuses |
5 gr Black Pepper (BP) 10 gr White Pepper (WP) 18 gr Oregano (OR) 3 gr Parsley (PA) 16 gr Sea Salt (SS) 12 gr Marjoram Leaves (ML) |
|
Sweetness
|
12 gr Cumin (CU) 15 gr Oregano (OR) 6 gr Cloves (CL) 8 gr Basil (BL) 3 gr Thyme (TH) |
|
Palate’s Delight |
6 gr Black Pepper (BP) 12 gr White Pepper (WP) 6 gr Sage (SG) 6 gr Sea Salt (SS) 15 gr Marjoram Leaves (ML) 3 gr Chili Powder (CP) |
|
Head Rush |
10 gr Black Pepper (BP) 15 gr White Pepper (WP) 7 gr Sea Salt (SS) 4 gr Parsley (PA) 8 gr Red Pepper (RP) 5 gr Ginger (GI) 6 gr Sage (SG) |
Table 1: Spice Mixes
Each Spice Mix is packaged in a box that retails for $9.95 each. While price is the same no matter the variety, the cost of ingredients varies for each Spice Mix based on the type and amounts of ingredients in each. Table 2 shows the per-gram cost of each ingredient, and how much of each ingredient is in stock and available for mixing:
|
Ingredient Name |
Cost per gram in $ |
Availability in grams |
|
Black Pepper (BP) |
$0.12 |
9600 |
|
Basil (BL) |
$0.18 |
13200 |
|
Parsley (PA) |
$0.15 |
12500 |
|
Thyme (TH) |
$0.21 |
9700 |
|
Garlic Powder (GP) |
$0.15 |
6700 |
|
Sage (SG) |
$0.09 |
9500 |
|
White Pepper (WP) |
$0.12 |
12800 |
|
Oregano (OR) |
$0.06 |
18400 |
|
Sea Salt (SS) |
$0.09 |
5400 |
|
Cumin (CU) |
$0.24 |
2700 |
|
Marjoram Leaves (ML) |
$0.27 |
3500 |
|
Cloves (CL) |
$0.18 |
5800 |
|
Chili Powder (CP) |
$0.09 |
3000 |
|
Red Pepper (RP) |
$0.21 |
6000 |
|
Ginger (GI) |
$0.15 |
2000 |
Table 2: Herbal Ingredients
Project Part 1:
A. Set up a Linear Programming model to maximize profit. Identify the objective function and the formulas for all constraints.
B. Run the model, and provide a copy of your answer report.
C. In a summary, identify how many boxes of each spice mixes will be produced (does it make sense to make .65 of a box?) and how much of each ingredient will be left over in inventory.
D. For each type of spice mix, identify the limiting factor(s) which prevented Heavenly Spices from making more of that spice mix.
Project Part 2:
A. With the exception of Market Pantry, Heavenly Spices is able to sell no more than 400 boxes of each spice mixes. Heavenly Spices is able to sell no more than 500 boxes of Market Pantry. Re-run your model and provide a copy of your answer report.
· Identify how many boxes of each spice mix will be produced and how much of each ingredient will be left over in inventory.
B. Continuing with demand constraints above, maintenance problems have limited today’s production to no more than 1600 units total. Re-run your model and provide a copy of your answer report.
· Identify how many boxes of each spice mix will be produced and how much of each ingredient will be left over in inventory.
Assignment Deliverables:
Create a spreadsheet that helps to answer these questions. Create a tab for each Project Part and produce an answer report within each tab. Clearly answer each question that is part of the project. Most importantly, create a dashboard with instructions on how to use the optimization you have created. It should have instructions on what things you could change (Recipes? Costs? Inventories? Other things?). It should have instructions on how to maximize profits. It should be well organized, well labeled, easy to use, and easy to understand.
3 of 3
