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

Classical labour market, using a graph of the classical labour market illu...

using a graph of the classical labour market illustrste the effects of real wage existing in the market lower than the equilibrium real wage

Society seeks for monopolists, Society seeks for monopolists to operate at ...

Society seeks for monopolists to operate at the point where _______ = MC which is the lowest point on the ATC curve (the most efficient). A) D B) ATC C) MR D) AVC

Maximizing tax revenue, Normal 0 false false false EN-I...

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Calculate the overall efficiency and operating cost, A company is consideri...

A company is considering investing in power generation. It wants to setup a 1000 MW power generation system. The company hired you as a consultant to explore different options for

Define the natural rate of unemployment, Define the Natural rate of unemplo...

Define the Natural rate of unemployment Natural rate of unemployment is defined as the sum of rates of structural, frictional, and classical unemployment (excluding cyclical un

Gdp price index, Determine the GDP price index for 1984, using 2005 as the ...

Determine the GDP price index for 1984, using 2005 as the base year

Balance of payments, factors that causes the shifts in balance of payments...

factors that causes the shifts in balance of payments

Current value of investment, An investment promised a payoff of $195 two an...

An investment promised a payoff of $195 two and a half years from today. At a discount rate of 75% per year what is the present value of this investment? A. 169.47 B. Not enoug

Probabilities, Compute the following probabilities a) If Y is distribute...

Compute the following probabilities a) If Y is distributed N(1,4) find Pr(y ? 3) b) If Y is distributed N(3,9) find pr(y>0) c) If Y is distributed N (50,25) find pr(40?Y?5

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