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, Whenever real GDP declines, nominal GDP must also declin

Whenever real GDP declines, nominal GDP must also decline

Fixed versus floating exchange rates, Fixed versus floating exchange rates:...

Fixed versus floating exchange rates: To begin with, we will briefly review the balance of payments (BOP) table of a nation that you studied in the course on international eco

Production possibilities table for consumer goods, To the right is a produc...

To the right is a production possibilities table for consumer goods (automobiles) and capital goods (forklifts): a. Show these data graphically. Upon what specific assumptions is t

Difficulties in measuring the national income, DIFFICULTIES IN MEASURING TH...

DIFFICULTIES IN MEASURING THE NATIONAL INCOME  There are some conceptual and statistical problems in measuring national product. Some items are excluded from the national incom

Comparative advantage in cars and in rice, Suppose that in the United State...

Suppose that in the United States a car can be produced with 200 labor hours, while a ton of rice requires 20 labor hours. In Japan, it takes 150 labor hours to make a car and 50 l

Application of theory of consumer behavior, Application of Theory of Consum...

Application of Theory of Consumer Behavior As already discussed earlier, the theory is an important tool to interpret and analyse demand curves. Apart from its usefulness as a

Input combination if the price of capital decreased, In reference to the ab...

In reference to the above question, assume you know the combination of inputs that minimizes cost. What would happen to this input combination if the price of labor increased? What

The monetary policy of the U.S., I am writing a research paper for my macro...

I am writing a research paper for my macroeconomics class and I am having trouble with it. I am writing on the topic of the monetary policy and i can''t seem to understand a few th

Determine about the interest rates, Determine about the interest rates ...

Determine about the interest rates The interest rate may be fixed or floating. If it is fixed, you will pay the same percentage for the entire duration of the loan. With a floa

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