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

State the marginal productivity theory, Q. State the Marginal Productivity ...

Q. State the Marginal Productivity Theory. What are its features and assumption? Marginal Productivity Theory of distribution states that in a capitalist economy the demand for

What is modifications to a polymer, What are three modifications to a polym...

What are three modifications to a polymer that can make it transparent? How will these modifications affect the mechanical properties of the polymer?

Medium run adjustment - economy adjustment, Suppose the economy is currentl...

Suppose the economy is currently in recession, and the exchange rate if fixed using the IS-LM model. a) Explain and illustrate the economy adjustment (in the medium run) b) E

Price, The prices of fresh fruits have risen recently in the Jackson area. ...

The prices of fresh fruits have risen recently in the Jackson area. Why would this have occurred? Explain.

Unemployment, what is okun''s law ? In economics study, Okun's law also nam...

what is okun''s law ? In economics study, Okun's law also named after Arthur Melvin Okun is an empirically observed relationship relating among unemployment to losses in a specific

Summary of the cross model, Summary of the cross model The below list...

Summary of the cross model The below list summarizes the cross model and associates it to classical model:  Labor Market: Real wages W/P is exogenous in cross model

Fixed unemployment, Is the natural rate of unemployment fixed? Why or why n...

Is the natural rate of unemployment fixed? Why or why not? How are full employment and the natural rate of unemployment related? Is the actual rate of unemployment currently greate

Draw the demand curve, The total demand (marginal benefit) curve for visiti...

The total demand (marginal benefit) curve for visiting the Great Barrier Reef is as follows: Price = 5000+100*Fish Biomass (tons per square mile) -10*Number of Trips. a. Does th

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?

Fiscal restraint is required, If the AD excess is $300 billion and the MPC ...

If the AD excess is $300 billion and the MPC is 0.8 how much fiscal restraint is required? What does the "debt held by the public" mean?

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