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

Outsourcing to the private sector help reduce the deficit, I need some help...

I need some help organizing an outline for a 5000-6000 word paper. What I am asking for is ideas on how to best organize this topic: "Should Government do it all? Can outsourcing t

Macro, Difference between mec and mei.

Difference between mec and mei.

Explain about interest rate, Q. Explain about Interest rate? When you b...

Q. Explain about Interest rate? When you borrow money, you normally have to pay a fee for the loan. This fee is frequently known as interest, especially if the fee is proportio

Marginal cost of care, Given the following MV information, what is the opti...

Given the following MV information, what is the optimal allocation of care according to the Preteens criteria, when the marginal cost of care is constant at $100. Person A Person B

Call options on microsoft stock, Suppose you buy call options on Microsoft ...

Suppose you buy call options on Microsoft stock. Each option costs $2 and has the strike price of $40 and the expiration date July 1. Discuss whether you would exercise the options

Aggregate supply - long run equilibrium:graphical analysis, Long Run Equili...

Long Run Equilibrium:Graphical Analysis In the long run the natural rate of output is the level of output to which the economy will tend to adjust in the long run. This indicat

Why does yield on UK gov bond go up when stock markets down?, Doesn''t mone...

Doesn''t money move out of stock markets into bond? If more people buy bonds does this not push bond prices up and yields down? My question is about this quote from the Gardian tod

The transmission mechanism - monetary policy, The Transmission Mechanism ...

The Transmission Mechanism The mechanism by which the changes in monetary policy affect aggregate demand is called 'transmission mechanism'. Two stages in transmission mechanis

Lower tax rates, Is it true that government revenues are increased because ...

Is it true that government revenues are increased because of lower tax rates? Ans) It is true to a point. The Laffer curve determines that revenues enhance as the tax rates rise

Apparent paradox, Explain the apparent paradox that saving money is good fo...

Explain the apparent paradox that saving money is good for the individual but might be bad for the economy. Considering the circular flow diagram how is this relevant to public pol

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