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

Impulse response functions, The final and most important part of the method...

The final and most important part of the methodology is the impulse response functions which will provide the most information with regards to the aim of the project. In order to a

How can we determine fixed exchange rate, How can we determine fixed exchan...

How can we determine fixed exchange rate If a nation has a fixed exchange rate (say against a specific currency), the government or central bank may change this fixed exchange

Resulting market distortion, Consider a market for fish whose market demand...

Consider a market for fish whose market demand and market supply for fish are specified as Qd = 300 - 2.5 P and Qs = - 20 + 1.5 P respectively. The government decides to impose a p

Effect of distance on completed, From stock and watson 3rd edition introduc...

From stock and watson 3rd edition introduction to econometrics Using the data set CollegeDistance described, run a regression of years of completed education (ED) on distance to t

Assignment #1, Explain the meaning of a production possibilities curve

Explain the meaning of a production possibilities curve

LM or IS curve, I''m trying to figure out what the effect would be on LM or...

I''m trying to figure out what the effect would be on LM or IS curve, and additionally the interest rate and income if (a) the transactional demand for money increases, (b) the liq

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

What are the social economic and non economic factors, What are the social ...

What are the social economic and non economic factors? Development is also a procedure involving change in some social economic and non economic factors comprising: • Econom

Lag length criteria, In order to estimate aVAR, alag length must be used in...

In order to estimate aVAR, alag length must be used in the estimation. There are many different criteria which can be used to signal the ideal lag length to use.Asteriou & Hall (20

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