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

Monetary sector, If the reserve bank wants to pursue a contractionary polic...

If the reserve bank wants to pursue a contractionary policy, what should it do?

Determine what would be lowest bid of sfi , Snake Farm Inc. (SFI) has been ...

Snake Farm Inc. (SFI) has been offered to submit a competitive bid for building 31 and 22, 18, and 11offshore pits per year for Athletic Inc. over the next four years.  If the bid

Determine the net terminal year cash flow, A company is assessing a propose...

A company is assessing a proposed 4-year project.  The depreciable cost will involve the following: $300,000 for the equipment, $20,000 for shipping, and $30,000 for installation.

Production possibility frontiers, Using production possibility frontiers, a...

Using production possibility frontiers, and indifference curves for Argentina and Brazil, illustrate and explain the movement of both countries to the free-trade equilibrium patter

Unemployment, critically analyse the ways at which the govement of zimbabwe...

critically analyse the ways at which the govement of zimbabwe has put in place to address unequal employment opportunitiesbetween men andwomen

Assumptions of the AS-AD model, Q. Assumptions of the AS-AD model? The ...

Q. Assumptions of the AS-AD model? The most significant change we make going from IS-LM model to AS-AD model is to allow P to be endogenous. As P was constant in IS-LM model, w

What are the steps in hypothesis testing, An experiment is explained by an ...

An experiment is explained by an exponential random variable with mean ? and x1 and x2. A proposed test of the hypothesis ?=2 next to the alternative ?=½ uses the critical region {

Market demand curve, The entire market is capture by a single firm which ca...

The entire market is capture by a single firm which can produce at a constant average and marginal cost of AC = MC = 10. The firm faces a market demand curve given by Q = 60 ? P.

Impact of an aging population on state, Evaluate the impact of an aging pop...

Evaluate the impact of an aging population on state and local government expenditures. Suggest strategies that government should take in dealing with this situation. Justify your r

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