A manufacturing company's budgeted income statement includes the following data: $\begin{array}{|l|l|l|l|l|l|}
\hline\text { Data extracted from budgeted } & & & \
\text { income statement } & \text { Mar } & \text { Apr } & \text { May } & \text { Jun } \
\hline \text { Sales revenue } & \$ 130,000 & \$ 80,000 & \$ 130,000 & \$ 120,000 \
\hline \text { Commission expense (15\% of } \
\text { sales) }& 19,500 & 12,000 & 19,500 & 18,000 \
\hline\text { Salaries expense }& 33,000 & 33,000 & 33,000 & 33,000\
\hline \begin{array}{l}
\text {Miscellaneous expense $ -5 \% $ of }\
\text {sales}
\end{array} & 6,500 & 4,000 & 6,500 & 6,000 \
\hline \text { Rent expense } & 3,600 & 3,600 & 3,600 & 3,600 \
\hline \text { Utilities expense } & 2,300 & 2,300 & 2,300 & 2,300 \
\hline \text { Insurance expense } & 2,600 & 2,600 & 2,600 & 2,600 \
\hline \text { Depreciation expense } & 4,200 & 4,200 & 4,200 & 4,200 \
\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|l|l|l|l|l|}
\hline\text { Data extracted from budgeted } & & & \
\text { income statement } & \text { Mar } & \text { Apr } & \text { May } & \text { Jun } \
\hline \text { Sales revenue } & \$ 130,000 & \$ 80,000 & \$ 130,000 & \$ 120,000 \ 
\hline \text { Commission expense (15\% of } \
 \text { sales) }& 19,500 & 12,000 & 19,500 & 18,000   \
\hline\text { Salaries expense }& 33,000 & 33,000 & 33,000 & 33,000\
\hline \begin{array}{l}
\text {Miscellaneous expense $ -5 \% $ of }\
\text {sales}
\end{array} & 6,500 & 4,000 & 6,500 & 6,000 \ 
\hline \text { Rent expense } & 3,600 & 3,600 & 3,600 & 3,600 \
\hline \text { Utilities expense } & 2,300 & 2,300 & 2,300 & 2,300 \
\hline \text { Insurance expense } & 2,600 & 2,600 & 2,600 & 2,600 \
\hline \text { Depreciation expense } & 4,200 & 4,200 & 4,200 & 4,200 \
\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

To calculate the total budgeted cash payments for April, we need to consider the expenses paid in April:  - Commission expense: 60% of April's commission ($12,000) + 40% of March's commission ($19,500) = $7,200 + $7,800 = $15,000  - Salaries expense: 50% of April's salaries ($33,000) + 50% of March's salaries ($33,000) = $16,500 + $16,500 = $33,000  - Miscellaneous expense: April's miscellaneous expense = $4,000  - Rent expense: April's rent expense = $3,600  - Utilities expense: April's utilities expense = $2,300  Adding these amounts gives: $15,000 + $33,000 + $4,000 + $3,600 + $2,300 = $57,900.

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