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

MNO Company forecast sales in units for July to November as follows: Units JULY - 4000 aUGUST - 4300 SEPTEMBER - 4500 OCTOBER - 4700 NOVEMBER - 5000 MNO Company would like to maintain 200 units in its ending inventory at the end of each month starting July. Ending inventory for the month of June is 150 units. Beginning inventory at the start of January amounts to 100 units. 1. How many units should MNO Company produce for the month of July to fulfill the expected sales of the company?
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 >
Inventory elements: derecognition and measurement At the time of their exit, the inventory and other fungible assets are measured and recorded in accounting through applying one of the following formulas: First In - First Out C FIFO WAC Weighted Average Cost Last In - First Out LIFO Case study no. 1: At the beginning of January N entity A has an initial flour inventory of 200 kg evaluated at an actual cost of 46 lei/kg. The following transactions happen during the month with regard to the flour inventory: 07.01.N: acquisition 500 kg, actual cost 47 lei/kg: 09.01. N: acquisition 300 kg, actual cost 49 lei/kg: 12.01. N: consumption 600 kg: 17.01. N: consumption 100 kg: 20.01. N: acquisition 200 kg, actual cost 55 lei/kg: 24.01. N: consumption 400 kg: 27.01. N: acquisition 700 kg, actual cost 57 lei/kg: 30.01. N: consumption 750 kg.
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)?
A June sales forecast projects that 8,000 units are going to be sold at a price of $11.00 per unit. The desired ending inventory of units is 12% higher than the beginning inventory of 900 units. Merchandise purchases for June are projected to include how many units? O 8,000 units O 8,108 units O 7,892 units O 9,008 units O 8,450 units
The following sales and purchases are expected over the Four-month period from December to March Purchases Sales December OMR 30000 OMR 26000 January OMR 25000 OMR 30000 February OMR 24000 OMR 24000 March OMR 26000 OMR 28000 Additional Information: 1. Wages are paid each month of OMR 2000, which are paid in month that they are incurred 2. 30% of the Sales are on credit - and we allow one-month credit period - and 70% of the sales for immediate settlement 3. 40% of the Purchases are on credit - and 1 month credit period - and 60% of the purchases are for immediate settlement 4. The balance of cash as at 1 January was OMR 9000 If the company is preparing a budget from January to March, what will be the Closing balance of cash on March ? Select one: a. OMR 7800 b. OMR 7200 c. OMR 5800
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
3. Lunar Industry maintains ending inventory for each month at 40% of the next month’s sales. The company predicted the following sales for the first four months of the year: January February March April Sales (units) 1,560 1,820 1,950 1,560 How many units should be produced in February? a)1,988 b)1,092 c)1,872 d)1,768 e)2,600

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