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
While referring to the "EYE on YOUR LIFE" section on page 183 of the textbook, apply this concept to your life. Develop your own policy position on price floors and price ceilings.

what happens when there is changes in the quantity supply?

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

Typical start-up businesses' estimated profit are forecasted as following: State Bad Good Probability 81% 21%

assessment of interest rate in the economy of south africa, unemployment

what would be effect of fiscal and monetry policy on price and output level if meges are flexible and rigied?

1) Why does the adoption of Keynesian economics come out of the Great Depression? 1) Why does the adoption of Keynesian economics come out of the Great Depression? 2) What will ha

Consider an economy with the following characteristics: i. The price-level is fixed ii. The economy is closed (Exports - Imports = 0) iii. Government spending (G) and Inve

GKX Industries expects sales of its hydraulic seals (in inch and metric sizes) to increase according to the cash flow sequence $70+4k, where k is in years and cash flow is in $1000

The enrollment in a course offered by the College of Business is random and is described by the following probability distribution: there is a 9% chance of 18 students, 22% chance