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

International trade, how to maintain equilibrium gdp in foreign trade

how to maintain equilibrium gdp in foreign trade

What do you mean by capital flows, Q. What do you mean by Capital Flows? ...

Q. What do you mean by Capital Flows? With free capital flows, this is a very unreasonable assumption. If we domestic interest rate increase against the foreign interest rates,

How to control monetary policy, Q. How to control Monetary policy? Reme...

Q. How to control Monetary policy? Remember that the money supply is equal to the money multiplier times the monetary base. We will presume that money multiplier is constant an

Explain the economy automatic stabiliser, Explain the economy automatic sta...

Explain the economy automatic stabiliser A budget deficit is shortfall between a government's tax revenue and its spending in a given year. If a government runs a budget defici

Market determine who will get the goods and services, Think of a business f...

Think of a business firm you recently visited (such as Walmart, Home Depot, Red Lobster, Barnes & Noble, McDonald's, etc.). What motivated the producers of all the individual produ

Online homework, I sent to you an email for the online homework the deadlin...

I sent to you an email for the online homework the deadline through 10 hours all questions are about 10 please do it in full score

Net Exports and the price level, Ok... So if the price level is rising, th...

Ok... So if the price level is rising, this means that inflation is rising as well, so the value of the dollar in the US would decrease meaning that purchasing power decreases as

Show the adjustment process to new equilibrium using graph, Consider the mu...

Consider the multiplier model we have studied in class. Assume that the economy is initially in equilibrium and that real income is $180. The marginal propensity to expend is 0.66.

Homework, Potatoes cost Janice $0.50 per pound, and she has $5.00 that she ...

Potatoes cost Janice $0.50 per pound, and she has $5.00 that she could possibly spend on potatoes or other items. Suppose she feels that the first pound of potatoes is worth $1.50,

Chained dollar method and real gdp, how do I calculate the chained dollar m...

how do I calculate the chained dollar method for real gdp

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