Question: The CCCC wishes to develop its initial product planning design as it takes advantage of new legalization laws in Canada and the US for cannabis

The CCCC wishes to develop its initial product planning design as it takes advantage of new legalization laws in Canada and the US for cannabis products. It expects to expand and modify their cannabis distribution in the future, but they wish to maximize their profitability initially prior to the new market hitting equilibrium.
CCCC has 5 production facilities/farms (Code named F1 through F5) where raw cannabis is grown. The Farms(Fx) cannabis attributes include the maximum crop available (lbs), the per lb. growing cost, the THC measure per lb., and the CBD measure per lb. As a policy, the minimum amount of cannabis that can be used from each Farm is 60% of the maximum. And dont forget to model the maximum as well. Data is shown below.
CCCC will take cannabis from the five farms and blend them together to make three products PAIN, RELAX and FOCUS. Each product has a different sales price (per lb.)37 units per pound for PAIN, 32 units per pound for RELAX, and 41 units per pound for FOCUS.
Each product has different requirements in terms of the weighted average value of THC and CBD.
PAIN: THC levels must average less than or equal to 11.2.
RELAX: THC levels must average greater than or equal to 12.5
FOCUS: THC levels must average less than or equal to 10.1
CBD: All three products must INDIVIDUALLY average at least 8.7.
PAIN - an individual farm cannot provide more than 30% of the total cannabis used in PAIN.
RELAX - an individual farm cannot provide more than 32.5% of the total cannabis used in RELAX.
FOCUS - does not have any composition requirements.
Finally, you cannot make more than 1000 lbs. of any one product. CCCC wishes to determine how to optimally design the production of its 3 products using the cannabis grown at its 5 farms. The goal of your model is to maximize sales less costs.
At the very end, when your model is working well, save the solution without integers and then force the variables to be integers.If it takes longer than 3 minutes, kill and save that solution. Summarize your solution so I can understand it clearly doesnt have to be complicated.
This is version 1 of the problem. I reserve the right to alter if errors are uncovered!
 The CCCC wishes to develop its initial product planning design as

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!