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 are the social economic and non economic factors, What are the social ...

What are the social economic and non economic factors? Development is also a procedure involving change in some social economic and non economic factors comprising: • Econom

Gross domestic savings, Gross Domestic Savings  Income not devoted to ...

Gross Domestic Savings  Income not devoted to current consumption is saved. In an economy during a particular year some units will consume less than their income while some wi

Economic functions of money - a medium of exchange, Economic functions of m...

Economic functions of money - A medium of exchange This is its most important role. Without money we would live in a barter economy where we would have to trade goods and

Compare and contrast federal government expenditures, Compare and contrast ...

Compare and contrast federal government expenditures, state and local government expenditures, and financing government expenditures. Suggest a total of three actions that should b

Determine the current in the neutral conductor, A 415V, 3-phase, 4 wires, s...

A 415V, 3-phase, 4 wires, star-connected system supplies three resistive loads as shown in Figure. Determine (a) The current in each line and (b) The current in the neutr

Determine the exchange rate, Q. Determine the Exchange rate? Exchange r...

Q. Determine the Exchange rate? Exchange rate is determined by the ratio of domestic price level to the foreign price level. If, for instance domestic prices increase by 10% wh

Last deposit if your saving account, You make a monthly deposit of $1,000 i...

You make a monthly deposit of $1,000 into a saving account for the next 10 years. How much can you withdraw immediately after your last deposit if your saving account pays 6% per y

Fiscal stimulas, Suppose the consumption function is C = $500 billion + 0.5...

Suppose the consumption function is C = $500 billion + 0.55Y and the government wants to stimulate the economy. By how much will aggregate demand at current prices shift initially

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