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
1 (a) List two concerns with inflation. (b) Suppose that we are in a condition of fully flexible prices, but production of nails will not go above 200 chairs/month. What price w

You are the manager of a firm that receives revenues of $50,000 per year from product X and $80,000 per year from product Y. The own price elasticity of demand for product X is -3,

Four different measures of GDP Using circular flow model we see that there are 4 equivalent ways of measuring GDP:  Using the definition: market value of all finished goo

Bob's Bee is a small boutique honey manufacturer in Texas.  Bob's neighbor is Jon's James.  The more honey Bob produces, the more jam Jon is able to produce; that is, there is

please,how do i relate keynesian theories on fiscal policy to the topic"impact of oil revenue on agricultural productivity?

how long will be the solution

Using production possibility frontiers, and indifference curves for Argentina and Brazil, illustrate and explain the movement of both countries to the free-trade equilibrium patter

Explain the apparent paradox that saving money is good for the individual but might be bad for the economy. Considering the circular flow diagram how is this relevant to public pol

what is the relationship betwen growth and poverty? either it is positive or negative?

what is economic laws ans characteristics of economic laws?