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

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

Index numbers of production, INDEX NUMBERS OF PRODUCTION  Among the com...

INDEX NUMBERS OF PRODUCTION  Among the commonly used economic indicators to monitor current trends in the economy are indices of production. The main aggregative indices used t

Reserves and a reserve requirement, If the Banking system has $500,000 in d...

If the Banking system has $500,000 in demand deposit liabilities, $125,000 in total reserves and a reserve requirement of 15%: What is the maximum amount by which the money supply

Imperfect-information model, According to the imperfect-information model, ...

According to the imperfect-information model, when the price level is greater than the expected price level, output will _____ the natural level of output A) be greater than

Credit multiplier, how can the central bank influence the size of the multi...

how can the central bank influence the size of the multiplier

What are the advantages of regional integration, Benefits of Regional Integ...

Benefits of Regional Integration Most economic experts cite that regional integration permits disadvantaged countries to realize economies of scale, vie on a broader (often gl

Interest rates with different maturities, Including different interest rate...

Including different interest rates with different maturities would complicate the models however it wouldn't buy you very much. Because interest rates with different maturities are

Classical model, using a graph of the classical labour market,illustrate th...

using a graph of the classical labour market,illustrate the effects of a real wage existing in the market that is lower than the equilibrium real wage.What will eventually happen i

Moving along a demand curve, Moving along a demand curve, quantity demanded...

Moving along a demand curve, quantity demanded decreases 8 percent when price increases 10 percent. a. The price elasticity of demand is calculated to be____________ b. Given the

Engine performance in general are not adversely affected, Henry Ford's Mode...

Henry Ford's Model T was originally designed and built to be run on ethanol. Today, ethanol (190-proof alcohol) can be produced with domestic stills for about $0.75 per gallon. Whe

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