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
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

THE MODEL BUILDING    A model of individual or aggregate economic phenomena represents a simplification of real world economic complexities. It may be expressed in words, ta

A mechanical engineer who is anticipating paying for his daughter's college education plans to start depositing money now (year 0) and continue through year 17. If he deposits $ 50

Relationship between the interest rate and the bond price Note that the higher the issue price, the lower the interest rate. In the same way, when the price of a government bon

Determine the exchange rate When a currency is freely floating, the central bank doesn't have to set monetary policy to alter the external value of the currency unless instruct

Which of the following will cause property crime to increase? a) An increase in jail terms. b) A decrease in personal incomes. c) An increase in the probability of arrest.

Let us now see a bit more closely how monetary policy works. See Figure Figure  The initial equilibrium at point E is on the initial LM schedule that corresponds to a

The elasticity of demand in the local hardware industry is -2, while in the video market it is. Which industry has a higher markup over marginal cost (as a percentage of price)?

The following information has been extracted from the recently published accounts of Noddy Plc:                           Balance sheet as at 31 st May

Why does a production possibilities frontier with increasing opportunity costs have a bowed-out shape?   The curve is bowed-out because some resources are better suited for the