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

Analyze the effects of discrimination in labor markets, To analyze the effe...

To analyze the effects of discrimination in labor markets, use supply and demand curves for labor, with the demand curves representing the value of the marginal product, show the e

Describe classical model of macroeconomics, Q. Describe classical model of ...

Q. Describe classical model of macroeconomics? Though we use the term ‘the classical model' as if there were just one classical model, this isn't quite true. For all the models

How central banks increase the monetary base, How central banks increase th...

How central banks increase the monetary base When the Central Bank cuts the target rate, they must simultaneously increase the monetary base by buying government securities. The

Money supply in the mauritian financial sytem, Question 1: Discuss the ...

Question 1: Discuss the alternative theories of the demand for money and their relevance in specifying a demand for money function for a small island developing economy like

Marginal product of labor and marginal product, How Walmart''s marginal pr...

How Walmart''s marginal product labor related to its marginal product?

Gkx industries expects sales of its hydraulic seals, GKX Industries expects...

GKX Industries expects sales of its hydraulic seals (in inch and metric sizes) to increase according to the cash flow sequence $70+4k, where k is in years and cash flow is in $1000

Circular flow of income in a simple economy income consumed, The circular f...

The circular flow of income in a simple economy where all income is consumed  The operation of forces in an economy can be expressed in the form of a circular flow of incomes a

The micro-finance institutions in india, Have the micro-finance institution...

Have the micro-finance institutions failed in their objectives?

Economic system: protectionism and free trade, why is international trade i...

why is international trade important for South Africa?

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