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

State the term fall in the exchange rate, state the term fall in the exchan...

state the term fall in the exchange rate A fall in the exchange rate must make UK exports price competitive in international markets and increase demand for them. This should

Describe market interest rates, Q. Describe Market interest rates? The ...

Q. Describe Market interest rates? The most significant interest rates from a macroeconomic perspective are interest rates that government pays on the loans they use to finance

Elucidate the factors of global demand and supply, Many economists and mark...

Many economists and market analysts are avid followers of the BALTIC DRY INDEX (BDI) as a forward looking mechanism that may shed a bit of light on the evolution of global economic

Market index for small cap stocks, The Russell 2000 is a market index for s...

The Russell 2000 is a market index for small cap stocks - What do these changes in P/E ratios over last year tell you about current valuation in small caps and the different market

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

Define mortgage, When did mortgage? Default and housing foreclosure rates b...

When did mortgage? Default and housing foreclosure rates begin to rise rapidly? When did the economy go into recession? Was there a causal relationship between the two? Discuss.

State the both overnight target rates and inflation, Overnight target rates...

Overnight target rates and inflation One of the main targets of every central bank is a low and stable inflation. It's main control variable is the overnight interest rate targ

When ochratoxin molds can occur, Q. When Ochratoxin molds can occur? Oc...

Q. When Ochratoxin molds can occur? Ochratoxin A is a phenylalanyl derivative of a substituted isocoumarin produced by Penicillium verrucosum in temperate climate and by severa

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