Question

In: Accounting

Use the following information for #22 and #23: Bries Corporation is preparing its cash budget for...

Use the following information for #22 and #23: Bries Corporation is preparing its cash budget for January. The budgeted beginning cash balance is $18,000. Budgeted cash receipts total $183,000 and budgeted cash disbursements total $188,000. The desired ending cash balance is $30,000.

22. The excess (deficiency) of cash available over disbursements for January is: A. $23,000 B. $13,000 C. ($5,000) D. $201,000

23. To attain its desired ending cash balance for January, the company should borrow: A. $17,000 B. $0 C. $30,000 D. $43,000

Solutions

Expert Solution

  • All working forms part of the answer
  • Following Working is for Both #22 and #23

A

Beginning Cash Balance

$            18,000.00

B

Budgeted Cash Receipts

$          183,000.00

C = A + B

   Total Cash Available

$          201,000.00

D

Budgeted Cash Disbursement

$          188,000.00

E = C - D

   Excess (Deficiency) of Cash Available over Disbursements

$            13,000.00 [Answer for #22]

F

Desired ending Cash Balance

$            30,000.00

G = F - E

Amount to be borrowed

$            17,000.00 [Answer for #23]

  • Correct answer for #22 = Option ‘B’ $ 13,000
  • Correct answer for #23 = Option ‘A’ $ 17,000

Related Solutions

Papst Company is preparing its cash budget for the month of May. The following information is...
Papst Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable (based on sales made to customers on open account): Actual credit sales for March $ 130,000 Actual credit sales for April $ 160,000 Estimated credit sales for May $ 210,000 Estimated collections in the month of sale 25 % Estimated collections in the first month after the month of sale 60 % Estimated collections in the second month after...
Ilona Ltd is preparing its cash budget for May. The following information is available regarding the...
Ilona Ltd is preparing its cash budget for May. The following information is available regarding the monthly collection history of the company: Current month’s sales collections 30% Prior month’s sales collections 58% 2 months’ prior sales collections 6% 3 months’ prior sales collections 4% The remaining 2% is not collected and the company writes it off as bad debt. Credit sales to date are as follows: February R410 000 March R295 000 April R385 000 May R400 000 The total...
Petesy Corporation is preparing its Master Budget for 2019. Budget information is as follows:                           &nb
Petesy Corporation is preparing its Master Budget for 2019. Budget information is as follows:                                                         Sales                      Production Cost                                Operating Expenses 2019               1st Quarter          P280,000              P192,000                              P64,000                         2nd Quarter         320,000               200,000                                  68,000                         3rd Quarter          360,000               224,000                                  72,000                         4th Quarter          352,000               200,000                                  76,000 2020               1st Quarter          320,000               224,000                                  72,000 The budgeted Finished Goods Inventories are:         2018       March 31             P56,000                         June 30                 52,000                         September 30      60,000                         December 31     48,000 The company uses...
Walsh Corporation is preparing its cash budget for January. The budgeted beginning cash balance is $18,000....
Walsh Corporation is preparing its cash budget for January. The budgeted beginning cash balance is $18,000. Budgeted cash receipts total $183,000 and budgeted cash disbursements total $188,000. The desired ending cash balance is $30,000. The excess (deficiency) of cash available over disbursements for January is: Select one: a. 23,000 b. $13,000 c. $201,000 d. ($5,000)
2. Webster Corporation is preparing its cash budget for April. The March 31 cash balance is...
2. Webster Corporation is preparing its cash budget for April. The March 31 cash balance is $36,500. Cash receipts are expected to be $642,000 and cash payments for purchases are expected to be $609,500. Other cash expenses expected are $27,100 selling and $33,600 general and administrative. The company desires a minimum cash balance at the end of each month of $31,000. If necessary, the company borrows enough cash to meet the minimum using a short-term note. Webster's preliminary cash balance...
Bries Corporation is preparing its cash budget for January. The budgeted beginning cash balance is $18,900....
Bries Corporation is preparing its cash budget for January. The budgeted beginning cash balance is $18,900. Budgeted cash receipts total $187,500 and budgeted cash disbursements total $189,800. The desired ending cash balance is $30,900. To attain its desired ending cash balance for January, the company should borrow: Multiple Choice $30,900 $47,500 $14,300 $0 Sarafiny Corporation is in the process of preparing its annual budget. The following beginning and ending inventory levels are planned for the year. Beginning Inventory Ending Inventory...
ZYX Corporation is preparing a cash budget for January of the coming year. The following data...
ZYX Corporation is preparing a cash budget for January of the coming year. The following data have been forecasted: January February Sales 750,000 800,000 Purchases 450,000 480,000 Operating expenses Payroll 146,800 167,000 Advertising 52,700 62,800 Rent 8,750 8,750 Depreciation 23,750 23,750 End-of-December balances Cash 120,000 Accounts payable 250,000 Bank loan 480,000 Sales are 40% cash. The term of credit sales is 2/10, n/30. The collection pattern for credit sales is 75% in the month following the month of sale (of...
XYZ Corporation is preparing a cash budget for January of the coming year. The following data...
XYZ Corporation is preparing a cash budget for January of the coming year. The following data have been forecasted: January February Sales 750,000 800000 Purchases 450,000 480000 Operating expenses: Payroll 146,800 167400 Advertising 52,700 62800 Rent 8,750 8750 Depreciation 23,750 23,750 End-of-December balances: Cash 120,000 Accounts payable 200,000 Bank loan 480,000 Additional data: Sales are 40% cash. The term of credit sales is 2/10, n/30. The collection pattern for credit sales is 75% in the month following the month of...
XYZ Corporation is preparing a cash budget for January of the coming year. The following data...
XYZ Corporation is preparing a cash budget for January of the coming year. The following data have been forecasted: January February Sales 750,000 800000 Purchases 450,000 480000 Operating expenses: Payroll 146,800 167400 Advertising 52,700 62800 Rent 8,750 8750 Depreciation 23,750 23,750 End-of-December balances: Cash 120,000 Accounts payable 200,000 Bank loan 480,000 Additional data: Sales are 40% cash. The term of credit sales is 2/10, n/30. The collection pattern for credit sales is 75% in the month following the month of...
Sarafiny Corporation is in the process of preparing its annual budget. The following beginning and ending...
Sarafiny Corporation is in the process of preparing its annual budget. The following beginning and ending inventory levels are planned for the year. Beginning Inventory Ending Inventory Finished goods (units) 27,000 77,000 Raw material (grams) 57,000 47,000 Each unit of finished goods requires 2 grams of raw material. The company plans to sell 620,000 units during the year. How much of the raw material should the company purchase during the year?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT