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

Determine the term- gdp per capita, Determine the term- GDP per capita ...

Determine the term- GDP per capita GDP, being a flow, isn't a measure of the total wealth of a country though a measure of the "income" of country during a certain period of ti

Prices in the market, Who sets the prices in the market and what is the nat...

Who sets the prices in the market and what is the nature of competition? Is it buyer versus sellers or buyer versus buyers? What happens if the price is too high or too low? Is the

Demand for the hotel''s rooms, Suppose that a particular large hotel has 79...

Suppose that a particular large hotel has 790 rooms. Furthermore, suppose that the demand for the hotel's rooms are normally distributed with a mean demand of 733 rooms with a stan

Current value of investment, An investment promised a payoff of $195 two an...

An investment promised a payoff of $195 two and a half years from today. At a discount rate of 75% per year what is the present value of this investment? A. 169.47 B. Not enoug

Supply curve goes through the point, If a supply curve goes through the poi...

If a supply curve goes through the point P = $10 and Qs = 320, then a. $10 is the highest price that will induce firms to supply 320 units b. $10 is the lowest price that wil

Economic growth cyclic fluctuations, Economic Growth Cyclic Fluctuations ...

Economic Growth Cyclic Fluctuations At this stage, it is useful for us to understand the difference between economic growth and cyclical fluctuations. Economic Growth Econo

What is national income, Recognize which of the following purchases is coun...

Recognize which of the following purchases is counted as a part of NI: a) Tata motors purchases tire from Good year to equip latest Indica. b) Tata motors purchases tires fr

Traditional or a roth ira, Suppose one of your clients is four years away f...

Suppose one of your clients is four years away from retirement and has only $1,500 in pretax income to devote to either a Roth or a traditional IRA. The traditional IRA permits inv

SARB, #If the reserve bank wants to pursue a contractionary monetary policy...

#If the reserve bank wants to pursue a contractionary monetary policy, the bank should?

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