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

Production possibility curve, PRODUCTION POSSIBILITY CURVE As we have s...

PRODUCTION POSSIBILITY CURVE As we have seen, the essence of economic analysis is the problem of scarcity and choice. We know that limited productive resources compel individua

Marginal cost of care, Given the following MV information, what is the opti...

Given the following MV information, what is the optimal allocation of care according to the Preteens criteria, when the marginal cost of care is constant at $100. Person A Person B

How can we define the real wage as nominal wage, How can we define the real...

How can we define the real wage as nominal wage We define real wage as nominal wage divided by a price index (typically CPI). In the illustration above, your real wage was 20 i

Show the equations of the as-ad model, Q. Show the equations of the AS-AD m...

Q. Show the equations of the AS-AD model? The equations of the AS-AD model To précis the AS-AD model, we can have a glance at its equations. IS-LM model was "solved" by s

Trade cycle, discus the various measures that may be taken by a firm to cou...

discus the various measures that may be taken by a firm to counteract the evil effect of a trade cycle

Inflation, Inflation (RPI) - another imperative channel. Oil is a necessity...

Inflation (RPI) - another imperative channel. Oil is a necessity for the UK, and is price inelastic therefore one can analyse the correlation between a price shock and inflation. I

Nash equilibrium or equilibria, Suppose A can somehow change the game in pr...

Suppose A can somehow change the game in problem 5.1 to a new one in which his payoff from Up is reduced by 2, producing the following payoff matrix. a. Find the Nash equilibriu

The LM curve asset market equilibrium., what are the factors that shift the...

what are the factors that shift the LM curve what is the real interest rate and the nominal interest rate. what is expected rate of inflation why has the real interest rate that cl

Gdp, The following is the information from the national income accounts for...

The following is the information from the national income accounts for a hypothetical country: GDP Rs. 6000.00 Gross Investment Rs. 800.00 Net Investment Rs. 200.00 Consumption Rs.

Inflation, inflation of fuel price on consumer

inflation of fuel price on consumer

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