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

High blood pressure affected, To determine whether high blood pressure affe...

To determine whether high blood pressure affected whether a person had a stroke, a sample of 129 people who had had strokes are examined. In the sample, 39% had high blood pressure

Trade liberalisation under wto, TRADE LIBERALISATION UNDER WTO: In  th...

TRADE LIBERALISATION UNDER WTO: In  the Uruguay Round negotiations, India agreed to reduce tariff on a  large number of  commodities and  remove quantitative restrictions (QRs

Described as a market in equilibrium, Camping at Wilson's Promontory, a nat...

Camping at Wilson's Promontory, a national park in Victoria, isn't free, but for many years now not everyone who wants to camp at Wilson's Promontory during the Christmas holidays

Expenditure methods, Expenditure method is also called Flow-of-Expenditure ...

Expenditure method is also called Flow-of-Expenditure method, consumption and investment method, income Disposal method, etc. Expenditure method measures the final expenditure

Consumption, Consider two consumers, A and B. A and B both want perfect con...

Consider two consumers, A and B. A and B both want perfect consumption smoothing (c = cf) and both have no current wealth. However, the two consumers have different income streams.

New screening methods adopted price do you exect prevail, You are the manag...

You are the manager of an organization in America that distributes blood to hospitals in all 50 states and the District of Columbia. A recent report indicates that nearly 50 Americ

Economic system is the best solution, Which economic system is the best sol...

Which economic system is the best solution to handling a crisis of epic proportion?

Derive the engel curve for shortbread cookies, Jen spends all her income on...

Jen spends all her income on shortbread cookies (S) and cupcakes (C). Her utility function is given by: U(S,C) = S +2C. Suppose that Jen has an income of $10 and that a cupcake cos

Production possibilities curve, Using a production possibilities curve, an ...

Using a production possibilities curve, an economy that produces an output combination less than the maximum possible is depicted by a point located. a. at the top corner of the

Gross domestic capital formation, Gross Domestic Capital Formation  Pro...

Gross Domestic Capital Formation  Production requires services of fixed assets such as machinery, equipment and structures as well as working capital i.e. stocks of raw materia

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