Question

Crossland Construction’s design/build department allows their clients (owners) to select the design and construction team based...

Crossland Construction’s design/build department allows their clients (owners) to select the design and construction team based on their combined experience and track-record. Design/build firms typically have a cash flow problem since they tend to be paid in lump sums when projects are completed or hit milestones. However, their expenses, such as payroll, must be paid regularly. So, such firms need bank lines of credit to finance their initial costs, but in the past year, lines of credit were difficult to negotiate. The data file Crossland Construction contains month-end cash balances for the past 16 months. a) Plot the data as a time-series graph. Fit a linear line to the data. Discuss what the graph implies concerning the relationship between cash balance and the time variable, month. b) Fit a linear trend model to the data. Compute the coefficient of determination. Discuss the appropriateness of the linear trend model. What are the strengths and weaknesses of the model? c) Referring to part b), compute the MAD and MSE for the 16 data points. d) Plot the data as a time-series graph. Fit a polynomial line to the data. Discuss what the graph implies concerning the relationship between cash balance and the time variable, month. e) Use the t2 transformation approach and recompute the linear model using the transformed time variable. Discuss whether this model appears to provide a better fit than did the model without the transformation. Compare the coefficients of determination for the two models. Which model seems to be superior, using the coefficient of determination as the criterion? f) Referring to part e), compute the MAD and MSE for the 16 data values. Discuss how these compare to those that were computed in part c), prior to transformation. Do the measures of fit (R2, MSE, MAD) agree on the best model to use for forecasting purposes? g) Use the linear trend model (without transformation) for the first 15 months and provide a cash balance forecast for month 16. Then use the transformation model for the first 15 months and provide a cash balance forecast for month 16. Now, compare the accuracy of the forecasts with and without the transformation. Which of the two forecast models would you prefer? Explain your answer.

Need detailed answers please.

Month Cash Balance
1 75
2 70
3 77
4 89
5 80
6 92
7 91
8 102
9 106
10 130
11 155
12 160
13 180
14 199
15 240
16 305

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Crossland Construction’s design/build department allows their clients (owners) to select the design and construction team based...
Crossland Construction’s design/build department allows their clients (owners) to select the design and construction team based on their combined experience and track-record. Design/build firms typically have a cash flow problem since they tend to be paid in lump sums when projects are completed or hit milestones. However, their expenses, such as payroll, must be paid regularly. So, such firms need bank lines of credit to finance their initial costs, but in the past year, lines of credit were difficult to...
Background: Crossland Construction’s design/build department allows their clients (owners) to select the design and construction team...
Background: Crossland Construction’s design/build department allows their clients (owners) to select the design and construction team based on their combined experience and track-record. Design/build firms typically have a cash flow problem since they tend to be paid in lump sums when projects are completed or hit milestones. However, their expenses, such as payroll, must be paid regularly. So, such firms need bank lines of credit to finance their initial costs, but in the past year, lines of credit were difficult...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24 15 21 12 19 21 16 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) - Select your answer -Graph (i)Graph (ii)Graph (iii)Graph (iv)Item 1 What type of pattern exists in the data? - Select your answer -Positive trend patternHorizontal patternVertical patternNegative trend patternItem 2 (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month...
Question 1: Wendy's Happy Homes Inc. manufactures Home Appliances. Monthly sales of Wendy's Washers and Dryer...
Question 1: Wendy's Happy Homes Inc. manufactures Home Appliances. Monthly sales of Wendy's Washers and Dryer Sets for a nine-month period were as follows: MONTH Washer and Dryer Sales January 490 February 480 March 450 April 500 May 480 June 470 July 490 August 520 September 530 Forecast October sales using: 1) A four-month moving average 2) a six-month moving average 3. Compute the MAD for each forecast method you used. Actual October sales were 520 units. 4) Which method...
Use data below to create a file with monthly data from January 2015 to December 2017...
Use data below to create a file with monthly data from January 2015 to December 2017 for Hansen Company. The first variable is Time. The second variable, Sales 1, has data on sales of a product 1. The third variable, Sales 2, has data on sales of a product 2. Part 1: For this problem, use the Sales 1 variable to answer the following questions. What are the forecasts for the January of the year 2018 and evaluate the MSE...
1. In which phase of the business cycle is the U.S. economy currently in? ________________. How...
1. In which phase of the business cycle is the U.S. economy currently in? ________________. How many months has the U.S. economy been in this stage of the business cycle? ___________ months 2. How long has the current expansion/recovery lasted to date? _________________ How does this compare to the average length of U.S. recessions since 1854? ______________________________. 3. What do the last four recoveries/expansions (that is, the current recovery/expansion and the previous three recovery/expansions), suggest about a new trend in...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
Asia’s e-commerce landscape has been booming in recent years. The swift adoption of smartphones and greater...
Asia’s e-commerce landscape has been booming in recent years. The swift adoption of smartphones and greater access to the internet has allowed consumers in the region to be a major force in the global digital economy. The expansion looks set to continue at a rapid pace. According to a November 2018 report by Fitch Solutions, e-commerce sales in the region are forecast to increase by 14.2% this year, with an estimated average annual increase of 14% over the medium term...
QUESTION 1 1. Brianna is trying to increase her chances of being promoted to vice president...
QUESTION 1 1. Brianna is trying to increase her chances of being promoted to vice president by working to build good work relationships with other managers outside her own department. Brianna's behavior should be viewed as dysfunctional politics. functional politics. coercive power. functional influence. 2 points QUESTION 2 1. The Gingerbread Factory has a separate unit that makes their chocolate crunch cookies and another unit that is completely responsible for all operations in producing their ginger snap cookies. The Gingerbread...
MATHEMATICS 1. The measure of location which is the most likely to be influenced by extreme...
MATHEMATICS 1. The measure of location which is the most likely to be influenced by extreme values in the data set is the a. range b. median c. mode d. mean 2. If two events are independent, then a. they must be mutually exclusive b. the sum of their probabilities must be equal to one c. their intersection must be zero d. None of these alternatives is correct. any value between 0 to 1 3. Two events, A and B,...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT