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

Baumol model, what is the role of advertising in baumol''s model?

what is the role of advertising in baumol''s model?

Give a brief description of the transmission mechanism, Give a brief descri...

Give a brief description of the transmission mechanism 1. When the central bank target rate increases, other interest rates in the economy will increase (and the money supply

Trade-off between equity and efficiency, Explain the trade-off between equi...

Explain the trade-off between equity and efficiency. Identify how individuals and organizations are likely to change their behavior as a result of government actions.

Keynesian cross in an open economy, why does the price level not enter desi...

why does the price level not enter desire consumption, investment and net exports of the desired aggregate expenditure function in the keynesian cross model

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?

Null and alternative hypothesis, To determine whether high blood pressure a...

To determine whether high blood pressure affected whether a person had a stroke, a sample of 300 people who had had strokes are examined. In the sample, 37% had high blood pressure

Labor supply and labor demand in the keynesian model, Supply of labor, L S ...

Supply of labor, L S (W/P), depends positively on real wages in classical model. It isn't always clear which individuals are included in the labor supply. Labor supply may consist

Differentiate between nominal rate and real interest rates, Differentiate b...

Differentiate between Nominal rate and real interest rates To distinguish the real interest rate from the "normal" interest rate, the latter is called the nominal interest rate

The circular flow of income in an open economy, The circular flow of income...

The circular flow of income in an open economy   An open economy is one in which international trade exists. Assume also that there is government spending and taxation. Thus

What is demand for money, Q. What is Demand for money? Demand for mone...

Q. What is Demand for money? Demand for money The demand for money depends negatively on R and positively on the Yin the IS-LM model As fo

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