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

AD, in the keynesian cross assume that the consumption function is given by...

in the keynesian cross assume that the consumption function is given by c=200+0.75(y-t). given planned investment is 100, government purchases and taxes are both 100. then what i

Economic system is the best solution, Which economic system is the best sol...

Which economic system is the best solution to handling a crisis of epic proportion?

Interest rates, what is real and norminal interest rates?

what is real and norminal interest rates?

Objective of empirically analyses, The aim of this paper is to observe and ...

The aim of this paper is to observe and interpret the correlations between oil price changes, and changes to key macroeconomic indicators. From this we will be able to observe if t

Consumption function of an economy, The consumption function of an economy ...

The consumption function of an economy is given by c = 200+0.75(y-t) And the investment function by I = 200 = - 25r. Government purchases G and taxes Τ are both 100.  T

Describe the concept of economies of scale, Question: Using diagrams wh...

Question: Using diagrams where appropriate, describe the concepts of scarcity, choice and opportunity cost. Distinguish between negative and positive externalities, explain

What is average cost in the producing output, What is average cost in the p...

What is average cost in the producing output? Average total cost , frequently considered as to simply average cost, is sum of total cost divided through quantity of output gen

Describe wage and employment for healthcare workers, Analyze how a model of...

Analyze how a model of the labor market can be used to explain wage and employment for healthcare workers.

What is the real interest rate, The real interest rate Interest rates ...

The real interest rate Interest rates and inflation Suppose you have 1 million on 1st January 2008. A basket of goods and services similar to the CPI basket costs 100,000.

what is gdp in this economy, I. Consider the following static optimization...

I. Consider the following static optimization problem. Suppose that a consumer has financial wealth W and owns the house H¯ . She has utility over housing H and nonhousing co

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