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

Combination price of capital decreased, In reference to the above question,...

In reference to the above question, assume you know the combination of inputs that minimizes cost. What would happen to this input combination if the price of labor increased? What

Cobb-douglas production function, Consider an economy characterized by the ...

Consider an economy characterized by the following Cobb-Douglas production function: Y=4K 1/4 L 3/4 Where K and L represent physical capitaland labor, respectively. Assume t

What are the advantages of capitalism, The benefits of capitalism are that ...

The benefits of capitalism are that the governments have limited control over other business, which lets business compete.

explain how to solve the evacuation-route problem, You are the mayor of a ...

You are the mayor of a beautiful city by the ocean, and your city is connected to the mainland by a set of k bridges. Your city manager tells you that it is necessary to come up wi

Benefits in a perfectly competitive market, "Nearly all critics agree that ...

"Nearly all critics agree that consumers have the most benefits in a perfectly competitive market." Does the above statement apply to microeconomics or macroeconomics? Why? Think a

What are the important tools to consider monetary policy, What are the impo...

What are the important tools to consider Monetary Policy? Important tools to consider Monetary Policy: a. What the money demand curve is b. Why the liquidity preference m

Define the tools of competitive market, Define the tools of Competitive mar...

Define the tools of Competitive market. Competitive market: The supply and demand model a. The demand curve b. The supply curve c. Factors which cause the demand cu

Money demand, What will happen to the shape of the money demand curve if th...

What will happen to the shape of the money demand curve if the checking accounts bear interest? will it still slope down if the interest of the checking account is fixed while the

Help needed, what are the advantages and disadvantages of unemployment

what are the advantages and disadvantages of unemployment

Single nonprofit provider, For a single nonprofit provider, describe an out...

For a single nonprofit provider, describe an output-maximizing model to predict supplier behavior?

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