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

Hello, I could really use some help with this. I am struggling. Thank you
godo
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…
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?
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…
Assume that sales and expenses forecasts for months April, May, June, and July are as follows. month, 60% are paid in the next month, and 20% are paid in the second month after. All expenses in a month are paid in the same month. There is a $20,000,000 minimum required cash balance at the end of each month, and any shortage from this minimum requirement will be covered by obtaining a loan. Any excess over $20,000,000 will be used to reduce or pay off cumulative loan. Initial cash balance in June is $6,000,000 and there is no cumulative loan at this time. Monthly prorated tax rate is 2%, and monthly interest rate on cumulative loan is 1%. Requirements: Prepare cash budget proforma for months June and July and interpret the result in detail.
Al-Morooj Co. has the following sales forecasts for its hip waders next year: First Quarter 11000 units Second Quarter 4% increase over first quarter Third Quarter 8% decrease from first quarter Fourth Quarter 4% decrease over first quarter Required: Calculate the Al-Morooj's estimated sales in units for next year.
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
Omegon Limited has the following sales forecasts for its watches next year:First Quarter..10,000 unitsSecond Quarter.5% increase over first quarterThird Quarter 3% increase from second quarterFourth Quarter.8% increase over third quarterWhat is Omegon’s total sales budget in units for next year?1) 43,485 units.2) 42,995 units.3) 40,685 units.4) 40,000 units
answer?
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…
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.