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

Unemployment, Suppose that between January 2011 and January 2012 the total ...

Suppose that between January 2011 and January 2012 the total number of people employed and the unemployment rate both fell. Briefly explain how this is possible. [2 marks]

#GDP, #“Nominal GDP declined between 2008 and 2009, therefore the GDP defla...

#“Nominal GDP declined between 2008 and 2009, therefore the GDP deflator must also have declined.”

Graph, Maximum profits will occur at the output level where is the greatest...

Maximum profits will occur at the output level where is the greatest vertical distance between Total Revenue(TR) AND Total Cost(TC. uSE THE TOTAL REVENUE-TOTAL COST CURVES TO Illus

Describe about capital, Q. Describe about Capital? By capital we charac...

Q. Describe about Capital? By capital we characteristically mean manufactured goods which are used to produce other services and goods though aren't used up in the production p

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.

Controlling the supply of money, When the reserve requirement changes, whic...

When the reserve requirement changes, which of the following will change in the total banking system?  (Answer change or No Change) Transaction Deposits Total Reserves Req

Are credit cards, It is sometimes asked whether credit cards are money sinc...

It is sometimes asked whether credit cards are money since many purchases are made using these. Credit cards are a means of obtaining credit and using this to finance expenditure,

National income, what are the advantages and disadvantages of a national in...

what are the advantages and disadvantages of a national income and green GDP? national income figures are often used to compare living standards across countries and through time.

Determine modified accelerated cost recovery system, Suppose new instrument...

Suppose new instruments for a firm cost $18,000 along with an additional installation fee of $2,000, both of that are depreciable. Complete the depreciation schedule display below

Construction of real gross domestic product, Q. Construction of real gross ...

Q. Construction of real gross domestic product ? To be able to make reasonable comparisons of GDP over time, we should adjust for inflation. For instance, if prices are doubled

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