Question

In: Advanced Math

Sales of roof material, by quarter, since 2005 for Carolina Home Construction Inc. are shown below...

Sales of roof material, by quarter, since 2005 for Carolina Home Construction Inc. are shown below (in $ thousands).

Quarter
Year I II III IV
2004 210 180 60 246
2005 214 216 82 230
2006 246 228 91 280
2007 258 250 113 298
2008 279 267 116 304
2009 302 290 114 310
2010 321 291 120 320

1. Determine the typical seasonal patterns for sales using the ratio-to-moving-average method. (PLEASE DONOT USE EXCEL. PLEASE SHOW ALL MANUAL WORKINGS HOW DID YOU GET ANSWER IN THE TABLE)

2. Deseasonalize the data and determine the trend equation. PLEASE DONOT USE EXCEL. PLEASE SHOW ALL MANUAL WORKINGS HOW DID YOU GET ANSWER IN THE TABLE)

3. Project the sales for 2012, and then seasonally adjust each quarter.

Solutions

Expert Solution


Related Solutions

Sales of roof material, by quarter, for 2010 through 2016, by Carolina Home Construction Inc. are...
Sales of roof material, by quarter, for 2010 through 2016, by Carolina Home Construction Inc. are shown below (in $000). Quarter Year I II III IV 2010 69 241 211 220 2011 85 236 249 222 2012 100 284 253 256 2013 117 298 275 268 2014 113 305 309 299 2015 120 311 325 296 2016 130 327 210 183 Click here for the Excel Data File Determine the typical seasonal patterns for sales using the ratio-to-moving-average method. (Round...
Carolina Roof Construction sells roofing supplies and equipment. Experience has shown the owner, John Fransen, that...
Carolina Roof Construction sells roofing supplies and equipment. Experience has shown the owner, John Fransen, that the sales have a significant seasonal variability. It is critical that the sales forecasts are accurate so Fransen can plan the cash flow of the business. The file Carolina Roof Construction Spring 2019 contains the sales figures for 2011 to 2018.  Produce a forecast using regression of deseasonalized sales and reseasonalize the forecast. Write a report to Frans and include your forecast for winter, spring,...
Assume the Finch family of Charlotte, North Carolina, purchased their home in 1966 for $50,000. Since...
Assume the Finch family of Charlotte, North Carolina, purchased their home in 1966 for $50,000. Since then, comparable homes in their neighborhood have most recently sold for $150,000. The cost to replace the home would be $169,500. It is estimated that the house is one third (1/3) depreciated. The Finch’s have a $135,600 (Coverage A) Homeowners policy in force, similar to the policy shown in the Appendix. Answer the following questions as if each question were a separate event. (Assume...
Listed below is the net sales in $ million for Home Depot Inc. and its subsidiaries...
Listed below is the net sales in $ million for Home Depot Inc. and its subsidiaries from 1993 to 2015. Remember to code the years starting at 1 for year 1993. Year Net Sales 1993 $ 9,854 1994 12,629 1995 16,212 1996 19,085 1997 23,642 1998 31,934 1999 40,035 2000 46,621 2001 55,432 2002 58,246 2003 64,438 2004 73,664 2005 80,767 2006 89,476 2007 78,442 2008 73,135 2009 64,853 2010 67,223 2011 70,034 2012 75,408 2013 78,117 2014 82,730 2015...
Listed below is the net sales in $ million for Home Depot Inc. and its subsidiaries...
Listed below is the net sales in $ million for Home Depot Inc. and its subsidiaries from 1993 to 2015. Remember to code the years starting at 1 for year 1993. Year Net Sales 1993 $ 9,239 1994 11,836 1995 14,804 1996 18,165 1997 24,326 1998 31,349 1999 36,687 2000 47,660 2001 54,509 2002 57,861 2003 66,293 2004 75,025 2005 83,503 2006 90,116 2007 78,278 2008 70,438 2009 65,346 2010 67,300 2011 69,847 2012 75,519 2013 80,383 2014 83,101 2015...
Carolina Company is considering Projects S and L, whose cash flows are shown below. These projects...
Carolina Company is considering Projects S and L, whose cash flows are shown below. These projects are mutually exclusive, equally risky, and are not repeatable. If the decision is made by choosing the project with the higher IRR, how much value will be forgone? Note that under some conditions choosing projects on the basis of the IRR will cause $0.00 value to be lost. r: 7.75% Year 0 1 2 3 4 CFS −$1,050 $675 $650 CFL −$1,050 $360 $360...
Vehicle Sales: Consider the data below ( in thousands of units):   year Quarter 1 Quarter 2...
Vehicle Sales: Consider the data below ( in thousands of units):   year Quarter 1 Quarter 2 Quarter 3 Quarter 4 2016: 4072 4521 4452 4418 2017: 4010 4392 4399 4334 2018: 4092 4484 4277     4360 Obtain the seasonal factors and enter them into the appropriate yellow cells below: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Seasonal Factor Using the columns Year and Total (Annual Sales) below, obtain the regression equation from the Excel's Scatter Diagram Year Quarter 1...
Oriole Inc. had sales of $2,260,000 for the first quarter of 2020. In making the sales,...
Oriole Inc. had sales of $2,260,000 for the first quarter of 2020. In making the sales, the company incurred the following costs and expenses. Variable Fixed Cost of goods sold $925,000 $461,000 Selling expenses 74,000 91,000 Administrative expenses 109,000 100,000 Prepare a CVP income statement for the quarter ended March 31, 2020. ORIOLE INC. CVP Income Statement select an income statement item                                                         ...
Blossom Inc. had sales of $2,300,000 for the first quarter of 2020. In making the sales,...
Blossom Inc. had sales of $2,300,000 for the first quarter of 2020. In making the sales, the company incurred the following costs and expenses. Variable Fixed Cost of goods sold $936,000 $473,000 Selling expenses 119,000 71,000 Administrative expenses 116,000 120,000 Prepare a CVP income statement for the quarter ended March 31, 2020.
A partial balance sheet of ACE Construction Company is shown below. Can you identify which construction...
A partial balance sheet of ACE Construction Company is shown below. Can you identify which construction accounting method this company uses and which income recognition method is used by the company? Explain how you have identified the methods. Assets Cash $1,876,854 Accounts Receivable $875,202 Material Inventory $420,210 Costs and Estimated Earnings in excess of billings $250,653 Machinery and equipment $642,173 Cars and trucks $124,873 Less accumulated depreciation $218,748
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT