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

Ricardo Viner Model, How does the Ricardo Viner diagram react when once pri...

How does the Ricardo Viner diagram react when once price changes, effects on real wages, and labor allocation?

Strategic vs. tactical approaches, Consider Gold-Bernstein's Integration ro...

Consider Gold-Bernstein's Integration roadmap (p. 18).  Construct two business examples, one that clearly calls for a strategic integration effort and the other that call

Effect which have the bond market, Firms such a Moody's and Standard & Poor...

Firms such a Moody's and Standard & Poor's study corporations that issue bonds. They publish "ratings" for the bonds- evaluation of the likelihood of default. Suppose these rating

Long-run framework, In the long-run framework, budget surpluses: A. should ...

In the long-run framework, budget surpluses: A. should be run on a permanent basis since they boost saving and investment and stimulate economic growth. B. should be run whenever o

Analyse data using anova, A scientist postulates that grazing by gastropod ...

A scientist postulates that grazing by gastropod snails affects the settlement of Spirorbid worms in estuaries. She sets up a manipulative experiment to test this by using cages to

Additional marginal opportunity costs of our choices, We have been looking ...

We have been looking at just the Additional Marginal Opportunity Costs of our choices. What about the total cost? For example, we see and hear ads all the time about different cell

Monetary Economics, What is the difference between money multiplier and cre...

What is the difference between money multiplier and credit multiplier

Unemployment, Why do we still have problem of "unemployment" ? How could we...

Why do we still have problem of "unemployment" ? How could we solve the problem? Which one is better fixed or flexible exchange rate of unemployment ?

Fiscal restraint is required, If the AD excess is $300 billion and the MPC ...

If the AD excess is $300 billion and the MPC is 0.8 how much fiscal restraint is required? What does the "debt held by the public" mean?

What are the macroeconomic variables, Macroeconomics usually deals with the...

Macroeconomics usually deals with the behaviour of aggregates of economic variables. An economic variable is a magnitude whose value may changes. Important variables in macroeconom

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