Explain clearly how you chose the decision variables,formulate the objective function and constraints

SKU: wufoo13 Category:

Solve for the optimal solution using Microsoft Excel Solver


Order Now

Posh Fragrance is a company that supplies tea leaves to the regional hotels and restaurants. Their two best seller tea leaf blends are Flora1 and Scent2. Due to the upcoming festive season, there is a consolidated order commitment for at least 150 kg of Flora1, and 200 kg of Scent2. To produce 1 kg of Flora1, it should contain at most 55 percent dried figs while each kg of Scent2 should contain at least 65 percent of orange peel. The source for orange peel comes from two mixtures; mixture Alpha and mixture Beta. Mixture Alpha contains 70 percent orange peel and 20 percent dried figs, while mixture Beta contains 25 percent orange peel and 60 percent dried figs. Mixture Alpha costs 85 cents per kg and mixture Beta costs 40 cents per kg. The company CEO would like to know the cost-effective way of mixing Alpha and Beta.


(a) Develop the portfolio selection case as a linear programming problem. Please explain clearly how you choose the decision variables, formulate the objective function and constraints.


(b) Solve for the optimal solution using Microsoft Excel Solver. Show the relevant solution output and sensitivity output.


(c) Interpret the reports and discuss the following scenarios (without resolving it using Microsoft Excel Solver):

(i) If the cost of Mixture Alpha is 50 cents, explain if there will be any changes to the original optimal mix?

(ii) If the order for Flora1 is actually 50kg instead of 150kg, what would be the implications on the total cost on acquiring mixture Alpha and Beta?



Writing your homework and assignments all on your own is a difficult task. So, Assignments4u has made it easy for students by helping them in writing their assignments. Assignments4u will assist you in completing your tasks, and you can approach us with all your assignment, homework, and essay writing requirements.

We have over 4350+ experienced writers working as experts in different streams of study. Get all your academic doubts clarified and take pride in learning subjects like history, math’s or law. Our assignment help and essay help is available in countries like USA, Australia, New Zealand, Singapore and many more. Get accounting assignment help, corporate nursing assignment help, marketing assignment help or else statistics assignment help in exchange for a nominal price.


There are no reviews yet.

Be the first to review “Explain clearly how you chose the decision variables,formulate the objective function and constraints”

Your email address will not be published. Required fields are marked *

Sorry no more offers available