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

U.s. department of agriculture, Suppose that the U.S. Department of Agricul...

Suppose that the U.S. Department of Agriculture (USDA) administers the price floor for cheese, set at $0.17 per pound of cheese. (The price floor is officially set at $16.10 per hu

Real per capita gdp levels, If two countries had the same initial level of ...

If two countries had the same initial level of real GDP per capita, and Country A grows at 2.8 percent, while Country B grows at 3.5 percent, how will their real per capita GDP lev

How commercial banks create money, How commercial banks "create money" ...

How commercial banks "create money" Commercial banks obviously cannot influence the amount of currency in the economy or the monetary base, since they are not allowed to print

Determine modified accelerated cost recovery system, Suppose new instrument...

Suppose new instruments for a firm cost $18,000 along with an additional installation fee of $2,000, both of that are depreciable. Complete the depreciation schedule display below

Wage rate increases, A person chooses between leisure and consumption. All ...

A person chooses between leisure and consumption. All of their consumption comes from current income. The utility derived from any combination of leisure and consumption is given b

Change in the dependent variable, All other things being held constant, wha...

All other things being held constant, what is the change in the dependent variable for a unit change in the first independent variable for the multiple regression equation: ? = 5.2

Difference between productive and allocative efficiency, Explain the differ...

Explain the difference between productive and allocative ( economic ) efficiency. Explanation of productive efficiency, e.g. output at AC minimum Define to the effect th

Aggregate supply in the short run, Aggregate Supply in the Short Run P...

Aggregate Supply in the Short Run Production takes place in business sector on the basis of an expected price for its output. However, costs are incurred in anticipation of sa

Analyze the effects of discrimination in labor markets, To analyze the effe...

To analyze the effects of discrimination in labor markets, use supply and demand curves for labor, with the demand curves representing the value of the marginal product, show the e

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