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

Consumption, (40 points) Consider two consumers, A and B. A and B both want...

(40 points) Consider two consumers, A and B. A and B both want perfect consumption smoothing (c = cf) and both have no current wealth. However, the two consumers have different inc

Explain AS-AD model and inflation, Q. Explain AS-AD model and inflation? ...

Q. Explain AS-AD model and inflation? Even though AS-AD permits changes in the price level, it doesn't allow for persistent inflation or deflation. We can't have continued decr

Identification problem associated, Note and explain the identification prob...

Note and explain the identification problem associated with the following statement. "During Bill Clinton's presidency the US economy saw unusually strong economic growth; thus, Mr

Consumption, what is the impact of interest rate in consumption

what is the impact of interest rate in consumption

Production, mention and explain four factors that determine the volume of p...

mention and explain four factors that determine the volume of production.

Market structures, illustrate and discuss the market structures competitive...

illustrate and discuss the market structures competitiveand non competitive for price determination

Axiom of completeness - ordinal theory, Axiom of completeness: Consume...

Axiom of completeness: Consumer's choice is complete. Implication: Since consumer is rational, she must have a unique preference relation. That means the consumer choice is ei

Define elasticity of supply, Define elasticity of supply. What factors infl...

Define elasticity of supply. What factors influence Elasticity of Supply? There is only one type of identifiable elasticity of supply measuring the responsiveness of market sup

Macroeconomic models, Now we will analyse how macroeconomic variables fit t...

Now we will analyse how macroeconomic variables fit together and present models which explain the main macroeconomic variables.  Using these models we can, for instance, analyse

Overnight interest rates targets and money supply, Q. Overnight interest ra...

Q. Overnight interest rates targets and money supply? There are many ways to explain the significant connection between overnight interest rate target and money supply. We will

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