Consider the following time series data:
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| Value | 25 | 12 | 20 | 11 | 20 | 23 | 15 |
| (a) | Compute MSE using the most recent value as the forecast for the next period. |
| If required, round your answer to one decimal place. | |
| What is the forecast for month 8? | |
| If required, round your answer to one decimal place. Do not round intermediate calculation. | |
| (b) | Compute MSE using the average of all the data available as the forecast for the next period. |
| If required, round your answer to one decimal place. Do not round intermediate calculation. | |
| What is the forecast for month 8? | |
| If required, round your answer to one decimal place. | |
| (c) |
Which method appears to provide the better forecast? (Naiive or all data coverage) |
In: Math
In: Economics
| year 0 | year 1 | year 2 | year 3 | year 4 | |
| cashflow for S | -100 | 40 | 50 | 30 | 30 |
| cashflow for L | -100 | 10 | 10 | 50 | 90 |
If the company's cost of capital is 5% and the decision is made by choosing the project with the higher IRR, how much value will be forgone?
a. $4.01
b. $20.80
c. $29.89
d. $1.79
e. $12.45
In: Finance
Consider the following time series data:
Month 1 2 3 4 5 6 7
Value 23 15 20 12 18 22 15
| (b) | Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. |
| If required, round your answers to two decimal places. Do not round intermediate calculation. | |
| MSE: | |
| The forecast for month 8: | |
| (c) | Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for month 8. |
| If required, round your answers to two decimal places. Do not round intermediate calculation. | |
| MSE: | |
| The forecast for month 8: | |
| (e) | Use trial and error to find a value of the exponential smoothing coefficient α that results in the smallest MSE. |
| If required, round your answer to two decimal places. | |
| α = |
In: Math
explain market research process:
1- Identifying the problem
2- Planing market research
3- Collecting data
4- Qualitative data
5- Quantitative data
6- Data analysis
7- processing data into usable information
8- Presenting data and making decisions
In: Operations Management
|
A |
B |
C |
D |
|
| 1 | Chapter 5: Applying Excel | |||
| 2 | ||||
| 3 | Data | |||
| 4 | Unit sales | 30,000 | units | |
| 5 | Selling price per unit | $70 | per unit | |
| 6 | Variable expenses per unit | $42 | per unit | |
| 7 | Fixed expenses | $420,000 | ||
| 8 |
|
|
If your formulas are correct, you should get the correct answers to the following questions. |
| (a) | What is the break-even in dollar sales? |
| (b) |
What is the margin of safety percentage? |
| (c) |
What is the degree of operating leverage? (Round your answer to 2 decimal places.) |
| 3. |
Using the degree of operating leverage and without changing anything in your worksheet, calculate the percentage change in net operating income if unit sales increase by 20%. |
| 4. |
Confirm your calculations in Requirement 3 above by increasing the unit sales in your worksheet by 20% so that the Data area looks like this: |
||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||
| (a) |
What is net operating income? (Negative amount should be indicated by a minus sign.) |
| (b) |
By what percentage did the net operating income increase? |
| 5. |
Thad Morgan, a motorcycle enthusiast, has been exploring the possibility of relaunching the Western Hombre brand of cycle that was popular in the 1930s. The retro-look cycle would be sold for $17,000 and at that price, Thad estimates 400 units would be sold each year. The variable cost to produce and sell the cycles would be $13,600 per unit. The annual fixed cost would be $1,224,000. |
| a. | What is the break-even in unit sales? |
| b. |
What is the margin of safety in dollars? |
| c. | What is the degree of operating leverage? (Round your answer to 2 decimal places.) |
| Thad is worried about the selling price. Rumors are circulating that other retro brands of cycles may be revived. If so, the selling price for the Western Hombre would have to be reduced to $14,200 to compete effectively. In that event, Thad would also reduce fixed expenses to $1,139,000 by reducing advertising expenses, but he still hopes to sell 400 units per year. |
| d. | What would the net operating income be in this situation? (Negative amount should be indicated by a minus sign.) |
In: Accounting
Consider the following cash flows:
Year 0 1 2 3 4 5 6
Cash Flow -$10,000 $2,200 $3,300 $2,500 $2,500 $2,300 $2,100
A. Payback The company requires all projects to payback within 3 years. Calculate the payback period. Should it be accepted or rejected?
B. Discounted Payback Calculate the discounted payback using a discount rate of 10%. Should it be accepted or rejected?
C. IRR Calculate the IRR for this project. Should it be accepted or rejected?
D. NPV Calculate the NPV for this project at a rate of 10%. Should it be accepted or rejected?
E. PI Calculate the Profitability Index (PI) for this project. Should it be accepted or rejected?
There are two common formulas for the profitability Index:
PV of Future Cash Flows/Initial Cost, accept if PI > 1.0 or NPV/ Initial Cost, accept if PI > 0
In: Finance
C++ Questions:
1. True/False: an int uses 4 bytes in memory on all systems.
2. True/False: a double typically offers better precision than a float.
3. True/False: The following two statements are equivalent assuming isPair is a variable of type bool:
if (isPair) if (isPair == true)
4. Provide a value we could put in the blank so that the value of x will be 20 after the code snippet.
int x = _____; x *= 4;
5. Provide a value we could put in the blank so that the value of x will be 7 after the code snippet.
int x = _____; x = x % 10;
6. What is the error in the code below:
string slogan = 'Go Giants!';
In: Computer Science
MATCH EACH TYPE OF CRYSTALLINE SOLID TO THE APPROPRIATE EXAMPLE: 1. ATOMIC 2.METALLIC 3.IONIC 4. NETWORK COVALENT 5.MOLECULAR
A)C (GRAPHITE) B)N2 C)Kr D)Au e)MgBr2
In: Chemistry
Zeta, Inc., has identified the following two mutually exclusive projects:
| Year | 0 | 1 | 2 | 3 | 4 | |
| Cash Flow A | -$20,500 | 10,500 | 15,500 | |||
| Cash Flow B | -$20,500 | 5,700 | 10,500 | 12,000 | 15,500 |
Use both the equal lives method and the equivalent annuity method to determine which project the company should implement.
In: Finance