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

International trade, Suppose home cost pricing prevails in international tr...

Suppose home cost pricing prevails in international trade, while world output is declining. Consider two economies, A and B, both having floating exchange rates and the same moneta

Impact of property crime to increase, Which of the following will cause pro...

Which of the following will cause property crime to increase? a) An increase in jail terms. b) A decrease in personal incomes. c) An increase in the probability of arrest.

Quantity theory of money, what is the importance of the quantity theory of ...

what is the importance of the quantity theory of money

Define the term- inflation, Define the term- inflation Inflation betwee...

Define the term- inflation Inflation between two points in time is defined as the percentage increase of price index between these two points in time.

Industry''s long-run supply schedule, A perfectly competitive painted neckt...

A perfectly competitive painted necktie industry has a large number of potential entrants. Each firm has an identical cost structure such that long-run average cost is minimized at

To make economic profits in the long term, Jessica Alba, a famous actress, ...

Jessica Alba, a famous actress, starts the baby and family products business, The Honest Company, with Christopher Gavigan. Alba and Gavigan set up their site so families can choos

Show the adjustment process to new equilibrium using graph, Consider the mu...

Consider the multiplier model we have studied in class. Assume that the economy is initially in equilibrium and that real income is $180. The marginal propensity to expend is 0.66.

Decrease the nominal deficit, Which of the following will decrease the nomi...

Which of the following will decrease the nominal deficit? A. An increase in taxes. B. An increase in the debt. C. An increase in government expenditures. D. An increase in interest

Rice production is land intensive, If rice production is land intensive and...

If rice production is land intensive and computer production is labor intensive, though both good require some land and labor, the two-good production possibilities frontier will c

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