Question

Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding...

Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows:

October

November

December

Cash sales

$85,000

$75,000

$85,000

Credit Sales

85,000

90,000

93,500

Total

170,000

165,000

178,500

Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month following the month of sale. Customers are granted a 1.5% discount for payment within 10 days of billing. Approximately 75% of collectible credit sales take advantage of the cash discount.

    Inventory purchases each month are 100% of the cost of the following month’s projected sales. (The gross profit rate for Timpco is approximately 30%.) All merchandise purchases are made on credit, with 20% paid in the month of purchase and the remainder paid in the following month. No cash discounts for early payment are in effect.

Required:

1.

Calculate the budgeted total cash receipts for November and December.

(Round your intermediate calculations and final answers to the nearest whole dollar amount)

November

December

Total Cash Receipts

2.

Calculate budgeted cash payments for November and December (budgeted total sales for January of the coming year = $175,000). (Do not round intermediate calculations. Round your final answers to nearest whole dollar amount.)

November

December

Budgeted cash payments

Homework Answers

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
Information pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019...
Information pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019 (Budgeted) Cash sales $ 120,000 $ 124,000 $ 76,000 Credit sales 288,000 416,000 212,000 Total sales $ 408,000 $ 540,000 $ 288,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next...
Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $...
Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $ 107,000 $ 136,000 $ 89,000 Credit sales 299,000 461,000 245,000 Total sales $ 406,000 $ 597,000 $ 334,000 Management estimates that 4% of credit sales are eventually uncollectible. Of the collectible credit sales, 60% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an...
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000...
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000 January 9,000 23,000 February 11,000 25,000 March 77,800 12,000 12,000 22,000 March 68,500 12,500 12,500 23,500 May 72,000 12,300 12,300 24,500 Wages & other operating expenses are estimated as follows: Month Wages Other Expenses March 20,000 28,000 April 17,500 22,000 May 20,000 23,000  Newequipment purchased in February for $16,750 istobepaid forin April.  New furniture purchased in March for $15,000 isto be paid...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $123,000 November 154,000 December 225,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $107,000 November 134,000 December 196,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 20% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $107,000 November 134,000 December 196,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $117,000 November 146,000 December 214,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $129,000 November 161,000 December 236,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $128,000 November 160,000 December 234,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $131,000 November 164,000 December 240,000...