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

Determination of all the endogenous variables, Q. Determination of all the ...

Q. Determination of all the endogenous variables? Determination of all the endogenous variables in the AS-AD model Determination of P and Y: Prices and

Classical model, using a graph of the classical labour market, illustrate t...

using a graph of the classical labour market, illustrate the effects of a real wage existing in the market that is lower than the equilibruim real wage.what will eventually happen

Federal income tax be changed to a flat tax, Take a position on the followi...

Take a position on the following economic issue in the "yes" or "no" selection, support your position with economic theory and critical thinking skills. ISSUE: Should the Feder

Difference between sampling error and standard error, Which is not true of ...

Which is not true of the difference between sampling error and standard error? a. Standard error is a difference from the population. b. Sampling error can't usually be calcula

Balance of payments, state and explain two factors that cause the shifts in...

state and explain two factors that cause the shifts in the balance of payments curve.

The circular flow of income in a closed economy, The circular flow of incom...

The circular flow of income in a closed economy   A closed economy exists when there is no international trade. We shall also assume that in this particular closed economy there

Production required to produce rice, In the heckscherohlin model, a decreas...

In the heckscherohlin model, a decrease in the factors of production required to produce rice and beans would: a. shift the production possibilities frontier for rice and beans

When patulin molds can occur, Occurrence: It is found in a range of foods b...

Occurrence: It is found in a range of foods based on fruits. Presence of patulin in fruit juice is a indication that the juice was extracted from poor quality fruit which is undesi

Inflation, inflation of fuel price on consumer

inflation of fuel price on consumer

Economic analysistenets of tenets, One of the main tenets of economic analy...

One of the main tenets of economic analysis is that people act in their own narrow interests. Why, then, do people leave tips in restaurants? If a study were to compare the size of

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