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

Give a brief description of the transmission mechanism, Give a brief descri...

Give a brief description of the transmission mechanism 1. When the central bank target rate increases, other interest rates in the economy will increase (and the money supply

Tariffs & quotas, the suitability of utilising a policy of tariffs and quot...

the suitability of utilising a policy of tariffs and quotas given the case of perfect competition.

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

State the both overnight target rates and inflation, Overnight target rates...

Overnight target rates and inflation One of the main targets of every central bank is a low and stable inflation. It's main control variable is the overnight interest rate targ

Explain about IS-LM-model, Q. Explain about IS-LM-model? The key differ...

Q. Explain about IS-LM-model? The key difference between the IS-LM model and the cross model is that nominal interest rate is exogenous in cross model on the other handit is en

Price and quantity of lumber, The price and quantity of lumber and other bu...

The price and quantity of lumber and other building materials has gone up recently. Show graphically and explain what might have caused this.

Price-elasticity of demand coefficient of a firm''s product, a) Use the arc...

a) Use the arc-approximation formula to calculate the price-elasticity of demand coefficient of a firm's product demand between the (quantity, price) points of (100, $20) and (300,

Online homework, I want you to do online homework as you did before on apl...

I want you to do online homework as you did before on aplia.com All questions are 10. They are in Aggregate Demand and Aggregate Supply The deadline within 24 hours. Please do

Unemployment, critically analyse the ways at which the govement of zimbabwe...

critically analyse the ways at which the govement of zimbabwe has put in place to address unequal employment opportunitiesbetween men andwomen

Analysis, provide data and analysis for the real GDP (as total and per capi...

provide data and analysis for the real GDP (as total and per capita) and its growth rate then draw a graph and identify the periods of the Malaysia’s business cycle 2007 -2011

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