Question

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

d.$295,200

2.

Stephanie Corporation sells a single product. Budgeted sales for the year are anticipated to be 645,000 units, estimated beginning inventory is 100,000 units, and desired ending inventory is 83,000 units. The quantities of direct materials expected to be used for each unit of finished product are given below.

Material A 0.50 lb. per unit @ $0.72 per pound
Material B 1.00 lb. per unit @ $2.07 per pound
Material C 1.20 lb. per unit @ $0.80 per pound

The dollar amount of material A used in production during the year is

a.$226,080

b.$232,200

c.$1,299,960

d.$602,880

3.

The Cardinal Company had a finished goods inventory of 55,000 units on January 1. Its projected sales for the next four months were: January - 200,000 units; February - 180,000 units; March - 210,000 units; and April - 230,000 units. The Cardinal Company wishes to maintain a desired ending finished goods inventory of 20% of the following months sales.

What is the budgeted units of inventory for March 31?

a.36,000

b.42,000

c.46,000

d.cannot be determined from the data given.

Answer 1

1) Budgeted Cash Collection from account receivable in November is $276,500 i.e.(a)
		Sept	Oct	November
Budgeted Sales Revenue	a	$      260,000.00	$      375,000.00	$ 400,000.00
Cash sales	b=a*30%	$        78,000.00	$      112,500.00	$ 120,000.00
Credit sales	c=a-b	$      182,000.00	$      262,500.00	$ 280,000.00
Cash receipts from customer				.
80% Cash receipt from sale of Current month	d=c*80%	$      145,600.00	$      210,000.00	$ 224,000.00
20% Cash receipt from sale of Previous month	e=c*20%	$                       -	$        36,400.00	$    52,500.00
Expected Cash collection from account receivable	f=e+f		$      246,400.00	$ 276,500.00
2) $ amount of Material A used in production is $226,080 i.e (a)
		Current year
Budgeted Sales unit	a	645,000
Add: Closing stock of FG	b	83,000
Less: Opening stock of FG	c	100,000
Budgeted Production units	d=a+b-c	628,000
Material A-consumption(lb)	e=d*0.5 lb	314,000
$ amount of Material A used in production	i=h*$0.72	$      226,080.00
3) The budgeted unit of inventory for 31st March is $46,000 units i.e (c)
		March	April
Budgeted Sales unit	a	210,000	230,000
Add: Closing stock of FG(20% of next month sales)= (230,000*20%)	b	46,000
Less: Opening stock of FG(20% of previous month sales)	c	42,000	46,000
Budgeted Production units	d=a+b-c	214,000	184,000
Please do upvote if you found the answer useful.
Feel free to reach in the comment section in case of any clarification or queries.