Question

In: Accounting

7) Using the information below, calculate Party Time Inc.'s total cash receipts for January, February, and...

7) Using the information below, calculate Party Time Inc.'s total cash receipts for January, February, and March.

Of the 11,000 “Pirate Treasure Chests” (party favor boxes) expected to be sold in Q1, 3,000 boxes are expected to be sold in January, 3,500 in February, and 4,500 in March. Each box sells for $5.50, as reflected in the Sales Budget for the year. Sixty percent of the Party Time Inc.’s sales are credit sales. Of the credit sales, 52 percent is collected in the month of the sale, 38 percent is collected during the following month, and 10 percent is collected in the second month following the sale. Assume that there were $4,000 of accounts receivable from last year's sales that will be collected in January.

Jan.

Feb.

March

Budgeted Sales Revenue

Cash Sales 40%

Credit sales current 52%

Credit Sales Next 38%

Credit Sales 2nd 10%

Total Cash Receipts (Cash Collected)

Solutions

Expert Solution

Feb. March
Jan.
Budgeted Sales Revenue     16,500     19,250        24,750
Cash Sales 40%       6,600       7,700          9,900
Credit sales current 52%       5,148       6,006          7,722
Credit Sales Next 38%              -         3,762          4,389
Credit Sales 2nd10%              -                -               990
Accounts receivables       4,000              -                  -  
Total Cash Receipts (Cash Collected)     32,248     36,718        47,751

Related Solutions

Newman Medical Clinic has budgeted the following cash flows. January February March   Cash receipts $ 106,000...
Newman Medical Clinic has budgeted the following cash flows. January February March   Cash receipts $ 106,000 $ 112,000 $ 132,000   Cash payments      For inventory purchases 93,000 75,000 88,000      For S&A expenses 34,000 35,000 30,000      Newman Medical had a cash balance of $11,000 on January 1. The company desires to maintain a cash cushion of $5,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 1 percent...
Thornton Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 116,000...
Thornton Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 116,000 $ 122,000 $ 142,000 Cash payments For inventory purchases 98,000 80,000 93,000 For S&A expenses 39,000 40,000 35,000 Thornton Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash cushion of $9,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent...
Newman Medical Clinic has budgeted the following cash flows. January February March   Cash receipts $ 101,000...
Newman Medical Clinic has budgeted the following cash flows. January February March   Cash receipts $ 101,000 $ 107,000 $ 127,000   Cash payments      For inventory purchases 90,500 72,500 85,500      For S&A expenses 31,500 32,500 27,500      Newman Medical had a cash balance of $8,500 on January 1. The company desires to maintain a cash cushion of $6,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent...
Based on the data presented in the Spreadsheet below (Cash Budget tab), calculate the cash receipts...
Based on the data presented in the Spreadsheet below (Cash Budget tab), calculate the cash receipts for the first quarter of this year. Complete your calculations by filling in the highlighted cells. Discuss your observations about the way cash is collected if the company needs $150,000 per month for expenses. Cookie Business The budgeted credit sales are as follows: December last year $          250,000 January $          125,000 February $          300,000 March $             90,000 Collection: Month of the sale 80% Month...
Month Cash disbursement Cash receipts January 100,000 100,000 February 110,000 90,000 March 110,000 80,000 April 150,000...
Month Cash disbursement Cash receipts January 100,000 100,000 February 110,000 90,000 March 110,000 80,000 April 150,000 100,000 May 180,000 120,000 June 180,000 160,000 July 180,000 200,000 August 180,00 250,000 September 150,000 250,000 October 110,000 200,000 November 100,000 140,000 December 100,000 100,000 Below table shows the monthly estimates of cash disbursement and receipts from January to December 2019 for preparing the cash budgets for Bintang Sdn Bhd. Bintang Sdn Bhd has beginning cash on hand of RM10,000 and the company wishes...
1. Please use the following information to develop a cash budget for January and February: January...
1. Please use the following information to develop a cash budget for January and February: January February Beginning balance of cash $ 25,000 ? Cash collections from customers 150,000 200,000 Cash payments 205,000 110,000 Minimum cash balance at end of each month $20,000 Money is assumed to be borrowed at the beginning of any month when it is needed and paid back at the end of any month when it can be paid back. Interest is paid in the month...
Rockers expects total sales of $ 701,000 for January and $351,000 for February Assume that Rockers​'s...
Rockers expects total sales of $ 701,000 for January and $351,000 for February Assume that Rockers​'s sales are collected as​ follows: 60% in the month of the sale 30% in the month after the sale 7% two months after the sale 3% never collected November sales totaled $397,000​, and December sales were $400,000. Prepare a schedule of cash receipts from customers for January and February. Round answers to the nearest dollar.​
During 2018, HomeVideo, Inc. recorded all cash receipts and cash disbursements. However, HomeVideo, Inc.’s banker is...
During 2018, HomeVideo, Inc. recorded all cash receipts and cash disbursements. However, HomeVideo, Inc.’s banker is requiring an income statement and balance sheet prepared on an accrual basis. The following is a recap of the cash receipts for 2018: Collections from customers $      356,800 Proceeds from bank loan            75,000 Proceeds from sale of common stock          100,000 $      531,800 The cash disbursements data is available on the attached Excel sheet. In addition, HomeVideo, Inc.’s payroll disbursements for wages totaled $105,200. The data was...
Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January 415 $ 6,100 February...
Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January 415 $ 6,100 February 365 $ 5,624 March 434 $ 6,315 April 449 $ 6,453 May 391 $ 5,874 June 366 $ 5,627 July 441 $ 6,380 August 392 $ 5,887 Management believes that inspection cost is a mixed cost that depends on units produced. Using the least-squares regression method, the estimate of the fixed component of inspection cost per month is closest to:
Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January 428 $ 6,126 February...
Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January 428 $ 6,126 February 378 $ 5,637 March 447 $ 6,341 April 462 $ 6,479 May 404 $ 5,887 June 379 $ 5,640 July 454 $ 6,406 August 405 $ 5,900 Management believes that inspection cost is a mixed cost that depends on units produced. Using the least-squares regression method, the estimate of the fixed component of inspection cost per month is closest to:
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT