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

GDP AND PRICE LEVEL IN SHORT RUN, #question.WHAT IS GDP AND DIFFERENT PRICE...

#question.WHAT IS GDP AND DIFFERENT PRICE LEVEL IN SHORT RUN?.

When patulin molds can occur, Occurrence: It is found in a range of foods b...

Occurrence: It is found in a range of foods based on fruits. Presence of patulin in fruit juice is a indication that the juice was extracted from poor quality fruit which is undesi

What is gdp, Assuming an economy with no government and no foreign trade. M...

Assuming an economy with no government and no foreign trade. Measure GDP for the following output scenario: There are three firms: firm A is a minning company, firm B is a stee

Explain the term- inventory investment, Explain the term- inventory investm...

Explain the term- inventory investment We would have a negative inventory investment whenever inventories decrease. By net investments we mean gross investments minus depreciat

Show factors that govern the price elasticity of demand, Q. Show factors th...

Q. Show factors that govern the Price Elasticity of Demand? a. The number and closeness of the substitutes- The more and the better the substitutes, the grater is the Price Ela

Fed would cause the money supply, One alternative way to calculate the tota...

One alternative way to calculate the total change in money supply when the Fed injects money into the economy or takes away money from the economy is the amount of money injected o

Illustrate the uk macroeconomic performance, Illustrate the UK macroeconomi...

Illustrate the UK macroeconomic performance UK macroeconomic performance must be judged on economy's long-term ability to produce growth, create jobs and improve living standa

Determine about the expected inflation, Determine about the Expected inflat...

Determine about the Expected inflation Note that it is changes in prices during 2008 which matter for the high real interest rate (the time period when your deposit is earning

Change in the dependent variable, All other things being held constant, wha...

All other things being held constant, what is the change in the dependent variable for a unit change in the first independent variable for the multiple regression equation: ? = 5.2

Automatic stabilizer, what is automatic stabilizer, example with diagram or...

what is automatic stabilizer, example with diagram or graph please

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