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

Lilie, What are the requirements for something to be considered money? Why ...

What are the requirements for something to be considered money? Why does the dollar have value?

Assignment, Consider the economic data for Country A: Unemployment level of...

Consider the economic data for Country A: Unemployment level of 15% Natural Rate of Unemployment is 6%. Required Reserves is 25% C = 50 + 0.75Y; I = 600; G = 250 (note: T = 200 for

Change in demand for the product, The price will change in the market, only...

The price will change in the market, only due to the change in demand for the product. True or false

Factors influence group members, Norms influence behavior conformity among ...

Norms influence behavior conformity among group members. What factors will influence group members to conform to a group's norms, and when will members remain independent? Do indiv

Distinguish static and dynamic gains from trade, Question 1: Critically...

Question 1: Critically analyse the costs of inflation. Which of these items is likely to have encouraged many governments in their adoption of inflation as public enemy number

Country personal consumption expenditures, If in some country personal cons...

If in some country personal consumption expenditures in a specific year are $50 billion, purchases of stocks and bonds are $30 billion, net exports are $-10 billion, government pur

National income statistics, discuss four weaknesses of using national incom...

discuss four weaknesses of using national income statistics in comparing living standards between two countries

MEC and MEI, MEC and MEI curvs and their role in economics

MEC and MEI curvs and their role in economics

#title. phillip curve, what does phillip curve signify? how do you reconcil...

what does phillip curve signify? how do you reconcile the difference in the shap of the curve in the short run and the long run?

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