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

Compute the npv-the irr the mirr, Suppose a company is considering two inde...

Suppose a company is considering two independent projects, Project A and Project B.  The cash outlay for Project A is $14,000. The cash outlay for Project B is $20,000. The company

Classical and non-classical model, what is the difference between classical...

what is the difference between classical and non-classical model

Real per capita gdp levels, If two countries had the same initial level of ...

If two countries had the same initial level of real GDP per capita, and Country A grows at 2.8 percent, while Country B grows at 3.5 percent, how will their real per capita GDP lev

Peoples national bank required reseves, Suppose that the reserve requiremen...

Suppose that the reserve requirement is 10 percent and the balance sheet of the People's National Bank looks like the accompanying example. a. What are the required reseves of P

Gross domestic product, In 1 to 2 sentences respond to the following commen...

In 1 to 2 sentences respond to the following comment. "Pollution restrictions will reduce gross domestic product and therefore hurt the economy."

Money supply and monetary policy, Money Supply and Monetary Policy   All...

Money Supply and Monetary Policy   All modern societies use money as the medium of exchange. Since money can be exchanged for goods and services it also becomes a financial asse

Abnormal profits, explain the terms abnormal profits and normal profits

explain the terms abnormal profits and normal profits

Way they do at home, 1. Should each person behave in the workplace the way ...

1. Should each person behave in the workplace the way they do at home? Or should each person have a separate set of ethics for each part of their life? 2. What if you are the bo

Investment., whwt is the difference between the fixed accelerator and the f...

whwt is the difference between the fixed accelerator and the flexible accelerator theories of investment?

Balance of payment, derive balance of payment line graphically

derive balance of payment line graphically

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