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

Explain the labor market in the cross model, Q. Explain the labor market in...

Q. Explain the labor market in the cross model? In cross model, both P and W are exogenous andconstant. Hence real wage is constant and it is not essentially equal to the equil

Robert''s new way vacuum cleane, Robert's New Way Vacuum Cleaner Company is...

Robert's New Way Vacuum Cleaner Company is a newly started small business that produces vacuum cleaners and belongs to a monopolistically competitive market. Its demand curve for t

Explain the classical motivation, Q. Explain the classical motivation? ...

Q. Explain the classical motivation? The classical motivation: Consumers want to smooth their consumption over time. In good times, consumers know that it is a temporary stat

National income, briefly explain any five uses of national income statistic...

briefly explain any five uses of national income statistics

Keynesian, critically examine the keynesian theory of unemployment

critically examine the keynesian theory of unemployment

Fiscal Policy, When is a balanced budget presented?

When is a balanced budget presented?

How do countries grow economic growth, How do countries grow Economic growt...

How do countries grow Economic growth? Economic growth is attaining by increasing: • Quantity of resources by investment • Quality of resources by training as well as R

GDP, Calculate the marginal cost and marginal analysis for the following ta...

Calculate the marginal cost and marginal analysis for the following table. Calculate the answers and insert them into the shaded cells. Units Produces Cost per Unit Total Cost Ma

Mutual funds into stock also funds from money market, How would the followi...

How would the following influence the growth rates of theM1 and M2 money supply figures over time? a. an increase in the quantity of U.S. currency held overseas b. a shift of f

Utility level and indifference curves, Consider the utility function u(x1, ...

Consider the utility function u(x1, x2) = x1x2. (a) Graph the indifference curves for utility levels 1 and 2. (They are symmetric hyperbolas Asymptotic to both axes). (b) Graph the

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