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

AD, in the keynesian cross assume that the consumption function is given by...

in the keynesian cross assume that the consumption function is given by c=200+0.75(y-t). given planned investment is 100, government purchases and taxes are both 100. then what i

Calculate asset turnover, The following information has been extracted from...

The following information has been extracted from the recently published accounts of Noddy Plc:                           Balance sheet as at 31 st May

Trade, What is the difference between merchantilism and absolute theory?

What is the difference between merchantilism and absolute theory?

Analyse the effects of oil price, As previously stated, the aim of the pape...

As previously stated, the aim of the paper is to observe and analyse the effects of oil price shocks on key macroeconomic indicators in the UK economy. From this the aim is to conc

Demand, Demand: Demand is quantity of a good buyer who wishes to purcha...

Demand: Demand is quantity of a good buyer who wishes to purchase at each conceivable price. The law of demand explains us that if the price of certain commodity increases,

Mutual funds was taken, A sample of 57 mutual funds was taken and the mean ...

A sample of 57 mutual funds was taken and the mean return in the sample was 14.1% with a standard deviation of 9.2%. The return on a particular index of stocks (against which the m

Production possibility frontiers, Using production possibility frontiers, a...

Using production possibility frontiers, and indifference curves for Argentina and Brazil, illustrate and explain the movement of both countries to the free-trade equilibrium patter

What is trade liberalisation, What is Trade liberalisation Trade liber...

What is Trade liberalisation Trade liberalisation is the removal of barriers to trade. This has mainly taken the form of restrictions created by national governments like quot

Unit root testing, Firstly, it is imperative that I investigate the stochas...

Firstly, it is imperative that I investigate the stochastic properties of each series considered in the model prior to estimating the effects of oil price shocks on macroeconomic a

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