This assignment focuses on Lecture # 4 and 5 and particularly using Linear programming Method. Please answer the 3 questions and show all your work in detail:

Defining and describe your variables clearly with explanations of why you think they are the variables

Develop your objective function and how it is related to its variables. (show it mathematically)

Determine what are you trying to achieve: Maximize or Minimize?

What are your constraints? Explain them in words and write them mathematically

Attached Excel file showing how you used the Solve function to achieve your result.

What is the best combination of Channels that would give the client the maximum exposure to the market with provided constrains above.

Question 2. [5 Marks]

A company manufactures two types of products: A and B. Each package of A contains 2 pounds of wheat and 3 pounds of veggies; each package of B contains 3 pounds of wheat and 1.5 pounds of veggies. The Company believes it can sell as much of each product as it can make. Product A sells for $2.80 per package and product B sells for $2.00 per package. The companys production is limited in several ways. First, it can buy only up to 400,000 pounds of wheat each month at $0.20 per pound. It can buy only up to 300,000 pounds of veggies per month at $0.50 per pound. In addition, a special piece of machinery is required to make product A, and this machine has a capacity of 90,000 packages per month. The variable cost of blending and packing the product is $0.25 per package for product A and $0.20 per package for product B. This information is given in the table below

required to make product A, and this machine has a capacity of 90,000 packages per month. The variable cost of blending and packing the product is $0.25 per package for product A and $0.20 per package for product B. This information is given in the table below Suppose you are the manager of the product division of the Company, so you are trying to maximize its profit. How should you operate the division to maximize its profit