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

Find real interest rate and nominal interest rate, Assume that an economy's...

Assume that an economy's GDP Y=5000. Also assume that the government runs a deficit where tax revenue T=1000 and government expendituresG= 1500. The consumption function is represe

Single nonprofit provider, For a single nonprofit provider, describe an out...

For a single nonprofit provider, describe an output-maximizing model to predict supplier behavior.

What is effective demand, Effective Demand The concept of effective dem...

Effective Demand The concept of effective demand is the logical starting point of Keynes Theory of Employment. Effective demand manifests itself in the aggregate expenditure of

Determination of gdp in the cross model, Q. Determination of GDP in the cro...

Q. Determination of GDP in the cross model? In the cross model, GDP is determined as the solution to the equation Y D (Y) = Y We may explain

What is average cost in the producing output, What is average cost in the p...

What is average cost in the producing output? Average total cost , frequently considered as to simply average cost, is sum of total cost divided through quantity of output gen

Marginal, using the marginal utility theory explain the consumption patten ...

using the marginal utility theory explain the consumption patten of consumers

Give example to calculate the price level, Give example to calculate the pr...

Give example to calculate the price level Imagine that we have created a particular basket of services and goods. We calculate price level at four different points in time duri

Codinal theory - consumer choice concernin utility, Ordinal Theory: A...

Ordinal Theory: A Short Note In ordinal approach, utility is measured ordinally i.e., qualitatively (not numerically or quantitatively). Alternatively, consumer can rank her

Product information to consumers, Should the government increase, decrease ...

Should the government increase, decrease or remain the same in its level of intervention when it comes to mandating that companies provide product information to consumers? What ha

Rent control agency of new york city, The rent control agency of New York C...

The rent control agency of New York City has found that market demand is QD=100-5P With quantity measured in tens of though sands of apartments and price, the monthly rental rate,

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