Required: 1. 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.) 2. For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier.

Required: 1. 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.) 2. For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier.

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

Fi
Mesh Merchandising Company expects to purchase $86,000 of materials in July and $118,000 of materials in August. Three-quarters of all purchases are paid for in the month of purchase, and the other one-fourth are paid for in the month following the month of purchase. How much will August's cash disbursements for materials purchases be? A) $118,000 B) $64,500 C) $88,500 D) $110,000
Paper Corporation expects to have the sales and expenses shown for August, September,andOctober. The company expects to receive 55% of collections for sales in the month the saleoccurs, 35% in the following month, and the remainder to be uncollectible. The companypolicy for manufacturing expenses requires that 70% of the expenses be paid in the monthincurred and 30% in the following month. All other expenses are paid in the month incurred.The company also earns and collects $5,000 of rental revenue eachmonth. At the end of thequarter, Paper Corporation must make an estimated tax payment, which the companyestimates will be 7% of the quarter’s total sales. Prepare the cash budget for the three monthsif cash as of August 1, 2015, totaled $51,500. The company requires a $50,000 minimum cashbalance. July August September October Sales $34,000 $39,000 $46,000 $40,000 Manufacturing costs 15,200 16,800 20,100 19,900 Selling expenses 10,000 10,200 14,500 16,500 Administrative…
Nyanza, Incorporated anticipates sales of 55,000 units, 53,000 units, and 56,000 units in July, August, and September, respectively. Company policy is to maintain an ending finished-goods inventory equal to 30% of the following month's sales. On the basis of this information, how many units would the company plan to produce in July?
One Device makes universal remote controls and expects to sell 526 units in January, 575 in February, 922 in March, 420 in April, and 590 in May. The required ending inventory is 19% of the next month’s sales. Calculate the total production for the first four months (January, February, March and April). Round to the nearest hundreth, two decimal places.
Majan Company expects sales of Product G to be 30,000 units in April, 40,000 units in May and 50,000 units in June. The company desires that the inventory on hand at the end of each month be equal to 30% of the next month's expected unit sales. Due to excessive production during March, on March 31 there were 20,000 units of Product G in the ending inventory. Majan Company's production of Product G for May should be:
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: 20,000 22,000 19,500 18,000 March April May June Wright maintains an ending inventory for each month in the amount of two and one-half times the expected sales in the following month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $7 per unit and are paid for in the month after production. Labor cost is $11 per unit and is paid for in the month incurred. Fixed overhead is $19,000 per month. Dividends of $21,400 are to be paid in May. The firm produced 19,000 units in February. Complete a production schedule and a summary of cash payments for March, April, and May. Remember that production in any one month is equal to sales plus desired ending inventory minus beginning inventory. Note: Input all amounts as positive values except Beginning inventory values under Production Schedule which should be entered with a minus sign. Leave no cells blank…
New Energy Incorporated has a beginning inventory balance on January 1 of 25,000 units and desires an ending balance of 20% of the next month’s sales. If sales are expected to be 28,000 for January and 35,000 for February, what is the ending balance as of January 31?
Victory Enterprise manufactures cabinets. Projected sales in units are as follows: October - 4.600 units; November - 5,000 units; December - 4,200 units; January - 6,000 units. | | The ending finished goods inventory for every month is projected to be at 50% of the sales in units of the next month. The number of units to be produced in December should be: 1. 3,000 units 2. 5,100 units 3. 4,200 units 4. 5,000 units O 1 O 2 O 3 4
The Porch Cushion Company manufactures foam cushions. The number of cushions to be produced in the upcoming three months follows: Number of foam cushions to be produced in July Number of foam cushions to be produced in August Number of foam cushions to be produced in September Each cushion requires 2 pounds of the foam used as stuffing. The company has a policy that the ending inventory of foam each month must be equal to 30% of the following month's expected production needs. How many pounds of foam does The Porch Cushion Company need to purchase in August? OA. 20,800 OB. 15,400 13,000 11,000 9,000 OC. 27,400 OD. 28,600
(Production schedule) The projected sales, in units,for Einstein Inc. By month for the first four months were January 8,000 February 12,000 March 16,000 April 19,200 Inventory of finished goods on December 31 was 6,400 units. The company desired to have an ending inventory each month equal to one-half of next month's estimated sales. Determine the company's production requirements for each month of the first quarter
Garza Electronics expects to sell 500 units in January, 250 units in February, and 1,000 units in March. January's beginning inventory is 700 units. Expected sales for the whole year are 7,200 units. Garza has decided on a level monthly production schedule of 600 units (7,200 units/12 months = 600 units per month). What is the expected end- of-month inventory for January, February, and March?