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

Nursing home can experience before it begins to lose money, A nursing home ...

A nursing home contracts with an HMO for skilled nursing care at $2.00 PMPM. If costs are expected to average $120 per day, what is the maximum utilization of days per 1,000 member

What are the production elasticities of demand, The following Cobb-Douglas ...

The following Cobb-Douglas production function is used to describe the output generated by a local government maintenance agency. Q = αL β1 K β2 E β3 Where L represents numb

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 meant by the term national debt?, When a government spends more tha...

When a government spends more than it receives in taxes; it runs a budget deficit, which is generally covered by issuing debt obligations to domestic and/or international investors

Illustrate the policy - beggar my neighbour, Illustrate the policy - Beggar...

Illustrate the policy - Beggar my neighbour 'Beggar my neighbour' policies are government policies which attempt to gain a competitive benefit at the expense of other countries

Firm wants to sell goods, If a firm wants to sell goods more often, would t...

If a firm wants to sell goods more often, would they prefer to produce a high quality good that will not wear out or one that will wear out faster. For example, what is the 'life e

Unusually high period, The consumer price index for the 1978-82 periods and...

The consumer price index for the 1978-82 periods and the GDP deflator follow. This was a period of unusually high, but declining, inflation. (The CPI is equal to 100 in the base ye

Name the largest budget deficit country, Name the largest budget deficit co...

Name the largest budget deficit country In 2009 Greece was eurozone country with largest budget deficit (about 16.0% of GDP), while Finland was the country with the smallest bu

Labor supply and labor demand in the keynesian model, Supply of labor, L S ...

Supply of labor, L S (W/P), depends positively on real wages in classical model. It isn't always clear which individuals are included in the labor supply. Labor supply may consist

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