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

Give brief introduction about interest rate, Give brief Introduction about ...

Give brief Introduction about Interest rate When you borrow money, you usually have to pay a fee for the loan. This fee is often called interest, particularly if the fee is pr

Credit multiplier, what is credit multiplir and how does it work

what is credit multiplir and how does it work

International trade, why is international trade important south africa

why is international trade important south africa

Balance of payments, state and explain two factors that cause the shifts in...

state and explain two factors that cause the shifts in the balance of payments curve.

Elucidate elasticity of supply using the midpoint formula, An attorney supp...

An attorney supplies 40 hours of work per week when her fee is $100 per hour but supplies 60 hours of work per week when her fee rises to $120 per hour. Using the midpoint formula,

Principles of macroeconomics, what is the company lidted in NASDAQ that is ...

what is the company lidted in NASDAQ that is included in the dow jones industrial average

Wal-marts supply chain management, Explain the impact of Wal-Mart's supply ...

Explain the impact of Wal-Mart's supply chain management on its total product, marginal product, and average product curves. What has been the effect on its retail prices?

Discuss about asymmetric information, A) With asymmetric information, free ...

A) With asymmetric information, free markets may not lead to efficient outcomes because the market for a service or product may break down due to adverse selection. Explain what ad

Calculate the income elasticity and good , Due to the recent downturn in e...

Due to the recent downturn in economic activity, Taz, has seen his hours at work reduced. He used to work 30 hours a week at $13 and hour, but now he works 22 hours. Due to this

Aplia Assignment, Need answers for problems after chapters 10, 11 & 12 for ...

Need answers for problems after chapters 10, 11 & 12 for Macroeconomics in Aplia.com. Need today or tomorrow. Can you help?

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