What is the maximum probable daily profit

Assignment Help Algebra
Reference no: EM13663056

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

Reference no: EM13663056

Questions Cloud

Interview notes : Interview Notes
Journalizing in the cash disbursements journal : Accounts Payable is money you pay to customers and vendor default information needs to be setup to establish the criteria used when computing vendor discounts.
What are the expected hardy-weinberg genotype frequencies : What are the observed eenotvne frequencies in this nonularinn and what are the allele frequencies in this population and what are the expected Hardy-Weinberg genotype frequencies?
Show what would the annual percentage rate : The City of Phoenix plans to buy five additional mass transit cars for $15 million, and pay off its loan in 10 years. What would the annual percentage rate be if the city plans to make an interest payment of $2 million?
What is the maximum probable daily profit : What is the maximum probable daily profit, and how many of each product must be produced in order to achieve this and What is the solutions the linear programming model
What length of time did the wheel rotate : After fixing a flat tire on a bicycle you give the wheel a spin. If its initial angular speed was7.01 rad/s and it rotated 15.0 revolutions before coming to rest, what was its average angular acceleration? (Consider speeding up positive and slowing d..
The equation of a transverse wave on a string : The equation of a transverse wave on a string is y = (2.0mm) sin[(22 m-1)x - (500s-1)t]. The tension in the string is 20 N. What is the wave speed? Discover the linear density of this string.
A toaster uses a nichrome heating wire : A toaster uses a nichrome heating wire. When the toaster is turned on at 20 degrees Celsius, the initial current is 1.5 amps. a few seconds later the toaster warms up and the current now has a value of 1.3amps.
Two electrons in an atom have quantum numbers : Suppose two electrons in an atom have quantum numbers n = 3 and l =1. (a) How many states are possible for those two electrons? (Keep in mind that the electrons are indistinguishable.)

Reviews

Write a Review

Algebra Questions & Answers

  Find the slope intercept equation

Find the slope intercept equation

  Value in quartic equation

To solve the quartic equation, one of the approaches is to seek squares on both sides. For example, to find x, in ax^4+bx^2+cx=d.

  Make the solutions that can be read from the simplex tableau

Make the solutions that can be read from the simplex tableau

  Elimination or substitution methods

Elimination or substitution methods

  Radical equation and rational exponents

What is the difference between radical equation and rational exponents?

  Galois group of polynomial

Find explicitly Gal(x^3 - 2) over Q (the rationals). That is, explicitly give the automorphisms.

  Find the solution for x

Find the solution for x

  Equivalence relation on set of ordered pairs

Let S be the set of ordered pairs of positive integers, let z = (5,8), and define R so that (x1, x2) R (y1, y2) means that x1 + y2 = y1 + x2.

  Find the lcm of the denominators

Find the LCM of the denominators

  Barn painting rational expression

Write a rational expression for the fraction of the barn that they complete in one day by working together. Evaluate the expression for x = 5.

  Find how many bowls does each machine produce

Find how many bowls does each machine produce

  Why are there two solutions in quadratic equations

When solving a rational equation why is it ok to remove the denominator by multiplying both sides of the LCD and why can you not do the same operation when simplifying a rational expression. Why are there two solutions in quadratic equations?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd