Additional info

Keep a raw material inventory at 25% of the requirements for the next periods production

per production unit (Finished Goods) OPERATING EXPENSES \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|l|}{ Wages and Salaries Payment } \\ \hline \multirow[t]{2}{*}{ Payment Policy } & 2 & \multicolumn{2}{|c|}{ times monthly on the 15 th and 30 th } \\ \hline & & \multicolumn{2}{|c|}{ Fully paid each month } \\ \hline Variable Selling \& Administrative Exp. & 3.50% & of selling price & \\ \hline \multicolumn{4}{|l|}{ Fixed Selling \& Administrative Exp } \\ \hline Depreciation & 55,000 & per quarter & \\ \hline Other Selling \& Administrative Exp & 180,000 & per quarter & \\ \hline \end{tabular} Projected for Year Ending 12/31/2024 \begin{tabular}{l|c|c|c|c|c} \hline & First & Second & Third & Fourth & Annual \\ & Quarter & Quarter & Quarter & Quarter & Total \\ \hline \begin{tabular}{l} Budgeted Sales in Units \\ Selling Price \\ Budgeted Sales in Dollars \end{tabular} & & & & & \\ \cline { 2 - 6 } \end{tabular} \begin{tabular}{l|c|c|c|c|c} \hline & \begin{tabular}{c} First \\ Quarter \end{tabular} & \begin{tabular}{c} Second \\ Quarter \end{tabular} & \begin{tabular}{c} Third \\ Quarter \end{tabular} & \begin{tabular}{c} Fourth \\ Quarter \end{tabular} & \begin{tabular}{c} Annual \\ Total \end{tabular} \\ \hline Budgeted Sales in units & & & & & \\ \cline { 2 - 6 } \begin{tabular}{l} Ending Inventory of Finished Goods \\ \cline { 2 - 6 } Total Need for Finished Goods \end{tabular} & & & & & \\ \cline { 2 - 6 } & & & & & \\ \hline Beginning Inventory of Finished Goods & & & & & \\ \hline Budgeted Finished Goods Produced in units & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|l|}{ Direct Materials Purchases Budget } \\ \hline & First & Second & Third & Fourth & Annual \\ \hline & Quarter & Quarter & Quarter & Quarter & Total \\ \hline \multicolumn{6}{|l|}{ Budgeted Finished Goods Produced (units) } \\ \hline \multicolumn{6}{|l|}{ Raw Materials needed per unit } \\ \hline \multicolumn{6}{|l|}{ Raw Materials needed for production } \\ \hline \multicolumn{6}{|l|}{ Raw Material Ending Inventory (units) } \\ \hline \multicolumn{6}{|l|}{ Total Raw Materials needed } \\ \hline \multicolumn{6}{|l|}{ Raw Materials Beginning Inventory (units) } \\ \hline \multicolumn{6}{|l|}{ Raw Materials Purchases (units) } \\ \hline \multicolumn{6}{|l|}{ Cost per Unit } \\ \hline Raw Material Purchases Cost (dollars) & & & & & \\ \hline \end{tabular} Direct Labor Budget \begin{tabular}{|c|c|c|c|c|c|} \hline & First & Second & Third & Fourth & Annual \\ \hline & Quarter & Quarter & Quarter & Quarter & Total \\ \hline \multicolumn{6}{|c|}{ Einished Goods Produced (units) } \\ \hline \multicolumn{6}{|c|}{ Direct Labor Hours Required per Unit } \\ \hline \multicolumn{6}{|c|}{ Total Direct Labor Hours Required } \\ \hline \multicolumn{6}{|l|}{ Hourly Labor Rate } \\ \hline Direct Labor Cost (dollars) & & & & & \\ \hline \end{tabular} Selling \& Administrative Expense Budget \begin{tabular}{l|c|c|c|c|c} \hline & First & \begin{tabular}{c} Second \\ Quarter \end{tabular} & \begin{tabular}{c} Third \\ Quarter \end{tabular} & \begin{tabular}{c} Fourth \\ Quarter \end{tabular} & \begin{tabular}{c} Annual \\ Total \end{tabular} \\ \hline Budgeted Sales in Dollars & & & & & \\ Variable S\&A rate & & & & & \\ \hline Variable S\&A Cost & & & & & \\ \hline Fixed S\&A Cost without Depreciation & & & & & \\ \hline Depreciation Cost & & & & & \\ \hline Total S\&A Cost & & & & & \\ \hline \end{tabular} per production unit (Finished Goods) OPERATING EXPENSES \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|l|}{ Wages and Salaries Payment } \\ \hline \multirow[t]{2}{*}{ Payment Policy } & 2 & \multicolumn{2}{|c|}{ times monthly on the 15 th and 30 th } \\ \hline & & \multicolumn{2}{|c|}{ Fully paid each month } \\ \hline Variable Selling \& Administrative Exp. & 3.50% & of selling price & \\ \hline \multicolumn{4}{|l|}{ Fixed Selling \& Administrative Exp } \\ \hline Depreciation & 55,000 & per quarter & \\ \hline Other Selling \& Administrative Exp & 180,000 & per quarter & \\ \hline \end{tabular} Projected for Year Ending 12/31/2024 \begin{tabular}{l|c|c|c|c|c} \hline & First & Second & Third & Fourth & Annual \\ & Quarter & Quarter & Quarter & Quarter & Total \\ \hline \begin{tabular}{l} Budgeted Sales in Units \\ Selling Price \\ Budgeted Sales in Dollars \end{tabular} & & & & & \\ \cline { 2 - 6 } \end{tabular} \begin{tabular}{l|c|c|c|c|c} \hline & \begin{tabular}{c} First \\ Quarter \end{tabular} & \begin{tabular}{c} Second \\ Quarter \end{tabular} & \begin{tabular}{c} Third \\ Quarter \end{tabular} & \begin{tabular}{c} Fourth \\ Quarter \end{tabular} & \begin{tabular}{c} Annual \\ Total \end{tabular} \\ \hline Budgeted Sales in units & & & & & \\ \cline { 2 - 6 } \begin{tabular}{l} Ending Inventory of Finished Goods \\ \cline { 2 - 6 } Total Need for Finished Goods \end{tabular} & & & & & \\ \cline { 2 - 6 } & & & & & \\ \hline Beginning Inventory of Finished Goods & & & & & \\ \hline Budgeted Finished Goods Produced in units & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|l|}{ Direct Materials Purchases Budget } \\ \hline & First & Second & Third & Fourth & Annual \\ \hline & Quarter & Quarter & Quarter & Quarter & Total \\ \hline \multicolumn{6}{|l|}{ Budgeted Finished Goods Produced (units) } \\ \hline \multicolumn{6}{|l|}{ Raw Materials needed per unit } \\ \hline \multicolumn{6}{|l|}{ Raw Materials needed for production } \\ \hline \multicolumn{6}{|l|}{ Raw Material Ending Inventory (units) } \\ \hline \multicolumn{6}{|l|}{ Total Raw Materials needed } \\ \hline \multicolumn{6}{|l|}{ Raw Materials Beginning Inventory (units) } \\ \hline \multicolumn{6}{|l|}{ Raw Materials Purchases (units) } \\ \hline \multicolumn{6}{|l|}{ Cost per Unit } \\ \hline Raw Material Purchases Cost (dollars) & & & & & \\ \hline \end{tabular} Direct Labor Budget \begin{tabular}{|c|c|c|c|c|c|} \hline & First & Second & Third & Fourth & Annual \\ \hline & Quarter & Quarter & Quarter & Quarter & Total \\ \hline \multicolumn{6}{|c|}{ Einished Goods Produced (units) } \\ \hline \multicolumn{6}{|c|}{ Direct Labor Hours Required per Unit } \\ \hline \multicolumn{6}{|c|}{ Total Direct Labor Hours Required } \\ \hline \multicolumn{6}{|l|}{ Hourly Labor Rate } \\ \hline Direct Labor Cost (dollars) & & & & & \\ \hline \end{tabular} Selling \& Administrative Expense Budget \begin{tabular}{l|c|c|c|c|c} \hline & First & \begin{tabular}{c} Second \\ Quarter \end{tabular} & \begin{tabular}{c} Third \\ Quarter \end{tabular} & \begin{tabular}{c} Fourth \\ Quarter \end{tabular} & \begin{tabular}{c} Annual \\ Total \end{tabular} \\ \hline Budgeted Sales in Dollars & & & & & \\ Variable S\&A rate & & & & & \\ \hline Variable S\&A Cost & & & & & \\ \hline Fixed S\&A Cost without Depreciation & & & & & \\ \hline Depreciation Cost & & & & & \\ \hline Total S\&A Cost & & & & & \\ \hline \end{tabular}