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

Homework Help, An unanticipated demand-pulled inflation would normally lead...

An unanticipated demand-pulled inflation would normally lead to all the following problems except?

Difference between economic growth and economic development, What is the di...

What is the difference between economic growth and economic development? Growth is only individual dimension of development. Economic development is a complicated multi-dimensio

Each good as a final good or intermediate good, Classify each good as a fin...

Classify each good as a final good or intermediate good. (briefly explain wach choice) 1. running shoes 2. cotton fibers 3. watches 4. textbooks 5. coal 6. sunscr

Lewis model, what is the relevance of the lewis model

what is the relevance of the lewis model

Real exchange rates, Real Exchange Rates (EXCH) is the next variable that w...

Real Exchange Rates (EXCH) is the next variable that will be analysed in this VAR. The reason for including exchange rates in the VAR is that they are an important channel through

Determined at the intersection of the money demand, Consider the supply of ...

Consider the supply of money graph above. Which of the following can be determined at the intersection of the Money Demand and Money Supply curves? The rate of open market transact

How is economics work with interaction of individual choices, How is econom...

How is economics works with interaction of individual choices? Principles behind the interaction of individual choices: 1. There are gains through trade. • Specialization

Defective electric tooth brushes, Three defective electric tooth brushes we...

Three defective electric tooth brushes were shipped to a drug store by Clean Brush Products along with 17 non defective ones. A) What is the probability the first two electric t

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

Change in nominal gdp, By given scenario answer the following questions. ...

By given scenario answer the following questions. 1. What phase of the business cycle is the economy? 2. If inflation increased by 5% during the same period, what was the cha

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