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
what are the three motives of holding money?

Briefly explain the dynamics of the 2007 financial crisis in terms of adverse selection and moral hazard.

circular flow of national income?

Draw the supply and demand graph for pizza, then answer the questions below. SUPPLY OF AND DEMAND FOR PIZZA Quantity Supplied Price Quantity Demanded 300 $15.00 100 240 12.00 180 1

Below is a simple/familiar (I hope) worksheet for the "Dice Game".  Answer the following questions given the data for the each Work Center's scheduled production:

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

How can an economic development be measured? The UN has developed an extensively accepted set of indices to measure development in opposition to a mix of composite (element or

Review the most current results of FORTUNE Magazine's annual ranking of America's "100 Best Companies to Work For." Explore the website of at least three of the companies noted. De

In your answer, discuss the Federal Reserve's use of open-market operations to influence the money supply and the respective consequences of such actions. Include a discussion of t

Could you explain the "interest rate effect" in terms of the slope of a curve?