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

Define the interpreting the price elasticity of demand, Define the interpre...

Define the interpreting the price elasticity of demand. Interpreting the Price Elasticity of Demand: Demand is: a. Elastic when the price elasticity of demand is greater

Total firm''s cost schedules to calculate, Use the following data on a firm...

Use the following data on a firm's total cost schedules to calculate its average variable cost, average fixed cost, average total cost, and marginal cost schedules. Output Total

Inflation, how inflation trade off is not feasible under adaptive expectati...

how inflation trade off is not feasible under adaptive expectation

Explain gdp, You are given the following information about an economy: ...

You are given the following information about an economy: Gross Investment  =                                                         40 Govt. purchases of goods & service =

Growth, What is Bolivia''s growth in 1985?

What is Bolivia''s growth in 1985?

Purchase an annuity, Suppose you have $10,000 and wish to purchase an annui...

Suppose you have $10,000 and wish to purchase an annuity that pays you a fixed dollar amount every month. How much would you receive each month if the annuity rate is 1% and you in

Determine the principle of equity, Determine the principle of equity Th...

Determine the principle of equity The principle of equity is that a tax must be fair and the tax is levied on those with the ability to pay tax. The principle of efficiency

AS-AD model, evaluate the usefulness of the model in South Africa

evaluate the usefulness of the model in South Africa

State the marginal productivity theory, Q. State the Marginal Productivity ...

Q. State the Marginal Productivity Theory. What are its features and assumption? Marginal Productivity Theory of distribution states that in a capitalist economy the demand for

Relationship between the interest rate and the bond price, Relationship bet...

Relationship between the interest rate and the bond price Note that the higher the issue price, the lower the interest rate. Similarly when the price of a government bond incr

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