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

What are the important tools to consider monetary policy, What are the impo...

What are the important tools to consider Monetary Policy? Important tools to consider Monetary Policy: a. What the money demand curve is b. Why the liquidity preference m

Particular group of mutual funds, Suppose the returns of a particular group...

Suppose the returns of a particular group of mutual funds are normally distributed with a mean of 9.1% and a standard deviation of 5.1%. If the manager of a particular fund wants h

Accounting system-example ii, ACCOUNTING SYSTEM-EXAMPLE Let us now intr...

ACCOUNTING SYSTEM-EXAMPLE Let us now introduce a complication. There are three firms in the production sector. The Fruit Extracts Company manufactures from raw fruit, fruit ext

Calculate percent removal pollutant and steady state, You are considering t...

You are considering three design alternatives for treating a pollutant in wastewater using a first-order process ( k = 1 min -1 ). The total flow is 10 million gallons per day (mg

What is net present worth for new computer system, Kermit is considering pu...

Kermit is considering purchasing a new computer system. The purchase price is $106,430. Kermit will borrow one-fourth of the purchase price from a bank at 10 percent per year compo

Describe the short run effect of the supply shock, Question : The long-...

Question : The long-run position of an economy is described by the quantity theory of money: M/P = L (Y, r) Where M: nominal money stock; P: price level; Y: real income a

Describe exports and imports in as-ad model, Q. Describe Exports and import...

Q. Describe Exports and imports in AS-AD model? Exports and imports. This is more difficult to justify owing to exchange rate. Suppose that we have a flexible exchange rate a

Find out fixed cost and average cost, Sara runs a small business assembling...

Sara runs a small business assembling personal computers. This table shows her total cost at different levels of output. Number of computers produced

Cost benefit analysis-vat, (1) Based on the article, describe as best you c...

(1) Based on the article, describe as best you can: (i) the reference group for the cost benefit analysis, (ii) the purpose of the study (i.e., what is the "project" in this

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