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

• What are the main goods and services the United States tra, I am working ...

I am working on a project for my class and this week discussion is on international trade and exports. what I am needing is the information for the 1970s

Explain the consumer prices index, Consumer Prices Index Two economic ...

Consumer Prices Index Two economic indices learnt at AS are the Consumer Prices Index (CPI) and the Retail Prices Index (RPI). Both are used to calculate the average price lev

Describe wages and income, Q. Describe Wages and income? Remember that ...

Q. Describe Wages and income? Remember that by wage we characteristically mean what you receive for working one hour, whereas income is the total revenue from all sources over

Normal population standard deviation, A normal population has a mean of 12....

A normal population has a mean of 12.2 and a standard deviation of 2.5. A) Compute the Z value associated with 14.3. B) What proportion of the population is between 12.2 and 14.3.?

Explain about a model and use of it in economics, Explain about a model and...

Explain about a model and use of it in economics. A model is a simplified demonstration of a real situation which is used to better understand real-life circumstances. The

Neo-Keynesian Synthesis, how would you describe a neo-keynesian (or neoclas...

how would you describe a neo-keynesian (or neoclassical) synthesis? and why did Joan Robinson label it "bastard Keynesian"

Deceased relative at zero prices, Kennesaw University Professor Frank A. Ad...

Kennesaw University Professor Frank A. Adams III and Auburn University Professors A. H. Barnett and David L. Kaser man recently estimated the effect of legalizing the sale of cadav

National income, difference between gdp at market price and nnp at factor c...

difference between gdp at market price and nnp at factor cost

Credit multiplier, use a numerical example to illustrate how credit multipl...

use a numerical example to illustrate how credit multiplier works

Illustrate biological effects of patulin, Q. Illustrate biological effects ...

Q. Illustrate biological effects of Patulin? Biological activity: Patulin has an acute oral LD 50 in rodents of about 30-50 mg/kg and has been shown to be teratogenic, immunot

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