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
Q. Explain about Household savings? Remember that consumption may refer to observed consumption as well as to demand for consumption. The same is true for 'household savings',

Question 1: Consider a closed economy with no government sector in which consumption (C) is related to income (Y) by the equation: C = A + bY (a) What is the marginal pr

Q. Show the analysis of cross model? We can divide our analysis of cross model into three sections:  Aggregate demand. Aggregate demand is a major component of cross mo

Q. Monetary base and the supply of money? It isn't possible for central bank to print and distribute money -which would increase their debt without increasing their assets. Rat

"International bodies such as the aced argue that more unequal income and wealth distribution erode social cohesion and increase the scope for internal conflict."

Explain the Economic functions of money - A unit of account In a monetary economy, all prices may be expressed in monetary units which everyone may relate to. Without money,

Q. Nominal interest rate and expected inflation? When we have inflation, we can't, of course, presume that expected inflation is zero. So real interest rate will no longer be e

How much does GDP rise in each of the following scenarios: 1. During a recession, the government raises unemploymemnt benefits by $100 million. 2. A new US airline purchases

Relate overnight rate with money supply When the overnight interest rate decreases, the money supply increases When the overnight interest rate increases, the money supply d

The following table have data for a hypothetical open economy. The amount of investment spending is unknown. Question: What is the level of private savings? Question: Wh