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

How do tax cuts affect the economy, Tax cuts get better the economy by givi...

Tax cuts get better the economy by giving the people more spending power and higher consumer confidence, which leads to them spending more of all of their income which lead to more

What are the production elasticities of demand, The following Cobb-Douglas ...

The following Cobb-Douglas production function is used to describe the output generated by a local government maintenance agency. Q = αL β1 K β2 E β3 Where L represents numb

Industry''s long-run supply schedule, A perfectly competitive painted neckt...

A perfectly competitive painted necktie industry has a large number of potential entrants. Each firm has an identical cost structure such that long-run average cost is minimized at

Certain private property rights, The more certain private property rights a...

The more certain private property rights are, a. the less people need to invest in education or human capital development. b. The less entrepreneurship there will be. c. t

Explain demand management of keynesian economists, Explain demand managemen...

Explain demand management of Keynesian economists The demand management of Keynesian economists of 50's and 60's is attacked by free-marketers for ignoring the importance of s

#title., .Clearly explain how net foreign investment links the market for l...

.Clearly explain how net foreign investment links the market for loanable funds and the market for foreign currency exchange. Make sure you define net foreign investment in your an

Production possibilities curve, Using a production possibilities curve, an ...

Using a production possibilities curve, an economy that produces an output combination less than the maximum possible is depicted by a point located. a. at the top corner of the

Control of ochratoxin, Q. Control of ochratoxin? Control: Once ochratox...

Q. Control of ochratoxin? Control: Once ochratoxin A has been formed in a food, it is difficult to remove by most forms of food processing. Cooking with or without previous soa

International trade, How can a country maintain equilibrium GDP with foreig...

How can a country maintain equilibrium GDP with foreign trade?

Equilibrium quantity price and quantity, Over the past few years there has ...

Over the past few years there has been much concern about falling housing prices, and some policy makers have argued that the government should put a floor under prices so that the

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