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
Assume that a Mazda 2 sells for 16,000 Australian dollars in Australia and 10,000 Canadian dollars in Canada If purchasing-power parity holds, what is the Canadian dollar/Australia

What factors shift out the PPC and what is the opportunity cost of the economy moving out to get back on the PPC? Explain?

Can the federal government go bankrupt? Explain.

how can we derive IS curve why has it negative slope

The Transmission Mechanism The mechanism by which the changes in monetary policy affect aggregate demand is called 'transmission mechanism'. Two stages in transmission mechanis

Q. What is national income? What are the different methods of measuring national income? National income is the aggregate money value of the annual flow of final goods and serv

impact of change in government expenditure and tax on fiscal policy

As previously stated, the aim of the paper is to observe and analyse the effects of oil price shocks on key macroeconomic indicators in the UK economy. From this the aim is to conc

Consider two bonds. Each has a face value of $100 and matures in one year. One has a zero coupon payment, and the other pays $10 per year. A. Explain how the two bonds differ

Such analysis permits the firm to determine at what level of operations it will break even (earn zero profit) and to discover the relationship among volume, costs, and profits. It