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

Negative performances of the economy, An advantage of observing statistics ...

An advantage of observing statistics from this range is that it encapsulates both positive and negative performances of the economy helping to produce a much more accurate insight

Market structure, Ask question #Minimum 100 words accepWith aid of evidence...

Ask question #Minimum 100 words accepWith aid of evidence in the given article, comprehensively discuss the market structure in the South African mobile telecommunications industry

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

Relationship between oil prices and economic, It was observed that followin...

It was observed that following a one standard deviation shock to the price of oil, interest rates rose sharply immediately afterwards reaching a maximum after two quarters. Then fr

Decision maker''s approach or logic, Listed here are several examples of ba...

Listed here are several examples of bad, or at least questionable, decisions. Evaluate the decision maker's approach or logic. In which of the six decision steps might the decision

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

what is the importance of the quantity theory of money

Process to control inflation rate, Process to control inflation rate Th...

Process to control inflation rate The belief that control of inflation must be the primary economic objective of government can be traced back to neo-liberal revolution that st

Classical and non-classical model, what is the difference between classical...

what is the difference between classical and non-classical model

Planning activities, What are the different stages of analysis in planning ...

What are the different stages of analysis in planning activities?

Analyse manipulating monetary policy, Buckley (2009) writes that the UK was...

Buckley (2009) writes that the UK was in recession for several short periods during this time, which placed further emphasis on researchingrelationships between the price of oil an

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