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

Purchase an annuity, Suppose you have $10,000 and wish to purchase an annui...

Suppose you have $10,000 and wish to purchase an annuity that pays you a fixed dollar amount every month. How much would you receive each month if the annuity rate is 1% and you in

Should the fiscal policy be active or passive?, In the view of above compli...

In the view of above complications, there is a long-standing debate on whether the fiscal policy should be active or passive in nature. Note that in the Keynesian context; even a p

#title. phillip curve, what does phillip curve signify? how do you reconcil...

what does phillip curve signify? how do you reconcile the difference in the shap of the curve in the short run and the long run?

Mutual funds into stock also funds from money market, How would the followi...

How would the following influence the growth rates of theM1 and M2 money supply figures over time? a. an increase in the quantity of U.S. currency held overseas b. a shift of f

Pros and cons of commercial transactions, Examine the pros and cons of comm...

Examine the pros and cons of commercial transactions in blood from the egoistic, the utilitarian, and the Kantian perspectives

System of private property rights, A system of private property rights A...

A system of private property rights A. enhances economic growth by creating incentives to the Fed to maintain stable prices. B. enhances economic growth by increasing the pro

Classical model, using a graph of the classical labour market,illustrate th...

using a graph of the classical labour market,illustrate the effects of a real wage existing in the market that is lower than the equilibrium real wage.What will eventually happen i

Liberalisation and changing sectoral composition of fdi, Liberalisation and...

Liberalisation and Changing Sectoral Composition of FDI: The latest is the ICT wave that has influenced the global shift in service industries the most. Therefore, these  flow

Production possibilities, you and your neighbor (n) consume without trading...

you and your neighbor (n) consume without trading. suppose you are initially consuming 7 bananas and 3 coconuts and your neighbor is initially consuming 6 bananas and8 coconuts. Yo

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