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

The multiplier analysis , THE MULTIPLIER ANALYSIS  Multiplier analysis ...

THE MULTIPLIER ANALYSIS  Multiplier analysis explains what happens to circular flow of economic life when the behavior of one of the sectors or the components of aggregate dema

Consumer surplus and producer surplus, Suppose the inverse demand curve for...

Suppose the inverse demand curve for a market is equal to p = 100 -- 0.3Q. The inverse market supply curve is p = 20 + 0.5Q. 1. Calculate the equilibrium price and quantity;

Supply-side economics market freedom, What is Supply-side Economics Market ...

What is Supply-side Economics Market Freedom? Markets must be allowed to work more freely and steps taken to improve this efficiency by:   freeing them from governm

The circular flow of income in an open economy, The circular flow of income...

The circular flow of income in an open economy   An open economy is one in which international trade exists. Assume also that there is government spending and taxation. Thus

Illustrate diffrent types of money, Q. Illustrate diffrent types of money? ...

Q. Illustrate diffrent types of money? In most countries, one may identify two 'types of money': Bank deposits Currency and coins   The total value of all th

General principles of marginal and average total cost curves, What are the ...

What are the general principles about marginal and average total cost curves? General principles which are always true concerning a firm’s marginal and average total cost curve

Dynamic muliplier, distinguish between state and dynamic multiplier and ill...

distinguish between state and dynamic multiplier and illusrate balanc budget theorm in hindi

Inflation, discuss the action the procurement function should take to achie...

discuss the action the procurement function should take to achieve raw materials at economic cost durin inflation

Classical labour market, A rise in the real wage will bring a decrease in t...

A rise in the real wage will bring a decrease in the quantity demanded of labor because of diminishing returns in production. As more and more labor is employed, it is increasingly

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