Question

In: Finance

Sales receipts.  California Cement Company anticipates the following​ fourth-quarter sales for​ 2014:   ​$1 comma 800 comma...

Sales receipts.  California Cement Company anticipates the following​ fourth-quarter sales for​ 2014:  

​$1 comma 800 comma 0001,800,000

​(October),

$ 1 comma 600 comma 000$1,600,000

​(November), and

​$2 comma 100 comma 0002,100,000

​(December). It posted the following sales figures for the third quarter of​ 2014:  

$ 1 comma 900 comma 000$1,900,000

​(July),

​$2 comma 050 comma 0002,050,000

​(August), and

​$2 comma 200 comma 0002,200,000

​(September). The company sells

90 %90%

of its products on​ credit, and

10 %10%

are cash sales. The company collects credit sales as​ follows:  

60 %60%

in the following​ month,

20 %20%

two months​ later, and

19 %19%

three months​ later, with

1 %1%

defaults. What are the anticipated cash inflows for the last quarter of​ 2014?

Given the July sales of

​$1 comma 900 comma 0001,900,000​,

The amount collected in July is

​$nothing.

​ (Round to the nearest​ dollar.)The amount collected in August is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in September is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in October is

​$nothing.

​(Round to the nearest​ dollar.)The amount not collected is

​$nothing.

​(Round to the nearest​ dollar.)Given the August sales of

​$2 comma 050 comma 0002,050,000​,

The amount collected in August is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in September is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in October is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in November is

​$nothing.

​(Round to the nearest​ dollar.)The amount not collected is

​$nothing.

​(Round to the nearest​ dollar.)Given the September sales of

​$2 comma 200 comma 0002,200,000​,

The amount collected in September is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in October is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in November is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in December is

​$nothing.

​(Round to the nearest​ dollar.)The amount not collected is

​$nothing.

​(Round to the nearest​ dollar.)Given the October sales of

​$1 comma 800 comma 0001,800,000​,

The amount collected in October is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in November is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in December is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in January is

​$nothing.

​(Round to the nearest​ dollar.)The amount not collected is

​$nothing.

​(Round to the nearest​ dollar.)Given the November sales of

​$1 comma 600 comma 0001,600,000​,

The amount collected in November is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in December is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in January is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in February is

​$nothing.

​(Round to the nearest​ dollar.)The amount not collected is

​$nothing.

​(Round to the nearest​ dollar.)Given the December sales of

​$2 comma 100 comma 0002,100,000​,

The amount collected in December is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in January is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in February is

​$nothing.

​(Round to the nearest​ dollar.)The amount collected in March is

​$nothing.

​(Round to the nearest​ dollar.)The amount not collected is

​$nothing.

​(Round to the nearest​ dollar.)The receipts for October are

​$nothing.

​(Round to the nearest​ dollar.)The receipts for November are

​$nothing.

​(Round to the nearest​ dollar.)The receipts for December are

​$nothing.

​(Round to the nearest​ dollar.)

Solutions

Expert Solution

Given the July sales of $1,900,000:

Amount collected in July = July’s cash sales
Amount collected in July = $190,000

Amount collected in August = 60% * July’s credit sales
Amount collected in August = 60% * $1,710,000
Amount collected in August = $1,026,000

Amount collected in September = 20% * July’s credit sales
Amount collected in September = 20% * $1,710,000
Amount collected in September = $342,000

Amount collected in October = 19% * July’s credit sales
Amount collected in October = 19% * $1,710,000
Amount collected in October = $324,900

Amount not collected = 1% * July’s credit sales
Amount not collected = 1% * $1,710,000
Amount not collected = $17,100

Given the August sales of $2,050,000:

Amount collected in August = August’s cash sales
Amount collected in August = $205,000

Amount collected in September = 60% * August’s credit sales
Amount collected in September = 60% * $1,845,000
Amount collected in September = $1,107,000

Amount collected in October = 20% * August’s credit sales
Amount collected in October = 20% * $1,845,000
Amount collected in October = $369,000

Amount collected in November = 19% * August’s credit sales
Amount collected in November = 19% * $1,845,000
Amount collected in November = $350,550

Amount not collected = 1% * August’s credit sales
Amount not collected = 1% * $1,845,000
Amount not collected = $18,450

