(a) Compute four-week and five-week moving averages for the time series. Do not round intermediate calculations. If required, round your answers to two decimal places. Week Sales 4-Week Moving Average 5-Week Moving Average 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22 10 20 11 15 12 22 (b) Compute the MSE for the four-week and five-week moving average forecasts. Do not round intermediate calculations. If required, round your answers to two decimal places. MSE for four-week moving average = MSE for five-week moving average = Refer to the gasoline sales time series data in the given table. Click on the datafile logo to reference the data. DATA file Week Sales (1,000s of gallons) 1 17 2 21 3 19 4 23 5 6 7 18 16 8 20 18 6 22 10 20 11 15 12 22

(a) Compute four-week and five-week moving averages for the time series. Do not round intermediate calculations. If required, round your answers to two decimal places. Week Sales 4-Week Moving Average 5-Week Moving Average 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22 10 20 11 15 12 22 (b) Compute the MSE for the four-week and five-week moving average forecasts. Do not round intermediate calculations. If required, round your answers to two decimal places. MSE for four-week moving average = MSE for five-week moving average = Refer to the gasoline sales time series data in the given table. Click on the datafile logo to reference the data. DATA file Week Sales (1,000s of gallons) 1 17 2 21 3 19 4 23 5 6 7 18 16 8 20 18 6 22 10 20 11 15 12 22

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter15: Financial Statement Analysis

Section: Chapter Questions

Problem 41E

See similar textbooks

Similar questions

2) Use the information above to complete the Aging of Accounts Receivable Schedule below. Create a formula for cach age category, using the Excel IF and AND FUNCTIONS (fx) to determine wh customer amount belongs. The IF statement may include the following arguments: ,>=, <=, Excel AND FUNCTION (fx).
Qq.8.a
Consider the following time series: a. Construct a time series plot. What type of pattern exists in the data? Is there an indication of a seasonal pattern? b. Use a multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. c. Compute the quarterly forecasts for next year.
Consider the following time series data: Compute MSE using the most recent value as the forecast for the next period. What is the forecast for month 8? Compute MSE using the average of all the data available as the forecast for the next period. What is the forecast for month 8? Which method appears to provide the better forecast?
Consider the following time series data: Construct a time series plot. What type of pattern exists in the data? Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2. 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Compute the quarterly forecasts for next year based on the model you developed in part (b). Use a multiple regression model to develop an equation to account for trend and seasonal effects in the data. Use the dummy variables you developed in part (b) to capture seasonal effects and create a variable t such that t = 1 for quarter 1 in year 1, t = 2 for quarter 2 in year 1, … t = 12 for quarter 4 in year 3. Compute the quarterly forecasts for next year based on the model you developed in part (d). Is the model you developed in part (b) or the model you developed in part (d) more effective? Justify your answer.
Consider the following time series data: Construct a time series plot. What type of pattern exists in the data? Develop a three-week moving average for this time series. Compute MSE and a forecast for week 8. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 8. Compare the three-week moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE? Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.2.
Consider the following time series data: Construct a time series plot. What type of pattern exists in the data? Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Compare the three-week moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE? Explain. Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.2.
Please don't give image format
Using the ending balances shown in the Partial Adjusted Trial Balance listed below, what is the total dollar ($) balance for the accounts that have a normal credit balance? Fill in the blank with your calculated number. DO NOT include commas, $ signs, period, decimal points, etc., just enter the raw number. Webcourses will add commas to your answer automatically. For example, if you calculated the answer to be $24,123, you would only input: 24123 Partial Adjusted Trial Balance December 31, 20xx Accounts Normal Balance Cash 10,000 Accounts Receivable 5,000 Inventory 150,000 Sales Tax Payable 50,000 Accounts Payable 1,000 Deferred Revenue 10,000 Current Portion Long-term Debt 10,000 Long-term Debt Common Stock 50,000 25,000 Treasury Stock Retained Earnings 3,000 50,000 Dividends 5,000 20,000 Service Revenue Cost of Good Sold 5,000 Rent Expense 5.000 ASUS 13 f4 f5 f6 f7 E3 X f9 f10 f11 4. 5 6 9. C8 图 %24
Please Solve all Requirement With details and Do not give solution in images format
(b) Your answer is partially correct. Flounder Co. sells $390,000 of 12% bonds on June 1, 2025. The bonds pay interest on December 1 and June 1. The due date of the bonds is June 1, 2029. The bonds yield 10%. On October 1, 2026, Flounder buys back $120,900 worth of bonds for $124,900 (includes accrued interest). Give entries through December 1, 2027.
Danielle Battle has trouble keeping her debits and credits equal. During a recent month, Danielle made the following errors: In preparing the trial balance, Danielle omitted a $5,800 note payable. Danielle recorded a $230 purchase of supplies on account by debiting Supplies and crediting Accounts Payable for $320. In recording a $280 payment on account, Danielle debited Supplies instead of Accounts Payable. In journalizing a receipt of cash from service revenue, Danielle debited Cash for $80 instead of the correct amount of $800. The credit was correct. Danielle posted a $900 utility expense as $90. The credit to Cash was correct. а. b. c. d. е. Required For each of these errors, state whether total debits equal total credits on the trial balance. 1. 2. Identify each account that has an incorrect balance, and indicate the amount and direction of the error (such as "Accounts Receivable $500 too high"). Requirement 1. For each of these errors, state whether total debits equal total…