2. Company A is expecting to sell 10,000 cases in July, 20,000 cases in August, and 30,000 in September of Year 2. Selling price per case is $30. All sales are on account. The sales are collected 70% in the month of sale and 30% in the month following sale. June sales totaled $200,000. Bad debts are negligible and can be ignored. Required: a) Prepare a sales budget. (pls. Disregard the 70% and 30%, just focused on the sales budget formula.)

2. Company A is expecting to sell 10,000 cases in July, 20,000 cases in August, and 30,000 in September of Year 2. Selling price per case is $30. All sales are on account. The sales are collected 70% in the month of sale and 30% in the month following sale. June sales totaled $200,000. Bad debts are negligible and can be ignored. Required: a) Prepare a sales budget. (pls. Disregard the 70% and 30%, just focused on the sales budget formula.)

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

How do you get the last addition loan and ending cash balance?
Please do not give solution in image format
From past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, another 75% are collected in the month following sale, and the remaining 5% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $270,000, and March sales totaled $300,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?
How would this be solved ?
A company requires a minimum $12,400 cash balance at each month-end. If necessary, a loan is taken to meet this requirement at a cost of 1% interest per month (paid at the end of each month). Any preliminary cash balance above $12,400 is used to repay loans at month-end. The cash balance on March 1 is $12,400, and the company has no outstanding loans. Budgeted cash receipts from sales are: March, $26,000; April, $32,400; and May, $41,000. Budgeted cash payments (excluding loan or interest payments) are: March, $30,000; April, $30,200; and May, $32,400. Required: Prepare a cash budget for March, April, and May. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar. Beginning cash balance Add: Cash receipts from sales Total cash available Add: Cash receipts from sales Total cash payments Preliminary cash balance Loan activity Additional loan (loan repayment) Ending cash balance Loan balance,…
ABC Farm is preparing a collection budget for the year. Sales are expected to be P100,000 in January; P200,000 in February; and P300,000 in March. Approximately 60% of the sale is collected during the month of sale and the other 40% is collected in the following month. What is the ending accounts receivable balance of March? 1. P 80,000 2. P120,000 3. P180,000 4. P200,000 1 O 2 O 4
The projected sales for the Leeds Company is given below. The company has determined that all sales are on credit and they do not have any cash sales. For the credit sales, experience tells Leeds they will collect 60% of sales in the quarter of the sale and the remaining 40% is collected the quarter after the sale. The sales in the last quarter of the previous year is $200,000. Qtr 1 Qtr 2 Qtr 3 Qtr 4 Budgeted Sales S600,000 S1,600,000 S800,000 S1,000,000 Leeds need cash to pay for purchases, wages, rent, interest, income taxes, cash dividends, and most other expenses. Leeds Company is a manufacturing company, the material purchases requirement for the next four quarters is given in the following table. Leed Company makes all material purchases on credit. Leed Company will pay for material purchases 80% in the quarter of purchase and 20% in the quarter after the purchase. The materials purchased in the last quarter of previous years is $400,000. Budgeted Material Purchases $250,000…
9. Chadmark Cor. budgeted monthly sales are P3,000. Per experience, 40% of its customers pay in the first month and take the 2 % discount. The remaining 60% pay in the month following the sale and don't receive a discount. Bad debts are very small and are excluded from this analysis. Purchases for next month's sales are constant each month at P1,500. Other payments for wages, rent, and taxes are constant at P700 per month. Construct a single month's cash budget with the information given. What is the average cash gain or (loss) during a typical month? A. P728 B. P740 C. P776 D. P800 E. P2,600
The projected sales for the Leeds Company is given below. The company has determined that all sales are on credit and they do not have any cash sales. For the credit sales, experience tells Leeds they will collect 60% of sales in the quarter of the sale and the remaining 40% is collected the quarter after the sale. The sales in the last quarter of the previous year is $200,000. Qtr 1 Qtr 2 Qtr 3 Qtr 4 Budgeted Sales $600,000 $1,600,000 $800,000 $1,000,000 Leeds need cash to pay for purchases, wages, rent, interest, income taxes, cash dividends, and most other expenses. Leeds Company is a manufacturing company, the material purchases requirement for the next four quarters is given in the following table. Leed Company makes all material purchases on credit. Leed Company will pay for material purchases 80% in the quarter of purchase and 20% in the quarter after the purchase. The materials purchased in the last quarter of previous years is $400,000. Budgeted Material Purchases $250,000…
ABC Farm is preparing a collection budget for the year. Sales are expected to be P100,000 in January; P200,000 in February; and P300,000 in March. Approximately 60% of the sale is collected during the month of sale and the other 40% is collected in the following month. What is the beginning accounts receivable balance of March? 1. P 80,000 2. P120,000 3. P180,000 4. P200,000 01 O 2 O 3 0 4
Need help with this
Clay Co.'s projected sales are as follows: August $400,000 September $450,000 October $550,000 Clay estimates that it will collect 30% in the month of sale, 50% in the month after the sale, and 18% in the second month following the sale. Two percent of all sales are estimated to be bad debts. Instructions: How much are Clay Co.'s budgeted cash receipts for October?