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

GDP, HOW MARRIAGE AFFECTS GDP

HOW MARRIAGE AFFECTS GDP

Labor supply and labor demand in the keynesian model, Supply of labor, L S ...

Supply of labor, L S (W/P), depends positively on real wages in classical model. It isn't always clear which individuals are included in the labor supply. Labor supply may consist

International Trade, How can an economy achieve mutual gain from Internatio...

How can an economy achieve mutual gain from International Trade?

Solve equilibrium price and the equilibrium quantity, Suppose that a widget...

Suppose that a widget market is described by the following supply and demand equations. Supply: Q = 3 P Demand: Q =400 - P a. Solve for the equilibrium price and the

AS-AD model, evaluate the usefulness of the model in South Africa

evaluate the usefulness of the model in South Africa

Gross domestic savings, Gross Domestic Savings  Income not devoted to c...

Gross Domestic Savings  Income not devoted to current consumption is saved. In an economy during a particular year some units will consume less than their income while some wil

Define the tools of competitive market, Define the tools of Competitive mar...

Define the tools of Competitive market. Competitive market: The supply and demand model a. The demand curve b. The supply curve c. Factors which cause the demand cu

Two-period model, Suppose that a household in a two-period model has incom...

Suppose that a household in a two-period model has income of $30,000 in period 1 and $25,000 in period 2, and the interest rate is 75 percent. Assume that the price of the good is

Financial payments flow between firms and government, Explain whether, the...

Explain whether, the following statements are TRUE, FALSE or UNCERTAIN. Briefly justify your answer. (i) The circular flow shows how real resources and financial payments flow

Meaning of convex indifference curves, Explain what convex indifference cur...

Explain what convex indifference curves means in terms of marginal utility. What properties must a utility function have in order to obtain convex indifference curves?

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