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

Determination of l in the cross model, Determination of L in the cross mode...

Determination of L in the cross model As firms will produce less than Y OPT , they require less labor than L OPT . We can determine exactly how much L they need in order to pro

Explain the gains from trade of market, Explain the Gains from Trade of mar...

Explain the Gains from Trade of market. Producer Surplus, Consumer Surplus, Gains through Trade and Efficiency of Markets: Consumers and producers both are better off since

Uniform series of payments, Your project has an estimated cost for land rec...

Your project has an estimated cost for land reclamation to be realized at the end of 20 years from today for $70,000,000. If current bond long-term interest rates are 7% compounded

What do you mean by gross domestic product, What do you mean by Gross Domes...

What do you mean by Gross Domestic Product? Gross Domestic Product: GDP stands for Gross domestic product, measures the value of all concluding goods and services produce

Firm make profits of losses with this quantity, The Marginal Costs (MC) for...

The Marginal Costs (MC) for a firm is given by the function MC=50x. Please find the Marginal Revenues (MR) for each of the following scenarios (if appropriate). Then, find the prof

Determine the categories of finished goods, Determine the categories of fin...

Determine the categories of finished goods Finished goods in the goods market are divided into 4 categories: private consumption going to private sector, public consumption for

Demand for memberships at the health club, a health club sells 50 membershi...

a health club sells 50 memberships when the monthly price is $60 and 70 memberships when the monthly price is $40. the price elasticity of demand for memberships at this health clu

State about the United States government bonds, State about the unitesd sta...

State about the unitesd state government bonds In most countries, you find government bonds with longer maturity. For example, in the United States you have Treasury notes (two

Myth of public goods''''?, a) Summarize the basic tenets of the arguments i...

a) Summarize the basic tenets of the arguments in this case. b) Do you agree with main tenets of the arguments in the case? Why? Justify your answer with detailed explanations. s

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