I will appreciate if you can help solve this question in less than 5 hours. I need to submit it asap. Thanks

Flying Carpet Brewery produces two drinks (drink 1 and drink 2) that are produced by blending two ingredients (ingredient 1 and ingredient 2). By weight, drink 1 must contain at least 66% ingredient 1, and drink 2 must contain at least 56% ingredient 1. Drink 1 sells for $7 per ounce, and drink 2 sells for $5 per ounce. Ingredient 1 and 2 can be produced by one of two production processes.

Running process 1 for an hour requires 8 ounces of raw material and 2 hours of skilled labour, and it yields 3 ounces of each ingredient.

Running process 2 for an hour requires 6 ounces of raw material and 3 hours of skilled labour and yields 3 ounces of ingredient 1 and 1 ounce of ingredient 2.

A total of 3000 hours of skilled labour and 6000 ounces of raw material are available.

a. Formulate and solve a spreadsheet model to help this company solve its problem.

b. Based on the Excel Solver reports, what would be the change in the optimal profit if 1000 ounces of extra raw material were available to the firm at no cost?

c. How would your answer change if 2000 ounces of extra raw material were available to the firm at no cost?