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

Example of a party who lacks competence, The law requires that the parties ...

The law requires that the parties be competent to enter into a contract. Give an example of a party who lacks competence.

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

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

Name the largest budget deficit country, Name the largest budget deficit co...

Name the largest budget deficit country In 2009 Greece was eurozone country with largest budget deficit (about 16.0% of GDP), while Finland was the country with the smallest bu

Chartered a bus to atlanta, A group has chartered a bus to Atlanta. The dri...

A group has chartered a bus to Atlanta. The driver costs $200, the bus costs $500, and parking in Atlanta will be $90. You have already paid $700 to reserve the bus and a driver. T

Money and credit, MONEY AND CREDIT  In any modern economy, the quantity...

MONEY AND CREDIT  In any modern economy, the quantity of money, aggregate volume of credit and its sectoral composition are important variables which exert significant influenc

Full employment and the natural rate, Is the natural rate of unemployment f...

Is the natural rate of unemployment fixed? Why or why not? How are full employment and the natural rate of unemployment related? Is the actual rate of unemployment currently greate

Find real interest rate and nominal interest rate, #questionAssume that an ...

#questionAssume that an economy''s GDP Y=5000. Also assume that the government runs a deficit where tax revenue T=1000 and government expendituresG= 1500. The consumption function

New screening methods adopted price do you exect prevail, You are the manag...

You are the manager of an organization in America that distributes blood to hospitals in all 50 states and the District of Columbia. A recent report indicates that nearly 50 Americ

Elucidate elasticity of supply using the midpoint formula, An attorney supp...

An attorney supplies 40 hours of work per week when her fee is $100 per hour but supplies 60 hours of work per week when her fee rises to $120 per hour. Using the midpoint formula,

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