Estimate the maximum possible daily profit, Macroeconomics

Assignment Help:

Shambles have selected the "Mythical Beasts" range and decided to concentrate on "Pegasus" and "Phoenix." They would now like to find the right mix of these two products in order to maximise profit. Each 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 possible daily profit, and how many of each product should be produced in order to achieve this?

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

a print-out of cell values
a print-out of cell formulae
a print-out of the Solver dialogue box with optimisation conditions and constraints
an Answer Report from Solve
a statement of the answer in words

 


Related Discussions:- Estimate the maximum possible daily profit

What are the gains from trade, Shows the productivity for the countries Pin...

Shows the productivity for the countries Pin and Pang. Machines Bread Pin     4 or 3 Pang 3 or 8 1) If the working population of Pin and Pang are both 6 million, divide

Social cohesion and increase the scope, "International bodies such as the a...

"International bodies such as the aced argue that more unequal income and wealth distribution erode social cohesion and increase the scope for internal conflict."

Scarcity and choice, how to solve problem of scarcity and choice

how to solve problem of scarcity and choice

Explain growth theory, Q. Explain Growth theory? The purpose of this to...

Q. Explain Growth theory? The purpose of this topic is to try to explain growth in GDP. The models in this topic are very different from the rest of the models as they use only

New equilibrium price and equilibrium quantity, If demand increases and the...

If demand increases and the supply increases also, then what will happen to the new equilibrium price and equilibrium quantity? Explain what is happening with the curves and how pr

Same Basket of Goods, assume the cost of a market basket in 2008 is 1717.0....

assume the cost of a market basket in 2008 is 1717.0. Calculate the cost of the same basket of goods and services in 2007. Price index in 2008 was 100 and price index in 2007 was

Price-elasticity of demand coefficient of a firm''s product, a) Use the arc...

a) Use the arc-approximation formula to calculate the price-elasticity of demand coefficient of a firm's product demand between the (quantity, price) points of (100, $20) and (300,

Show the equations of the as-ad model, Q. Show the equations of the AS-AD m...

Q. Show the equations of the AS-AD model? The equations of the AS-AD model To précis the AS-AD model, we can have a glance at its equations. IS-LM model was "solved" by s

Define the fisher equation, Define the Fisher equation Fisher equation ...

Define the Fisher equation Fisher equation is: Money supply (stock of money) x velocity of circulation of money = price level x total transactions in the economy or     MV =

What is the value of the test statistic, For the United States, the mean mo...

For the United States, the mean monthly Internet bill is $32.79 per household (CNBC, January 18, 2006). A sample of 50 households in a southern state showed a sample mean of $30.63

Write Your Message!

Captcha
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