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

Granger causality, With the aim of this project to observe the impact of oi...

With the aim of this project to observe the impact of oil price shocks on macroeconomic indicators, testing for causality between these variables will establish whether or not, oil

International trade, How can a country maintain equilibrium GDP with foreig...

How can a country maintain equilibrium GDP with foreign trade?

Explain about monetary base, Q. Explain about Monetary base? Monetary b...

Q. Explain about Monetary base? Monetary base is defined as the total value of all currency (coins andbanknotes) outside the central bank and commercial banks' (net) reserves w

Elucidate raising the price profitable., George has been selling 5,000 T-sh...

George has been selling 5,000 T-shirts per month for $8.50. When he increased the price t0 $9.50 he sold only 4,000 T-shirts. What is the demand elasticity? If his marginal cost is

Estimating womens labor supply, 1.    Estimating Women's Labor Supply a....

1.    Estimating Women's Labor Supply a.    The following regression was run for an estimate of the current women's labor supply curve: Where h i = hours of labor suppl

Calculate the kernel estimator and plot histograms, We will look now at cha...

We will look now at changes in the income distribution of Canadians between 1991 and 2001. Use the census data for these years provided in the course web page. Download that data i

How do reductions in government spending affect the economy, Usually the go...

Usually the government is very good at wasting money and resources so less spending, by the government helps the economy as those resources are allocated in areas that are more wel

Price of dvd players decreases, If the price of DVD players decreases, we c...

If the price of DVD players decreases, we can expect that the demand for DVDs will: a. increase. b. be unaffected. c. shift left. d. Decrease

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