Question

In: Accounting

Tausi Corporation, a company located in Tacoma, WA, started operations in September and had the following sales.

 

Tausi Corporation, a company located in Tacoma, WA, started operations in September and had the following sales.

 

SEP

OCT

NOV

DEC

JAN

FEB

Total Sales

$400,000

$520,000

$660,000

$900,000

$720,000

$700,000

30% of all sales are cash sales. The rest are credit sales. Credit sales are collected as follows: 20% in the month of sale, 70% in the month following sale, and 10% in the second month following sale. There are no bad debts

REQUIREMENTS: (Note: As long as you can answer one question under each category below, you do not need to answer all questions; put effort in understanding "HOW" to solve)

1. Calculate the total cash collections during the month of September

2. Calculate the total cash collections during the month of October

3. Calculate the total cash collections during the month of November

4. Calculate the total cash collections during the month of December

5. Calculate the Accounts Receivable balance as at September 30th

6. Calculate the Accounts Receivable balance as at October 31

7. Calculate the Accounts Receivable balance as at November 30th

8. Calculate the Accounts Receivable balance as at February 28th

Solutions

Expert Solution

sept oct nov Dec jan Feb
cash sale 120000 156000 198000 270000 216000 210000
credit sale 280000 364000 462000 630000 504000 490000
total sale 400000 520000 660000 900000 720000 700000
credit sales collection
sept oct nov Dec jan Feb total
sept 56000 196000 28000 280000
oct 72800 254800 36400 364000
nov 92400 323400 46200 462000
dec 126000 441000 63000 630000
jan 100800 352800 453600
feb 98000 98000
total 56000 268800 375200 485800 588000 513800
1) cash collection for September 120,000+56000= 176000
2) cash collection for october 156,000+268800= 424800
3) cash collection for November 198000+375200= 573200
4) Cash collection for December 270000+485800= 755800
5) Account receivable on september 224000
6) Account receivable oct 31 319200
7) Account receivable nov 30 406000
8) Account receivable Feb 28 442400

Related Solutions

Smith Company started business on September 1. Smith had credit sales of $200,000 in September and...
Smith Company started business on September 1. Smith had credit sales of $200,000 in September and $300,000 in October. The pattern for collection of cash from customers is expected to be 40% in the month of sale (subject to a 2% cash discount), 50% in the month following the month of sale, and 7% in the second month following the month of sale, with 3% uncollectible. How much cash did Smith Company receive from customers on account during October?.
Smith Company started business on September 1. Smith had credit sales of $200,000 in September and...
Smith Company started business on September 1. Smith had credit sales of $200,000 in September and $300,000 in October. The pattern for collection of cash from customers is expected to be 40% in the month of sale (subject to a 2% cash discount), 50% in the month following the month of sale, and 7% in the second month following the month of sale, with 3% uncollectible. How much cash did Smith Company receive from customers on account during October?
Mischief Company had been experimenting with various sales and operations plans. As the firm started to...
Mischief Company had been experimenting with various sales and operations plans. As the firm started to lay out plans for next year, management decided to use a six-month planning horizon to reduce computation cost. The firm’s basic data were: Employment level for this December = 20 people. Demand forecasts for January to June of next year are 200, 240, 220, 300, 250, and 240 units respectively. Inventory level planned for the end of this December = 0. Back-orders aren’t allowed...
Dove Corporation began its operations on September 1 of the current year. Budgeted sales for the...
Dove Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business are $250,000, $320,000, and $410,000, respectively, for September, October, and November. The company expects to sell 25% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month of the sale and 30% in the month following the sale. ​ The cash collections expected in October are a. $320,000 b. $304,250 c....
Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the...
Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business—September, October, and November—are $237,000, $304,000, and $414,000, respectively. The company expects to sell 30% of its merchandise for cash. Of sales on account, 80% are expected to be collected in the month of the sale and 20% in the month following the sale. The cash collections expected in September from accounts receivable are estimated to be
Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the...
Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business—September, October, and November—are $260,000, $375,000, and $400,000, respectively. The company expects to sell 30% of its merchandise for cash. Of sales on account, 80% are expected to be collected in the month of the sale and 20% in the month following the sale. The cash collections expected in November from accounts receivable are projected to be a.$276,500 b.$280,000 c.$316,400...
Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the...
Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business September, October, and November are $243,000, $307,000, and $429,000, respectively. The company expects to sell 30% of its merchandise for cash. Of sales on account, 80% are expected to be collected in the month of the sale and 20% in the month following the sale. The cash collections expected in October from accounts receivable are estimated to be a.$247,128...
A company had the following purchases and sales during its first year of operations: Purchases Sales...
A company had the following purchases and sales during its first year of operations: Purchases Sales January: 10 units at $120 6 units February: 20 units at $125 5 units May: 15 units at $130 9 units September: 12 units at $135 8 units November: 10 units at $140 13 units On December 31, there were 26 units remaining in ending inventory. Using the Perpetual FIFO inventory valuation method, what is the cost of the ending inventory? (Assume all sales...
A company had the following purchases and sales during its first year of operations: Purchases Sales...
A company had the following purchases and sales during its first year of operations: Purchases Sales January: 22 units at $180 14 units February: 32 units at $185 12 units May: 27 units at $190 16 units September: 24 units at $195 15 units November: 22 units at $200 28 units On December 31, there were 42 units remaining in ending inventory. Using the Perpetual LIFO inventory valuation method, what is the cost of the ending inventory? (Assume all sales...
A company had the following purchases and sales during its first year of operations: Purchases Sales...
A company had the following purchases and sales during its first year of operations: Purchases Sales January: 11 units at $135 7 units February: 21 units at $140 5 units May: 16 units at $145 9 units September: 13 units at $150 8 units November: 11 units at $155 14 units On December 31, there were 29 units remaining in ending inventory. Using the Perpetual LIFO inventory valuation method, what is the cost of the ending inventory? (Assume all sales...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT