Question

In: Accounting

Sioux Corporation is estimating the following sales for the first four months of next year: January:...

Sioux Corporation is estimating the following sales for the first four months of next year:

January: $260,000

Febraury: $230,000

March: $270,000

April: $320,000

Sales are normally collected 60% in the month of slae, 35% in the month following the sale, and the remaining 5% being uncollectible. Based on this information, how much cash should Sioux expect to collect during the month of April?

A.) $286,500

B.) $320,000

C.) $192,000

D.) $94,500

Expert Solution

Concepts and reason

Cash collection schedule: This schedule is prepared for the estimation of the cash collection for the period. This includes probable cash from the sources. This is a very important schedule. This schedule determines the expected cash inflow from the operating activities.

Fundamentals

Cash collection from different periods is calculated by multiplying the credit sales value with expected cash collection percentage. All expected cash calculations for the period are added together to find the total expected cash collection for the period.

Credit sale for March is $200,000. Cash collected from the March month credit sales, during April is 35% of total credit sales.

Determine the expected cash collection from March sale as follows: -

$\begin{array}{c}\\Cash\,\,collection\,\,from\,\,March\,\,sale = March\,\,sale\,\, \times 35\% \\\\ = \$ 270,000\, \times 35\% \\\\ = \$ 94,500\\\end{array}$

Credit sale for April is $320,000. The expected cash collection for April sale is 60% of the total sales. The expected cash collection from the March sale is $94,500.

Determine the cash collection during April as follows: -

$\begin{array}{c}\\Cash\,\,collected = Cash\,\,collected\,\,for\,March + Cash\,\,collected\,\,for\,\,April\,\,Sale\\\\ = \,\$ 94,500 + \,(\$ 320,000\,\, \times \,\,60\% )\\\\ = \$ 286,500\\\end{array}$

Therefore, the total cash collected during April is $286,500.

Ans:

The total cash collected during April is $286,500.

ekkarill92 answered 2 years ago

Lubriderm Corporation has budgeted the following unit sales for the next four months: Month Unit Sales...

Lubriderm Corporation has budgeted the following unit sales for the next four months: Month Unit Sales July 120,000 August 210,000 September 150,000 October 180,000 Plans are to have an ending inventory of finished products that equals 20% of the unit sales for the next month. Five pounds of materials are required for each finished unit produced, and each pound of material costs $8. The desired ending inventory level for materials is equal to 30% of the materials needs...

Company projects the following sales for the first three months of the year: $14300 in January;$...

Company projects the following sales for the first three months of the year: $14300 in January;$ 10100, in February;and $10,400 in March. The company expects 60% of the sales to be cash and the remainder on account. Sales on account are collected in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Prepare a schedule of cash receipts for Armand for January...

ArmandCompany projects the following sales for the first three months of the year: $11,200 in January;...

ArmandCompany projects the following sales for the first three months of the year: $11,200 in January; $10,100 in February; and $15,800 in March. The company expects 80 % of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Requirements: 1. Prepare a schedule of cash...

Company projects the following sales for the first three months of the year: $15,800 in January;...

Company projects the following sales for the first three months of the year: $15,800 in January; $12,200 in February; and $11,100 in March. The company expects 80%of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Prepare a revised schedule of cash receipts if receipts...

The Boswell Corporation forecasts its sales in units for the next four months as follows: March...

The Boswell Corporation forecasts its sales in units for the next four months as follows: March 16,000 April 18,000 May 15,500 June 14,000 Boswell maintains an ending inventory for each month in the amount of three times the expected sales in the following month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $8 per unit and are paid for in the month after production. Labour cost is $12 per unit and is paid for in...

Wildcat Inc has estimates sales (in millions) for the next four months as follows: January: $230...

Wildcat Inc has estimates sales (in millions) for the next four months as follows: January: $230 February: $195 March: $270 April: $290 Gross sales in November were $250, in December were $200, and May are projected at $250 million. Wildcat has a 60-day collection period. Wildcat’s purchases from suppliers in a month are equal to 55 percent of the next month’s forecasted sales, and suppliers are normally paid in 30 days. Wages, taxes, and other expenses run about 30 percent...

1. Hospitable Co. provides the following sales forecast for the next four months: Sales (units) ....

1. Hospitable Co. provides the following sales forecast for the next four months: Sales (units) . . . . . . . . April: 500, May: 580, June: 540, July: 620 The company wants to end each month with ending finished goods inventory equal to 25% of next month’s sales. Finished goods inventory on April 1 is 190 units. Assume July’s budgeted production is 540 units. Prepare a production budget for the months of April, May, and June. 2. Refer...

Getty Company expects sales for the first three months of next year to be $195,000, $265,000...

Getty Company expects sales for the first three months of next year to be $195,000, $265,000 and $315,000, respectively. Getty expects 50 percent of its sales to be cash and the remainder to be credit sales. The credit sales will be collected as follows: 10 percent in the month of the sale and 90 percent in the following month. Compute a schedule of Getty’s cash receipts for the months of February and March.

The Fraley Company, a merchandising firm, has planned the following sales for the next four months:...

The Fraley Company, a merchandising firm, has planned the following sales for the next four months: March April May June Total budgeted sales...... $50,500 $71,450 $93,600 $67,000 All sales at Fraley are on credit. From experience, the company has learned that a month’s sales on account are collected according to the following pattern: Month of sale....................................................... 68% First month following month of sale................. 29% Uncollectible........................................................ 3% The company requires a minimum cash balance of $5,000 to start a month....

Budgeted sales in Acer Corporation over the next four months are given below: September October November...

Budgeted sales in Acer Corporation over the next four months are given below: September October November December Budgeted Sales $140,000 $150,000 $170,000 $130,000 25% of the company's sales are for cash and 75% are on account. Collections for sales on account follow a stable pattern as follows: 50% of a month's credit sales are collected in the month of sale, 30% are collected in the month following sale, and 15% are collected in the second month following sale. The remainder...