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

Define exchange rate systems, Q. Define Exchange rate systems? Differen...

Q. Define Exchange rate systems? Different nations have different exchange rate systems. The most significant characteristic of an exchange rate system is to what degree the co

Substitute a less expensive good, If the price of a good rises, what are pe...

If the price of a good rises, what are people likely to do? a Substitute a less expensive good b Buy more of the good c Buy more of all goods because of added buying power d All of

Command economy, define history and full deatil of command economy

define history and full deatil of command economy

Classical labour market, A rise in the real wage will bring a decrease in t...

A rise in the real wage will bring a decrease in the quantity demanded of labor because of diminishing returns in production. As more and more labor is employed, it is increasingly

Assignment, explain the profit maximizing/loss minimizing rule may be appli...

explain the profit maximizing/loss minimizing rule may be applied under the 3 scenarios

U.s. corporations and workers, What do you presume had happened to get the ...

What do you presume had happened to get the U.S. corporations and workers to take their eyes off of their own economic interest? It seems the "carrot" of cheaper prices were dangle

Give detail explanation of exchange rate, Give detail explanation of Exchan...

Give detail explanation of Exchange Rate In most countries, exchange rate is expressed using foreign currency as base currency. For instance, in Denmark, USD exchange rate woul

What is the price elasticity of supply, What is the price elasticity of sup...

What is the price elasticity of supply? Price elasticity of supply: The price elasticity of supply is a measure of the receptiveness of the quantity of a good supplied to pr

Employment, the production of 200 units of consumer goods and 300 units of ...

the production of 200 units of consumer goods and 300 units of capital goods : a) indicates full employment b) may be a result of unemployment c) may be impossible for now d)

Business economics, Critically evaluate measures used by governments and ce...

Critically evaluate measures used by governments and central banks to manage the economies of their countries. By critical evaluation use convincing arguments for or against measur

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