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

Major economic indicators, A. What are the major differences between capita...

A. What are the major differences between capitalism, communism, and socialism? B. Discuss the three major economic indicators and how they are indicative of our current economi

Passive deficit is the portion, A passive deficit is the portion of the def...

A passive deficit is the portion of the deficit that exists when: A. inflation is not fully anticipated. B. inflation is fully anticipated. C. the economy is at potential income. D

State the market for overnight loans, State the market for overnight loans ...

State the market for overnight loans Overnight interest rates are rates for loans over a single night - these are the shortest of all interest rates. During the day, banks norm

Accounting system-example iii, ACCOUNTING SYSTEM-EXAMPLE III  Now suppo...

ACCOUNTING SYSTEM-EXAMPLE III  Now suppose the Jam Co. manufactures some herbal chemicals and flavors which it sells partly to Extracts Co., partly to Bottling Co., some are co

#title.national income ddetermkination, explain how national income is dete...

explain how national income is determined under the following economies; 1.frugal economy 2.governed economy

Show the ad curve over time, Q. Show the AD curve over time? With infla...

Q. Show the AD curve over time? With inflation, AD curve will no longer be stable over time. In its place, it will glide upwards or downwards at a rate determined by growth rat

Types of taxes and laffer curve, Types of Taxes Which a Government can impo...

Types of Taxes Which a Government can impose on the citizens are as follows: With the theory of taxation covered, we can now move towards the actual menu of the taxes the gover

Elasticity of supply, The supply equation for widgets is P = 100 + 10QS. Th...

The supply equation for widgets is P = 100 + 10QS. The elasticity of supply between quantity supplied of 9 and 11?

Explain the basic characteristics of IS-curve, Q. Explain the basic charact...

Q. Explain the basic characteristics of IS-curve? IS-LM diagram IS-curve The IS curve shows all combinations of R and Y where the goods marketis in

What do you mean by yield curve, Q. What do you mean by yield curve? Yi...

Q. What do you mean by yield curve? Yield curve is a graph of interest rates of different maturity (recalculated to yearly rates) at a specific point in time. It's common for t

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