Given the September sales of $2,200,000:

Amount collected in September = September’s cash sales
Amount collected in September = $220,000

Amount collected in October = 60% * September’s credit sales
Amount collected in October = 60% * $1,980,000
Amount collected in October = $1,188,000

Amount collected in November = 20% * September’s credit sales
Amount collected in November = 20% * $1,980,000
Amount collected in November = $396,000

Amount collected in December = ​19% * September’s credit sales
Amount collected in December = 19% * $1,980,000
Amount collected in December = $376,200

Amount not collected = 1% * September’s credit sales
Amount not collected = 1% * $1,980,000
Amount not collected = $19,800

Given the October sales of $1,800,000​:

Amount collected in October = October’s cash sales
Amount collected in October = $180,000

Amount collected in November = 60% * October’s credit sales
Amount collected in November = 60% * $1,620,000
Amount collected in November = $972,000

Amount collected in December = 20% * October’s credit sales
Amount collected in December = 20% * $1,620,000
Amount collected in December = $324,000

Amount collected in January = 19% * October’s credit sales
Amount collected in January = 19% * $1,620,000
Amount collected in January = $307,800

Amount not collected = 1% * October’s credit sales
Amount not collected = 1% * $1,620,000
Amount not collected = $16,200

Given the November sales of $1,600,000:

Amount collected in November = November’s cash sales
Amount collected in November = $160,000

Amount collected in December = 60% * November’s credit sales
Amount collected in December = 60% * $1,440,000
Amount collected in December = $864,000

Amount collected in January = 20% * November’s credit sales
Amount collected in January = 20% * $1,440,000
Amount collected in January = $288,000

Amount collected in February = 19% * November’s credit sales
Amount collected in February = 19% * $1,440,000
Amount collected in February = $273,600

Amount not collected = 1% * November’s credit sales
Amount not collected = 1% * $1,440,000
Amount not collected = $14,400

Given the December sales of $2,100,000​:

Amount collected in December = December’s cash sales
Amount collected in December = $210,000

Amount collected in January = 60% * December’s credit sales
Amount collected in January = 60% * $1,890,000
Amount collected in January = $1,134,000

Amount collected in February = 20% * December’s credit sales
Amount collected in February = 20% * $1,890,000
Amount collected in February = $378,000

Amount collected in March = 19% * December’s credit sales
Amount collected in March = 19% * $1,890,000
Amount collected in March = $359,100

Amount not collected = 1% * December’s credit sales
Amount not collected = 1% * $1,890,000
Amount not collected = $18,900

Receipts for October = $180,000 + $324,900 + $369,000 + $1,188,000
Receipts for October = $2,061,900

Receipts for November = $160,000 + $350,550 + $396,000 + $972,000
Receipts for November = $1,878,550

Receipts for December = $210,000 + $376,200 + $324,000 + $864,000
Receipts for December = $1,774,200


Related Solutions

