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

Illustrate biological effects of patulin, Q. Illustrate biological effects ...

Q. Illustrate biological effects of Patulin? Biological activity: Patulin has an acute oral LD 50 in rodents of about 30-50 mg/kg and has been shown to be teratogenic, immunot

When patulin molds can occur, Occurrence: It is found in a range of foods b...

Occurrence: It is found in a range of foods based on fruits. Presence of patulin in fruit juice is a indication that the juice was extracted from poor quality fruit which is undesi

Marginal propensity, Marginal propensity to SPEND refers to: a. a nation's ...

Marginal propensity to SPEND refers to: a. a nation's additional spending on a good per an additional unit of expenditure. b. a nation's additional consumption based on a unit incr

Average price of a textbook, The demand for textbooks is Q=200-P+25U-50Pbee...

The demand for textbooks is Q=200-P+25U-50Pbeer. Assume that the unemployment rate U is 8 and the price of beer P beer is $2. When the average price of a textbook is P=$100, the el

Cost benefit analysis-vat, (1) Based on the article, describe as best you c...

(1) Based on the article, describe as best you can: (i) the reference group for the cost benefit analysis, (ii) the purpose of the study (i.e., what is the "project" in this

The money supply and the interest rate, Another area where monetarists diff...

Another area where monetarists differ from Keynesians is money supply and interest rates. In the Keynesian analysis with less than full employment level equilibrium, the interest r

Exam, real gdp measures?

real gdp measures?

Other bankers and wall street firms, Some charge that the Crisis of 2008 wa...

Some charge that the Crisis of 2008 was caused by the "greed" of Wall Street firms and other bankers. Do you agree with this view? Do you think there was more greed on Wall Street

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