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
If you take nations total income and subtract out private consumption government consumption what you will find?

Analyze how a model of the labor market can be used to explain wage and employment for healthcare workers.

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

a) Get the latest data for each of the following variables for France in 2011: 1. Nominal GDP 2. Real GDP (Y) 3. Consumption (C) 4. Investment (I) 5. Government purchases (G)

Treatment of Na2PdCI4 with 3-chloro-2-methyl-1-propene under an atmosphere of CO yields the dimer [(11 3 - C 4 H 7 )PdClb (A). The 1H NMR spectrum of A at 298 K shows 3 signals: a

Examine the graph below. The mayor has placed a $2 tax on the sale of each taco sold within the city. How large is the decrease in producer surplus?

The market demand for a factor   The market demand curve for any input is not simply the horizontal summation of the individual demand curves of all the firms. This is due to th

The number of gallons of paint that Home Depot sells in a given day is normally distributed with a mean of 150 gallons and a standard deviation of 35 gallons (I realize that the di

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

TRADE IN SERVICES: India had objected to  the  inclusion of  trade in services  in  the agreement for  the UR  negotiations. The  Indian negotiations continued to raise object