Question

In: Accounting

5-24 Preparing a cash payments budget (LO 4) Dakota Williams is one of Texas’s premiere party...

5-24 Preparing a cash payments budget (LO 4)

Dakota Williams is one of Texas’s premiere party planners. She purchases a variety of supplies, such as plastic tableware, stemware, and decorations, throughout the year. Dakota has prepared the following purchases budget for the coming year.

1st Quarter

2nd Quarter

3rd Quarter

4th Quarter

Budgeted purchases

$300,000

$420,000

$435,000

$515,000

Historically, Dakota has paid for 40% of her purchases in the quarter of purchase and 60% in the quarter following purchase. On December 31 of this year Dakota had a $250,000 accounts payable balance.

Required

Prepare Dakota’s cash payments budget for the coming year.

Solutions

Expert Solution

Dakota Williams
cash payments budget
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year
Accounts Payable $                                   250,000 $     250,000
1st Quarter purchases $300,000*40% = $120,000 $300,000*60% = $180,000 $     300,000
2nd Quarter purchases $420,000*40% = $168,000 $420,000*60% = $252,000 $     420,000
3rd Quarter purchases $435,000*40% = $174,000 $435,000*60% = $261,000 $     435,000
4th Quarter purchases $515,000*40% = $206,000 $     206,000
Total $                                   370,000 $                                   348,000 $                                   426,000 $                                   467,000 $ 1,611,000

You can reach me over comment box if you have any doubts. Please rate this answer


Related Solutions

Dakota Williams is one of Texas’s premiere party planners. She purchases a variety of supplies, such...
Dakota Williams is one of Texas’s premiere party planners. She purchases a variety of supplies, such as plastic tableware, stemware, and decorations, throughout the year. Dakota has prepared the following purchases budget for the coming year. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted purchases $300,000 $420,000 $435,000 $515,000 Historically, Dakota has paid for 40% of her purchases in the quarter of purchase and 60% in the quarter following purchase. On December 31 of this year Dakota had a...
Exercise 14-11 Preparing a schedule of cash payments for selling and administrative expenses LO 14-4 The...
Exercise 14-11 Preparing a schedule of cash payments for selling and administrative expenses LO 14-4 The budget director for Munoz Cleaning Services prepared the following list of expected selling and administrative expenses. All expenses requiring cash payments are paid for in the month incurred except salary expense and insurance. Salary is paid in the month following the month in which it is incurred. The insurance premium for six months is paid on October 1. October is the first month of...
Exercise 14-13 Preparing a cash budget LO 14-5 The accountant for Rooney’s Dress Shop prepared the...
Exercise 14-13 Preparing a cash budget LO 14-5 The accountant for Rooney’s Dress Shop prepared the following cash budget. Rooney’s desires to maintain a cash cushion of $17,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 3 percent per month. Required Complete the cash budget by filling in the missing amounts. Determine the amount of net cash flows from operating...
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash...
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash collections from sales for the first quarter of 2019. They expect sales in January to be $400,000, February to be $300,000, and March to be $500,000. !0% of the sales will be paid for in cash. The remainder will be charged on account. From past experience, the company knows their customers take 3 months to pay their bills in total, with 40% of a...
Exercise 20-32A Merchandising: Cash budget LO P4 Kelsey is preparing its master budget for the quarter...
Exercise 20-32A Merchandising: Cash budget LO P4 Kelsey is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for merchandise for the next three months follow. Budgeted July August September Sales $ 63,200 $ 80,800 $ 48,800 Cash payments for merchandise 42,000 32,800 33,600 Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $13,100 in cash;...
Exercise 20-32A Merchandising: Cash budget LO P4 Kelsey is preparing its master budget for the quarter...
Exercise 20-32A Merchandising: Cash budget LO P4 Kelsey is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted July August September Sales $ 63,500 $ 80,500 $ 48,500 Cash payments for merchandise 41,400 33,100 33,900 Sales are 15% cash and 85% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $12,800 in cash;...
PA12-3 Preparing a Statement of Cash Flows (Indirect Method) [LO 12-2, LO 12-3, LO 12-4, LO...
PA12-3 Preparing a Statement of Cash Flows (Indirect Method) [LO 12-2, LO 12-3, LO 12-4, LO 12-5] XS Supply Company is developing its annual financial statements at December 31. The statements are complete except for the statement of cash flows. The completed comparative balance sheets and income statement are summarized:     Current Year Previous Year Balance Sheet at December 31             Cash $ 35,370   $ 30,450   Accounts Receivable   36,600     28,800   Inventory   42,600     38,800   Equipment   133,000     108,000   Accumulated Depreciation—Equipment   (31,600 )   (25,800 )...
Cash Budget The Williams Supply Company sells for $50 one product that it purchases for $20....
Cash Budget The Williams Supply Company sells for $50 one product that it purchases for $20. Budgeted sales in total dollars for the year are $3,000,000. The sales information needed for preparing the July budget follows: Month Sales Revenue May $ 175,000 June 240,000 July 295,000 August 320,000 Account balances at July 1 include these: Cash $ 125,000 Merchandise inventory 47,200 Accounts receivable (sales) 84,530 Accounts payable (purchases) 47,200 The company pays for one-half of its purchases in the month...
Required information PA4-4 Identifying and Preparing Adjusting Journal Entries [LO 4-1, LO 4-2, LO 4-3, LO...
Required information PA4-4 Identifying and Preparing Adjusting Journal Entries [LO 4-1, LO 4-2, LO 4-3, LO 4-6] [The following information applies to the questions displayed below.] Val’s Hair Emporium operates a hair salon. Its unadjusted trial balance as of December 31, 2018, follows, along with information about selected accounts. Account Names Debit Credit Further Information Cash $ 2,800 As reported on December 31 bank statement. Supplies 3,300 Based on count, only $800 of supplies still exist. Prepaid Rent 3,000 This...
PA4-1 Preparing a Trial Balance, Closing Journal Entry, and Post-Closing Trial Balance [LO 4-3, LO 4-5]...
PA4-1 Preparing a Trial Balance, Closing Journal Entry, and Post-Closing Trial Balance [LO 4-3, LO 4-5] Required: 1-a. Prepare an adjusted trial balance at September 30, 2015. Starbooks Corporation provides an online bookstore for electronic books. The following is a simplified list of accounts and amounts reported in its accounting records. The accounts have normal debit or credit balances. Assume the year ended on September 30, 2015. PA4-1 Part 2 2. Prepare the closing entry required at September 30, 2015....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT