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

Calculate the demand and probability, Sally's Silk Screning produces specia...

Sally's Silk Screning produces specialty T-shirts that are primarily sold at special events. She is trying to decide how many to produce for an upcoming event. During the event its

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

Marginal product of labor and capital, We define marginal product of labor,...

We define marginal product of labor, MP L as the derivative of f with respect to the L - which is, as (approximately) how much Y will increase when L increases by one unit. We als

National income, # ???? .. difference between gdp at market price and nnp...

# ???? .. difference between gdp at market price and nnp at factor cost

Find the equilibrium quantity, Find the Equilibrium Quantity In a smal...

Find the Equilibrium Quantity In a small town only two candy shops operate and they compete with each other in quantity. Consumers do not differentiate between candies sold by

INFLATION-UNEEMPLOYMENT TRADE-OFF UNDER ADAPTIVE EEX, Explain how inflation...

Explain how inflation unemployment trade-off is not feasible under adaptive expectation.MEC002

Balance of payments, factors that causes the shifts in balance of payments...

factors that causes the shifts in balance of payments

Impulse response functions, After an oil price shock was impacted upon the ...

After an oil price shock was impacted upon the other five variables in the model, many interesting results were found. I have already demonstrated that oil Granger causes i

Describe the meaning of word -investment, Describe the meaning of word -Inv...

Describe the meaning of word -Investment When we use the word investment, we generally mean "gross investment". Essentially, gross investment comprises all finished goods which

Investment banks underwrite ipos, When investment banks underwrite IPOs, th...

When investment banks underwrite IPOs, they are typically sell stock for 5-10 percent more than they pay for it. When they underwrite stock for companies that are already public, t

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