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

Quantity Theory of Money, 2. Use the Quantity Theory of Money to explain in...

2. Use the Quantity Theory of Money to explain inflation (a increase in the overall level of prices). (4 points) If you were a member of the Federal Reserve Board of the Governor

How much money can banks create, Q. How much money can banks create? Do...

Q. How much money can banks create? Does that mean that banks can create an unlimited amount of money? No the answer is no - it would require them to lend an unlimited amount o

Normal population standard deviation, A normal population has a mean of 12....

A normal population has a mean of 12.2 and a standard deviation of 2.5. A) Compute the Z value associated with 14.3. B) What proportion of the population is between 12.2 and 14.3.?

IS LM curve, example on the calculation of IS LM Curve?

example on the calculation of IS LM Curve?

Employees'' productivity, what measures should be taken to raise the produc...

what measures should be taken to raise the productivity of the workers?

Example of introducing the government- accounting system, Example of Introd...

Example of Introducing the Government- ACCOUNTING SYSTEM   So far there was no government in any of our stylized economies. Let us now introduce it. To begin with, our governmen

Interest rate risk, If interest rates increase, which would you rather be h...

If interest rates increase, which would you rather be holding, long term or short term bond? Why? Which type of bond has the greater interest rate risk?

How to calculate the total income of the economy, Consider an economy that ...

Consider an economy that having only of those who bake bread and those who make its ingredients. Assume that this economy's production is as follows: 1 million loaves of bread

The supply and demand for oil in the us, Over the last year both the supply...

Over the last year both the supply and demand for oil in the US has gone up. What might have caused this and what happened to the price and quantity of oil?

Money creation process, what is the meaning of the credit multiplier in the...

what is the meaning of the credit multiplier in the monetary sector

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