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

Pine village needs some additional recreation fields, Pine Village needs so...

Pine Village needs some additional recreation fields. Construction will cost $225,000 and annual O&M expenses are $85,000. The city council estimates that the value of added youth

Kind of organization, Informal groups exist in almost every kind of organiz...

Informal groups exist in almost every kind of organization. Answer the following questions and provide examples to support your position: • What types of informal groups do you

For product price elasticity of demand, You are the manager of a firm that ...

You are the manager of a firm that receives revenues of $50,000 per year from product X and $80,000 per year from product Y. The own price elasticity of demand for product X is -3,

Econ, Christina Romer and Jared Bernstein in "The Job Impact of the America...

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

Sustainability of current account deficit, Sustainability of Current Accoun...

Sustainability of Current Account Deficit: Theoretically speaking, a current account deficit can be sustained as long as the growth rate of national income exceeds the rate of

Explain friis equation- affective aperture, In your own words, explain the ...

In your own words, explain the following: a) affective aperture, b) array factor, c) Friis equation, d) Antenna H-plane and E-plane, e) radiation resistance

Describe in detail about exchange rate systems, Describe in detail about Ex...

Describe in detail about Exchange rate systems Various countries have different exchange rate systems. The most significant characteristic of an exchange rate system is to what

Important for policymakers, Why is it important for policymakers to conside...

Why is it important for policymakers to consider both the direct and indirect effects of public policies?

Explain the pre-emptive monetary policy, Explain the pre-emptive monetary p...

Explain the pre-emptive monetary policy Since 1992 UK monetary policy has been 'pre-emptive'. In pre-emptive monetary policy authorities announce that they are prepared to rai

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