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

Tax-deductible and interest rate, Suppose that Lilistan has two types of ci...

Suppose that Lilistan has two types of citizens: low-income citizens (income = $20,000) and high-income citizens (income = $80,000). Interest income is currently taxed and each typ

Influence the risk accompanying long-term contracts, What impact will high ...

What impact will high and variable rates of inflation have on the economy? How will they influence the risk accompanying long-term contracts and related business decisions?

Macroeconomic problems, Question 1: The common characteristics of LDC...

Question 1: The common characteristics of LDCs include low GDP per capita, capital scarcity, high unemployment, chronic budget deficit, high levels of external debt, hig

Bop on capital account, BOP on Capital Account: BOP on Capital Account...

BOP on Capital Account: BOP on Capital Account  shows only export and import of capital and  the difference between  the  two represents a country's capital account balance. C

Basic concepts and terminology, when domestic currency becomes more valuabl...

when domestic currency becomes more valuable in terms of foreign currency, the domestic currency is said to have

Explain the facts or economics rate, Explain the facts or economics rate ...

Explain the facts or economics rate Boom: The period leading up to the peak of the cycle when an overheating economy is experiencing high GDP growth and inflationary pressures

Explain reversed say''s law, Q. Explain Reversed Say's Law? In the cros...

Q. Explain Reversed Say's Law? In the cross model, supply should instead follow demand. Cross model not only rejects Say's Law, it turns it entirely upside down. In the cross m

Changes in price promotion, An end-of-aisle price promotion changes the pri...

An end-of-aisle price promotion changes the price elasticity of a good from -2 to -3. If the normal price is $10, what should the promotional price be?

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

Determine the experimental design, An ecologist is interested in the possib...

An ecologist is interested in the possible negative effects of marinas and boat mooring areas on the abundances of fish. Having read Hurlbert's paper about pseudoreplication, he de

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