Solve the problems provided using LP Solver models in EXCEL.

Canadian Cannabis Consortium Company Version CCCC

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. The data is shown on the next page.

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.) and a different cost to manufacture (also per lb.). Additionally, 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 35% 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 this requirement.

Finally, each of the three products must make up at least 25% of total production (measured in lbs.). Additionally, 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. All costs and revenues are measured on a per pound basis. Costs are production costs and growing costs (see data provided). Revenues come from total product made times the sales price. The goal of your model is to maximize revenue 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 with some sort of rudimentary picture, graphic or brief discussion.

DATA