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

MONOPOLY, WHAT ARE THE SOURCES OF MONOPOLY

WHAT ARE THE SOURCES OF MONOPOLY

Differentiate demand elasticity and supply elasticity, Describe elasticity?...

Describe elasticity? Differentiate demand elasticity and supply elasticity? What is arc elasticity? Please describe graphically with proper mathematical representation?

Corresponding future value, Calculate the present value P at time zero and ...

Calculate the present value P at time zero and the corresponding future value F at the end of year three for a series of $15,000 payments to be made at the end of each of years one

Foreign institutional investment, Foreign Institutional  Investment: ...

Foreign Institutional  Investment: Foreign  investment flows in the balance of payments  (BOP) comprise FDI flows and portfolio flows. The latter consists of resources mobilis

How rates depends on maturity, How rates depends on maturity Rates depe...

How rates depends on maturity Rates depending on maturity. Even though rates with different maturity (all recalculated to a yearly rate) need not be exactly equal, they cannot

Functions of commercial bank - granting a loan, Granting a ...

Granting a loan: When commercial banks lend, they create money. This can be explained by extending the hypothetical example of Bank

What do you mean by capital flows, Q. What do you mean by Capital Flows? ...

Q. What do you mean by Capital Flows? With free capital flows, this is a very unreasonable assumption. If we domestic interest rate increase against the foreign interest rates,

Supply and demand , construct the supply and demand curves for rental housi...

construct the supply and demand curves for rental housing, indicating equilibrium rent and quantity. Show the effects on this market( i.e., on supply, demand, equilibrium rent and

Fiscal policy and budget, Fiscal policy is the program of government’s with...

Fiscal policy is the program of government’s with respect to the amount and composition of (i) expenditure: the purchase of commodities and services, and spending in the form of su

Example of indirect taxes and subsidies- accounting system, Example of Indi...

Example of Indirect Taxes and Subsidies- ACCOUNTING SYSTEM   We now permit our government to impose what are called indirect taxes. This category includes sales tax, excise tax,

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