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

Gdp, The following is the information from the national income accounts for...

The following is the information from the national income accounts for a hypothetical country: GDP Rs. 6000.00 Gross Investment Rs. 800.00 Net Investment Rs. 200.00 Consumption Rs.

Analysis, provide data and analysis for the real GDP (as total and per capi...

provide data and analysis for the real GDP (as total and per capita) and its growth rate then draw a graph and identify the periods of the Malaysia’s business cycle 2007 -2011

Velocity of money is constant, Suppose that this year's the money supply is...

Suppose that this year's the money supply is $500 billion, nominal GDP is $10 trillion, and real GDP is $5trillion. a. What is the price level? b. What is the velocity of money

Illustrate the definition of money, Definition of Money We should defi...

Definition of Money We should define what we mean by money. Money has a long as well as interesting history and an understanding of how we came to use money is useful for any

Determine about the inflation rate, Determine about the Inflation rate ...

Determine about the Inflation rate For many central banks, this is the variable they are mostly interested in controlling. For all central banks, it is an important variabl

What causes economic growth, What causes economic growth? Causes of ec...

What causes economic growth? Causes of economic growth: Into the Solow model, economic growth is based onto the quantity and quality of technology and resources. Growth

What are long run and short run, What are long run and short run? Lon...

What are long run and short run? Long run: It is the time period wherein all inputs cannot be fixed. Short run: It is the time period within which at least one in

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

how can a country maintain equilibrium GDP with foreign trade?

What are the gains from trade, Shows the productivity for the countries Pin...

Shows the productivity for the countries Pin and Pang. Machines Bread Pin     4 or 3 Pang 3 or 8 1) If the working population of Pin and Pang are both 6 million, divide

Compute the gain and directivity of the antenna, An antenna in free-space d...

An antenna in free-space driven by current Io radiates far-field E as: for 0 ≤ Φ ≤ π, here C = constant = 0 everywhere else a) Compute the power density, b) Compute t

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