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

Open economy model, Use a diagram of the open economy model (e.g. fig 32.4 ...

Use a diagram of the open economy model (e.g. fig 32.4 from the text) to illustrate and explain the effect of the following event on the market for loanable funds, the level of net

Overnight target rates and inflation, Overnight target rates and inflation ...

Overnight target rates and inflation One of the major targets of every central bank is a low and stable inflation. Its main control variable is the overnight interest rate tar

What is demand for money, Q. What is Demand for money? Demand for mone...

Q. What is Demand for money? Demand for money The demand for money depends negatively on R and positively on the Yin the IS-LM model As fo

Determine price level from the quantity theory of money, Q. Determine price...

Q. Determine price level from the quantity theory of money? The price level The price level is determined from the quantity theory of money:  P = (M.V)/Y

Pareto optimality, Diagramatic explanation of pareto optimality

Diagramatic explanation of pareto optimality

Phillips curve in lowland, The Phillips curve in Lowland takes the form of ...

The Phillips curve in Lowland takes the form of ? = 0.04 - 0.5 (u - 0.05), where ? is the actual inflation rate and u is the unemployment rate. The Phillips curve in Highland takes

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

Quality of health care, Explain how changes in the quality of health care w...

Explain how changes in the quality of health care will influence the demand for care.

How are firms doing at the equilibrium price, Perfect Competition. a.  W...

Perfect Competition. a.  What does it mean for a market to be perfectly competitive?  What are the three conditions of perfect competition.  What does it mean for firms to be 'p

Illustrate the policy - beggar my neighbour, Illustrate the policy - Beggar...

Illustrate the policy - Beggar my neighbour 'Beggar my neighbour' policies are government policies which attempt to gain a competitive benefit at the expense of other countries

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