Reference no: EM131143128
Bert Humphries has left his home in a small town in rural manitoba and moved to toronto to enroll in a 4-year undergraduate program in economics. Bert is planning an investment strategy for the 4-year period, with the goal of having the largest possible amount of cash on hand when he graduates. Bert has some revenue from a combination of an RESP (registered education savings plan) fund that his parents opened for him when he was a baby, scholarship funds, and a small inheritance he recently received from his grandmother. His estimate of revenues and expenses over the four years is shown in the following table. Bert has $5000 in cash at the begining of the 1st year.
Year Revenues Expenses
2009-2010 $30,000 $10,000
2010-2011 $40,000 $25,000
2011-2012 $25,000 $25,000
2012-2013 $15,000 $12,500
Any money left over at the end of a year can be invested in guaranteed investment certificates (GICs) for one year at an annual interest rate of 2.9%, for two years at 3.0%, for 3 years at 3.1%, or for 4 years at 3.4%. Bert uses the following rule for each of the 4 years:
Money invested + Expenses paid < (less than or equal to) Revenues + Money earned from investment
(a) Formulate a linear program to determine an investment strategy that will maximize the value of Bert's GICs at the end of the 4th yr. (Hint: Bert can have up to 4 GICs coming due at the end of the 4th yr: a 4 year GIC invested at the begining of year 1, a three-year GIC invested at the begining of year 2, a two-year GIC invested at the begining of year 3, and a one year GIC invested at the begining of year 4. It is the sum of these values that Bert wants to maximize, as he plans to cash in all of his GICs and travel the world for a year between graduation and starting his career.)
b) Solve using excel.
|
Consider three decisions
: Consider three decisions you have made today. (They could be simple such as, taking a turn while driving or even choosing a soda at a convenience store.) In each case determine the data, information, or knowledge that were involved in the decision.
|
|
Lean production concepts are widely used-accepted practices
: The Toyota Production System (TPS) was developed by the Japanese in the 1950’s and became the foundation for Just-in-Time (JIT). By 1970, JIT was being used by most factories in Japan. In the 1980’s JIT was introduced into the USA. Currently, JIT and..
|
|
Broadening their markets by updating classic products
: Some Companies are broadening their markets by updating classic products to appeal to younger peoples tastes and preferences. What primary and secondary marketing information would you want to have if you were planning to reinvigorate an established ..
|
|
Write team contract to maximize effectiveness of the group
: Write a team contract to maximize the effectiveness of the group if you were a new product development team. Be sure to address how the team will handle disagreements, how you will make decisions, and how the team will ensure that all team members' i..
|
|
Formulate linear program to determine investment strategy
: Bert Humphries has left his home in a small town in rural manitoba and moved to toronto to enroll in a 4-year undergraduate program in economics. Bert is planning an investment strategy for the 4-year period, with the goal of having the largest possi..
|
|
Popularity of values as topic of organizational behavior
: All of the following are reasons for the popularity of values as a topic of organizational behavior except ______.
|
|
Process management is about continuous improvement
: Process Management is about continuous improvement. Discuss similarities and differences between the Deming Cycle Methodology and the Kaizen approach to process improvement.
|
|
Superior for evaluating the training programs effects
: Explain why a controlled study may be superior for evaluating the training programs effects. Define a controlled study and give an example that you could use for the “company” you created for this course or a company that has been discussed during ou..
|
|
Witnessed an unethical communication situation
: Describe a situation where you witnessed an unethical communication situation. This does not have to be in a work environment. Was anything said or done about the situation? If so, explain what was done and by whom and if you agree with the action th..
|