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

Introduction to demand analysis, INTRODUCTION TO DEMAND ANALYSIS: It i...

INTRODUCTION TO DEMAND ANALYSIS: It is generally seen that market demand curve is downward sloping. Market demand curve (or sometimes called Aggregate demand curve) is nothing

Unit root testing, Firstly, it is imperative that I investigate the stochas...

Firstly, it is imperative that I investigate the stochastic properties of each series considered in the model prior to estimating the effects of oil price shocks on macroeconomic a

Gpd., the whole explanation of dpd

the whole explanation of dpd

Determine the problems there with consumer price index, Determine the Probl...

Determine the Problems evolved with Consumer Price Index To illustrate problems involved in calculating CPI we consider MP3 players. If you measure average price of MP3 players

Economic system: protectionism and free trade, why is international trade i...

why is international trade important for South Africa?

Monetary policy vs. fiscal policy, Monetary Policy Vs. Fiscal Policy Ac...

Monetary Policy Vs. Fiscal Policy According to monetarists, money is very important in determining the level of aggregate demand and that monetary policy is very potent. In con

Relate overnight interest rates with interest rates, Relate overnight inte...

Relate overnight interest rates with interest rates By controlling overnight interest rates, the central bank will affect the interest rates with longer maturity. The reason f

Employment, critically analyse the ways at which the government of zimbzbwe...

critically analyse the ways at which the government of zimbzbwe has put in place to address unequal employment opportunities between men and women

What do you mean by price index, Q. What do you mean by Price index? Be...

Q. What do you mean by Price index? Because we are only interested in percentage change of the price level and not particular value, we can divide every price level by a given

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