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

Modeling an economy using the solow model., Suppose we're modeling an econo...

Suppose we're modeling an economy using the Solow model. It begins in steady state. By what proportion does y? (the post-change steady-state per capita GDP) change in response to t

Wto negotiations, WTO Negotiations: As is obvious from the above expla...

WTO Negotiations: As is obvious from the above explanation  that India has favoured multilateral trade reforms ever since the time of GATT (1947) to WTO (1995). Currently WTO

State the both overnight target rates and inflation, Overnight target rates...

Overnight target rates and inflation One of the main targets of every central bank is a low and stable inflation. It's main control variable is the overnight interest rate targ

Theories of international trade, comparison between neoclassical factor end...

comparison between neoclassical factor endowment theory of international trade and classical labor cost theory of comparative advantage

Welfare economic, Evaluate the Bergson social welfare functions

Evaluate the Bergson social welfare functions

Multiple regression analysis, In multiple regression analysis, before testi...

In multiple regression analysis, before testing the significance of the individual regression coefficients, (a) the intercept must equal 0. (b) the multiple standard error of the e

Uniform series of payments, Your project has an estimated cost for land rec...

Your project has an estimated cost for land reclamation to be realized at the end of 20 years from today for $70,000,000. If current bond long-term interest rates are 7% compounded

Solow growth model, graph the central equation of the solow model. argue th...

graph the central equation of the solow model. argue that a steady state exists and that the economy will converge to this point from any initial starting capital stock

Find real interest rate and nominal interest rate, #questionAssume that an ...

#questionAssume that an economy''s GDP Y=5000. Also assume that the government runs a deficit where tax revenue T=1000 and government expendituresG= 1500. The consumption function

Price level depends on current money supply and future, If the price level ...

If the price level depends on both the current money supply and future expected money supplies, in order to stop a hyperinflation, a central bank may try to establish credibility b

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