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

Mec, Lucas’ point of view, what are the limitations of the Keynesian model?...

Lucas’ point of view, what are the limitations of the Keynesian model? What improvements does he suggest?

Determine the velocity of circulation, The demand for nominal balances rise...

The demand for nominal balances rises with the price level. At the similar time inflation causes the real demand for money to fall. Describe how these two assertions can be both co

Economies of scale, what are the limitation of economies scales

what are the limitation of economies scales

Fed would cause the money supply, One alternative way to calculate the tota...

One alternative way to calculate the total change in money supply when the Fed injects money into the economy or takes away money from the economy is the amount of money injected o

Explain AS-AD model and inflation, Q. Explain AS-AD model and inflation? ...

Q. Explain AS-AD model and inflation? Even though AS-AD permits changes in the price level, it doesn't allow for persistent inflation or deflation. We can't have continued decr

Determined at the intersection of the money demand, Consider the supply of ...

Consider the supply of money graph above. Which of the following can be determined at the intersection of the Money Demand and Money Supply curves? The rate of open market transact

Price-elasticity of demand coefficient of a firm''s product, a) Use the arc...

a) Use the arc-approximation formula to calculate the price-elasticity of demand coefficient of a firm's product demand between the (quantity, price) points of (100, $20) and (300,

Estimate the value of wacc method, You can work on this assignment individu...

You can work on this assignment individually or in a group of up to 4 people.  If you choose to work as a group, your group should hand in one assignment and you will all receive t

Production possibilities, you and your neighbor (n) consume without trading...

you and your neighbor (n) consume without trading. suppose you are initially consuming 7 bananas and 3 coconuts and your neighbor is initially consuming 6 bananas and8 coconuts. Yo

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