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

Kinked demand curve, disuss with an aid of a diagram the kinked demand cur...

disuss with an aid of a diagram the kinked demand curve

Purposes economists disagree and using models of economics, Explain the pur...

Explain the purposes economists disagree and using models of economics. Using Models of Economics: a. Positive economics b. Normative economics A forecast is an easy p

Real exchange rates, Real Exchange Rates (EXCH) is the next variable that w...

Real Exchange Rates (EXCH) is the next variable that will be analysed in this VAR. The reason for including exchange rates in the VAR is that they are an important channel through

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

Evaluating legal prices, Evaluating Legal Prices: Collect information regar...

Evaluating Legal Prices: Collect information regarding the minimum wage. State the procedure of this legal price, assess its impact on the market for labor, and evaluate the extent

How much money can banks create, How much money can banks create? Does...

How much money can banks create? Does this mean that banks can create an unlimited amount of money? The answer is no - that would require them to lend an unlimited amount of m

Marginal propensity to consume mpc, Marginal Propensity to consume or known...

Marginal Propensity to consume or known as  (MPC)  relates to a change in net or total consumption expenditure to a change in the total disposable income. Symbolically it is writt

Gold standard after world war i, Did Germany ever go back on the Gold Stand...

Did Germany ever go back on the Gold Standard after World War I and prior to World War II? If so, what were the economic and political effects of doing so? I know it was on the Gol

International trade, Suppose home cost pricing prevails in international tr...

Suppose home cost pricing prevails in international trade, while world output is declining. Consider two economies, A and B, both having floating exchange rates and the same moneta

Cobb-douglas production function, Consider an economy characterized by the ...

Consider an economy characterized by the following Cobb-Douglas production function: Y=4K 1/4 L 3/4 Where K and L represent physical capitaland labor, respectively. Assume t

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