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

Describe supply and demand in macroeconomics, Q. Describe Supply and demand...

Q. Describe Supply and demand in macroeconomics? In microeconomics, we are careful to distinguish between demand, supply and observed quantity. The first two are hypothetical c

Assignment, Ask question #MinDerive the isoprofit function ?imum 100 words...

Ask question #MinDerive the isoprofit function ?imum 100 words accepted#

Find out reserve-deposit ratio and currency-deposit ratio , 1.  Assume the ...

1.  Assume the required reserve-deposit ratio is 12%, and the currency-deposit ratio is 38%. How much would money supply change if the Fed made open market purchases of $100 millio

Components of trade policy, COMPONENTS OF TRADE POLICY: External secto...

COMPONENTS OF TRADE POLICY: External sector reforms beginning with 1991 included dismantling of  trade restrictions along with tariff rationalization, a move towards current a

How to calculate participation rate., 7 people have jobs, 3 want to work bu...

7 people have jobs, 3 want to work but are not, and there are 20 adults. What is the participation rate?

Money supply, does central bank determine money supply in the economy

does central bank determine money supply in the economy

Balance of payments, factors that causes the shifts in balance of payments...

factors that causes the shifts in balance of payments

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

Describe in detail about exchange rate systems, Describe in detail about Ex...

Describe in detail about Exchange rate systems Various countries have different exchange rate systems. The most significant characteristic of an exchange rate system is to what

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