Required information
[The following information applies to the questions displayed below.]
Lexon Inc. is a large manufacturer of affordable DVD players. Management recently became aware of rising expenses resulting from returns of malfunctioning products. As a starting point for further analysis, Paige Jennings, the controller, wants to test different forecasting methods and then use the best one to forecast quarterly expenses for 2019. The relevant quarterly data for the previous three years follow:
2016 Quarter |
Return Expenses | 2017 Quarter |
Return Expenses | 2018 Quarter |
Return Expenses | ||||||
1 | $ | 13,900 | 1 | $ | 14,300 | 1 | $ | 14,800 | |||
2 | 12,600 | 2 | 13,400 | 2 | 13,700 | ||||||
3 | 12,900 | 3 | 13,000 | 3 | 13,500 | ||||||
4 | 15,200 | 4 | 15,600 | 4 | 16,300 | ||||||
The result of a simple regression analysis using all 12 data points yielded an intercept of $13,154.55 and a coefficient for the independent variable of $145.45. (R-squared = 0.45, SE = $1,084.18.)
2. Looking at the graph you prepared for requirement 1, select two representative data points and calculate the quarterly forecast for 2019 using the high-low method.
3. Calculate the quarterly forecasts for 2019 using the results of a regression analysis. Evaluate the results of the regression analysis and make appropriate changes to improve the model.
Calculate the quarterly forecasts for 2019 using the results of a regression analysis. Evaluate the results of the regression analysis and make appropriate changes to improve the model. (Round your answers to 2 decimal places for Regression One.)
|
Required information [The following information applies to the questions displayed below.] Lexon Inc. is a large...
2019 Quarter Return expenses 1 .. 2 3 4 Calculate the quarterly forecasts for 2019 using the results of a regression analysis. Evaluate the results of the regression analysis and make appropriate changes to improve the model. (Round your answers to 2 decimal places for Regression One.) Regression One 2019 Quarter Predicted expenses 1 2 3 4 Regression Two 2019 Quarter Predicted Expenses 1 2 3 4 Required informatio [The following information applies to the questions displayed below.] Lexon Inc....
i need answer to number 3, fill in the answers in the format shown below please i keep getting completely wrong snd unrelated answers please only answer if you understand what needs to be done Lexon Inc. is a large manufacturer of affordable DVD players. Management recently became aware of rising expenses resulting from returns of malfunctioning products. As a starting point for further analysis, Paige Jennings, the controller, wants to test different forecasting methods and then use the best...
got number 2 solved now need solution to number 3 fill in the above chart (similar question and solution below , that's what I need ) Lexon Inc. is a large manufacturer of affordable DVD players. Management recently became aware of rising expenses resulting from returns of malfunctioning products. As a starting point for further analysis, Paige Jennings, the controller, wants to test different forecasting methods and then use the best one to forecast quarterly expenses for 2019. The relevant...
Lexon Inc. is a large manufacturer of affordable DVD players. Management recently became aware of rising expenses resulting from returns of malfunctioning products. As a starting point for further analysis, Paige Jennings, the controller, wants to test different forecasting methods and then use the best one to forecast quarterly expenses for 2019. The relevant quarterly data for the previous three years follow: 2016 Quarter 2017 Quarter 2018 Quarter Return Expenses $ 12,750 11,500 11,800 13,900 Return Expenses $ 13,100 12,300...
6. eBook The quarterly sales data (number of copies sold) for a college textbook over the past three years follow Quarter Year 1 Year 2 Year 3 1,765 1,063 2,974 2,554 1,591 1,827 935 2,646 2,423 980 2,812 2,358 4 There appears to be a seasonal pattern in the data and perhaps amoderate upward linear trend b. Use the following dummy variables to develop an estimated regression equation to account for any seasonal effects in the data: Qtrl 1 if...
8. Examine the following quarterly data: Quarter 11 Quarter 2 2 Quarter 3 3 15 26 20 12 34 51 Quarter 44 Quarter 1 5 Quarter 2 6 Quarter 3 7 Quarter 4 8 Quarter 1 9 Quarter 2 1 38 62 Quarter 311 Quarter 4 12 84 Calculate the seasonal indexes for each quarter. a. Quarter 1 Quarter 2 Quarter 3 Quarter 4 b. Deseasonalize the time series. Produce the trend line using the deseasonalized data. Produce seasonaly adjusted...
Required information (The following information applies to the questions displayed below.] Milea Inc. experienced the following events in 2018, its first year of operations: 1. Received $12,000 cash from the issue of common stock. 2. Performed services on account for $45,000. 3. Paid the utility expense of $1,400. 4. Collected $33,110 of the accounts receivable. 5. Recorded $5,600 of accrued salaries at the end of the year. 6. Paid a $1,150 cash dividend to the stockholders. Required a. Record the...
Quarter Year 1 Year 2 Year 3 Year 4 Year 5 1 20 42 69 98 175 2 101 141 149 211 288 3 168 250 333 388 436 4 6 20 47 91 181 South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New York. Although the firm has been in business only five years, revenue has increased from $295,000 in the first year of operation to $1,080,000 in the most recent year....
Please help I am very confused on how to solve this South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New York. Although the firm has been in business only five years, revenue has increased from $315,000 in the first year of operation to $1,075,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars. Quarter Year 1 TE Year 2 Year 3 Year 4 Year 5...
Required Information [The following information applies to the questions displayed below.] The following transactions apply to Jova Company for 2018, the first year of operation: 1. Issued $10,000 of common stock for cash. 2. Recognized $210.000 of service revenue earned on account. 3. Collected $162,000 from accounts receivable. 4. Paid operating expenses of $125,000. 5. Adjusted accounts to recognize uncollectible accounts expense. Jova uses the allowance method of accounting for uncollectible accounts and estimates that uncollectible accounts expense will be...