Estimate the maximum possible daily profit, Macroeconomics

Assignment Help:

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

 


Related Discussions:- Estimate the maximum possible daily profit

Income and expedenture, Illustrate the circular flow of income and expendit...

Illustrate the circular flow of income and expenditure according to their models ( classical and keynesian)

Money, what are the three motives of holding money?

what are the three motives of holding money?

Foreign trade, how can a country maintain equilibrium GDP with foreign trad...

how can a country maintain equilibrium GDP with foreign trade?

Important the industry effects, Firm effects are more important the industr...

Firm effects are more important the industry effects. What does this mean? Can you think of situations where this might not be true?

National income, difference between gdp at market price and nnp at factor c...

difference between gdp at market price and nnp at factor cost

Phillips curve in lowland, The Phillips curve in Lowland takes the form of ...

The Phillips curve in Lowland takes the form of ? = 0.04 - 0.5 (u - 0.05), where ? is the actual inflation rate and u is the unemployment rate. The Phillips curve in Highland takes

Explain quantity supplied and supply, What is the difference between 'quant...

What is the difference between 'quantity supplied' and 'supply'?  There is a distinction among supply and quantity supplied. Supply explains the behavior of sellers at every pr

Reducing the budget deficit, Reducing the budget deficit by cutting governm...

Reducing the budget deficit by cutting government spending could conceivably: A. increase income if interest rates rise enough and government spending is more productive than priva

Energy supply, What happens to the extraction path if the choke price falls...

What happens to the extraction path if the choke price falls

Define the real wage, Q. Define the Real wage? Consider the following s...

Q. Define the Real wage? Consider the following scenario. You work full time and during January 2008 you make 2000 euro after tax. A certain basket of goods and services costs

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd