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

What is the value of the test statistic, For the United States, the mean mo...

For the United States, the mean monthly Internet bill is $32.79 per household (CNBC, January 18, 2006). A sample of 50 households in a southern state showed a sample mean of $30.63

Consumption and GDP, At first, it may seem obvious that consumption will re...

At first, it may seem obvious that consumption will rely on Y. If GDP is doubled in real terms over a number of years, government consumption, private consumption and investment wi

Demand and supply, The Australian government administers two programs that ...

The Australian government administers two programs that affect the market for cigarettes. First, media campaigns and labelling requirements aimed at making public aware of the dan

Government can finance its budget deficit, A government can finance its bud...

A government can finance its budget deficit by doing all of the following except: A. borrowing from its central bank. B. printing money. C. selling bonds. D. buying bonds.

Codinal theory - consumer choice concernin utility, Ordinal Theory: A...

Ordinal Theory: A Short Note In ordinal approach, utility is measured ordinally i.e., qualitatively (not numerically or quantitatively). Alternatively, consumer can rank her

Compare and contrast federal government expenditures, Compare and contrast ...

Compare and contrast federal government expenditures, state and local government expenditures, and financing government expenditures. Suggest a total of three actions that should b

Open-market operations to influence, In your answer, discuss the Federal Re...

In your answer, discuss the Federal Reserve's use of open-market operations to influence the money supply and the respective consequences of such actions. Include a discussion of t

Increasing opportunity cost, Using the PPC show what is meant by the law of...

Using the PPC show what is meant by the law of increasing opportunity cost and explain (state) why that law exists. Why is that law important when deciding whether or not to watch

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

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