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 is cost-push inflation, What is Cost-push inflation Cost-push infl...

What is Cost-push inflation Cost-push inflation takes place when costs of production increase causing short-run aggregate supply curve to shift to left. The main causes of c

The aggregate demand curve, The aggregate demand curve shows the combinatio...

The aggregate demand curve shows the combinations of the price level and the level of output at which the goods and money markets are simultaneously in equilibrium. Let us now go o

State the both -cyclical and classical unemployment, State the both -Cyclic...

State the both -Cyclical and Classical unemployment Cyclical unemployment Unemployment because of a recession. Classical unemployment Unemployment because of

Relationship between saving and income, The following table contains data o...

The following table contains data on the relationship between saving and income. Rearrange these data into a meaningful order and graph them on the accompanying grid. What is the s

Determine the cross elasticity demand for margarine, Question 1: (a) D...

Question 1: (a) Distinguish between the short run and long run profits of a competitive firm by using graphical representations. (b) Compare and contrast between perfect c

Give brief introduction about interest rate, Give brief Introduction about ...

Give brief Introduction about Interest rate When you borrow money, you usually have to pay a fee for the loan. This fee is often called interest, particularly if the fee is pr

Inverse market supply curve, Consider the market for the trusty widget (the...

Consider the market for the trusty widget (the most common good in the world if economics textbooks are to be believed). Assume that the market is perfectly competitive. Suppose th

How internal resources important, Why is it important to study the internal...

Why is it important to study the internal resources, capabilities, and activities of firms? What insights can be gained?

Growth, I used to think that economic growth ( more production) was only po...

I used to think that economic growth ( more production) was only possible / able to occur because banks lent out more than they had (fractional reserve credit banking). Apparently

Economic incidence of the tax on the consumers price, Suppose the demand fo...

Suppose the demand for bread is D(p), where dD/dp Illustrate equilibrium with price on the Y-axis and quantity on the X-axis in which the t > 0. Show the economic incidence

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