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

Export promotion measures, Export Promotion Measures: While a number o...

Export Promotion Measures: While a number of  existing  export promotion schemes  such as  incentive related to Duty Free Replenishment Certificate (DFRC), Duty Entitlement Pa

Economics, n 2013, approximately 58 percent of the adult population (245 mi...

n 2013, approximately 58 percent of the adult population (245 million) was employed, the lowest employment rate in 20 years. If the employment rate increased to the prerecession l

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

MEC and MEI curvs and their role in economics

How much money can banks create, How much money can banks create? Does...

How much money can banks create? Does this mean that banks can create an unlimited amount of money? The answer is no - that would require them to lend an unlimited amount of m

Production possibility curve, PRODUCTION POSSIBILITY CURVE As we have s...

PRODUCTION POSSIBILITY CURVE As we have seen, the essence of economic analysis is the problem of scarcity and choice. We know that limited productive resources compel individua

What do you understand production method, Question 1 Discuss the relation...

Question 1 Discuss the relationship between microeconomics and macroeconomics Question 2 What do you understand production method? What precaution should be taken while

To compare prices what is consumers ability, How has the Internet revolutio...

How has the Internet revolution affected the workings of businesses, consumers, and government in a free market economy? Specifically, how has Internet affected businesses' ability

Show the analysis of cross model, Q. Show the analysis of cross model? ...

Q. Show the analysis of cross model? We can divide our analysis of cross model into three sections:  Aggregate demand. Aggregate demand is a major component of cross mo

Taxes and government expenditures were constant, If taxes and government ex...

If taxes and government expenditures were constant and did not vary with income, then: A. passive deficits would increase. B. structural deficits would increase. C. passive deficit

Abnormal profits, explain the terms abnormal profits and normal profits

explain the terms abnormal profits and normal profits

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