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?
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?
Foyert Corporation requires a minimum $7,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid at the end of each month). Any preliminary cash balance above $7,000 is used to repay loans at month-end. The cash balance on October 1 is $7,000, and the company has an outstanding loan of $3,000. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. (please see picture for other info) October November December Cash receipts $ 23,000 $ 17,000 $ 21,000 Cash payments 25,500 16,000 15,000 Prepare a cash budget for October, November, and December.
Foyert Corporation requires a minimum $7,400 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid at the end of each month). Any preliminary cash balance above $7,400 is used to repay loans at month-end. The cash balance on October 1 is $7,400, and the company has an outstanding loan of $3,400. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. October November December Cash receipts $ 23,400 $ 17,400 $ 21,400 Cash payments 26,100 16,400 14,600 Prepare a cash budget for October, November, and December. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.)
Foyert Corporation requires a minimum $6,300 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid at the end of each month). Any preliminary cash balance above $6,300 is used to repay loans at month-end. The cash balance on October 1 is $6,300, and the company has an outstanding loan of $2,300. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments October $ 22,300 24,450 November $ 16,300 15,300 December $ 20,300 15,700 Prepare a cash budget for October, November, and December. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) FOYERT CORPORATION es Beginning cash balance Add: Cash receipts Total cash available Add: Cash payments for Interest on loan Total cash payments Preliminary cash balance Loan activity Additional loan (loan repayment) Ending cash…
Karim Corporation requires a minimum $8,100 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid at the end of each month). Any preliminary cash balance above $8,100 is used to repay loans at month-end. The cash balance on July 1 is $8,500, and the company has no outstanding loans. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments Beginning cash balance Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) Total cash available July August $ 24,100 $ 32,100 28,150 30,100 Total cash payments Preliminary cash balance Loan activity Ending cash balance September $ 40,100 32,100 KARIM CORPORATION Cash Budget $ July Loan balance Loan balance - Beginning of month Additional loan (loan repayment) Loan balance…
How would this be solved ?
Karim Corporation requires a minimum $9,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid at the end of each month). Any preliminary cash balance above $9,000 is used to repay loans at month-end. The cash balance on July 1 is $9,400, and the company has no outstanding loans. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. July August September Cash receipts $ 25,000 $ 33,000 $ 41,000 Cash payments 29,500 31,000 33,000 Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.)
hrs
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
please give me answer in excel.