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 is the price elasticity of demand, Consider the following utility func...

Consider the following utility function: U = X 1 X 2 Where X 1 and X 2 are quantities consumed of two goods. You are considering the actions of a consumer that maxi

What is causing the rise in the price of oil, The rise in the price of oil ...

The rise in the price of oil can be traced to a easy factor, but there are various other contributing factors. The easiest explanation is that the demand for oil is greater than

Licensed drivers revealed the following number of speeding, A sample of 2,0...

A sample of 2,000 licensed drivers revealed the following number of speeding violations. 0 violations for 1,910 drivers. 1 Violations for 46 drivers. 2 violations for 18 drivers. 3

Unemployment rate, Unemployment rate (LUNEMP): A key variable to assess...

Unemployment rate (LUNEMP): A key variable to assess the performance of any economy when an economy is growing, the unemployment rate will fall as job creation increases and in

Fact that price and quantity, The fact that price and quantity demanded are...

The fact that price and quantity demanded are related negatively illustrates the? a. law of supply b. law of quantity supply c. law of demand d. law of quantity demande

Same Basket of Goods, assume the cost of a market basket in 2008 is 1717.0....

assume the cost of a market basket in 2008 is 1717.0. Calculate the cost of the same basket of goods and services in 2007. Price index in 2008 was 100 and price index in 2007 was

Why marketers are interested in discretionary income, Because discretionary...

Because discretionary Income = the money people have left over once they have paid for all of their basic needs (Food, Clothing, Shelter). You could also call it Disposable Inc

Enumerate in detail about the financial markets, The Government, Rest of th...

The Government, Rest of the World and the financial markets Total expenditure of the government may be divided into two parts: transfers to the private sector and consumpti

explain how to solve the evacuation-route problem, You are the mayor of a ...

You are the mayor of a beautiful city by the ocean, and your city is connected to the mainland by a set of k bridges. Your city manager tells you that it is necessary to come up wi

What are the indicators of development, What are the indicators of developm...

What are the indicators of development? Economic development is a complicated multi-dimensional idea. Preferably each aspect of development needs its own indicator. • Prof

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