Problem to maximize the revenue as a linear program

Assignment Help Operation Management

Reference no: EM13967089

Bond aroma co. sells two products: cologne and perfume. Cologne sells for $3 per ounce; each ounce requires 2 grams of fragrance, and 6 grams of intensifier. Perfume sells for $8 per ounce; each ounce requires 4 grams of fragrance, 2 grams of intensifier, and 1 gram of stabilizer. Bond has limited supplies. In particular, it has 1,600 grams of fragrance, 1,800 grams of intensifier, 350 grams of stabilizer. Formulate the problem to maximize the revenue as a linear program and solve it using excel.

Please provide excel sheet using solver.

Reference no: EM13967089

Questions Cloud

Price structure is supplier offering for fixed ordering cost : Whole Foods Operations has selected a shortlist of local suppliers for important produce items for a new store. Discuss how WF will proceed making this decision. Think, for example, inventory standpoint in making such a decision. For example, what pr..

Formulate the problem as a linear programming problem : Union Airways is adding more flights to and from its hub airport and so needs to hire additional customer service agents. The five authorized eight-hour shifts and staffing costs per agent are Shift 1: 6am to 2pm $170 per agent Shift 2: 8am to 4pm $1..

Safety stocks be considered a form of insurance : Why should safety stocks be considered a form of "insurance?" Why does a transporter think in terms of keeping equipment moving?

Respectively to achieve the minimum operating cost : UPS wants to deliver 400 packages in downtown Miami today. There are 11 large trucks available with capacity 40 packages each, and 10 small trucks with capacity 25 packages each. Solve the problem using excel; in other words, find the number of drive..

Problem to maximize the revenue as a linear program : Bond aroma co. sells two products: cologne and perfume. Cologne sells for $3 per ounce; each ounce requires 2 grams of fragrance, and 6 grams of intensifier. Perfume sells for $8 per ounce; each ounce requires 4 grams of fragrance, 2 grams of intensi..

Annual demand-find the optimal order quantity : ABC Company has annual demand of 3000 units, the setup or ordering cost is $15; and the holding cost per unit per year is $0.75. Find the Optimal order quantity. (Show all your calculations. If you can’t find the square root sign, you can simply type..

Research on link between happiness and health demonstrates : Lottery winners are no happier than anyone else a year after their big win. Similarly, people who have experienced serious physical injuries seem to "get over it" fairly well across time and return to their pre-injury level of happiness. These findin..

Find the number of kilometres that the car could travel : Explain how you could use your graph to ?nd the number of kilometres that the car could travel on average for £12. Construct a formula for the cost in pounds, C, of travelling x kilometres.

Localization be on collection of international statistics : Many countries take a major terminology such as ICD and customize it to suit their local needs. Discuss the costs and benefits of this approach from an individual country’s point of view. What could the impact of Localization be on the collection of ..

User Account

All Pages