Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months.The forecasts and actual sales are as follows.Month SolesForecast 1Forecast 218357858102835800825383084584548558308155770765810683580581177807908108845790780979082081010815795840a. Compute the MSE and MAD for each forecast (Round your answers to 2 decimal places.)MSEMADForecast 1Forecast 2

Step 1: Formulas: Absolute deviation= |Forecast - Sales| MAD= mean absolute deviation= sum of…

Answered: Two independent methods of forecasting…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Watt's Lighting Stores made the following sales projection for the next six months. All sales are credit sales. March April May June July August $ 42,000 48,000 37,000 46,000 54,000 56,000 Sales in January and February were $45,000 and $44,000, respectively. Experience has shown that of total sales, 10 percent are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale. Prepare a monthly cash receipts schedule for the firm for March through August. Credit sales Collections: In month of sale One month after sale Watt's Lighting Stores Cash Receipts Schedule January February March April May June July August Two months after sale $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 Total cash receipts
Sales for February of this year totaled $192,096. If the planned seasonal sales distribution is as follows, figure the dollar sales for the remaining months of the period. Round to the nearest dollar. February 10% March 14% April 16% May 18% June 14% July 12%
Production and sales estimates for March for Robin Co. are as follows: Estimated inventory (units), March 1 18,000 Desired inventory (units), March 31 19,100 Expected sales volume (units): Area M 7,000 Area L 9,100 Area O 7,400 Unit sales price $14 The number of units expected to be manufactured in March is
Complete this question by entering your answers in the tabs below. 4 Required 1 Required 2 Prepare a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive. (Hint: There will be only one forecasted number for January-this is the forecast done in December. For February, there will be two forecasts: one done in December and a second done in January. For June, there will be six forecasts, one done in each of the preceding six months.) Month of Forecast for Month of Forecast January February March April May June December January • February March April May Required 1 Required 2 >
Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter which has been provided in the below table. Following Year Quarter in Coming Year Second $362 Third $338 Fourth $386 First First Quarter Sales forecast $374 $386 Paymore's labor and administrative expenses are $67 per quarter and interest on long-term debt is $42 per quarter. Paymore's cash balance at the start of the first quarter is $40 and its minimum acceptable cash balance is $30. Assume that Paymore can borrow up to $338 from a line of credit at an interest rate of 2% per quarter. On average, one-third of sales are collected in the quarter that they are sold, and two-thirds are collected in the following quarter. Assume that sales in the last quarter of the previous year were $338. On average, two-thirds of purchases are paid for in the quarter that they are purchased, and one-third are paid in the following quarter. Prepare a short-term financing plan using the above table. (Leave no…
Using the weighted mean method, determine the valuation of ending inventory on December. Assume 35 FitBits in inventory at the end of the year. (Round to the nearest whole dollar.) b. What was the Cost of Goods Sold (COGS)?
Production and saies estimates for March for the Robin Co. are as follows: Estimated inventory (units), March 1 17,700 Desired inventory (unit), March 31 19,100 Expected sales volume (units): Area M 6,500 Area L 8,300 Area O 7,900 Unit sales price $13 The number of units expected to be manufactured in March is Ob. 41,800 OC 22.700 Od. 24,100

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS