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

  What is a rational exponent

What is a rational exponent? How are rational exponents related to radicals? Give an example of how an expression with a rational exponent can be rewritten as a radical expression.

  Intercepts and parallel lines

Find an equation for the line w/given properties Parallel to the line 5x-y=-10; containing the point (0,0). Find the equation of a line that is perpendicular to the line y=1/9x+9 and contains the point (-3,0)

  Function values

Function values.

  Conversion between cubic yard and cubic feet

An Airconditioning systemcan circulate 280 cubic feet of air per minute. How many cubic yards of air can it circulate per minute?

  Backpacks problem

Upon examining the contents of 38 backpacks, it was found that 23 contained a black pen, 27 contained a blue pen, and 21 contained a pencil, 15 contained both a black pen and a blue pen

  Equation in slope-intercept form

For the given equation, list the intercepts and test for symmetry. Find the slope-intercept equation of the line with the following properties

  Determining the linear inequality

Determining the linear inequality. Graph the solution set on a number line: 4-X/6?7. What is the solution set?

  The vriend monument is a scared place for geometry students

the vriend monument is a scared place for geometry students in western albania. chance jones uses a surveying device to

  Find the ordered pairs

Find the ordered pairs

  Identify the parent function

Write a function for the cost C of purchasing x fruits from Freddie in a given month and identify the parent function and list the transformations being applied to the parent function, in a correct order.

  A single card is drawn from an ordinary 52-card deck find

a single card is drawn from an ordinary 52-card deck. find the probability of getting a 2 of

  Rationalize the denominator to simplify radicals

A painting is shaped like a golden rectangle. It's length is 24 cm. What is the painting's width to the nearest tenth of a cm - Rationalize the Denominator to Simplify Radicals

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