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

When patulin molds can occur, Occurrence: It is found in a range of foods b...

Occurrence: It is found in a range of foods based on fruits. Presence of patulin in fruit juice is a indication that the juice was extracted from poor quality fruit which is undesi

Macro, Over long spans of time, macroeconomies typically grow, but over sho...

Over long spans of time, macroeconomies typically grow, but over short spans there are fluctuations in output and prices known as ____ ?

Define price elasticity of demand, Suppose the price elasticity of demand f...

Suppose the price elasticity of demand for used cars is estimated to be 3 what does this mean?

Determine the velocity of circulation, The demand for nominal balances rise...

The demand for nominal balances rises with the price level. At the similar time inflation causes the real demand for money to fall. Describe how these two assertions can be both co

IS and LM model, An economy shows the following features C=50+0.9(Y-T) T=1...

An economy shows the following features C=50+0.9(Y-T) T=100 I=100-5i G=100 L=0.2Y-10i M/P=100 X=20 M=10+0.1Y a)Obtain the IS and LM for this economy b)Find out the equilibrium inc

What is the meaning of capital - Gross domestic product, What is the meanin...

What is the meaning of Capital - Gross domestic product By capital we characteristically mean manufactured goods which are used to produce other goods and services though are

Determine nominal & real demand for money., Suppose that the quantity theor...

Suppose that the quantity theory of money holds & the velocity of money are constant at 5. Output is fixed at its full employment value of 10,000 & the price level is 2. a) Ver

What is the marginal product, What is the marginal product? The margina...

What is the marginal product? The marginal product of an input is the extra quantity of output which is generated by using one more unit of which input. Marginal product of

Calculating the accounting and economic profit , Kate uses a sewing machin...

Kate uses a sewing machine to alter and repair clothes for one year in her own small business, Kate's Tailoring. She earns $20,000 during the year for various sewing projects. In t

Gdp, The following is the information from the national income accounts for...

The following is the information from the national income accounts for a hypothetical country: GDP Rs. 6000.00 Gross Investment Rs. 800.00 Net Investment Rs. 200.00 Consumption Rs.

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