(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

Find the APR, or stated rate, in each of the following cases. Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. Use 365 days in a year. *From a previous question, i learned that I should use APR=[(1+EAR)1/m-1]*m, but im still not getting the correct answer. I dont think im following the correct steps to solve the equation properly.
Determine the following (1–18) measures for 20Y2, rounding to one decimal place, except the dollar amount, which should be rounded to the nearest cent. Use the rounded answer to the requirement for subsequent requirements, if required. Assume 365 days a year. Show each formula and calculation on the worksheet. amount which should be rounded to the nearest cent. use the rounded answer to the requirment for subsequent requirements, if required. Assume 365 days a year. Formula Calculation and Answer 1 Working Capital Stargel Inc. 2 Current ratio Comparative Retained Earnings Statement 3 Quick ratio For the Years Ended December 31, 20Y2 and 20Y1 4 Accounts receivable turnover 20Y2 20Y1 5 Number of days' sales in receivables days Retained…
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.
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
You tested the allowance for uncollectible accounts with regression analysis, and obtained the following results: MAXIMUM TOLERABLE MISSTATEMENT = $500 $0 $500 $750 $1,500 LCL ALLOW UCL THIS IS THE ALLOWANCE CURRENTLY RECOGNIZED, $750 By what amount should the currently recognized allowance, $750, be credited so that the adjusted allowance is materially correct? $250 $0 $500 $750
a) Setup cost = b) Setup time = (round your response to two decimal places). minutes (round your response to two decimal places).
In cell D7, enter a formula without using a function that multiples the Monthly_Payment (cell D6) by the Term_in_Months (cell D5) and then subtracts the Loan_Amount (cell B8) from the result to determine the total interest. In cell D8, enter a formula without using a function that adds the Price (cell B6) to the Total_Interest (cell D7) to determine the total cost.
Two alternative means of providing engineering drafting services are under consideration. Handy-Cam $250,000 $115/hr $250/hr $15,000 R-tistry $200,000 $120/hr $250/hr $20,000 Purchase Price Operating Cost Revenue Market value (end of useful life) Useful life б years б years It is anticipated that the chosen alternative will be used to generate revenue 8 hrs/day, 250 days per year. The company uses a MARR = 12% for all investments.