(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

please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
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.
The general approach for handling advertising costs which benefit future quarters in interim reports is to O a. disclose them only in the notes O b. prorate them over the current and remaining quarters O c. charge the expenses in the quarter incurred d. prorate them over all four quarters
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.
The aging of Torme Designs shown below. Calculate the amount of each periodicity range that is deemed to be uncollectible. The Allowance for Doubtful Accounts carries a credit balance of $1,135.00. Write the adjusting entry for the end of the current year. Est Uncollectible Accts Age Interval: Balance: Percentage: Amount: Not past due 850,000 3.50% 1~30 days past due: 47,500 5.00% 31~60 days past due: 21,750 10.00% 61~90 days past due: 11,250 20.00% 91~180 days past due: 5,065 30.00% 181~365 days past due: 2,500 50.00% Over 365 days past due: 1,145 95.00% Total: 939,210
a) Setup cost = b) Setup time = (round your response to two decimal places). minutes (round your response to two decimal places).
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
Use this table for calculations: Minimum Days Maximum days % uncollectible 1 30 1.5% 31 60 3.5% 61 90 12% 91 365 70% I need to calculate the number of days each receivable is outstanding look at image to fill in , show work when calculating or using formulas , included all work please. After that fill in the schedule accounts recievable shown in the other image for context. When filling in the schedule of accounts recievable show what the formulas w you use and all work.
Please Solve all Requirement With details and Do not give solution in images format