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

Explain about economic cycle, Explain about economic cycle The economic...

Explain about economic cycle The economic cycle is a period of approximately 6 or 7 years in which the economy completes a cycle of downturn, recovery, recession, and boom. A p

Describe the macroeconomic variables, Q. Describe the macroeconomic variabl...

Q. Describe the macroeconomic variables? In this section we have summarizes all the macroeconomic variables. The first column denotes the symbol we use for variable whereas col

U.s. department of agriculture, The U.S. Department of Agriculture, nass.us...

The U.S. Department of Agriculture, nass.usda.gov, publishes charts on the prices of farm products. Go to the USDA home page and select Charts and Maps and then Agricultural Prices

Government revenue, Government revenue, government spending and net exports...

Government revenue, government spending and net exports  G, NT and NX are exogenous variables in the classical model In the classical model (and

Effect of that on the tofu market, New technology was just invented that de...

New technology was just invented that decreases the cost of planting and harvesting soybeans: show the effect of this on the soybean market. Show the effect of that on the tofu mar

Difference between sampling error and standard error, Which is not true of ...

Which is not true of the difference between sampling error and standard error? a. Standard error is a difference from the population. b. Sampling error can't usually be calcula

The transmission mechanism - monetary policy, The Transmission Mechanism ...

The Transmission Mechanism The mechanism by which the changes in monetary policy affect aggregate demand is called 'transmission mechanism'. Two stages in transmission mechanis

Per year interest rate, For an interest rate of 12% per year compounded con...

For an interest rate of 12% per year compounded continuously, find (a) the nominal rate per year, (b) the nominal rate per quarter, (c) the effective rate per quarter, and (d) the

Explain why interest rates are pro-cyclical, Critically explain why interes...

Critically explain why interest rates are pro-cyclical, using the supply and demand for bonds framework.

Simple regression analysis uncover the ceteris paribus, Let kids denote the...

Let kids denote the number of children ever born to a woman, and let educ denote years of education for the woman. A simple model relating fertility to years of education is kids =

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