Question

The Lawn Antique Mall expects to make purchases in the first quarter of 2018 as follows:...

The Lawn Antique Mall expects to make purchases in the first quarter of 2018 as follows:

January $87,700
February 99,000
March 82,000


Purchases in December 2017 are expected to be $91,000. The company expects that 55 percent of a month’s purchases will be paid in the month of purchase and 45 percent will be paid in the following month.

Estimate cash disbursements related to purchases for each month of the first quarter of 2018.

Cash disbursements for purchases January February March
Payment of December purchases $ $ $
Payment of January purchases
Payment of February purchases
Payment of March purchases
$ $ $

Homework Answers

Answer #1
Cash Payments Schedule
January February March Quarter
December Purchases $          40,950 $     40,950
January Purchases $          48,235 $           39,465 $     87,700
February Purchases $           54,450 $       44,550 $     99,000
March Purchases $       45,100 $     45,100
Total $          89,185 $          93,915 $      89,650 $ 2,72,750
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The Warrenburg Antique Mall expects to make purchases in the first quarter of 2018 as follows:...
The Warrenburg Antique Mall expects to make purchases in the first quarter of 2018 as follows: January $95,000 February 120,000                               March      85,000 Purchases in December 2017 are expected to be $92,000. The company expects that 50 percent of a month's purchases will be paid in the month of purchase and 50 percent will be paid in the following month. Estimate cash disbursements related to purchases for each month of the first quarter of 2018.
The Uli Antique Mall budgeted credit sales in the first quarter of 2018 to be as...
The Uli Antique Mall budgeted credit sales in the first quarter of 2018 to be as follows: January $199,000 February 211,000 March 226,000 Credit sales in December 2017 are expected to be $274,000. The company expects to collect 81 percent of a month’s sales in the month of sale and 19 percent in the following month. Estimate cash receipts for each month of the first quarter of 2018. Collection of credit sales January February March Collection of December sales $...
Clinton Retailers expects to make inventory purchases in the next quarter as follows: April $58,400 May...
Clinton Retailers expects to make inventory purchases in the next quarter as follows: April $58,400 May 69,800 June 95,500 Prior experience has shown that 80 percent of a month’s purchases are paid in the month of purchase and 20 percent are paid in the month following purchase. March purchases were $52,300. Estimate cash disbursements related to purchases for April, May, and June. Cash disbursements for purchases April May June Payment of March purchases $ $ $ Payment of April purchases...
Shamrock Shades operates in mall kiosks throughout the southwestern United States. Shamrock purchases sunglasses from bulk...
Shamrock Shades operates in mall kiosks throughout the southwestern United States. Shamrock purchases sunglasses from bulk discounters and sells the sunglasses in the mall kiosks. Shamrock is in the process of budgeting for the coming year and has projected sales of $430,000 for January, $510,000 for February, $670,000 for March, and $710,000 for April. Shamrock’s desired ending inventory is 40 percent of the following month’s cost of goods sold. Cost of goods sold is expected to be 30 percent of...
Shamrock Shades operates in mall kiosks throughout the southwestern United States. Shamrock purchases sunglasses from bulk...
Shamrock Shades operates in mall kiosks throughout the southwestern United States. Shamrock purchases sunglasses from bulk discounters and sells the sunglasses in the mall kiosks. Shamrock is in the process of budgeting for the coming year and has projected sales of $400,000 for January, $480,000 for February, $640,000 for March, and $680,000 for April. Shamrock’s desired ending inventory is 25 percent of the following month’s cost of goods sold. Cost of goods sold is expected to be 40 percent of...
Shamrock Shades operates in mall kiosks throughout the southwestern United States. Shamrock purchases sunglasses from bulk...
Shamrock Shades operates in mall kiosks throughout the southwestern United States. Shamrock purchases sunglasses from bulk discounters and sells the sunglasses in the mall kiosks. Shamrock is in the process of budgeting for the coming year and has projected sales of $480,000 for January, $560,000 for February, $720,000 for March, and $760,000 for April. Shamrock’s desired ending inventory is 35 percent of the following month’s cost of goods sold. Cost of goods sold is expected to be 45 percent of...
Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during...
Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during the first quarter of 2016 (receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1, 2016) January February March Cash receipts $300,000 $320,000 $290,000 Cash disbursements 280,000 360,000 300,000 The expected cash balance at January 1, 2016, is $82,000. Brewster wants to maintain a cash balance at the end of each month of at least $80,000. Short-term borrowings at 1%...
Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling...
Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company’s accounting records: All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 35 percent are collected in the following month. Uncollectibles amounting to 5 percent of sales are anticipated, and management believes that only 20 percent of the accounts...
Exercise 9-18 Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The...
Exercise 9-18 Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2019 and expected service revenues for 2020...
The following is the sales budget for Profit, Inc., for the first quarter of 2018: January...
The following is the sales budget for Profit, Inc., for the first quarter of 2018: January February March   Sales budget $ 214,000 $ 234,000 $ 257,000 Credit sales are collected as follows: 60 percent in the month of the sale 25 percent in the month after the sale 15 percent in the second month after the sale The accounts receivable balance at the end of the previous quarter was $98,000 ($68,000 of which was uncollected December sales). a. Calculate the...