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

Determine why banks raise their interest rates, Determine Why banks raise t...

Determine Why banks raise their interest rates A way to explain why banks raise their interest rates is as follows. With higher overnight interest rates, it is more expensive fo

Nash equilibrium or equilibria, Suppose A can somehow change the game in pr...

Suppose A can somehow change the game in problem 5.1 to a new one in which his payoff from Up is reduced by 2, producing the following payoff matrix. a. Find the Nash equilibriu

Federal communications commission, A few years ago, the Federal Communicati...

A few years ago, the Federal Communications Commission (FCC) eliminated a rule that required Baby Bells to provide rivals access and discounted rates to current broadband facilitie

Apparent paradox, Explain the apparent paradox that saving money is good fo...

Explain the apparent paradox that saving money is good for the individual but might be bad for the economy. Considering the circular flow diagram how is this relevant to public pol

Unusually high period, The consumer price index for the 1978-82 periods and...

The consumer price index for the 1978-82 periods and the GDP deflator follow. This was a period of unusually high, but declining, inflation. (The CPI is equal to 100 in the base ye

Different of cost, discuss the different of cost?draw the cost curves

discuss the different of cost?draw the cost curves

The effect of market for milk, 1a. Show on the market for milk the effect o...

1a. Show on the market for milk the effect of the introduction of BGH (bovine growth hormone). 1b. Show on the market for cheese the impact of what happened in the milk market.

Calculate tax equilibrium quantity, 1. Consider two projects.  The fir...

1. Consider two projects.  The first project pays benefits of $90 today and nothing else.  The second project pays nothing today, nothing one year from now, but $100 two

Help, Given the following data for StewieLand, a closed economy in 2012… r...

Given the following data for StewieLand, a closed economy in 2012… real gdp = $20,000 public savings = $1,000 consumption = $11,000 tax revenue collected = $4,000 Solve for

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