Chapter 20, Problem 29E

(1)

To determine

To prepare: Merchandise purchase budget for July, August, September, October.

Explanation of Solution

Merchandise Purchase Budget
Particulars	June Amount ($)	July Amount ($)	August Amount ($)	September Amount ($)	October Amount ($)
Budgeted sales	350,000	290,000	320,000	275,000	265,000
Next month’s cost of goods sold (Working note 1)	245,000	203,000	224,000	192,500	185,500
Ending inventory (Working note 2)	49,000	40,600	44,800	38,500	37,100
Add: Cost of goods sold		245,000	203,000	224,000	192,500
Required inventory		285,600	247,800	262,500	229,600
Less: Opening inventory		49,000	40,600	44,800	38,500
Inventory to be purchased		236,600	207,200	217,700	191,100
Table (1)

Working note:

Formula to calculate next month’s cost of goods sold,

$\text{Cost of goods sold}=\text{Budgeted sales}\times 70\text{\%}$

Next month’s cost of goods sold
Particulars	June Amount ($)	July Amount ($)	August Amount ($)	September Amount ($)	October Amount ($)
Budgeted sales	350,000	290,000	320,000	275,000	265,000
Cost of goods sold $\left(\text{Sales}\times 7\text{0\%}\right)$	245,000	203,000	224,000	192,500	185,500
Table (2)

Working note:

Ending inventory
Particulars	June Amount ($)	July Amount ($)	August Amount ($)	September Amount ($)	October Amount ($)
Next month’s cost of goods sold	245,000	203,000	224,000	192,500	185,500
Ending inventory $$\left(\begin{array}{l}\text{Next month's }\\ \text{cost of goods }\\ \text{sold}\times \text{20\%}\end{array}\right)$$	49,000	40,600	44,800	38,500	37,100
Table (3)

(2)

To determine

To prepare: Budgeted cash payments on account payables.

Explanation of Solution

Budgeted Cash Payments on Account payables
Particulars	September Amount ($)	October Amount ($)
Payment for July purchases	35,490
Payment for August purchases	124,320	31,080
Payment for September purchases	54,425	130,620
Payment for October purchases		47,775
Total	214,225	209,475
Table (4)

(3)

To determine

To prepare: Budgeted accounts payable for September and October.

Explanation of Solution

Budgeted cash payments on account payables
Particulars	June Amount ($)	July Amount ($)	August Amount ($)	September Amount ($)
Beginning accounts payable	0	177,450	190,890	194,355
Add: Budgeted purchases	236,600	207,200	217,700	191,100
Amount payable after purchases $\left[\text{A}\right]$	236,600	384,650	408,590	385,455
Cash disbursement
Payment for July purchases	59,1501	41,960	35,490
Payment for August purchases		51,800	124,380	31,080
Payment for September purchases			54,425	130,620
Payment for October purchases				47,725
Total Cash payments $\left[\text{B}\right]$	59,150	193,760	214,235	209,475
Ending accounts payable $\left[\text{A}-\text{B}\right]$	177,450	190,890	194,355	175,980
Table (5)