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

Nine patients are selected at random, A recent study in NJ showed that 50% ...

A recent study in NJ showed that 50% of all patients will return to the same dentist. Suppose nine patients are selected at random, what is the probability that: (a) exactly five o

What are the comparative benefits, What are the comparative benefit The...

What are the comparative benefit The idea of comparative benefit defines that a nation must specialise in the industries in which it has a comparative advantage. Comparative be

Find the equivalent array-array factor, A 90 o perfectly conducting corner...

A 90 o perfectly conducting corner cube reflector has a shortdipole (oriented in the z-direction) placed at a distance d from the vertex. The antenna is fed by current Io. a) F

Money supply, different between money multplier vs credit multplier ?

different between money multplier vs credit multplier ?

Retirement planning, For retirement planning, you decided to deposit $1,000...

For retirement planning, you decided to deposit $1,000 per month and increase your deposit by $100 per month. How much will you have at the end of 10 years if the bank pays 3% annu

Explain the following equation, Which of the following equations is FALSE f...

Which of the following equations is FALSE for perfectly competitive firms? A. Total cost = fixed cost + variable cost B. Marginal cost = change in total cost / change in quantity o

Describe a hypothetical ideal, Design a hypothetical ideal randomized contr...

Design a hypothetical ideal randomized controlled experiment to study the effects on highway traffic deaths of wearing seat belts. Suggest some impediments to implementing this exp

Evaluate the additional social loss, A monopoly has a total cost function o...

A monopoly has a total cost function of C(Q) = 8Q and faces a market demand Q = 100 ? 2p, (a) calculate the deadweight loss; (b) The firm now spent an amount equal to half of

Explain the basic characteristics of IS-curve, Q. Explain the basic charact...

Q. Explain the basic characteristics of IS-curve? IS-LM diagram IS-curve The IS curve shows all combinations of R and Y where the goods marketis in

Calculate the value of a maximum flow, The following network N has sourc...

The following network N has source S and sink T with arc capacities as shown. (a) Use the maximum flow algorithm to find a maximum flow from S to T and draw a diagram

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