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

Description of inflation in detail, Description of Inflation in detail ...

Description of Inflation in detail Inflation is the rate at which average price level of services and goods rises in a given time period. In UK the Office for National Statist

What is money supply, What is Money supply The monetary base is only a ...

What is Money supply The monetary base is only a small part of the total money supply but, through the multiplier effect, the central bank's control over the money supply is ma

Macroeconomics policy, explanations to the short-run fluctuation and pilicy...

explanations to the short-run fluctuation and pilicy prescriptions of the schools macroeconomics thought

Define the multiplier and rate of inflation, 1 (a) List two concerns with i...

1 (a) List two concerns with inflation. (b) Suppose that we are in a condition of fully flexible prices, but production of nails will not go above 200 chairs/month. What price w

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.

Describe the goods in the circular flow, Goods in the circular flow ...

Goods in the circular flow If Y R is total value of all goods going from F R to F H , then total value added from all firms in the F R box is equal to Y R (they don't pu

DSGE model, I need to run DSGE model of one published paper of another auth...

I need to run DSGE model of one published paper of another author. Just I would like to request to run that paper using MATLAB(Dynare). And send me the dynare code.m 100 words acce

Firms use crowd sourcing technique, Thread less is an example of a firm bui...

Thread less is an example of a firm building on its customer base to use new products and also to participate in the design and vetting of popular designs. In the summer of 2010, D

Difference between accounting profit and economic profit, What is the diffe...

What is the difference between accounting profit and economic profit? Accounting Profit: The accounting profit of a business is the revenue of business minus the explicit

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