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

Oecd, What is the significance of the observations made by OECD in this cas...

What is the significance of the observations made by OECD in this case study regarding “The OECD economies are more strongly dependent on the production, distribution and use of kn

LM or IS curve, I''m trying to figure out what the effect would be on LM or...

I''m trying to figure out what the effect would be on LM or IS curve, and additionally the interest rate and income if (a) the transactional demand for money increases, (b) the liq

Determination of variables in as-ad model, Q. Determination of variables in...

Q. Determination of variables in AS-AD model? Once Y and P are determined, all other endogenous variables would be determined as well. Interest rate is determined by money mark

Accredited similar dental offices, Should dental offices be accredited simi...

Should dental offices be accredited similar to the standards that hospitals are?

Show the advantage and disadvantage of money, Q. Show the advantage and dis...

Q. Show the advantage and disadvantage of money? Money has one significant advantage and one disadvantage compared to bonds:  · Advantage: Money is more liquid than bond

Subsidizing the price of milk, "Subsidizing the price of milk or other agri...

"Subsidizing the price of milk or other agricultural products is not very expensive considering how many consumers there are in the United States. Therefore, there is little harmfu

Actively-managed mutual funds, A sample of 60 mutual funds was taken and th...

A sample of 60 mutual funds was taken and the mean return in the sample was 13% with a standard deviation of 6.9%. The return on a particular index of stocks (against which the mut

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