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

Firm wants to sell goods, If a firm wants to sell goods more often, would t...

If a firm wants to sell goods more often, would they prefer to produce a high quality good that will not wear out or one that will wear out faster. For example, what is the 'life e

Estimate efficient outcome, The city of Johnstown decides to build a new st...

The city of Johnstown decides to build a new stadium to attract a basketball team from the city of Rosendale.  One economic advisor suggests that the stadium should be fi

Microsoft and standard oil, In what major way do the Microsoft and Standard...

In what major way do the Microsoft and Standard Oil cases differ?

What is social cost benefit analysis, It refers to the study of feasibility...

It refers to the study of feasibility of a project in terms of its total economic cost and total economic advantages. It means to compare total cost with total advantage if we

What is the basic function of central banks, Q. What is the basic function ...

Q. What is the basic function of Central banks? A central bank is a public authority which is responsible for monetary policy for a country or a group of countries. Two signifi

Trade barries , #discuss the arguments for and against the use of trade bar...

#discuss the arguments for and against the use of trade barries in anay counrty

Impact of minimum wage law, Minimum wage laws are common in many countries....

Minimum wage laws are common in many countries. The debate over minimum wage includes claims about the impact of this action on employment levels and wage levels. What impact does

Alternatives type of production, Production Alternatives Type of production...

Production Alternatives Type of production A B C D E Automobiles 0 2 4 6 8 Forklifts 30 27 21 12 0 If the economy is at point C, what is the (opportunity) cost of 2 more automobile

Liberalisation and mode of entry, Liberalisation and Mode of Entry: Va...

Liberalisation and Mode of Entry: Various new forms of FDI flows have also emerged. Besides mergers and  joint ventures, transactional relationships are emerging such  as lice

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