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

Introduction of Macroeconomics, Macroeconomics We have explained severa...

Macroeconomics We have explained several concepts and Macroeconomic Aggregates which form the basic terminology of macroeconomic analysis. Like other empirical sciences, econom

Is-lm model, what is Y = C(Y,T) + G + I(r)

what is Y = C(Y,T) + G + I(r)

What causes economic growth, What causes economic growth? Causes of ec...

What causes economic growth? Causes of economic growth: Into the Solow model, economic growth is based onto the quantity and quality of technology and resources. Growth

Alternatives type of production, Production Alternatives Type of production...

Production Alternatives Type of production A B C D E Automobiles 0 2 4 6 8 Forklifts 30 27 21 12 0 If the economy is at point C, what is the (opportunity) cost of 2 more automobile

Relative cost-effectiveness, Stephanie Robbins is the Three Hills Power Com...

Stephanie Robbins is the Three Hills Power Company management analyst assigned to simulate maintenance costs. In Section 14.6 we describe the simulation of 15 generator breakdowns

What is the basic function of central banks, Q. What is the basic function ...

Q. What is the basic function of Central banks? A central bank is a public authority which is responsible for monetary policy for a country or a group of countries. Two signifi

Supply curve goes through the point, If a supply curve goes through the poi...

If a supply curve goes through the point P = $10 and Qs = 320, then a. $10 is the highest price that will induce firms to supply 320 units b. $10 is the lowest price that wil

Two-way anova., A scientist has been studying the organisms colonising the ...

A scientist has been studying the organisms colonising the pilings underneath a wharf in Sydney Harbour. He postulates two factors might make these communities of sponges, worms, a

Macroeconomic variables, Furthermore it can be seen that there are interest...

Furthermore it can be seen that there are interesting relationships between the remaining variables. Firstly, at the 95% significance level it can be seen that interest rates Grang

Capital output ratio, Ask question #impotance of capital output ratio#

Ask question #impotance of capital output ratio#

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