Integrated Purchases and Cash Payments Budget Senegalese Specialties,a Retailer of West

Integrated purchases and cash payments budget Senegalese Specialties,a retailer of West African food products,has completed the sales forecast for the coming year:
$$\begin{array}{llll}\text { January } & \$ 37,000 & \text { July } & \$ 38,000 \\\text { February } & \$ 38,000 & \text { August } & \$ 37,000 \\\text { March } & \$ 32,000 & \text { September } & \$ 33,000 \\\text { April } & \$ 40,000 & \text { October } & \$ 40,000 \\\text { May } & \$ 36,000 & \text { November } & \$ 48,000 \\\text { June } & \$ 31,000 & \text { December } & \$ 52,000\end{array}$$

$\begin{array}{lrrrrrr} & \underline{1^{\text {st }} \textbf { Quarter }}&\underline{{2}^{\text {nd }} \textbf { Quarter } }&\underline{{3}^{\text {rd }} \textbf { Quarter }} &\underline{{4}^{\text {th }} \textbf { Quarter}}& \underline{\textbf {Annual }} \\\quad\text{Budgeted production} & 520 & 480 & 440 & 570 & 2,010 \\\times \text{ Standard pump motors per spa} & \underline{\times 1.2} & \underline{\times 1.2} & \underline{\times 1.2} & \underline{\times 1.2} & \underline{\times 1.2} \\=\text{ Production needs} & 624 & 576 & 528 & 684 & 2,412 \\+\text{ Budgeted ending inventory} & \underline{288} & \underline{264} & \underline{342} & \underline{300} & \underline{300} \\=\text{ Total DM required motors} & 912 & 840 & 870 & 984 & 2,712 \\-\text{ Beginning inventory} & \underline{400} & \underline{288} & \underline{264} & \underline{342} & \underline{400} \\=\text{ Budgeted purchases motors} & 512 & 552 & 606 & 642 & 2,312 \\\times \text{ Standard price per motor} & \underline{\times \$160} & \underline{\times \$160} & \underline{\times \$160} & \underline{\times \$160} & \underline{\times \$160} \\= \text{ Budgeted purchases cost} & \underline{\underline{\$81,920}} & \underline{\underline{\$ 88,320}} & \underline{\underline{\$ 96,960}} & \underline{\underline{\$102,720}} & \underline{\underline{\$369,920}} \\\end{array}$
Senegalese Specialties maintains an ending inventory level of 60 percent of the following month’s cost of goods sold. The company’s cost of goods sold is 35 percent of sales.

Required:

a. Prepare Senegalese Specialties purchases budget for June and July. Use the following format:

$$\begin{array}{l} ~~~\text { Budgeted sales dollars}\\\times \text { \underline{Cost of goods sold percentage}}\\= \text { Cost of goods sold}\\+ \text { \underline{Ending inventory}}\\= \text { Total inventory required}\\- \text { \underline{Beginning inventory}}\\= \text { Budgeted purchases}\\\end{array}$$
b.Assuming that Senegalese Specialties pays for 50 percent of its purchases in the month of purchase and the remaining 50 percent in the month following the purchase,prepare the company's cash payments budget for July.