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 is the total cost of producing output, What is the total cost of produ...

What is the total cost of producing output? The total cost of producing a specified quantity of output is the total of the fixed cost along with the variable cost of producing

Wages, what is a wage? and the difference between real and nominal wages gi...

what is a wage? and the difference between real and nominal wages giving examples?

Calculate the desired capital stock, Suppose that the desired capital stock...

Suppose that the desired capital stock is given as: K* = 0.3Y/i r Where Y = GDP, and i r is the real interest rate.  Suppose further that Y = $5 trillion and that i r

Percentage did the price level, By what percentage did the price level, as ...

By what percentage did the price level, as measured by this index, rise between 1984 and 2005?

Economic concepts models- demand/supply concepts, Questions: ...

Questions: Search through newspapers for ONE article that is relevant to the economics concepts. You are also required to attach the article to your final report

Aggregate supply in the long run, In the short run, the discrepancy between...

In the short run, the discrepancy between actual and expected price level causes changes in output and employment. But in the long run, if all other things remain constant, the hig

Illustrate aspect depends on producers and consumers surplus, Illustrate th...

Illustrate the aspect depends onto producers and consumers surplus. a. How much advantage do producers and consumers receive by the existence of a market? b. How is the welf

Willing to hold money, Was money a better store of value in the United Stat...

Was money a better store of value in the United States in the 1950s than it was in the 1970s? Why or why not? In which period would you have been willing to hold money? Which one w

Same Basket of Goods, assume the cost of a market basket in 2008 is 1717.0....

assume the cost of a market basket in 2008 is 1717.0. Calculate the cost of the same basket of goods and services in 2007. Price index in 2008 was 100 and price index in 2007 was

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