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

TERMS OF TRADE, HOW INCOME TERMS OF TRADE DIFFER WITH COMMODITY TERMS OF TR...

HOW INCOME TERMS OF TRADE DIFFER WITH COMMODITY TERMS OF TRADE"

Calculate the production with antitrust laws, The following Table summarize...

The following Table summarizes the profits of two firms as a function of their capacity investments levels (you can also interpret these levels as the quantities they produce):

State the important aspects of inflation data for sweden, Four aspects are ...

Four aspects are interesting when we look at inflation data for Sweden During 1800s, when Sweden was primarily an agricultural society, deflation where almost as common as

Wal-marts supply chain management, Explain the impact of Wal-Mart's supply ...

Explain the impact of Wal-Mart's supply chain management on its total product, marginal product, and average product curves. What has been the effect on its retail prices?

Models, give three example of models show endogenous and exogenous varibles...

give three example of models show endogenous and exogenous varibles

Can growth arise without development, Can growth arise without development?...

Can growth arise without development? Growth is just one feature of development and therefore is an essential but not enough condition for economic development. For example, g

Modern global economic system, 1) The modern global economic system I...

1) The modern global economic system In finance we learn that while the future is always uncertain there are ways we gain insight and make the best possible investment decisi

Find the optimal amounts and solve the dual problem, After some consultants...

After some consultants point out that the Acme Toy Company has two bottlenecks in its production of xylophones and yo-yos. The first is a critical grinding machine that only has 9

Define sunk costs-fixed costs-economies of scale, Address the following iss...

Address the following issues concerning technological and strategic barriers to entry. (a) Explain the role of economies of scale and (long run) fixed costs as technological bar

Explain the problem involved in consumer price index, Q. Explain the proble...

Q. Explain the problem involved in consumer price Index? To explain the problems involved in calculating CPI we consider MP3 players. If you measure the average price of MP3 pl

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