Question

In: Accounting

Pavone Corp. has prepared a preliminary cash budget for the third quarter as shown​ below: Cash...

Pavone Corp. has prepared a preliminary cash budget for the third quarter as shown​ below:

Cash Budget

Jul

Aug

Sep

Beginning cash balance

​$34,000

​$15,000

​$18,500

​Plus: Cash collections

​$56,000

​$52,000

​47,000

Cash available

​90,000

​$67,000

​$65,500

​Less: Cash​ payments:

Purchases of direct materials

​35,000

​9,000

​11,000

Operating expenses

​40,000

​30,500

​30,800

Capital expenditures

0

​9,000

​7,400

Ending cash balance

​$15,000

​$18,500

​$16,300

​Subsequently, the marketing department revised its figures for cash collections. New data are as​ follows: $53,000 in​ July, $56,000 in​ August, and​ $43,000 in September. Based on the new​ data, calculate the new projected cash balance at the end of September.

A.

​$16,300

B.

​$19,500

C.

​$13,300

D.

​$12,000

Solutions

Expert Solution


Related Solutions

Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 258941 265299 284380 Credit Purchases 97804 116018 135024 Wages, Taxes, and Expenses 26612 31353 33454 Interest 7193 7571 8062 Equipment Purchases 54213 61494 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 254958 266136 282816 Credit Purchases 97321 115536 137343 Wages, Taxes, and Expenses 26176 31560 33787 Interest 7124 7595 7934 Equipment Purchases 54316 61677 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 254849 266370 281008 Credit Purchases 97712 113113 131293 Wages, Taxes, and Expenses 26632 31305 33401 Interest 7166 7522 7997 Equipment Purchases 54127 61180 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 258,079 268,029 281,095 Credit Purchases 97,436 118,919 136,436 Wages, Taxes, and Expenses 26,505 31,848 33,758 Interest 7,182 7,615 7,921 Equipment Purchases 54,184 61,353 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below:
    Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below:   Beech CorporationBalance SheetJune 30 Assets     Cash $   91,000   Accounts receivable 133,000   Inventory 36,000   Plant and equipment, net of depreciation 213,000       Total assets $ 473,000     Liabilities and Stockholders’ Equity     Accounts payable $   74,000   Common stock 328,000   Retained earnings 71,000    ...
Swifty, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts,...
Swifty, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Swifty desires to maintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $1,000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) October November December Quarter Beginning cash balance $ $15,100 $ $16,100 Collections from sales 55,980 242,380 Total cash...
Sheridan, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts,...
Sheridan, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Sheridan desires to maintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $1,000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) October November December Quarter Beginning cash balance $ $15,930 $ $16,020 Collections from sales 55,850 241,890 Total cash...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT