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

Var model, The estimated statistics from the VAR model are not able to be i...

The estimated statistics from the VAR model are not able to be interpreted to solve the problem of this coursework due to reasons that are discussed in the next subchapter. Therefo

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

MPC, A change in government purchases of goods and services results in a ch...

A change in government purchases of goods and services results in a change in real GDP equal to $200 million. Assume the absence of taxes, international trade, and changes in the a

Price elasticity of demand, Suppose that quantity demand falls by 30% as a ...

Suppose that quantity demand falls by 30% as a result of a 5% increase in price. What would be the price elasticity of demand for this good?

Diversify the business of firm a, The managers of Firm A recommend that Fir...

The managers of Firm A recommend that Firm A purchase Firm B because the purchase will diversify the business of Firm A. Diversification of risks is a desirable strategy for indivi

Price to the government of buying unsold units firms, Consider a market whe...

Consider a market where supply and demand are given by QXS = -12 + PX and QXd = 78 - 2PX. Suppose the government imposes a price floor of $35, and agrees to purchase any and all un

Project topics, i want a project topics in macroeconomics

i want a project topics in macroeconomics

Investment multiplier, what is the formula for calculating investment multi...

what is the formula for calculating investment multiplier for 4 sector economy?

Wi cost of debt and wacc, hi I just found an interesting problem on your pa...

hi I just found an interesting problem on your page,(wood investments ... Mutch PLC) I would like to see the answer Could you please give me a quote for the answer?

Show the ad curve over time, Q. Show the AD curve over time? With infla...

Q. Show the AD curve over time? With inflation, AD curve will no longer be stable over time. In its place, it will glide upwards or downwards at a rate determined by growth rat

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