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

Differentiate comparative and absolute advantage, What is the difference be...

What is the difference between Comparative Advantage and Absolute Advantage? Difference between Comparative Advantage and Absolute Advantage: Comparative advantage: it is

Income and Spending, I am trying to figure out how to calculate the eqilibr...

I am trying to figure out how to calculate the eqilibrium level of income and the multiplier

Reserves and a reserve requirement, If the Banking system has $500,000 in d...

If the Banking system has $500,000 in demand deposit liabilities, $125,000 in total reserves and a reserve requirement of 15%: What is the maximum amount by which the money supply

Compute total demand and firms profit, Suppose three identical firms are e...

Suppose three identical firms are engaged in Cournot competition in quantities. They all have marginal costs equal to 40. Market demand is given by: P(X) = 200 - X = 200 - (x

Moodys and standard & poors study corporations, Firms such a Moody's and St...

Firms such a Moody's and Standard &Poor's study corporations that issue bonds. They publish "ratings" for the bonds- evaluation of the likelihood of default. Suppose these rating c

Impact of property crime to increase, Which of the following will cause pro...

Which of the following will cause property crime to increase? a) An increase in jail terms. b) A decrease in personal incomes. c) An increase in the probability of arrest.

Demand for money, what is the meaning of the statement ''money is not merel...

what is the meaning of the statement ''money is not merely a veil or wrapper''?

EXCHANGE RATES, WHAT IS THE BEST EXCHANGE RATE TYPE

WHAT IS THE BEST EXCHANGE RATE TYPE

Tax-adjusted multiplier and the balanced budget multiplier, The tax-adjuste...

The tax-adjusted Multiplier and the balanced budget Multiplier are explained below: Taxes act as drag on the multiplier effect of government expenditure, because they represent

What is profitability analysis, This is an examination of costs and revenue...

This is an examination of costs and revenue to explain whether a venture will make a profit. This is significant information in deciding on whether to make an investment. The lengt

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