Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter. The sales forecasts for the next five quarters are as follows: Following Year First Quarter Quarter in Coming Year First Second Third Fourth Sales forecast $460 $334 $351 $399 $399 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 $351. What is the forecast for Paymore's cash receipts in each quarter of the coming year? (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) Quarter Collections 1 2 3 4

Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter. The sales forecasts for the next five quarters are as follows: Following Year First Quarter Quarter in Coming Year First Second Third Fourth Sales forecast $460 $334 $351 $399 $399 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 $351. What is the forecast for Paymore's cash receipts in each quarter of the coming year? (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) Quarter Collections 1 2 3 4

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

Shown below is the sales forecast for Tulip's industry. For the first four Quarter of the coming year. Quarter 1 sales (in units) are 40 000 increases in sequent by the multiple of 20 000 for the rest of quarters except for the last quarter sales are 50 000 units. • Tulip's single product sells for 8$.• Sales collected in the following pattern, 75% in the quarter of sales, and the remaining 25% in the following quarter. The financial statement position (FSP) showed $65 000 balance of account receivables. All of which will be collected in the first quarter.• The company desires an ending finished goods inventory at the end each quarter equal to 30% of the budget sales unit sales for the next quarter. It had 12 000 units in hand on December, 31. Beginning balance of finished goods is 10 000 units• Five pounds of raw materials are required to complete one unit of product. Tulip Company require ending raw materials inventory at the end of each quarter equal to 10% of following quarter's…
Wildcat, Incorporated, has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $170 $185 $200 $225 Sales for the first quarter of the year after this one are projected at $180 million. Accounts receivable at the beginning of the year were $71 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 45 percent of the next quarter's forecast sales, and suppliers are normally paid in 36 days. Wages, taxes, and other expenses run about 25 percent of sales. Interest and dividends are $14 million per quarter. Wildcat plans a major capital outlay in the second quarter of $85 million. Finally, the company started the year with a $54 million cash balance and wishes to maintain a $30 million minimum balance. Assume that Wildcat can borrow any needed funds on a short-term basis at a rate of 3 percent per quarter and can Invest any excess funds in short-term marketable securities at a rate of 2 percent per…
All sales are made on credit terms of net 30 days and are collected the following month and no bad debts are anticipated. The accounts receivable on the balance sheet at the end of September thus will be collected in October. The October sales will be collected in November, and so on. Inventory on hand represents a minimum operating level (or “safety” stock), which the company intends to maintain. Cost of goods sold average 80 percent of sales. Inventory is purchased in the month of sale and paid for in cash. Other cash expenses average 7 percent of sales. Depreciation is $10,000 per month. Assume taxes are paid monthly and the effective income tax rate is 40 percent for planning purposes. The annual interest rate on outstanding long-term debt and bank loans (notes payable) is 12%. There are no capital expenditures planned during the period, and no dividends will be paid. The company’s desired end-of-month cash balance is $80,000. The president hopes to meet any cash shortages during…
Valley's managers have made the following additional assumptions and estimates: Estimated sales for July and August are $345,000 and $315,000 respectively Each month's sales are 20% cash sales and 80% credit sales. Each month's credit sales are collected 30% in the month of the sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July Each month's ending inventory must equal 20% of the cost of the next month's sales. The Cost of Goods Sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July Monthly selling and administrative expenses are always $75,000. Each month $10,000 of this total amount is depreciation expense and the remaining $65,000 relates to expenses that are paid in the month they are incurred The company does not plan to buy or sell any plant and…
69) Western Company expects the following credit sales for the first five months of the year: January, $43,000; February, $58,000; March, $48,000; April, $54,000, May $58,000. Experience has shown that payment for the credit sales is received as follows: 60% in the month of sale, 25% in the first month after sale, 10% in the second month after sale, and the remainder is uncollectible. How much cash can Western Company expect to collect in March as a result of credit sales (current and past)? A) $28,800. B) $42,600. C) $48,000. D) $47,600. E) $41,100.
Neon Inc.’s forecast sales for July is $72,000. It has $15,000 in accounts receivable at the end of June. 30% of its total sales are expected to be cash sales. Of the remaining 70%, 80% are expected to be collected in the month of the sale and the remaining 20% in the month following the sale. Determine the amount of accounts receivable at the end of July. Group of answer choices $79,200 $61,920 $10,080 $40,320
The production planner of a company forecasts the sales over the next six months as 180, 220 , 210, 190, 170, and 210 units, respectively. The beginning inventory is 100 units and the last monthly production level was 130 units. The unit costs are given as follows: Inventory holding cost is 90 TL per unit per month; production cost is 1150 TL per unit; production level increasing cost is 300 TL per unit; and production level decreasing cost is 400 TL per unit. The planner decides to use level strategy, where the monthly production level is determined equal to the average of net demand. What is the total cost (in TL) of the resulting plan? O a 1,246,350 O b. 1,347,450 O c. 1,412,850 O d. 1,391,100 O e. 1,278,600
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…
JoAnn Manufacturing has projected the following sales for the coming year: Sales $25,847.50 C$25,182.50 $22,604.17 Q1 $23,560.83 Q2 $ 54,750 $ 61,850 Q3 The company places orders each quarter that are 35 percent of the following quarter's sales and has a 30-day payables period. What is the payment of accounts for the third quarter? $70,050 Q4 $75,750
Narai Co. has a desired ending inventory of 30% of the next months forecasted sales. In turn, their cost of goods sold is 60%, and their forecasted sales for the months of March, April, May, June, and July are as follows: $750,000, $880,000, $700,000, $800,000, and $900,000 respectively. Purchases for the months of February and March were $500,000 and $360,000 and their purchases are paid as follows: 10% during the month of the purchase 80% in the next month and the final 10% in the next month. Required: Prepare budget schedules for the months of April, May, and June for required purchases and also for disbursements for purchases.
NuParts, Inc., has estimated quarterly sales for next year, starting with Quarter 1, of $15,900, $16,800, $17,500, and $16,400. Purchases are equal to 67 percent of the following quarter's sales and the accounts payable period is 60 days. Assume 30 days in each month. How much will the firm owe its suppliers at the end of Quarter 3? $7,066.67 $7,506.67 $7,816.67 $6,933.33 $7,325.33
Valley's managers have made the following additional assumptions and estimates: Estimated sales for July and August are $345,000 and $315,000 respectively Each month's sales are 20% cash sales and 80% credit sales. Each month's credit sales are collected 30% in the month of the sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July Each month's ending inventory must equal 20% of the cost of the next month's sales. The Cost of Goods Sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July Monthly selling and administrative expenses are always $75,000. Each month $10,000 of this total amount is depreciation expense and the remaining $65,000 relates to expenses that are paid in the month they are incurred The company does not plan to buy or sell…