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

Theory of trade cycle, how the theories of trade cycle affects in the busin...

how the theories of trade cycle affects in the business

What are the international economic crisis, What are the international econ...

What are the international economic crisis A current account surplus can only take place in one nation if there is a current account shortage in another country. So it makes no

Expenditures and the effects of fiscal policy, Expenditures and the Effects...

Expenditures and the Effects of Fiscal Policy are stated as follows: Having finished the discussion on the tax policy and taxation, now let’s us focus on expenditures and the e

Liberalisation and mode of entry, Liberalisation and Mode of Entry: Va...

Liberalisation and Mode of Entry: Various new forms of FDI flows have also emerged. Besides mergers and  joint ventures, transactional relationships are emerging such  as lice

Trade and development, TRADE AND DEVELOPMENT: In the earlier Units of ...

TRADE AND DEVELOPMENT: In the earlier Units of this block, you have learnt about the trade policy from historical perspective and the recent shift in policy during nineties. Y

Show the components of gdp, Q. Show the components of GDP? The circular...

Q. Show the components of GDP? The circular flow - simple version We have defined GDP, gross domestic product, as the market value of all finished service and goods produced

Illustrate about the effective exchange rate, Illustrate about the Effectiv...

Illustrate about the Effective exchange rate Assume that we are interested in external competitiveness of a country, say Japan. To do this we could look at evolution of a speci

Money illusion, A significant argument for the augmentation has to do with ...

A significant argument for the augmentation has to do with concept of money illusion. Money illusion means that you care about nominal rather than real amounts. Imagine that your s

AS/AD model, In an effort to provide tax relief for households while still ...

In an effort to provide tax relief for households while still balancing the budget, Congress votes to raise business taxes and decrease personal taxes. explain the impact of these

Monetary policy vs. fiscal policy, Monetary Policy Vs. Fiscal Policy Ac...

Monetary Policy Vs. Fiscal Policy According to monetarists, money is very important in determining the level of aggregate demand and that monetary policy is very potent. In con

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