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

Differentiate economic growth and economic development, Differentiate econo...

Differentiate economic growth and economic development. Economic growth is a raise into real GDP. GDP is only one dimension of development and therefore is a narrow measure of

What is national income, Q. What is national income? What are the different...

Q. What is national income? What are the different methods of measuring national income? National income is the aggregate money value of the annual flow of final goods and serv

Supply & Demand Graph, Ok, so the supply curve for goal in the U.S. is perf...

Ok, so the supply curve for goal in the U.S. is perfectly elastic, while the demand curve has the usual shape. In 2011, the U.S. used 1,003 million tons of coal at an average price

SARB, #If the reserve bank wants to pursue a contractionary monetary policy...

#If the reserve bank wants to pursue a contractionary monetary policy, the bank should?

Export promotion measures, Export Promotion Measures: While a number o...

Export Promotion Measures: While a number of  existing  export promotion schemes  such as  incentive related to Duty Free Replenishment Certificate (DFRC), Duty Entitlement Pa

Determination of all endogenous variables, Determination of all endogenous ...

Determination of all endogenous variables  We can explain how all the endogenous variables are determined in below figure:  Figure: The Keynesian model with the Phillips c

Public Sector, What is top marginal rate of taxation?

What is top marginal rate of taxation?

Explain the long-run phillips curve, Q. Explain the long-run Phillips curve...

Q. Explain the long-run Phillips curve? The long-run Phillips curve The augmented Phillips curve has an important consequence: the long-run Phillips curve must be vertical

Var model, The estimated statistics from the VAR model are not able to be i...

The estimated statistics from the VAR model are not able to be interpreted to solve the problem of this coursework due to reasons that are discussed in the next subchapter. Therefo

Live around a hazardous waste dump, : Suppose that 100 people live around a...

: Suppose that 100 people live around a hazardous waste dump. If the people continue to live there for 20 years, one of them will likely contract a painful, non-fatal cancer that w

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