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
If Country A had four times the initial level of real GDP per capita of Country B and it was growing at 1.4 percent a year, while real GDP was growing at 2.3 percent in Country B,

The circular flow of income in a closed economy   A closed economy exists when there is no international trade. We shall also assume that in this particular closed economy there

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

Introduce about the open-economy macroeconomics shortly. The Open Economy: a. One of the major concerns introduced through open-economy macroeconomics is the exchange rat

1a. Show on the market for milk the effect of the introduction of BGH (bovine growth hormone). 1b. Show on the market for cheese the impact of what happened in the milk market.

i have an assignment i need it to be done by thursday march the 10th before midnight

Q. What do you mean by Gross domestic product? Perhaps the most significant concept in macroeconomics is Gross Domestic Product (GDP): Gross Domestic Product (

The benefits of capitalism are that the governments have limited control over other business, which lets business compete.

if the price elasticity of demand is computed for two products, and product A measures .79 , and product B measures 1.6 , then ? a. product A is more price elastic than product

Which of the following equations is FALSE for perfectly competitive firms? A. Total cost = fixed cost + variable cost B. Marginal cost = change in total cost / change in quantity o