Ask Algebra Expert

What is the solutions the linear programming model where it should include a graphic and i need to understand about it.

Linear Programming (Optimisation) Model)

Shambles have selected the "Mythical Beasts" range and decided to contemplate on "Pegasus" and "Phoenix."  They would now like to find the right mix of these two products in order to maximise profit.  Every toy has to go through two processes during manufacture: sewing and stuffing.

Pegasus takes 30 minutes to sew whilst Phoenix takes 20 minutes; there are 10 hours (600 minutes) available for sewing each day.

Pegasus takes 20 minutes to stuff whilst Phoenix takes 25 minutes; there are 10 hours (600 minutes) available for stuffing each day.

Pegasus generates £4 profit per toy whilst Phoenix generates £5 profit per toy.

What is the maximum probable daily profit, and how many of each product must be produced in order to achieve this?

Use "Solver" in Microsoft Excel to solve this problem.  Include:

i) A print-out of cell values

ii) A print-out of cell formulae

iii) A print-out of the Solver dialogue box with optimisation conditions and constraints

iv) An Answer Report from Solver

v) A statement of the answer in words

Algebra, Academics

  • Category:- Algebra
  • Reference No.:- M91193108

Have any Question?


Related Questions in Algebra

Assignment topic - abstract algebraq1 let r be the ring of

Assignment Topic - Abstract Algebra Q1: Let R be the ring of all 2 X 2 matrices over Z p , p is a prime. Let G be the set of elements x in the ring R such that det(x) ≠ 0. Find the order of G. Q2: If R is a commutative r ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As