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

Money supply and monetary policy, Money Supply and Monetary Policy   All...

Money Supply and Monetary Policy   All modern societies use money as the medium of exchange. Since money can be exchanged for goods and services it also becomes a financial asse

Velocity and the quantity equation, when the income velocity of circulation...

when the income velocity of circulation (V) rises, why does the economy''s total output must rise?

Explain the classical motivation, Q. Explain the classical motivation? ...

Q. Explain the classical motivation? The classical motivation: Consumers want to smooth their consumption over time. In good times, consumers know that it is a temporary stat

Opportunity cost theory, discuss how opportunity cost principles influences...

discuss how opportunity cost principles influences a supplier''s decision to supply labor

Price elasticity of demand, has determined that the price elasticity of dem...

has determined that the price elasticity of demand for two customer segments (Coach and Business Class) is -1.35 and -2.50. Based on their expectations of profitability, Kashian r

Oil revenue on agricultural productivity, please,how do i relate keynesian ...

please,how do i relate keynesian theories on fiscal policy to the topic"impact of oil revenue on agricultural productivity?

Gdp, what is gdp

what is gdp

Impact of an aging population on state, Evaluate the impact of an aging pop...

Evaluate the impact of an aging population on state and local government expenditures. Suggest strategies that government should take in dealing with this situation. Justify your r

Calculate rental price of capital, Let the real interest rate, i r , equal ...

Let the real interest rate, i r , equal 5 percent and the rate of depreciation, d, equal 10 percent.  In this case, if the price of a piece of capital is P K = $10,000, what is th

Market Demand., Ask question #The market demand for brand X has been estima...

Ask question #The market demand for brand X has been estimated as Qx=1500-3Px-0.05I-2.5Py+7.5Pz Where Px is the price of brand X, I is per-capita income, Py IS the price of brand Y

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