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

Employment, the production of 200 units of consumer goods and 300 units of ...

the production of 200 units of consumer goods and 300 units of capital goods : a) indicates full employment b) may be a result of unemployment c) may be impossible for now d)

Create a graph showing average wages, For this question you will use the da...

For this question you will use the dataset "march01.dat", which includes wages (column 1), age (column 2), a dummy variable indicating females (column 3), and years of education (c

Determine the term - hot money, Determine the term - hot money A large ...

Determine the term - hot money A large 'hot money' inflow shifts the demand curve for currency to the right, leading to exchange rate rising and to an overvalued exchange rate

Gross domestic product, In 1 to 2 sentences respond to the following commen...

In 1 to 2 sentences respond to the following comment. "Cleaning your own house is not counted in gross domestic product because it does not represent economic production."

Codinal theory - consumer choice concernin utility, Ordinal Theory: A...

Ordinal Theory: A Short Note In ordinal approach, utility is measured ordinally i.e., qualitatively (not numerically or quantitatively). Alternatively, consumer can rank her

Inflation unemployment trade off under adaptive expectations, Explain how i...

Explain how inflation unemployment trade off is not feasible under adaptive expectations?

Medical goods or services, For which of the following medical goods or serv...

For which of the following medical goods or services is the income elasticity of demand largest? a. emergency services after a car accident b. measles shots c. physical ex

Public economics., Critically examine the statement that privatization can ...

Critically examine the statement that privatization can always decentralize economic power.

HOMEWORK, How do you figure out the answer to this question: You are a stud...

How do you figure out the answer to this question: You are a student at a university. You pay $8,000 per year in tuition, $5,000 per year in living expenses, and $1,000 per year fo

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