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 do you mean by patulin, Q. What do you mean by Patulin? It is a to...

Q. What do you mean by Patulin? It is a toxic and antibiotic metabolite produced by several species of Penicillin, Aspergillus and Paeciliomyces but the most important in the c

Give examples of a monopoly, Give examples of a monopoly and an example of ...

Give examples of a monopoly and an example of perfect competition. Explain how each of your examples matches the textbook's definition of that market structure. Monopoly-a firm tha

What is bowed-out shape, Why does a production possibilities frontier with ...

Why does a production possibilities frontier with increasing opportunity costs have a bowed-out shape?   The curve is bowed-out because some resources are better suited for the

Supply and Demand, During the 1990s, technological advance reduced the cost...

During the 1990s, technological advance reduced the cost of computer chips. Explain, with the use supply and demand diagrams, how the following markets are affected in terms of pr

Steady state in solow model, conditions for steady state in solow model.in ...

conditions for steady state in solow model.in what respects is golden rule different from steady state?

Employment, Employment  Full employment of human and non-human resource...

Employment  Full employment of human and non-human resources or at least minimization of unemployment is an accepted goal of macroeconomic policy. Also the best way to alleviat

Every month price of the telecommunication services, You are an assistant t...

You are an assistant to a senator who chairs an ad hoc committee on reforming taxes on telecommunication services. Based on your research, AT&T has spent over $15 million on relate

Pat, Explain the concept of diminishing returns to labor.

Explain the concept of diminishing returns to labor.

Economics, Ask question #Minimum 100 words accepted I need help with homew...

Ask question #Minimum 100 words accepted I need help with homewok

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