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

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

What is the macroeconomic policy, Macroeconomic policy Macroeconomic p...

Macroeconomic policy Macroeconomic policy trade-offs are likely along the short-run Phillips curve however are not maintainable in the long run. In the short run a government

Balance of payments, factors that causes the shifts in balance of payments...

factors that causes the shifts in balance of payments

Project topics, i want a project topics in macroeconomics

i want a project topics in macroeconomics

Modern theory of rent, Explain modern theory of rent eith diagrams and defi...

Explain modern theory of rent eith diagrams and defination

Commercial transactions in blood from the egoistic, Examine the pros and co...

Examine the pros and cons of commercial transactions in blood from the egoistic, the utilitarian, and the Kantian perspectives.

How do countries grow economic growth, How do countries grow Economic growt...

How do countries grow Economic growth? Economic growth is attaining by increasing: • Quantity of resources by investment • Quality of resources by training as well as R

The model building, THE MODEL BUILDING    A model of individual or a...

THE MODEL BUILDING    A model of individual or aggregate economic phenomena represents a simplification of real world economic complexities. It may be expressed in words, ta

Labor force participation rate, The following Table B presents the 2010 pop...

The following Table B presents the 2010 population, employment, and unemployment data among working age persons for several countries. a. Calculate the number of people in the l

Percentage did the price level, By what percentage did the price level, as ...

By what percentage did the price level, as measured by this index, rise between 1984 and 2005?

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