Estimate the maximum possible daily profit, Macroeconomics

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

 

Posted Date: 3/20/2013 5:28:37 AM | Location : United States







Related Discussions:- Estimate the maximum possible daily profit, Assignment Help, Ask Question on Estimate the maximum possible daily profit, Get Answer, Expert's Help, Estimate the maximum possible daily profit Discussions

Write discussion on Estimate the maximum possible daily profit
Your posts are moderated
Related Questions
Explain the purposes economists disagree and using models of economics. Using Models of Economics: a. Positive economics b. Normative economics A forecast is an easy p

A firm with a U-shaped average cost curve finds that its revenues exceed its costs when it sets price equal to marginal cost. On which part of its average cost curve is the firm op

Q. Define Nominal wages? The nominal wage is wage per unit of time in the currency used in the country- what we usually just call wage. When we mention wage in macroeconomics w

To the right is a production possibilities table for consumer goods (automobiles) and capital goods (forklifts): a. Show these data graphically. Upon what specific assumptions is t

If the Banking system has $500,000 in demand deposit liabilities, $125,000 in total reserves and a reserve requirement of 15%: What is the maximum amount by which the money supply

Q. Demand for money and GDP? The demand for money also relies on the GDP as GDP is closely associated to national income. If you choose to hold a fixed proportion of your wealt

A monopoly has a total cost function of C(Q) = 8Q and faces a market demand Q = 100 ? 2p, (a) calculate the deadweight loss; (b) The firm now spent an amount equal to half of

Macro Economics 1. How was the Classical Theory of interest role criticized by Keynes? 2. Illustrate the barter system that was used in early times in lieu of money. 3.

If rice production is land intensive and computer production is labor intensive, though both good require some land and labor, the two-good production possibilities frontier will c

What are the Changes in the exchange rate Assume that United States is our home country and that current euro exchange rate in direct notation is SD= 1.5 (euro/USD). In indirec