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

Break-even level of income, Assume that when an economy has a GDP of $500, ...

Assume that when an economy has a GDP of $500, Consumption is $550. The MPC is .75. Investment is 25. Begin the problem by setting up an Income/Consumption Schedule like the one on

Show the example on IS-curve, Q. Show the example on IS-curve? Fi...

Q. Show the example on IS-curve? Figure We can explain this argument with the above figure.  1. Start by identifying R 1 and R 2 in lower graph.  2. Draw aggr

Increase demand for diamonds and in supply of diamonds, Suppose there is a ...

Suppose there is a simultaneous increase in the demand for diamonds and increase in the supply of diamonds. Which of the following will occur as a result of these simultaneous even

Multiplier, multiplier static and dynamic

multiplier static and dynamic

Static and dynamic multiplier, The formula for calculating static and dyna...

The formula for calculating static and dynamic multiplier

Marginal approach to profit maximization, The marginal approach to profit m...

The marginal approach to profit maximization means that a firm should produce until a. marginal revenue equals zero b. marginal revenue equals marginal costs c. marginal cost becom

What is money wage rate, What is money wage rate While the money wage ...

What is money wage rate While the money wage rate or nominal wage rate is the hourly wage rate calculated in money that a worker receives for supplying labour, the real wage r

Determination of all endogenous variables, Determination of all endogenous ...

Determination of all endogenous variables  We can explain how all the endogenous variables are determined in below figure:  Figure: The Keynesian model with the Phillips c

Illustrate the overview and importance of macroeconomics, Illustrate the ov...

Illustrate the overview and importance of macroeconomics? After familiar with this illustration, able to know: a. An overview of macroeconomics is the study about the econom

Standard deviation for sample bills, Suppose the country club bills based o...

Suppose the country club bills based on a sample of 4 members are: 383, 1,051, 637, 928. What is the standard deviation for this sample of bills? (please round your answer to 1 dec

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