Question

In: Accounting

Receivables are collected 40% in the month of sale, 45% in the month following sale, and 15%...

Receivables are collected 40% in the month of sale, 45% in the month following sale, and 15% in the second month following sale.

Budgeted sales: July $28,000, August $24,000, September $30,000

Determine the September ending receivables balance:

1.b. The budgeted sales volume is 8,700 units. Inventories planned for the period :

Beginning Ending

Direct material 8,000 8,500

Finished goods 2,400 2,800

Each unit of finished goods requires four units of direct material in production.

Work in process inventory is zero at the beginning and end of the period.

Determine the number of units of direct material to be purchased.

Expert Solution

Solution

Computation of September ending receivable balance :

Particulars	Working	Amount in $
Cash received in month of sale	(40% of $ 30,000) (40%of current month sales)	$ 12,000
Cash collected from previous month ( August)	45% of $ 24,000 [45% of past month sales(august)]	$ 10,800
Cash collected from previous months ( July)	15 % of $ 28,000 [ 15 % of past month sales ( July)]	$ 4200
September ending receivable balance		$ 27,000 ($12,000+$10,800+$4200)

Computation of production budget

Each unit requires = 4 units of direct material

Production budget

Particulars	Number of units
Budgeted sales	8700 units
Add: Ending inventory	2800 units
Less : Beginning inventory	(2400) units
Budgeted production of finished goods	9100 units

direct material consumed : Budgeted production of finished goods * direct materials required per unit

= 9100 units * 4 units of direct material

= 36,400 units of direct material is consumed

Computation of direct material purchase budget in units

Particulars	Number of units
Direct material consumed	36,400 units
Add: Ending inventory of direct material	8,500 units
Less: Beginning inventory of direct material	(8,000 units)
Number of units of direct material to be purchased	36,900 units

Please do rate if my answer was found helpful. Thankyou !!!!!!

ekkarill92 answered 1 year ago

Eastern Corporation collects 45% in the second month following sale, 40% in the month following sale...

Eastern Corporation collects 45% in the second month following sale, 40% in the month following sale and 15% of a month's sales in the month of sale. Budgeted sales for the upcoming four months are: April budgeted sales $ 60,000. May budgeted sales. $180,000 June budgeted sales $250,000. July budgeted sales $220,000. The amount of cash that will be collected in July is budgeted to be.

All sales are on account (credit) with 50% collected in the month of sale, 30% collected in the following month after sale, and 20% collected in the second month after sale.

Black Horse Transportation's sales budget for the first quarter follows: January February March $125,000 300,000 290,000 All sales are on account (credit) with 50% collected in the month of sale, 30% collected in the following month after sale, and 20% collected in the second month after sale. There are no uncollectable accounts. The March cash receipts are: Select one: A. $250,500 B. $172,500 C. $102,500 D. $260,000

Sales are collected as follows: 10% in the month of sale; 60% in the month following the sale, and the remaining 30% in the second month following the sale.

Harrti Corporation has budgeted for the following sales: July August September October November December $455,000 $557,000 $663,000 $823,000 $773,000 $733,000 Sales are collected as follows: 10% in the month of sale; 60% in the month following the sale, and the remaining 30% in the second month following the sale. In Razz's budgeted balance sheet at December 31, at what amount will accounts receivable be shown?$733,000 $659,700 $891,600 $231,900

Seventy percent of Pitkin Corporation's sales are collected in the month of sale, 20% in the...

Seventy percent of Pitkin Corporation's sales are collected in the month of sale, 20% in the month following sale, and 10% in the second month following sale. The following are budgeted sales data for the company: January February March April Budgeted sales $200,000 $300,000 $350,000 $250,000 Total budgeted cash collections in April would be: Multiple Choice $175,000 $275,000 $70,000 $30,000

3) 60 % percent of Putnam Corporation's sales are collected in the month of sale, 30%...

3) 60 % percent of Putnam Corporation's sales are collected in the month of sale, 30% in the month following sale, and 10% in the second month following sale. The following are budgeted sales data for the company: January February March April Budgeted sales $200,000 $300,000 $350,000 $250,000 Total budgeted cash collections in April would be: A) $175,000 B) $150,000 C) $285,000 D) $255,000 4) Half of Curry Corporation's sales are on account (credit)- the other half is cash on...

Of Sharpe's sales, 30 percent is for cash, another 40 percent is collected in the month...

Of Sharpe's sales, 30 percent is for cash, another 40 percent is collected in the month following the sales, and 30 percent is collected in the second month following sales. November and December sales for 2018 were $250,000 and $205,000, respectively.Sharpe purchases its raw materials 2 months in advance of its sales. The purchases are equal to 60 percent of the final sales price of Sharpe's products. The supplier is paid 1 month after it makes a delivery. For example,...

The water in a 40-L tank is to be heated from 15°C to 45°C by a...

The water in a 40-L tank is to be heated from 15°C to 45°C by a 25-cm-diameter spherical heater whose surface temperature is maintained at 85°C. Determine how long the heater should be kept on. Given: The properties of air at 1 atm and the film temperature of 57.5°C. Fluid temperature = Average temperature for water (15+45)/2=30°C k = 0.6515 W/m.°C, v = 0.493 x 10-6 m2/s, Pr = 3.12, and ? = 0.501 x 10-3 K-1 The properties of...

A box contains 100 balls, of which 15% are green, 40% are red, and 45% are...

A box contains 100 balls, of which 15% are green, 40% are red, and 45% are spotted. Use simulation to find the probability that if you randomly draw a ball you get a Red Ball. Use the following 20 randomly generated numbers: 97, 52, 61, 87, 07, 48, 73, 49, 23, 75, 18, 15, 70, 34, 67, 40, 48, 98, 49, 70

use the following contingency table a b c total 1 15 30 45 90 2 40...

use the following contingency table a b c total 1 15 30 45 90 2 40 45 50 135 total 55 75 95 225 a. compute the expected frequency for each cell b. compute x^2stat. is it significant at a=0.01

A basket contains 100 balls.40 are red,45 are orange and 15 are yellow.Three balls will be...

A basket contains 100 balls.40 are red,45 are orange and 15 are yellow.Three balls will be drawn out one at a time at random with replacement.Match the probabilities. (a) P(all three draws are red) (b) P(all three draws are orange) (c) P(at least one draw is red) (d) P(at least one draw is orange) 2.Refer to the previous question about the balls in the basket.Instead of drawing out three balls one at a time with repalcement, suppose we selected balls...