A manufacturing company's budgeted income statement includes the following data: $\begin{array}{|l|r|r|r|r}
\hline\text { Data extracted from budgeted }\
\text { income statement } & \text { Mar } & \text { Apr } & \text { May } & \text { Jun } \
\hline \text { Sales revenue } & \$ 130,000 & \$ 90,000 & \$ 140,000 & \$ 120,000 \
\hline \text { Commission expense (20\% of } & & & & \
\hline \text { sales) } & 26,000 & 18,000 & 28,000 & 24,000 \
\hline \text { Salaries expense } & 32,000 & 32,000 & 32,000 & 32,000 \
\hline \text { Miscellaneous expense }-6 \% \text { of } & 7800 & 5400 & 8400 & 7200 \
\hline \text { sales } & 3900 & 3900 & 3900 & 3900 \
\hline \text { Rent expense } & 2300 & 2300 & 2300 & 2300 \
\hline \text { Utilities expense } & 2400 & 2400 & 2400 & 2400 \
\hline \text { Insurance expense } & 4200 & 4200 & 4200 & 4200 \
\hline \text { Depreciation expense } & & & & \
\hline
\end{array}$
The budget assumes that 60% of commission expenses are paid in the month they are incurred and the remaining 40% are paid one month later. In addition, 50% of salaries expenses are paid in the same month, and the remaining 50% are paid one month later. Miscellaneous expenses, rent expense, and utilities expenses are assumed to be paid in the same month in which they are incurred. Insurance has been paid in advance for the year on January 1.
Calculate total budgeted cash payments for selling and administrative expenses for the month of April.

Question

A manufacturing company's budgeted income statement includes the following data: $\begin{array}{|l|r|r|r|r}
\hline\text { Data extracted from budgeted }\
\text { income statement } & \text { Mar } & \text { Apr } & \text { May } & \text { Jun } \
\hline \text { Sales revenue } & \$ 130,000 & \$ 90,000 & \$ 140,000 & \$ 120,000 \
\hline \text { Commission expense (20\% of } & & & & \
\hline \text { sales) } & 26,000 & 18,000 & 28,000 & 24,000 \
\hline \text { Salaries expense } & 32,000 & 32,000 & 32,000 & 32,000 \
\hline \text { Miscellaneous expense }-6 \% \text { of } & 7800 & 5400 & 8400 & 7200 \
\hline \text { sales } & 3900 & 3900 & 3900 & 3900 \
\hline \text { Rent expense } & 2300 & 2300 & 2300 & 2300 \
\hline \text { Utilities expense } & 2400 & 2400 & 2400 & 2400 \
\hline \text { Insurance expense } & 4200 & 4200 & 4200 & 4200 \
\hline \text { Depreciation expense } & & & & \
\hline
\end{array}$ 
The budget assumes that 60% of commission expenses are paid in the month they are incurred and the remaining 40% are paid one month later. In addition, 50% of salaries expenses are paid in the same month, and the remaining 50% are paid one month later. Miscellaneous expenses, rent expense, and utilities expenses are assumed to be paid in the same month in which they are incurred. Insurance has been paid in advance for the year on January 1.
Calculate total budgeted cash payments for selling and administrative expenses for the month of April.

Quizplus · Accepted Answer

- Commission expenses: 60% paid in April and 40% paid in May. Total commission expenses = $14,000, so $8,400 will be paid in April and $5,600 will be paid in May. 
- Salaries expenses: 50% paid in April and 50% paid in May. Total salaries expenses = $26,000, so $13,000 will be paid in April and $13,000 will be paid in May.
- Miscellaneous expenses, rent expense, and utilities expenses: assumed to be paid in April. Total of these expenses = $6,800.
- Insurance expense: already paid on January 1, no need to consider.

Total budgeted cash payments for selling and administrative expenses for the month of April = $8,400 + $13,000 + $6,800 = $28,200.

Therefore, the correct choice is C.

A Manufacturing Company's Budgeted Income Statement Includes the Following Data