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

What are the capitalist countries in the world, Capitalism is the dominant,...

Capitalism is the dominant, most used form of government there is in the globe today. Presently, over 80% of countries use capitalism and a free market economy.

Factors shift out the ppc, What factors shift out the PPC and what is the o...

What factors shift out the PPC and what is the opportunity cost of the economy moving out to get back on the PPC? Explain?

Firm make profits of losses with this quantity, The Marginal Costs (MC) for...

The Marginal Costs (MC) for a firm is given by the function MC=50x. Please find the Marginal Revenues (MR) for each of the following scenarios (if appropriate). Then, find the prof

What is national income, Q. What is national income? What are the different...

Q. What is national income? What are the different methods of measuring national income? National income is the aggregate money value of the annual flow of final goods and serv

Unusually high period, The consumer price index for the 1978-82 periods and...

The consumer price index for the 1978-82 periods and the GDP deflator follow. This was a period of unusually high, but declining, inflation. (The CPI is equal to 100 in the base ye

Derive the engel curve for shortbread cookies, Jen spends all her income on...

Jen spends all her income on shortbread cookies (S) and cupcakes (C). Her utility function is given by: U(S,C) = S +2C. Suppose that Jen has an income of $10 and that a cupcake cos

MARKET, COMPARE AND CONTRAST CLASSICAL MODEL AND KEYNESIAN THEOTY

COMPARE AND CONTRAST CLASSICAL MODEL AND KEYNESIAN THEOTY

Summary of the phillips curves, Summary of the Phillips curves In neo-c...

Summary of the Phillips curves In neo-classical synthesis, augmented Phillips curve is known as the short-run Phillips curve. It is presumed to be stable as long as expectation

Explain initial actual markup, George has been selling 5,000 T-shirts per m...

George has been selling 5,000 T-shirts per month for $8.50. When he increased the price to $9.50 he sold only 4,000 T-shirts. What is the demand elasticity? If his marginal cost is

Describe the goods in the circular flow, Goods in the circular flow ...

Goods in the circular flow If Y R is total value of all goods going from F R to F H , then total value added from all firms in the F R box is equal to Y R (they don't pu

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