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

What is national income, Q. What is national income? What are the different...

Q. What is national income? What are the different methods of measuring national income? National income is the aggregate money value of the annual flow of final goods and serv

Theory of aggregate deman, unplanned changes in inventory are counted as in...

unplanned changes in inventory are counted as inventory spending by firms.say true or false and justify

Aggregeta demand and aggregate supply, Using an aggregate demand and supply...

Using an aggregate demand and supply diagram, explain how each of the following scenarios affects the equilibrium price level and aggregate output a/Consumers expect a recession b/

Average price-earnings ratio, In a survey of 155 publicly-traded companies,...

In a survey of 155 publicly-traded companies, the average price-earnings ratio was 18.3 with a standard deviation of 7.6. When testing the hypothesis (at the 5% level of significan

Application of theory of consumer behavior, Application of Theory of Consum...

Application of Theory of Consumer Behavior As already discussed earlier, the theory is an important tool to interpret and analyse demand curves. Apart from its usefulness as a

Explain the term- inventory investment, Explain the term- inventory investm...

Explain the term- inventory investment We would have a negative inventory investment whenever inventories decrease. By net investments we mean gross investments minus depreciat

Estimate the wacc and cost of capital, Cowboy Corporation is estimating its...

Cowboy Corporation is estimating its WACC.  The firm's debt structure contains: (1) 30,100 long-term bonds with an 8.1% coupon, paid semiannually, a 10 years-to-maturity, and a $10

Determine the daily amount and ipa, A brewery produces two kinds of beer, s...

A brewery produces two kinds of beer, stout and IPA . Each batch of stout sells for $60 per unit while each batch of IPA sells for $108. Both products require malt, hops, barley, f

What are the important aspects in tracking the macro-economy, What are the ...

What are the important aspects in tracking the macro-economy? Important aspects in tracking the macro-economy: a. How economists utilizes aggregate measures to track the pre

How to find nominal gdp in the current year, Consider an economy that produ...

Consider an economy that produces only three types of fruit: apples, oranges & bananas. In the base year the production & price data are as follows: Fruit

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