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

MR AND MC, EXPLAIN THE MR AND MC APPROACH FOR EQUILIBRIUM DETERMINATION OF ...

EXPLAIN THE MR AND MC APPROACH FOR EQUILIBRIUM DETERMINATION OF FIRM IN SHORT RUN.

Prices in the market, Who sets the prices in the market and what is the nat...

Who sets the prices in the market and what is the nature of competition? Is it buyer versus sellers or buyer versus buyers? What happens if the price is too high or too low? Is the

Marginal tax rates imposed on individuals, Compared with the situation befo...

Compared with the situation before 1981, the marginal tax rates imposed on individuals and families with high incomes are now lower. What was the top marginal personal income tax r

Calculate rental price of capital, Let the real interest rate, i r , equal ...

Let the real interest rate, i r , equal 5 percent and the rate of depreciation, d, equal 10 percent.  In this case, if the price of a piece of capital is P K = $10,000, what is th

Determine the real rate of return on investment, A) Suppose Jean Splicer, a...

A) Suppose Jean Splicer, an investor, buys $300,000 of shares of stock in a diversified bundle of Bio-tech firms and exactly one year later sells those shares for $315,000. Assume

Money market, suppose that a persons wealth is kshs. 50,000 and her yearly ...

suppose that a persons wealth is kshs. 50,000 and her yearly income is kshs. 60,000. suppose further that her money demand function is given by Md = y(0.35-i) where i= interest

Determinants of long run prosperity rank, he questions posed are broad and ...

he questions posed are broad and open ended so be careful to allow yourself enough research and planning time. If you are completely on top of the material delivered in class, then

Pdf, asiignment on ppc

asiignment on ppc

How growth are improved living standards, How growth are improved living st...

How growth are improved living standards The two main benefits of growth are improved living standards and technological advancement. As an economy grows, the output of

Firm‘s lowest average cost, If the firm‘s lowest average cost is $52 and th...

If the firm‘s lowest average cost is $52 and the corresponding average variable cost is $26, what does it pay a perfectly competitive firm to do if • The market price is $51?

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