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

If the airline industry was an oligopoly and Qantas and Virg, If the airlin...

If the airline industry was an oligopoly and Qantas and Virgin could collude, what would be a dominant (Nash equilibrium strategy) that they could adopt with reference to their pri

Good to peanut butter, Bread is a related good to peanut butter: show on th...

Bread is a related good to peanut butter: show on the graph of the market for peanut butter, the impact on the price and quantity from an increase in the price of bread.

Determinants of balance of payments, Determinants of balance of payments: ...

Determinants of balance of payments: Broadly speaking, trend behaviour of merchandise exports and imports along with their  terms of  trade,  net invisible earnings and autono

Invest into an account, You have 300 right now. You invest into an account ...

You have 300 right now. You invest into an account and 12 years later your investment will be 8 times of the initial investment. What the investment rate if a) The bank pays sim

Determine the problems there with consumer price index, Determine the Probl...

Determine the Problems evolved with Consumer Price Index To illustrate problems involved in calculating CPI we consider MP3 players. If you measure average price of MP3 players

GDP and GNP, y explain whether you agree or disagree with the following sta...

y explain whether you agree or disagree with the following statements. “If nominal GDP is less than real GDP, then the price level must have fallen during the year.”

After your last deposit withdraw immediately, You make a monthly deposit of...

You make a monthly deposit of $1,000 into a saving account for the next 10 years. How much can you withdraw immediately after your last deposit if your saving account pays 6% per y

What do you meant by investment, Q. What do you meant by Investment? Wh...

Q. What do you meant by Investment? When we use the word investment, we characteristically mean 'gross investment'. Fundamentally, gross investment comprises all finished goods

Marginal approach to profit maximization, The marginal approach to profit m...

The marginal approach to profit maximization means that a firm should produce until a. marginal revenue equals zero b. marginal revenue equals marginal costs c. marginal cost becom

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