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

Traight-line or soyd depreciation, Some equipment that costs $1000.00 has a...

Some equipment that costs $1000.00 has a 5-year depreciable life and an estimated $50 salvage value at the end of time. Determine whether to use straight-line or SOYD depreciation.

Maintaining the building of explicit cost, An owner can lease her building ...

An owner can lease her building for $100,000 per year for the next three years. The explicit cost of maintaining the building is $35,000, and the implicit cost is $50,000. All reve

Economic theory helps society, Do you agee or disagree " Economic theory he...

Do you agee or disagree " Economic theory helps society reach economic goals that it has selected for itself?" Justify your answer.

Equilibrium price and quantity of hybrid vehicles, Suppose gasoline and hyb...

Suppose gasoline and hybrid vehicles are substitutes. Draw a graph indicating what will happen in the market for hybrid vehicles if the price of gasoline increases. Be sure to labe

National income statistics, briefly explain any five uses of national incom...

briefly explain any five uses of national income statistics

Real GDP using chained-dollar method, 2012 Mangoes 91 boxes $7 a box ...

2012 Mangoes 91 boxes $7 a box Pinapples 56 boxes $12 a box 2013 Mangoes 108 boxes $14 a box Pinapples 70 boxes $8 a box Real GDP in 2013 using the chained-dol

Unemployment, Assume an economy that is operating above full employment. A....

Assume an economy that is operating above full employment. A. Draw a correctly labeled AD/AS graph showing: i. the problem in the economy ii. current price level and output iii. fu

Lag length criteria, Lag Length criteria VAR Lag Order S...

Lag Length criteria VAR Lag Order Selection Criteria         Endogenous variables: OIL EXCH R RPI LUNEMP GDP

Why gdp is determined only by aggregate demand, Q. Why GDP is determined on...

Q. Why GDP is determined only by aggregate demand? Note that we haven't said anything about the aggregate supply so far. In order to justify why GDP is determined only by aggre

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