Sales in December were $960,000. Projected sales for the first quarter of next year are: January $1,080,000 February $1,300,000 March $1,280,000 Sales are 20% cash and 80% on credit. Debtors pay in the month following the sale. Calculate the total cash sales for the three months, January, February and March. Select one: O a. $732,000 O b. $256,000 O c. $960,000 O d. $2,848,000 O e. none of these

Sales in December were $960,000. Projected sales for the first quarter of next year are: January $1,080,000 February $1,300,000 March $1,280,000 Sales are 20% cash and 80% on credit. Debtors pay in the month following the sale. Calculate the total cash sales for the three months, January, February and March. Select one: O a. $732,000 O b. $256,000 O c. $960,000 O d. $2,848,000 O e. none of these

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 34E: A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and...

See similar textbooks

Similar questions

A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000
Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
Here is a forecast of sales by National Bromide for the first four months of 2022 (figures in $ thousands): Month 1 Month 2 Month 3 Month 4 Cash sales 35 44 38 34 Sales on credit 300 320 290 270 On average, 45% of credit sales are paid for in the current month, 25% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? Note: Do not round intermediate calculations. Enter your answers in thousands and rounded to one decimal place.
Wigmore, Incorporated, has estimated sales of $20,200, $21,825, $20,170, and $21,900 for each quarter next year, respectively. The accounts receivable period is 75 days. What is the expected accounts receivable balance at the end of the second quarter? Assume each month has 30 days. Multiple Choice $3,637.50 $16,833.33 $18.187.50 $16.808.33 $3,361.67
Fine Co. has the following sales forecasts for the third quarter of 2021: P85,000 (July), P88,000 (Aug), P82,000 (Sep). All sales are on credit. Seventy-five percent are collected in the month of sales and remainder is collected the following month. Minimum cash balance is P10,000. How much cash would be collected in September from sales? A P61,500 P66,000 P87,250 D P83,500
10. Right Answer Company has the following sales forecast for the selected three-month period in 2018. April, P120,000; May, P70,000; June, P80,000. 70% of sales are collected in the month of sale, and the balance are collected in the following month. Accounts receivable balance in April 1, P100,000. Cash balance in April 1, P60,000. Minimum cash balance required is P50,000. Cash can be borrowed in the multiples of P10,000 from local bank (disregard the interest charges). What is the cash balance at the end of April assuming that cash is received only from customers and that P200,000 is the cash out during April? 11.Selected information from the accounting records of Check Answer Co. is as follows: Net accounts receivable at Dec. 31, 2018, P900,000; Net accounts receivable at Dec. 31, 2019, P1,000,000; Inventories at Dec. 31, 2018, P1,100,000; Inventories at Dec. 31, 2019, P1,200,000; Accounts receivable turnover, 5 times; inventory turnover, 4 times. What is Check Answer Company's…
Here is a forecast of sales by National Bromide for the first four months of 2022 (figures in $ thousands): Month 1 Month 2 Cash sales Sales on credit 16 110 25 130 Month 3 Month 4 19 100 15 80 On average, 51% of credit sales are paid for in the current month, 31% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? Note: Do not round intermediate calculations. Enter your answers in thousands and rounded to one decimal place. Items Month 3 Month 4 Expected Cash Inflow from Operations (in $ thousands)
Dora Distribution has projected the following quarterly sales. The accounts receivable at the beginning of the year is $970 and the collection period is 60 days. What are collections for the first quarter? Q1 Q2 Q3 Q4 Sales $ 1,585 $ 1,705 $ 1,995 $ 2,075
A company estimates the following sales demand from Jan- July 2021: Sales (Units) 150,000 180,000 120,000 240,000 210,000 180,000 240,000 Month Jan Feb March April Мay June July Cash sales account for 50% of the total sales. Debtors are granted 2 months credit, of which half is collected in the month following sales, and the other half after 2 months. Determine the collection from sales in each of the months from April – June 2021. Explain how the credit policy offered by a company affects the budgeting exercise. (All workings must be clearly shown)
Here is a forecast of sales by National Bromide for the first 4 months of 2022 (figures in thousands of dollars): Month: Cash sales Sales on credit 1 23 140 Month 3 Month 4 On average, 50% of credit sales are paid for in the current month, 30% in the next month, and the remainder in the month after that. What are the expected cash collections in months 3 and 4? Note: Enter your answers in whole dollars not in thousands of dollars. $ $ 2 3 32 26 160 130 > Answer is complete but not entirely correct. Expected Cash Collections 4 22 110 191,000 X 172,000 X
Your projected sales for the first 3 months of next year are as follows:January, $15,000; February, $20,000; and March, $25,000. Based on lastyear’s data, cash sales are 20 percent of total sales for each month. Of theaccounts receivable, 60 percent are collected in the month after the sale and40 percent are collected in the second month following the sale. Sales forNovember of the current year are $15,000 and for December are $17,000.You have the following estimated payments: January, $4,500; February,$5,500; and March, $5,200.a. Using the format from the pro forma cash budget in Table 6–8, what is yourmonthly cash budget for January, February, and March?b. What will your accounts receivable be for the beginning of April?c. Will your company have any borrowing requirements for any month duringthis 3-month period?
Here is a forecast of sales by National Bromide for the first four months of 2022 (figures in $ thousands). Month 1 Month 2 25 34 200 220 Month 3 28 Month 4 24 190 170 Cash sales Sales on credit On average, 45% of credit sales are paid for in the current month, 25% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? Note: Do not round intermediate calculations. Enter your answers in whole dollars and not in thousands rounded to the nearest whole number. Answer is complete but not entirely correct. Expected Cash Inflow from Operations (in S thousands) Items Month 3 Month 4 $ 391 360