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

Credit, How credit is created or the creation of credit

How credit is created or the creation of credit

How much money can banks create, How much money can banks create? Does...

How much money can banks create? Does this mean that banks can create an unlimited amount of money? The answer is no - that would require them to lend an unlimited amount of m

Pros and cons of var, Since their inception, VAR models have been at the ce...

Since their inception, VAR models have been at the centre of many controversies associated with econometric modelling. The recurring criticism throughout history is due to the mode

The government - rest of the world and the financial markets, The Governmen...

The Government, Rest of the World and the financial markets total expenditure of government can be divided into two parts: transfers to private sector and consumption.

The circular flow of income in a closed economy, The circular flow of incom...

The circular flow of income in a closed economy   A closed economy exists when there is no international trade. We shall also assume that in this particular closed economy there

What is money has nothing to do with token itself, What is money has nothin...

What is money has nothing to do with token We also consider that what is money has nothing to do with token or commodity itself: USD is money in United States but not in

Long run imports will most likely be paid, In the long run, imports will mo...

In the long run, imports will most likely be paid for with: a. Aexports. b. The sale of real and financial assets. c. the extension of credit. d. higher domestic unempl

How to calculate rate of interest, Assume a sudden collapse in the stock ex...

Assume a sudden collapse in the stock exchange of an economy is expected to reduce the future profitability of the firms of the economy. Construct loanable funds market in a c

Illustrate biological effects of ochratoxin, Q. Illustrate Biological effec...

Q. Illustrate Biological effects of Ochratoxin? Biological effects: It is associated with the chronic progressive kidney disease in humans known as Balkan endemic nephropathy.

Components of gdp, Write a 4-5 page paper, double-spaced, Arial 12pt font, ...

Write a 4-5 page paper, double-spaced, Arial 12pt font, 1 inch margins all around (top, bottom, left, and right) that addresses the following news event summarized below In a to

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