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

Inflation, Inflation (RPI) - another imperative channel. Oil is a necessity...

Inflation (RPI) - another imperative channel. Oil is a necessity for the UK, and is price inelastic therefore one can analyse the correlation between a price shock and inflation. I

Neo-Keynesian Synthesis, how would you describe a neo-keynesian (or neoclas...

how would you describe a neo-keynesian (or neoclassical) synthesis? and why did Joan Robinson label it "bastard Keynesian"

Derive the complex amplitude of the double convex lens, Derive that the com...

Derive that the complex amplitude of the double convex lens shown in the image below with focal length 1/f = (n-1 ) (1/R 1 - 1/R 2 ). Hint: we derived an plano convex lens in cla

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

Determine the velocity of circulation, The demand for nominal balances rise...

The demand for nominal balances rises with the price level. At the similar time inflation causes the real demand for money to fall. Describe how these two assertions can be both co

Marginal, using the marginal utility theory explain the consumption patten ...

using the marginal utility theory explain the consumption patten of consumers

Imperfect-information model, According to the imperfect-information model, ...

According to the imperfect-information model, when the price level is greater than the expected price level, output will _____ the natural level of output A) be greater than

Budget constraint, The consumer's utility function is u(x1,x2) = (x1) (x2)^...

The consumer's utility function is u(x1,x2) = (x1) (x2)^2 (a) Graph his budget constraint for p1 = 3, p2 = 2 and M = 900, and write down the equation for his budget line. (b)

Assignment, explain the profit maximizing/loss minimizing rule may be appli...

explain the profit maximizing/loss minimizing rule may be applied under the 3 scenarios

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