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

TRUE or FALSE, 1.the AD curve represents at the same time the demand for go...

1.the AD curve represents at the same time the demand for goods, money and labor in the economy 2.in the AS-AD model, higher competition among producers leads to a medium run equil

Price of its cabernet sauvignon, When Sonoma Vineyards reduces the price of...

When Sonoma Vineyards reduces the price of its Cabernet Sauvignon from $15 a bottle to $12 a bottle, the result is an increase in a. the demand for this wine b. the supply of

Current value of investment, An investment promised a payoff of $195 two an...

An investment promised a payoff of $195 two and a half years from today. At a discount rate of 75% per year what is the present value of this investment? A. 169.47 B. Not enoug

Benefits and disadvantages of each scenario, Do you think that public admin...

Do you think that public administrators should be restricted to only laid down rules in the discharge of their duties as espoused by Max Weber or should they have some amount of di

Faced trade-offs, Provide an example of a decision in which you faced trade...

Provide an example of a decision in which you faced trade-offs, considered opportunity costs and evaluated the options by comparing the marginal benefits and the marginal costs ass

Fdi inflows - an appraisal, FDI Inflows - An Appraisal: A comparison o...

FDI Inflows - An Appraisal: A comparison of the magnitude of FDI inflows received by India would appear too small, especially when compared to the inflows received by other co

Other bankers and wall street firms, Some charge that the Crisis of 2008 wa...

Some charge that the Crisis of 2008 was caused by the "greed" of Wall Street firms and other bankers. Do you agree with this view? Do you think there was more greed on Wall Street

Change in nominal gdp, By given scenario answer the following questions. ...

By given scenario answer the following questions. 1. What phase of the business cycle is the economy? 2. If inflation increased by 5% during the same period, what was the cha

Quiz, To overcome the stagnant growth it was experiencing for the past 10-1...

To overcome the stagnant growth it was experiencing for the past 10-15 years, Japan undertook which of the following measures? Answer Undertook programs to build infrastructure

Investment, What are the basic differences between the investment curve and...

What are the basic differences between the investment curve and an investment demand curve for an economy

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