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

Business cycletories, list of all theories of business cycle theories

list of all theories of business cycle theories

Give brief explanation about the labour market, Introduction of labour mark...

Introduction of labour market A vital macroeconomic variable is the total amount of labor which is used in a certain time period. Amount of labor and amount of capital are sig

International trade, why is international trade important south africa

why is international trade important south africa

Opportunity costs associated, The opportunity costs associated with the use...

The opportunity costs associated with the use of resources owned by a firm are: a. externalities b. implicit costs c. explicit costs d. sunk costs

Phillips curve in lowland, The Phillips curve in Lowland takes the form of ...

The Phillips curve in Lowland takes the form of ? = 0.04 - 0.5 (u - 0.05), where ? is the actual inflation rate and u is the unemployment rate. The Phillips curve in Highland takes

Fiscal policy, Fiscal Policy An Increase in Government Spending: Fi...

Fiscal Policy An Increase in Government Spending: Figure 1 Let us examine how an increase in government spending affects the interest rate and the level of income.

Elucidate the factors of global demand and supply, Many economists and mark...

Many economists and market analysts are avid followers of the BALTIC DRY INDEX (BDI) as a forward looking mechanism that may shed a bit of light on the evolution of global economic

Illusrtate the equilibrium point, QXd = 14 - (1/2)PX and QXs = (1/4)PX - 1 ...

QXd = 14 - (1/2)PX and QXs = (1/4)PX - 1 Instructions: Round your answers to the nearest whole number. a. Determine the equilibrium price and quantity. Show the equilibrium g

Money market with inflation and constant money supply growth, Q. Money mark...

Q. Money market with inflation and constant money supply growth? If π M = π and π e = π, both IS- and LM-curve will be fixed.  Figure: The money market with inflatio

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