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

Servicing the maximum number of patients, A clinic uses doctors and nurses ...

A clinic uses doctors and nurses optimally and is servicing the maximum number of patients given a limited annual payroll. The last doctor hired treated 1,600 extra patients in a y

Value to change expect the market, You just inherited a house with a market...

You just inherited a house with a market value of $300,000, and do not expect the market value to change. Each year, you will pay $1,000 for utilities and $3,000 in taxes. You can

Average cost curve, A firm with a U-shaped average cost curve finds that it...

A firm with a U-shaped average cost curve finds that its revenues exceed its costs when it sets price equal to marginal cost. On which part of its average cost curve is the firm op

The growth of per-capita gdp in the period immediately, An economy has the ...

An economy has the following parameter values: s ?=.3,d ?=.1,A ?=1,andL ?=100.2 The economy begins at steady state but at some point is attacked by Godzilla, destroying 70% of the

Unemployed individual decides to spend the day fishing, 1. An unemployed in...

1. An unemployed individual decides to spend the day fishing. The opportunity cost of fishing is equal to A) The cost of bait and any other monetary expenses. B) Zero, becaus

Labor Economics, Assume Workers Comp awards $X to workers not working becau...

Assume Workers Comp awards $X to workers not working because of injury. $X is set to equal the workers previous wages. Once workers return to work, the award payments stop. Suppose

The structural deficit, The structural deficit: A. falls as the economy exp...

The structural deficit: A. falls as the economy expands and rises when it contracts. B. changes as actual income changes regardless of potential income. C. does not change when inc

Rapidly rises housing prices, Why did housing prices rise rapidly during 20...

Why did housing prices rise rapidly during 2002-2005? Why did the mortgage default rate increase so sharply during 2006 and 2007 even before the 2008-2009 recession began?

Functions of commercial bank - granting a loan, Granting a ...

Granting a loan: When commercial banks lend, they create money. This can be explained by extending the hypothetical example of Bank

Price of new equilibrium, Explain the adjustment to the new equilibrium pri...

Explain the adjustment to the new equilibrium price from an increase in demand.

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