National Beverage Company anticipates the following​ first-quarter sales for​ 2015: ​$1,874,000​(January), $1,592,000​(February), and ​$2,142,000 ​(March). It...
National Beverage Company anticipates the following​ first-quarter sales for​ 2015: ​$1,874,000​(January), $1,592,000​(February), and ​$2,142,000 ​(March). It posted the following sales figures for the last quarter of ​2014: $1,928,000​(October), ​$2,052,000​(November), and ​$2,192,000​(December). The company sells 45% of its products on​ credit; 55% are cash sales. The company collects credit sales as​ follows: 31% in the following​ month, 51% two months​ later, and 17% three months​ later, with 1% defaults. What are the anticipated cash inflows for the first quarter of​ 2015?...
top managers of Preston Preston Industries predicted 2014 2014 sales of 14 comma 400 14,400 units...
top managers of Preston Preston Industries predicted 2014 2014 sales of 14 comma 400 14,400 units of its product at a unit price of $ 8.50 $8.50. Actual sales for the year were 14 comma 300 14,300 units at $ 9.50 $9.50 each. Variable costs were budgeted at $ 2.60 $2.60 per​ unit, and actual variable costs were $ 2.70 $2.70 per unit. Actual fixed costs of $ 45 comma 000 $45,000 exceeded budgeted fixed costs by $ 3 comma...
“Fourth quarter U.S. online sales grew 26.2 percent as compared to the same period in the...
“Fourth quarter U.S. online sales grew 26.2 percent as compared to the same period in the previous year. Full year results show U.S. online sales year-over-year growth was 32.2%. Overall, full year total company sales, including both online and store sales, increased 9.5% year-over-year.” Which of the following would NOT explain what this is about? a. The data in the news release was computed using horizontal analysis based in the income statement. b. Total sales reported indicate year-over-year growth. c....
1. In the fourth quarter of 1982, economic statistics showed the following: Real GDP Unemployment rate...
1. In the fourth quarter of 1982, economic statistics showed the following: Real GDP Unemployment rate Inflation rate : $5,189.8 billion : 10.7% : 4.4% The conceptual variables corresponding to these data are: Potential output : $5,640.3 billion Natural rate of unemployment : 6.1% Ideal inflation rate : 1.0% a) Calculate the output gap. b) Calculate the unemployment gap. c) Calculate the inflation gap. d) Calculate the output loss and inflation loss. e) Calculate the total loss in the fourth...
In the fourth quarter of last year, Colditz Company embarked on a major effort to improve...
In the fourth quarter of last year, Colditz Company embarked on a major effort to improve productivity. It redesigned products, reengineered manufacturing processes, and offered productivity improvement courses. The effort was completed in the last quarter of the current year. The controller’s office has gathered the following year-end data to assess the results of this effort: Current Year Prior Year Units manufactured and sold 27,000 22,500 Selling price of the product $ 52 $ 52 Direct materials used (pounds) 15,200...
In the fourth quarter of last year, Colditz Company embarked on a major effort to improve...
In the fourth quarter of last year, Colditz Company embarked on a major effort to improve productivity. It redesigned products, reengineered manufacturing processes, and offered productivity improvement courses. The effort was completed in the last quarter of the current year. The controller’s office has gathered the following year-end data to assess the results of this effort: Current Year Prior Year Units manufactured and sold 24,000 18,000 Selling price of the product $ 59 $ 59 Direct materials used (pounds) 15,900...
Required: Prepare a master budget for the San Jacinto Emporium Company for the fourth quarter of...
Required: Prepare a master budget for the San Jacinto Emporium Company for the fourth quarter of 2017. The following component budgets must be included: 1. Sales Budget 2. Cost of Goods Sold, Inventory and Purchases Budget 3. Operating Expense Budget 4. Budgeted Income Statement 5. Schedule of Expected Cash Collections 6. Schedule of Expected Cash Disbursements - Merchandise Purchases 7. Schedule of Expected Cash Disbursements - Operating Expenses 8. Combined Cash Budget The San Jacinto Emporium Company is a merchandising...
in the fourth quarter of last year, Colditz Company embarked on a major effort to improve...
in the fourth quarter of last year, Colditz Company embarked on a major effort to improve productivity. It redesigned products, reengineered manufacturing processes, and offered productivity improvement courses. The effort was completed in the last quarter of the current year. The controller’s office has gathered the following year-end data to assess the results of this effort: Current Year Prior Year Units manufactured and sold 24,000 19,200 Selling price of the product $ 53 $ 53 Direct materials used (pounds) 15,300...
A cement manufacturer has supplied the following data: Tons of cement produced and sold 220000 Sales...
A cement manufacturer has supplied the following data: Tons of cement produced and sold 220000 Sales revenue $924000 Variable manufacturing expense $297000 Fixed manufacturing expense $285498 Variable selling and administrative expense $165000 Fixed selling and administrative expense $81917 If the company increases its unit sales volume by 5% without increasing its fixed expenses, what would operating income be closest to
A cement manufacturer has supplied the following data: Tons of cement produced and sold 262,000 Sales...
A cement manufacturer has supplied the following data: Tons of cement produced and sold 262,000 Sales revenue $ 1,179,000 Variable manufacturing expense $ 431,000 Fixed manufacturing expense $ 228,000 Variable selling and administrative expense $ 93,000 Fixed selling and administrative expense $ 218,000 Net operating income $ 209,000 What is the company's unit contribution margin? (Round your intermediate calculations to 2 decimal places.) Multiple Choice $2.00 per unit $0.52 per unit $4.50 per unit $2.50 per unit
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT