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

Economic data required for the assignment, Must use current data! I do not ...

Must use current data! I do not need a response until later this week, so take your time. In addition, I will be using your information as reference only. I will not plagiarize. Th

Events x and y are mutually exclusive, The events X and Y are mutually excl...

The events X and Y are mutually exclusive. Suppose P(X)=.05 and P(Y) =.02. What is the probability of either X or Y occurring? What is not probability of X nor Y happens?

Market structures, illustrate and discuss the implications of variou market...

illustrate and discuss the implications of variou market structures (competitive and noncompetitive) for price determination

Moving along a demand curve, Moving along a demand curve, quantity demanded...

Moving along a demand curve, quantity demanded decreases 8 percent when price increases 10 percent. a. The price elasticity of demand is calculated to be____________ b. Given the

Properties of indifference curve, Properties of indifference curve:   P...

Properties of indifference curve:   Property I: Higher indifference curve gives higher utility.      Explanation: Since all goods are non-satiated, larger consumpti

What is gdp, Assuming an economy with no government and no foreign trade. M...

Assuming an economy with no government and no foreign trade. Measure GDP for the following output scenario: There are three firms: firm A is a minning company, firm B is a stee

Determined that the firm''s cost function, Robert's New Way Vacuum Cleaner ...

Robert's New Way Vacuum Cleaner Company is a newly started small business that produces vacuum cleaners and belongs to a monopolistically competitive market. Its demand curve for t

Explain about phillips curve, Q. Explain about Phillips curve ? The Ph...

Q. Explain about Phillips curve ? The Phillips curve  According to traditional Phillips curve, there is a negative and stable relationship between unemployment andwage in

Federal communications commission, A few years ago, the Federal Communicati...

A few years ago, the Federal Communications Commission (FCC) eliminated a rule that required Baby Bells to provide rivals access and discounted rates to current broadband facilitie

Equilibrium in money markit, equilibrium in money market and derivation of ...

equilibrium in money market and derivation of lm curve

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