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

GDP AND PRICE LEVEL IN SHORT RUN, #question.WHAT IS GDP AND DIFFERENT PRICE...

#question.WHAT IS GDP AND DIFFERENT PRICE LEVEL IN SHORT RUN?.

Result of an export subsidy, Which of the following is a result of an expor...

Which of the following is a result of an export subsidy? a. The imposing nation always benefits from an export subsidy. b. The imposing nation suffers a terms of trade loss from an

Distinguish static and dynamic gains from trade, Question 1: Critically...

Question 1: Critically analyse the costs of inflation. Which of these items is likely to have encouraged many governments in their adoption of inflation as public enemy number

Show the changes in the exchange rate, Q. Show the Changes in the exchange ...

Q. Show the Changes in the exchange rate? Assume that United States is our home country and the current euro exchange rate in direct notation is SD = 1.5 (euro/USD). In indirec

Best estimate of real gdp, Consumption = $3 trillion, Investment spending =...

Consumption = $3 trillion, Investment spending =$2 trillion, Government purchases = $2 trillion, net exports via the ROW is $0 trillion. 1. What is the best estimate of real GDP

Annual fixed cost for a light fixture, The annual fixed cost for a light fi...

The annual fixed cost for a light fixture manufacturing company are $38,000, and the variable costs are $40 per unit. If the selling price per unit is p = 485 - 1.395X, what is the

Explain function of AS-AD model, Q. Explain function of AS-AD model? Th...

Q. Explain function of AS-AD model? The function of AS-AD model is to extend IS-LM model so that we can analyze situations where Y > Y OPT . To achieve this, we should make P e

Show the example on multiplier effect, Q. Show the example on multiplier ef...

Q. Show the example on multiplier effect? Emma makes a deposit:         Emma has 1,000 in her mattress and decides to deposit it in K-bank. Deposit won't affect the money

Real gdp growth rate of an economy, a.  State concisely, in your own words,...

a.  State concisely, in your own words, the essence i.of what GDP measures and ii.what GDP doesnot measure.  b.  Stocks and bonds issued by firms comprise the "Investment" co

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