Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
The Booster Shot Hot Sauce company has started a new product line: Spice Blends. To make a spice blend Booster buys ground up peppers of
The Booster Shot Hot Sauce company has started a new product line: Spice Blends. To make a spice blend Booster buys ground up peppers of three varieties: Chipotle, New Mexico, and Serano. They mix these together to make three products: Boost, Caboost, and Daboost. The costs per kg, revenue per kg, and processing fees for each product have been used to compute the profit per kg for each input and output. These profits are shown in the following table: profit/kg Chipotle Boost Caboost Daboost $ 0 $ 11 $ 30 $ 16 $36 $ 6 New Mexico $ 8 $ 13 $ 28 Serano There are only 700 kg available: (kg) 200 Amount Available Chipotle New Mexico 200 300 Serano Here are the additional constraints: Booster must make at least 275 kg of Boost. Booster cannot make more Daboost than Caboost. A tv Caboost must be at least 50% Chipotle. Daboost must be at least 60% New Mexico. Formulate this LP in Excel and solve it to find the optimal solution. Then answer the following questions: a. How many variables are there? b. How many regular constraints are there? c. How many nonnegativity constraints are there? 3
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669bc63965146_856669bc638b16c5.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669bc63a60504_857669bc639c06a1.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started