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

What is the macroeconomic policy, Macroeconomic policy Macroeconomic p...

Macroeconomic policy Macroeconomic policy trade-offs are likely along the short-run Phillips curve however are not maintainable in the long run. In the short run a government

How much money can banks create, How much money can banks create? Does...

How much money can banks create? Does this mean that banks can create an unlimited amount of money? The answer is no - that would require them to lend an unlimited amount of m

Differentiate comparative and absolute advantage, What is the difference be...

What is the difference between Comparative Advantage and Absolute Advantage? Difference between Comparative Advantage and Absolute Advantage: Comparative advantage: it is

Mba, Consider the following: The city council has just approved the constru...

Consider the following: The city council has just approved the construction of a water park in your town. You are responsible for studying the impact of the new water park on the l

Arc price elasticity of demand, The Stop decay company sells an electric to...

The Stop decay company sells an electric toothbrush for $25. Its sales have averaged 8,000 units per month over the past year. Recently, its closest competitor, Decay fighter, redu

Process of leave, The yeild of Maize is 73429 Hg/Ha, I need to translate it...

The yeild of Maize is 73429 Hg/Ha, I need to translate it into bu/a, and I konw use 56lbs/bu as test weight. Please leave the process so that I know how to do it, thankyou.

Institutional mechanisms for promotion of fdi, INSTITUTIONAL MECHANISMS FO...

INSTITUTIONAL MECHANISMS FOR  PROMOTION OF FDI: There is  increasing recognition that  understanding  'the forces of economic globalisation requires taking  a look  at  foreig

Spss , (I am providing them below) of Module 5 before beginning this assign...

(I am providing them below) of Module 5 before beginning this assignment.  You will have the opportunity to work through much of the assignment during the group activity for week 1

Firm make profits of losses with this quantity, The Marginal Costs (MC) for...

The Marginal Costs (MC) for a firm is given by the function MC=50x. Please find the Marginal Revenues (MR) for each of the following scenarios (if appropriate). Then, find the prof

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