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

Assigment question, Ask question #Minimum 100 wordsThe following is the inf...

Ask question #Minimum 100 wordsThe following is the information from the national income accounts for a hypothetical country: GDP

What do you mean by capital flows, Q. What do you mean by Capital Flows? ...

Q. What do you mean by Capital Flows? With free capital flows, this is a very unreasonable assumption. If we domestic interest rate increase against the foreign interest rates,

Differentiate between actual and potential output, Differentiate between Ac...

Differentiate between Actual and Potential output.  Actual output is that level which economy in fact produces. In contrast, potential output is the aggregate capacity output o

find the nash equilibria for all possible parameter, Two animals are fight...

Two animals are fighting over a prey. The prey is worth v to each animal. The cost of fighting is c1 for the first animal (player 1) and c2 for the second animal (player 2). If the

Outline two main restrictions by indian government applied t, outline two m...

outline two main restrictions by indian government applied to import. Using the data from your case study analyse and explain who would benefit directly and who would lose directly

Price elasticity of demand, has determined that the price elasticity of dem...

has determined that the price elasticity of demand for two customer segments (Coach and Business Class) is -1.35 and -2.50. Based on their expectations of profitability, Kashian r

Three independent variables, In a regression analysis, three independent va...

In a regression analysis, three independent variables are used in the equation based on a sample of forty observations. What are the degrees of freedom associated with the F-statis

Post-keynesian macroeconomics -rational expectations school, Rational Expec...

Rational Expectations School Expectations on the future values of economic variables play an important role in macroeconomic analysis and economic analysis in general. Because

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

Trade policy - summary, TRADE policy: We are now in a position to sum ...

TRADE policy: We are now in a position to sum up our analysis of India's trade policy. First, India's trade policy has always been very intricately related to India's basic de

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