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 } & \$ 120,000 & \$ 90,000 & \$ 95,000 & \$ 100,000 \\\hline \text { Commission expense (15\% of sales) } & 18,000 & 13,500 & 14,250 & 15,000 \\\hline \text { Salaries expense } & 30,000 & 30,000 & 30,000 & 30,000 \\\hline \text { Miscellaneous expense } - 4 \% \text { of sales } & 4,800 & 3,600 & 3,800 & 4,000 \\\hline \text { Rent expense } & 3,600 & 3,600 & 3,600 & 3,600 \\\hline \text { Utility expense } & 1,900 & 1,900 & 1,900 & 1,900 \\\hline \text { Insurance expense } & 2,100 & 2,100 & 2,100 & 2,100 \\\hline \text { Depreciation expense } & 4,400 & 4,400 & 4,400 & 4,400 \\\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 salary expenses are paid in the same month and the remaining 50% are paid one month later. Miscellaneous expenses, rent expense and utility 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^st.
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 } & \$ 120,000 & \$ 90,000 & \$ 95,000 & \$ 100,000 \\\hline \text { Commission expense (15\% of sales) } & 18,000 & 13,500 & 14,250 & 15,000 \\\hline \text { Salaries expense } & 30,000 & 30,000 & 30,000 & 30,000 \\\hline \text { Miscellaneous expense } - 4 \% \text { of sales } & 4,800 & 3,600 & 3,800 & 4,000 \\\hline \text { Rent expense } & 3,600 & 3,600 & 3,600 & 3,600 \\\hline \text { Utility expense } & 1,900 & 1,900 & 1,900 & 1,900 \\\hline \text { Insurance expense } & 2,100 & 2,100 & 2,100 & 2,100 \\\hline \text { Depreciation expense } & 4,400 & 4,400 & 4,400 & 4,400 \\\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 salary expenses are paid in the same month and the remaining 50% are paid one month later. Miscellaneous expenses, rent expense and utility 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^st.
Calculate total budgeted cash payments for selling and administrative expenses for the month of April.

Quizplus · Accepted Answer

The Answer of 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 } & \$ 120,000 & \$ 90,000 & \$ 95,000 & \$ 100,000 \ \hline \text { Commission expense (15\% of sales) } & 18,000 & 13,500 & 14,250 & 15,000 \ \hline \text { Salaries expense } & 30,000 & 30,000 & 30,000 & 30,000 \ \hline \text { Miscellaneous expense } - 4 \% \text { of sales } & 4,800 & 3,600 & 3,800 & 4,000 \ \hline \text { Rent expense } & 3,600 & 3,600 & 3,600 & 3,600 \ \hline \text { Utility expense } & 1,900 & 1,900 & 1,900 & 1,900 \ \hline \text { Insurance expense } & 2,100 & 2,100 & 2,100 & 2,100 \ \hline \text { Depreciation expense } & 4,400 & 4,400 & 4,400 & 4,400 \ \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 salary expenses are paid in the same month and the remaining 50% are paid one month later. Miscellaneous expenses, rent expense and utility 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^st. Calculate total budgeted cash payments for selling and administrative expenses for the month of April.

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