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

Find the optimal amounts and solve the dual problem, After some consultants...

After some consultants point out that the Acme Toy Company has two bottlenecks in its production of xylophones and yo-yos. The first is a critical grinding machine that only has 9

National income, # ???? .. difference between gdp at market price and nnp...

# ???? .. difference between gdp at market price and nnp at factor cost

Lorenz curve, what do we mean when we say export are exogenous and import a...

what do we mean when we say export are exogenous and import are endogeneos?

Quantitative data analysis and interpret , 1. To assess your ability to con...

1. To assess your ability to conduct quantitative data analysis and interpret the results of data analysis introduced inForecasting Trend. 2. To assess your ability to communicate

What is net present worth for new computer system, Kermit is considering pu...

Kermit is considering purchasing a new computer system. The purchase price is $106,430. Kermit will borrow one-fourth of the purchase price from a bank at 10 percent per year compo

Last deposit if your saving account, You make a monthly deposit of $1,000 i...

You make a monthly deposit of $1,000 into a saving account for the next 10 years. How much can you withdraw immediately after your last deposit if your saving account pays 6% per y

Money market in the AS-AD model, Q. Money market in the AS-AD model? g...

Q. Money market in the AS-AD model? goods and the money market in the AS-AD model We begin by studying goods market and money market when prices are no longer constant. Fi

What causes economic growth, What causes economic growth? Causes of ec...

What causes economic growth? Causes of economic growth: Into the Solow model, economic growth is based onto the quantity and quality of technology and resources. Growth

Voting for a republican candidate, Suppose that 70% of people who identify ...

Suppose that 70% of people who identify themselves as an "Independent" voter end up voting for a Republican candidate. What is the probability that out of 120 "independent" voters

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