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

Other bankers and wall street firms, Some charge that the Crisis of 2008 wa...

Some charge that the Crisis of 2008 was caused by the "greed" of Wall Street firms and other bankers. Do you agree with this view? Do you think there was more greed on Wall Street

Compute total demand and firms profit, Suppose three identical firms are e...

Suppose three identical firms are engaged in Cournot competition in quantities. They all have marginal costs equal to 40. Market demand is given by: P(X) = 200 - X = 200 - (x

Aplia Chapter Questions, Need answers for the questions (Chapters 10, 11 & ...

Need answers for the questions (Chapters 10, 11 & 12) Please see attached questions. Thanks!

Money demand function, Assume that the money demand function is (M/P) d = 2...

Assume that the money demand function is (M/P) d = 2,200 - 200r, where r is the interest rate in percent. The money supply M is 2,000 and the price level P is2. If the price level

Explain about a model and use of it in economics, Explain about a model and...

Explain about a model and use of it in economics. A model is a simplified demonstration of a real situation which is used to better understand real-life circumstances. The

How do you explain gni per capita, To determine of the wealth is earned by ...

To determine of the wealth is earned by nations by economic activates all around the globe. Gross National Income comprises the total value of goods and services formed within a

Money supply, different between money multplier vs credit multplier ?

different between money multplier vs credit multplier ?

Ketch the bakerys average cost curve, A bakery has fixed costs of $10 per d...

A bakery has fixed costs of $10 per day and variable costs of $1 per loaf. Its oven can handle up to 50 loaves a day and it is impossible to obtain additional capacity. Sketch the

Marginal cost of care, Given the following MV information, what is the opti...

Given the following MV information, what is the optimal allocation of care according to the Preteens criteria, when the marginal cost of care is constant at $100. Person A Person B

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