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

Open market policy, describe how open market policy can be used to stimulat...

describe how open market policy can be used to stimulate economic activity in the country

Econ, Christina Romer and Jared Bernstein in "The Job Impact of the America...

Christina Romer and Jared Bernstein in "The Job Impact of the American Recovery and Reinvestment Plan" calibrated the impact of the proposed expansionary fiscal policy (we know it

Circular flow of income, Explain a circular flow of income in a frugal econ...

Explain a circular flow of income in a frugal econmomy with diagram

Explain about nominal wage level, Q. Explain about Nominal wage level? ...

Q. Explain about Nominal wage level? In macroeconomics, we are usually not interested in the wage for a specific individual though in the average wage for all employed individu

Explain different levels of a hypothetic, Suppose that a public park is vis...

Suppose that a public park is visited by people living in five concentric zones around the park. Each zone has a population of 5000, and the total travel cost for a visit to the pa

Liberalisation and changing sectoral composition of fdi, Liberalisation and...

Liberalisation and Changing Sectoral Composition of FDI: The latest is the ICT wave that has influenced the global shift in service industries the most. Therefore, these  flow

Change in the level of real gdp, Assume that government purchases decrease ...

Assume that government purchases decrease by $10 billion, with other factors held constant, including the price level. Calculate the change in the level of real GDP demanded for ea

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