| a) Forecasted Sales of each quarter: | |||||
| Particulars | Q1 | Q2 | Q3 | Q4 | Period End |
| Cash Sales | 69,000 | 180,000 | 210,000 | 150,000 | 609,000 |
| Credit Sales | 46,000 | 120,000 | 140,000 | 100,000 | 406,000 |
| Total | 115,000 | 300,000 | 350,000 | 250,000 | 1,015,000 |
| b) Cash receipts section of the 2019 cash budget: | |||||
| Particulars | Q1 | Q2 | Q3 | Q4 | Period End |
| Cash sales for the quarter | 69,000 | 180,000 | 210,000 | 150,000 | 609,000 |
| 50% credit customers pay during the quarter in which sales took place | 23,000 | 60,000 | 70,000 | 50,000 | 203,000 |
| 30% pay in the following quarter | 24,000 | 13,800 | 36,000 | 42,000 | 115,800 |
| 15% pay in the second quarter | 8,100 | 12,000 | 6,900 | 18,000 | 45,000 |
| Total | 124,100 | 265,800 | 322,900 | 260,000 | 972,800 |
Sports sales for Hype Sports Inc. is a retailer of clothing and sports equipment. The following...
The Gruber Company has projected the following quarterly sales amounts for the coming year. Q1 Sales $670 Q2 Q3 $700 $780 Q4 $850 a. Accounts receivable at the beginning of the year are 5290. The company has a 45. day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. A negative answer should be indicated by a minus sign.)...
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, 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 $109,000 November 136,000 December 199,000 The Accounts Receivable balance on September 30...
Academic Learning had prepared the following sales budget,
schedule of budgeted cash receipts, and cash budget for 2019:
Academic Learning
Sales Budget
For the Year Ended December 31, 2019
First
Second
Third
Fourth
Quarter
Quarter
Quarter
Quarter
Total
Budgeted tablets to be sold
550
350
1,600
500
3,000
Sales price per unit
$550
$550
$550
$550
$550
Total sales
$302,500
$192,500
$880,000
$275,000
$1,650,000
Schdule of Cash Receipts from Customers
First
Second
Third
Fourth
Quarter
Quarter
Quarter
Quarter
Total
Total...
Active Life Inc., a sports equipment retailer, needs to prepare a cash budget for the first quarter of 2018. The financial staff at Active Life has forecasted the following sales figures: January February March April May $100,000 $150,000 $300,000 $250,000 $150,000 Actual sales in October, November, and December 2017 were $125,000, $146,000, and $125,000, respectively. Cash sales are 40% of the total, and the rest are on credit. Under the current credit policy the firm expects to collect 60% of...
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, 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 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 customers. OfficeMart estimates that 20% 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 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 $127,000 November 159,000 December 232,000...
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, 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
$109,000
November
136,000
December
199,000
The Accounts Receivable balance on September 30...
The Litzenberger Company has projected the
following quarterly sales amounts for the coming year:
The Litzenberger Company has projected the following quarterly sales amounts for the coming year: Sales 01 $800 02 $830 03 $910 04 $990 a. Accounts receivable at the beginning of the year are $390. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to 2 decimal...