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

State about the United States government bonds, State about the unitesd sta...

State about the unitesd state government bonds In most countries, you find government bonds with longer maturity. For example, in the United States you have Treasury notes (two

Explain the money market diagram, Q. Explain the Money market diagram? ...

Q. Explain the Money market diagram? Let's begin by studying the money market when GDP is given. When Y is given, MD will only rely (negatively) on R and we can draw a figure w

What is the value of the swap in terms of both bonds and fra, Suppose that ...

Suppose that the yield curve is flat at 5% per annum with continuous compounding. A swap with a notional principal of $100 million in which 6% is received and six-month LIBOR is pa

Clasical model., if we impose any rule and regulation on clasical model lik...

if we impose any rule and regulation on clasical model like not expoit polutionso what is effect on factor of clasical model

Overnight rates and interest rates with longer maturity, Q. Overnight rates...

Q. Overnight rates and interest rates with longer maturity? By controlling overnight interest rates, central bank will affect interest rates with longer maturity. Main reason f

Concept of growth and growth rate, The Concept of Growth and Growth Rate is...

The Concept of Growth and Growth Rate is explained below: Economic growth is rise in an economy’s level of the production of commodities, output or income. We can talk about th

Feds actions on gdp impact, Suppose the banking system has reserves of $750...

Suppose the banking system has reserves of $750,000, demand deposits of $2,500,000 and a reserve requirement of 20%. a) If the Fed now purchases $125,000 worth of government bon

Is-lm approach, with help of is-lm technique explain the process of integra...

with help of is-lm technique explain the process of integration of money market and goods market by way of keynesian approach

Explain reversed say''s law, Q. Explain Reversed Say's Law? In the cros...

Q. Explain Reversed Say's Law? In the cross model, supply should instead follow demand. Cross model not only rejects Say's Law, it turns it entirely upside down. In the cross m

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