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

  Solve the linear model

Select five values for x to plug into the linear function, P(x)=10x-7 and prepare a table of values

  Identify the sample and suggest a population

Identify the sample and suggest a population

  Evaluate the ratios

Evaluate the ratios and check are the ratios equivalent.

  Define variables and profit function

Define variables and profit function

  Make a linear equation

Assume you have a lemonade stand, & when you charge $1 per cup of lemonade you sell 50 cups. But when you raise your price to $2 you only sell 25 cups. Make an equation for the number of cups you sell as a function of the price you charge. Denote "C"..

  Classify linear and non linear functions

For each of the relationships given below, describe whether you think it is best explained by a linear function or a non-linear function.

  Which of the following are functions

Which of the following are functions?  The two problems, i.e., 1 & 3, are multi part relations consider all parts when determining whether or not these relations are functions. Explain your reason for 1, 2, & 3.

  Using venn diagram for solving word problems

Using venn diagram for solving word problems.

  Joint probability density function

The joint probability density function.

  Applications of combination

Applications of combination

  Solving problems using venn diagram

Solving problems using venn diagram.

  Solving problems into equation

Solving problems into equation.

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