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

Liberalisation and changing sources of fdi, Liberalisation and Changing Sou...

Liberalisation and Changing Sources of FDI: European countries  had been major sources of FDI inflows  to India until 1990. However, their relative importance declined in the

Tariff reform - trade liberalisation under wto, Tariff Reform: India's...

Tariff Reform: India's customs tariff rates have been declining since 1991. The "peak"  rate came down from 150 percent in 1991-92 to  40 percent  in 1997-98. The downward mom

Capital output ratio, Ask question #impotance of capital output ratio#

Ask question #impotance of capital output ratio#

Makers respond to the crisis monetary policy, Did monetary policy contribut...

Did monetary policy contribute to the economic crisis of 2008? Why or why not? How did monetary policy makers respond to the crisis? Has their response created an environment for f

Solve for all of these questions., Christina Romer and Jared Bernstein in "...

Christina Romer and Jared Bernstein in "The Job Impact of the American Recovery and Reinvestment Plan" calibrated the impact of the proposed expansionary fiscal policy (we know it

Government and price-determination, Government and Price-Determination can ...

Government and Price-Determination can be understood as follows: The government might intervene in the market and mandate the maximum price (price ceiling) or the minimum price

Break-even level of income, Assume that when an economy has a GDP of $500, ...

Assume that when an economy has a GDP of $500, Consumption is $550. The MPC is .75. Investment is 25. Begin the problem by setting up an Income/Consumption Schedule like the one on

Inflation, what are the causes of inflationary gap

what are the causes of inflationary gap

What causes economic growth, What causes economic growth? Causes of ec...

What causes economic growth? Causes of economic growth: Into the Solow model, economic growth is based onto the quantity and quality of technology and resources. Growth

Demand analysis, how the demand of pizzas in pizza hut affecting the market...

how the demand of pizzas in pizza hut affecting the market of fast food

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