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

New equilibrium price and equilibrium quantity, If demand increases and the...

If demand increases and the supply increases also, then what will happen to the new equilibrium price and equilibrium quantity? Explain what is happening with the curves and how pr

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

GDP, Calculate the marginal cost and marginal analysis for the following ta...

Calculate the marginal cost and marginal analysis for the following table. Calculate the answers and insert them into the shaded cells. Units Produces Cost per Unit Total Cost Ma

Macroeconomic variables, Furthermore it can be seen that there are interest...

Furthermore it can be seen that there are interesting relationships between the remaining variables. Firstly, at the 95% significance level it can be seen that interest rates Grang

Considering two types of water heaters, A company is considering two types ...

A company is considering two types of water heaters. The associated costs are shown below. The estimated annual cost of operation for oil heaters equals 365 x 41045/EF x Fuel Cost

Determine aggregate supply curve is vertical or not, Explain whether the fo...

Explain whether the following statements are true or false: a) The long run aggregate supply curve is vertical because economic forces do not affect long run aggregate supply.

Financial and real investment, Financial and Real Investment Financial ...

Financial and Real Investment Financial investment simply means transfer of right from one party to another. While one party has made investment, the other has made disinvestme

Income and substitution effects of a price change, Income and Substitution ...

Income and Substitution Effects of a Price Change Indifference curve analysis can be used to separate the income effect (IE) from substitution effect (SE). This is shown in Fig

Determine the main target of monetary policy, Determine the main target of ...

Determine the main target of monetary policy Since 1997 'official' main target of monetary policy has been to 'hit' inflation rate target set by government. Though since the o

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