Estimate the maximum possible daily profit, Macroeconomics

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


Posted Date: 3/20/2013 5:28:37 AM | Location : United States

Related Discussions:- Estimate the maximum possible daily profit, Assignment Help, Ask Question on Estimate the maximum possible daily profit, Get Answer, Expert's Help, Estimate the maximum possible daily profit Discussions

Write discussion on Estimate the maximum possible daily profit
Your posts are moderated
Related Questions
1. Practice identification of proper analysis type (1-Sample Z, 1-Sample t, 2-Sample t, Paired t, etc). 2. Practice hypothesis testing. 3. Practice interpretation of sta

Explain the facts or economics rate Boom: The period leading up to the peak of the cycle when an overheating economy is experiencing high GDP growth and inflationary pressures

Prepare an essay regarding the concept of maximization and the assumptions associated with the behavior of the economic man.

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-prior

Differentiate economic growth and economic development. Economic growth is a raise into real GDP. GDP is only one dimension of development and therefore is a narrow measure of

Q. Explain about Price Inflation? The major reason for allowing for non-constant wages in the model is that we then can allow for persistent deflation/inflation. With constant

Crowding out would most likely occur when: A. the Congress enacts budget cuts to balance the budget. B. workers lose jobs as a result of anti-inflationary fiscal policies. C. the f

given the consumer maximizing problem subjest to consumption, the firm''s maximizing problem subject to revenue as a function of labour demand, and the government''s budget as G=T.

What is the difference between an economic luxury and an economic necessity? Ans) An economic luxury is wasting land on pools huge garden, etc. An economic requirement is what y