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

Compute the equilibrium level as-ad model, 1 . Use the AS/AD model to a...

1 . Use the AS/AD model to a . Demonstrate graphically and explain verbally the situation the US economy is currently in. b. In the diagram you drew for part (a) above, sh

Product development project, What is the primary difference between a resea...

What is the primary difference between a research project and a product development project?

Classical labour market, A rise in the real wage will bring a decrease in t...

A rise in the real wage will bring a decrease in the quantity demanded of labor because of diminishing returns in production. As more and more labor is employed, it is increasingly

Real Gdp, What do I calculate with quantity of each good produced, to find ...

What do I calculate with quantity of each good produced, to find the Real GDP?

Proctor and gamble, Bayer Schering Pharma AG, Germany owns the Alka-Seltzer...

Bayer Schering Pharma AG, Germany owns the Alka-Seltzer, which was launched in 1931 and was meant for relief of minor aches, pains, inflammation, fever, headache, heartburn, sour s

Lm curve with inflation, The LM curve with inflation  We know that LM ...

The LM curve with inflation  We know that LM curve will shift upwards when P increases (presuming MS is constant). This is still true though we can also add that LM curve glid

Explain the concept of elasticity, Explain the concept of elasticity and de...

Explain the concept of elasticity and describe why the supply of petrol in the short run is relatively inelastic.

Opportunity Costs, Comparative if Person can make 15 wristbands and hour an...

Comparative if Person can make 15 wristbands and hour and 3 potholders. What is the comparative advantage? If same person works 20 hours a week graph the possible combinations sh

Pigou effect, The Pigou effect: A) suggests that as prices fall and real...

The Pigou effect: A) suggests that as prices fall and real money balances rise, consumers should feel less wealthy and spend less. B) suggests that as prices fall and real mo

Find the optimal amounts and solve the dual problem, After some consultants...

After some consultants point out that the Acme Toy Company has two bottlenecks in its production of xylophones and yo-yos. The first is a critical grinding machine that only has 9

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