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

Goods market and factors market, Goods Market and Factors Market: Good...

Goods Market and Factors Market: Goods  market  is  the  market  where  goods  are  bought  and  sold  for  the  purpose  of consumption Factors markets are the markets

Protectionism and free trade, why is international trade important for sout...

why is international trade important for south Africa

What are the contents in the market strikes back, What are the contents in ...

What are the contents in the market strikes back? a. Price controls • Price ceiling • Price floor b. Quantity controls quota c. Excise tax d. Inefficiency

Relationship between l and p, Q. Relationship between L and P? • As lon...

Q. Relationship between L and P? • As long as L is smaller than LB, L may change with no change in prices. In this range, there is no relation between L andP. • When L is betw

Give detail explanation about the inflation, Give detail explanation about ...

Give detail explanation about the Inflation Price index is computed at a particular point in time, inflation over a time period, mainly one year Inflation may just as

Ricardian model, a) There is a general trade, and sometimes prominent as in...

a) There is a general trade, and sometimes prominent as in case of UK, Canada, and Europe. When the tariff rates are showing an upward trend, the trade/GDP ratio is either declinin

Aggregate demand curve slopes downward, Which of the following is a reason ...

Which of the following is a reason why the aggregate demand curve slopes downward? a. At a higher price level, fewer goods and services are available. b. Periods when the price lev

Price of its cabernet sauvignon, When Sonoma Vineyards reduces the price of...

When Sonoma Vineyards reduces the price of its Cabernet Sauvignon from $15 a bottle to $12 a bottle, the result is an increase in a. the demand for this wine b. the supply of

Measurement of national income, what are the two precautions required while...

what are the two precautions required while estimating national income by value added method?

Nominal interest rate and expected inflation, Q. Nominal interest rate and ...

Q. Nominal interest rate and expected inflation? When we have inflation, we can't, of course, presume that expected inflation is zero. So real interest rate will no longer be e

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