Solved

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

Question 109

Essay

Craig Manufacturing Company's budgeted income statement includes the following data:
 Data extracted from budgeted  Income statement  Mar  Apr  May  Jun  Sales $120,000$90,000$95,000$100,000 Commission expense - 15% of sales 18,00013,50014,25015,000 Salary exp 30,00030,00030,00030,000 Miscellaneous expense 4% of sales 4,8003,6003,8004,000 Rent expense3,6003,6003,6003,600 Utility expense 1,9001,9001,9001,900 Insurance expense 2,1002,1002,1002,100 Depreciation expense 4,4004,4004,4004,400\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 - } \mathbf{1 5 \%} \text { of sales } & 18,000 & 13,500 & 14,250 & 15,000 \\\hline \text { Salary exp } & 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 were incurred and the remaining 40% are paid one month later. In addition, 50% of salary expenses are paid in the month incurred 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 was prepaid for the year on January 1.
Please provide a budget of cash payments for operating expenses using the following format:
 Budget of Cash Payments for  Operating Expenses  Apr  May  Jun  Variable expenses 40% of last month’s commission  expense 60% of this month’s commission  expense  Misc. expenses - 4% of sales  Total variable operating expenses  Fixed expenses 50% of last month’s salary expense 50% of this month’s salary expense  Rent exp.  Utility exp.  Total payments for fixed operating  expense  Total payments for operating expenses \begin{array} { | l | c | c | c | c | } \hline \begin{array} { l } \text { Budget of Cash Payments for } \\\text { Operating Expenses }\end{array} &\quad\quad & \text { Apr } & \text { May } & \text { Jun } \\\hline \text { Variable expenses } & & & & \\\hline \begin{array} {l } 40 \% \text { of last month's commission } \\\text { expense }\end{array} & & & & \\\hline \begin{array} { l} 60 \% \text { of this month's commission } \\\text { expense }\end{array} & & & & \\\hline \text { Misc. expenses - 4\% of sales } & & & & \\\hline \text { Total variable operating expenses } & & & & \\\hline \text { Fixed expenses } & & & & \\\hline 50 \% \text { of last month's salary expense } & & & & \\\hline 50 \% \text { of this month's salary expense } & & & & \\\hline \text { Rent exp. } & & & & \\\hline \text { Utility exp. } & & & & \\\hline \begin{array} { l } \text { Total payments for fixed operating } \\\text { expense }\end{array} & & & & \\\hline \text { Total payments for operating expenses } & & & & \\\hline\end{array}

Correct Answer:

verifed

Verified

\[\begin{array} { | l | c | c | c | c | ...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents