Question

1

A department store has budgeted sales of 12,700 men's coats in September. Management wants to have 6,700 coats in inventory at the end of the month to prepare for the winter season. Beginning inventory for September is expected to be 4,700 coats. What is the dollar amount of the purchase of suits if each coat has a cost of $82.

2.

A company's history indicates that 30% of its sales are for cash and the rest are on credit. Collections on credit sales are 30% in the month of the sale, 40% in the next month, and 25% the following month. Projected sales for January, February, and March are $71,000, $96,000 and $106,000, respectively. The March expected cash receipts from current and prior credit sales is:

3.

Zhang Industries sells a product for $800. Unit sales for May were 400 and each month's sales are expected to grow by 4%. Zhang pays a sales manager a monthly salary of $3,000 and a commission of 3% of sales in dollars. Assume 30% of Zhang's sales are for cash. The remaining 70% are credit sales; these customers pay in the month following the sale. Compute the budgeted cash receipts for June.

4.

Cahuilla Corporation predicts the following sales in units for the coming four months:

	April		May		June		July
Sales in units	310		350		370		310

Each month's ending Finished Goods Inventory in units should be 30% of the next month's sales. March 31 Finished Goods inventory is 93 units. A finished unit requires five pounds of direct material B at a cost of $3.00 per pound. The March 31 Raw Materials Inventory has 270 pounds of direct material B. Each month's ending Raw Materials Inventory should be 20% of the following month's production needs. The budgeted purchases of pounds of direct material B during May should be:

Answer 1

1.

Beginning inventory+purchase-ending inventory = sales

Budgeted sales	12,700
Add: desired ending inventory	6,700
Less: Available beginning inventory	(4,700)
Budgeted purchase in units	14,700
Cost per unit	$82
Budgeted purchase in dollars	$1,205,400 [14,700*$82]

2)

	March
Receipts from sale in Jan	$12,425($71,000*70% credit sales*25% in following month)
Receipts from sale in Feb	$26,880($96,000*70% credit sales *40% in next month)
receipts from sale in March	$22,260($106,000*70%*30%)
Total cash collection from credit sales	$61,565

3) budgeted cash receipts for June

sales in June = 400*104%=416 units

sales in dollar in may = 400*$800=$320,000

Sales in dollar in June = $800*416 =$332,800

	June
cash receipts from sale in May	$224,000($320,000*70% credit sales received in June)
Cash receipts from sale in June	$99,840($332,800*30%)
Total cash receipts	$323,840($224,000+$99,840)

4.

we will first find budgeted production

	April	May	Juen	jUly
sales	310	350	370	310
Add: desired ending inventory	105(350*30%)	111(370*30%)	93(310*30%)
Less: beginning inventory	93	105	111
Budgeted production	322	356	352

Now we will find budgeted raw material purchase

	April	May	June
Production	322	356	352
pound per unit	5	5	5
raw material required for production	1610 (322*5)	1780 (356*5)	1760 (352*5)
Add: desired ending inventory	356(1780*20%)	352(1760*20%)
Less: beginning inventory	270	356
Budgeted purchase (in pound)	1,696	1,776(1780+352-356)

Answer 1,776 pounds