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

Steps to real wage rates to fall, Steps to real wage rates to fall Wage...

Steps to real wage rates to fall Wage 'stickiness' or wage inflexibility may stop the real wage rate falling to the full-employment wage rate. Stickiness or inflexibility is ca

How price level rises differ from price rises, How price level rises differ...

How price level rises differ from price rises In macroeconomics, it's common to use term "prices" or "price" as short for price level. Expression "prices rise" must be interpre

GDP and GNP, y explain whether you agree or disagree with the following sta...

y explain whether you agree or disagree with the following statements. “If nominal GDP is less than real GDP, then the price level must have fallen during the year.”

Illustrate the problem for economic performance, Illustrate the problem for...

Illustrate the problem for UK economic performance This is a foremost problem for UK economic performance and helps elucidate the persistent deficit on the current account of

Find the npv and the irr determine cash flows, The Research and Development...

The Research and Development Division of your company has just developed a new gaming system called the Zed Box.  The R&D Division spent $800,000 developing this product and the Ma

Production possibilities, you and your neighbor (n) consume without trading...

you and your neighbor (n) consume without trading. suppose you are initially consuming 7 bananas and 3 coconuts and your neighbor is initially consuming 6 bananas and8 coconuts. Yo

What is gross national income per capita, What is gross national income per...

What is gross national income per capita The absolute difference in gross national income per capita is 29,828 PPP$ that means UK income per capita is approximately 860% higher

Steady state in solow model, conditions for steady state in solow model.in ...

conditions for steady state in solow model.in what respects is golden rule different from steady state?

Estimate efficient outcome, The city of Johnstown decides to build a new st...

The city of Johnstown decides to build a new stadium to attract a basketball team from the city of Rosendale.  One economic advisor suggests that the stadium should be fi

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