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

Perfectly competitive firm, Consider the following demand schedule. Does it...

Consider the following demand schedule. Does it apply to a perfectly competitive firm? Compute marginal and average revenue Price Quantity Price Quantity $95 2 $55 5 $88 3 $40 6 $

Value of this expansion project, Bruno's Lunch Counter is expanding and exp...

Bruno's Lunch Counter is expanding and expects operating cash flows of $26,000 a year for 4 years as a result. This expansion requires $39,000 in new fixed assets. These assets wil

Telemarketer makes six phone calls, A telemarketer makes six phone calls pe...

A telemarketer makes six phone calls per hour and is able to make a sale on 30 percent of these contacts. During the next two hours, find: A) The probability of making exactly four

Country club bills, Suppose the country club bills based on a sample of 4 m...

Suppose the country club bills based on a sample of 4 members are: 358, 958, 665, 846. What is the standard deviation for this sample of bills? (please round your answer to 1 decim

ENC 312, what have you learned from the class

what have you learned from the class

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

Business cycle, which turning point marks the end of an economic prosperity...

which turning point marks the end of an economic prosperity and the start pf contraction

What is the real interest rate, The real interest rate Interest rates ...

The real interest rate Interest rates and inflation Suppose you have 1 million on 1st January 2008. A basket of goods and services similar to the CPI basket costs 100,000.

Explain why quantitative measures, Suppose a company is considering two inv...

Suppose a company is considering two investment projects. Both projects require an upfront expenditure of $30 million. The company estimates that the cost of capital is 10% and tha

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