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

Unemployment, Find the labor force, the working-age population, the number ...

Find the labor force, the working-age population, the number of employed workers, and the number of unemployed workers. Unemployment rate 5.60 % Participation rate 62.50

Production possibility curve, PRODUCTION POSSIBILITY CURVE As we have s...

PRODUCTION POSSIBILITY CURVE As we have seen, the essence of economic analysis is the problem of scarcity and choice. We know that limited productive resources compel individua

Shift in the demand to the right mean, What does a shift in the demand to t...

What does a shift in the demand to the right mean? Why does the demand curve shift?

Money illusion, A significant argument for the augmentation has to do with ...

A significant argument for the augmentation has to do with concept of money illusion. Money illusion means that you care about nominal rather than real amounts. Imagine that your s

Explain about the diminishing returns to an input, Explain about the dimini...

Explain about the diminishing returns to an input. There are diminishing returns to an input while an increase within the quantity of which input, holding the levels of each of

Develop the mrp planning schedule, Product A is an end item and is made fro...

Product A is an end item and is made from two units of B and four of C. B is made of three units of D and two of E. C is made of two units of F and two of E. A has a lead time o

Estimate the probability density function, It is assumed that the hazaed ra...

It is assumed that the hazaed rate for a pressure valve is given by h(t)= 1/5+t. 1. What is the cumulative probability function of failure F(t)? 11. What is probability densi

What are the potential disadvantages of growth, What are the potential disa...

What are the potential disadvantages of growth? The potential disadvantages of growth are as follows: • Raised pollution, • Depletion of non renewable natural resources

Example of indirect taxes and subsidies- accounting system, Example of Indi...

Example of Indirect Taxes and Subsidies- ACCOUNTING SYSTEM   We now permit our government to impose what are called indirect taxes. This category includes sales tax, excise tax,

MARKET, COMPARE AND CONTRAST CLASSICAL MODEL AND KEYNESIAN THEOTY

COMPARE AND CONTRAST CLASSICAL MODEL AND KEYNESIAN THEOTY

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