Question

In: Finance

Problem 16-10 Calculating Cash Collections [LO 3] The following is the sales budget for Segura, Inc.,...

Problem 16-10 Calculating Cash Collections [LO 3]

The following is the sales budget for Segura, Inc., for the first quarter of 2013:

January

February

March

  Sales budget

$138,000

$151,000

$163,000

Credit sales are collected as follows:

65 percent in the month of the sale

20 percent in the month after the sale

15 percent in the second month after the sale

The accounts receivable balance at the end of the previous quarter was $94,000 ($69,000 of which was uncollected December sales).

Required:

(a)

Compute the sales for November. (Do not round intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)

  Sales

$

(b)

Compute the sales for December. (Do not round intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)

  Sales

$

(c)

Compute the cash collections from sales for each month from January through March. (Do not round intermediate calculations. Round your answers to 2 decimal places (e.g., 32.16).)

Cash Collection

  January

$     

  February

$    

  March

$    

References

eBook & Resources

Solutions

Expert Solution

a.sales for november.

out of closing balance of accounts receivalble $69,000 belongs to december sales.

=> ($94,000 - $69,000) =>$25,000 belongs to november sales.

since (65%+ 20% =>85%) of november sales is collected in november and december

=>this $25,000 represents 15% of november sales

=> november sales = $25,000 /15%

=>$166,666.67..............(rounded to two decimals).

b.sales for december.

$69,000 is december sale uncollected.

=> 65% is collected in december

=>$69,000 represents (100% -65%=>35% of december sale)

=> december sale = $69,000/35% =>$197,142.86.

c.cash collection for each month from january to march.

cash collection
january [(15% * $166,666.67 november sale) + (20%*$197,142.86 december sale) + (65%*$138,000) january sale] 154,128.57
february [(15%*$197,142.86 december sale) + (20%*$138,000 january sale) + (65%*$151,000 february sale)] 155,321.43
march [(15%*$138,000 january sale) + (20%*$151,000 february sale) + (65%*163,000 march sale)] 156,850

Related Solutions

Problem 18-10 Calculating Cash Collections The following is the sales budget for Shleifer, Inc., for the...
Problem 18-10 Calculating Cash Collections The following is the sales budget for Shleifer, Inc., for the first quarter of 2017: January February March Sales budget $ 215,000 $ 235,000 $ 258,000    Credit sales are collected as follows:    55 percent in the month of the sale. 30 percent in the month after the sale. 15 percent in the second month after the sale.    The accounts receivable balance at the end of the previous quarter was $99,000 ($69,000 of...
Building the Master Budget involve: The Sales Budget. The Production Budget Expected Cash Collections Budget The...
Building the Master Budget involve: The Sales Budget. The Production Budget Expected Cash Collections Budget The Direct Materials Budget Expected Cash Disbursement Budget The Direct Labor Budget Manufacturing Overhead Budget Ending Finished Goods Inventory Budget Selling and Administrative Expense Budget The Cash Budget The Budgeted Income Statement The Budgeted Balance Sheet Full Explanations
Problem 16-54 Sales Activity Variance (LO 16-3) The results for July for Brahms & Sons follow:...
Problem 16-54 Sales Activity Variance (LO 16-3) The results for July for Brahms & Sons follow: Actual (based on actual sales of 55,000 units) Master Budget (based on budgeted sales 50,000 units) Sales revenue $ 465,000 $ 575,000 Less Variable costs Direct material 60,300 63,000 Direct labor 56,100 79,000 Variable overhead 64,900 79,000 Marketing 21,900 35,000 Administrative 20,300 35,000 Total variable costs $ 223,500 $ 291,000 Contribution margin $ 241,500 $ 284,000 Less Fixed costs Manufacturing 103,900 103,000 Marketing 24,300...
Calculating the Cash Budget Wiggles, Inc., has estimated sales (in millions) for the next four quarters...
Calculating the Cash Budget Wiggles, Inc., has estimated sales (in millions) for the next four quarters as follows: (40 ptos) Q1 Q2 Q3 Q4 Sales $105 $90 $122 $140 Sales for the first quarter of the year after this one are projected at $120 million. Accounts receivable at the beginning of the year were $34 million. Wiggles, has a 45-day collection period. Wiggle’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecast sales,...
1)        Sales Budget and Expected Cash Collections The marketing department of Jessi Corporation has submitted the following...
1)        Sales Budget and Expected Cash Collections The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 11,000 12,000 14,000 13,000 The selling price of the company’s product is $18.00 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale 20 Percent paid in the month after the sale 55 Percent paid in the second month after the sale 23 To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April...
Required information Problem 10-53 (LO 10-2, LO 10-3) [The following information applies to the questions displayed...
Required information Problem 10-53 (LO 10-2, LO 10-3) [The following information applies to the questions displayed below.] Evergreen Corporation (calendar-year-end) acquired the following assets during the current year: (ignore §179 expense and bonus depreciation for this problem): (Use MACRS Table 1 and Table 2.) Date Placed Original Asset in Service Basis Machinery October 25 $ 76,000 Computer equipment February 3 14,500 Used delivery truck* August 17 27,500 Furniture April 22 157,500 *The delivery truck is not a luxury automobile. Problem...
1) Sales Budget and Expected Cash Collections The marketing department of Alex Corporation has submitted the...
1) Sales Budget and Expected Cash Collections The marketing department of Alex Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 11,000 12,000 14,000 13,000 The selling price of the company’s product is $18.00 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales...
Problem 10-34 (LO 10-3, 10-4) The following account balances are for the Agee Company as of...
Problem 10-34 (LO 10-3, 10-4) The following account balances are for the Agee Company as of January 1, 2017, and December 31, 2017. All amounts are denominated in kroner (Kr). January 1, 2017 December 31, 2017 Accounts payable (24,000 ) (31,500 ) Accounts receivable 45,000 95,000 Accumulated depreciation—buildings (36,000 ) (41,000 ) Accumulated depreciation—equipment 0 (6,600 ) Bonds payable—due 2020 (55,000 ) (55,000 ) Buildings 125,000 100,500 Cash 51,000 9,600 Common stock (60,000 ) (71,000 ) Depreciation expense 0 31,000...
Problem 12-17 Calculating the WACC [LO 3] You are given the following information concerning Parrothead Enterprises:...
Problem 12-17 Calculating the WACC [LO 3] You are given the following information concerning Parrothead Enterprises: Debt: 8,500 7.1 percent coupon bonds outstanding, with 24 years to maturity and a quoted price of 106.75. These bonds have a par value of $2,000 and pay interest semiannually. Common stock: 280,000 shares of common stock selling for $65.60 per share. The stock has a beta of 1.06 and will pay a dividend of $3.80 next year. The dividend is expected to grow...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT