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 is quantitative easing, What is Quantitative easing Quantitative ...

What is Quantitative easing Quantitative easing (QE) is an unorthodox monetary policy which since 2009 has been intermittently pursued by Bank of England and US Federal Reserv

Tariffs and non-tariff barriers, Tariffs and Non-tariff Barriers A sig...

Tariffs and Non-tariff Barriers A significant aspect of the trade reforms of the 1990s was the reduction in the then prevailing very high import duties (over 300 percent in so

Gdp, explain the structure of the economy and its impact on the gdp of soun...

explain the structure of the economy and its impact on the gdp of sountry.

Aggregate supply, As is the case with the supply and demand function for a ...

As is the case with the supply and demand function for a single business firm determining the equilibrium price and output for its product, the aggregate supply and aggregate deman

Difference among federal income tax and a federal sales, How could utility ...

How could utility theory help us understand the difference between a federal income tax and a federal sales tax on consumer consumption patterns?

Critique the effectiveness of the model, Discuss how decisions are made in ...

Discuss how decisions are made in your workgroup. Which model is used for what situation? Be sure to provide specific examples of at least three situations and what model was used

National income statistics, what is the use of national income statistics a...

what is the use of national income statistics as an indicator for a country''s standard of living?

Utility maximisation - graphical presentation , Utility Maximisation: ...

Utility Maximisation: Graphical Presentation  Let consider a two-commodity world, x 1 and x 2 representing good I and good II respectively. p 1 and p 2 are the prices o

What is the law of comparative advantage, What is The law of comparative ad...

What is The law of comparative advantage The law of comparative advantage, though, suggests that it would be unwise of UK economy to try to replicate German model. First German

#title.national income ddetermkination, explain how national income is dete...

explain how national income is determined under the following economies; 1.frugal economy 2.governed economy

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