Question: I need help with making the correct calculations for these budgets and if you can please include the working notes, so I can refer back
I need help with making the correct calculations for these budgets and if you can please include the working notes, so I can refer back to them. I'll include the data sheet (the first image) as well as the budgets.





Sales D-a:anta-n :- llu:ta SALES BUDGET \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & \multicolumn{2}{|r|}{ January } & \multicolumn{2}{|c|}{ February } & \multicolumn{2}{|c|}{ March } & \multicolumn{2}{|r|}{ April } \\ \hline Projected Sales in Units & $ & 13,719.00 & & 9.00 & & 66.00 & & 56581.00 \\ \hline Selling Price per Unit & $ & 53.00 & $ & 53.00 & $ & 53.00 & $ & 53.00 \\ \hline Anticipated Sales Dollars & $ & 727,107.00 & $ & 967.00 & & 0,398.00 & $ & 2,998,793.00 \\ \hline \end{tabular} SELLING \& ADMINISTRATIVE (S\&A) EXPENSE BUDGET \begin{tabular}{|l|rr|rr|rr|} \hline & \multicolumn{2}{c|}{ January } & \multicolumn{2}{c|}{ February } & \multicolumn{2}{c|}{ March } \\ \hline Sales in Units & \multicolumn{2}{|c|}{13719} & \multicolumn{2}{c|}{37339} & \multicolumn{2}{c|}{37366} \\ \hline Variable S\&A Rate/Unit & $ & 4.00 & $ & 4.00 & $ & 4.00 \\ \hline Anticipated Variable Costs & $ & 54,876.00 & $ & 149,356.00 & $ & 149,464.00 \\ \hline Fixed S\&A Costs & $ & 894 & $ & 894 & $ & 894 \\ \hline \begin{tabular}{l} Total Anticipated Selling \& \\ Administrative Costs \end{tabular} & $55,770.00 & $ & 150,250.00 & $ & 150,358.00 \\ \hline \end{tabular} PRODUCTION BUDGET \begin{tabular}{|l|c|c|c|c|} \hline & January & February & March & April \\ \hline Sales in Units & 13,719 & 37,339 & 37,366 & 56,581 \\ \hline Desired Ending Inventory & 2469 & 6721 & 6726 & 10185 \\ \hline Total Units Needed & 16188 & 44060 & 44092 & 66766 \\ \hline Beginning Inventory & 0 & 2469 & 6721 & 6726 \\ \hline Total Production in Units & 16188 & 41591 & 37371 & 60040 \\ \hline \hline \end{tabular} MATERIALS REQUIREMENTS BUDGET \begin{tabular}{|c|c|c|c|c|} \hline & January & February & March & April \\ \hline Units to be Produced & 16,188 & 41,591 & 37,371 & 60,040 \\ \hline Material/Unit & 1.0 & 1.0 & 1.0 & 1.0 \\ \hline Total Production Need & 16188 & 41591 & 37371 & \multirow[t]{7}{*}{60040} \\ \hline Desired Ending Inventory & 11315 & 29072 & 26122 & \\ \hline Total Materials Needed & 27503 & 70663 & 63493 & \\ \hline \multicolumn{4}{|l|}{ Beginning Inventory } & \\ \hline \multicolumn{4}{|l|}{\begin{tabular}{l} Total Materials Needed to be \\ Purchased \end{tabular}} & \\ \hline \multicolumn{4}{|l|}{ Cost per Unit of Material } & \\ \hline Total Material Cost & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Material/unit & \\ \hline Cost per Unit of Material & \\ \hline Cost of Material per Product & \\ \hline \end{tabular} Sales D-a:anta-n :- llu:ta SALES BUDGET \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & \multicolumn{2}{|r|}{ January } & \multicolumn{2}{|c|}{ February } & \multicolumn{2}{|c|}{ March } & \multicolumn{2}{|r|}{ April } \\ \hline Projected Sales in Units & $ & 13,719.00 & & 9.00 & & 66.00 & & 56581.00 \\ \hline Selling Price per Unit & $ & 53.00 & $ & 53.00 & $ & 53.00 & $ & 53.00 \\ \hline Anticipated Sales Dollars & $ & 727,107.00 & $ & 967.00 & & 0,398.00 & $ & 2,998,793.00 \\ \hline \end{tabular} SELLING \& ADMINISTRATIVE (S\&A) EXPENSE BUDGET \begin{tabular}{|l|rr|rr|rr|} \hline & \multicolumn{2}{c|}{ January } & \multicolumn{2}{c|}{ February } & \multicolumn{2}{c|}{ March } \\ \hline Sales in Units & \multicolumn{2}{|c|}{13719} & \multicolumn{2}{c|}{37339} & \multicolumn{2}{c|}{37366} \\ \hline Variable S\&A Rate/Unit & $ & 4.00 & $ & 4.00 & $ & 4.00 \\ \hline Anticipated Variable Costs & $ & 54,876.00 & $ & 149,356.00 & $ & 149,464.00 \\ \hline Fixed S\&A Costs & $ & 894 & $ & 894 & $ & 894 \\ \hline \begin{tabular}{l} Total Anticipated Selling \& \\ Administrative Costs \end{tabular} & $55,770.00 & $ & 150,250.00 & $ & 150,358.00 \\ \hline \end{tabular} PRODUCTION BUDGET \begin{tabular}{|l|c|c|c|c|} \hline & January & February & March & April \\ \hline Sales in Units & 13,719 & 37,339 & 37,366 & 56,581 \\ \hline Desired Ending Inventory & 2469 & 6721 & 6726 & 10185 \\ \hline Total Units Needed & 16188 & 44060 & 44092 & 66766 \\ \hline Beginning Inventory & 0 & 2469 & 6721 & 6726 \\ \hline Total Production in Units & 16188 & 41591 & 37371 & 60040 \\ \hline \hline \end{tabular} MATERIALS REQUIREMENTS BUDGET \begin{tabular}{|c|c|c|c|c|} \hline & January & February & March & April \\ \hline Units to be Produced & 16,188 & 41,591 & 37,371 & 60,040 \\ \hline Material/Unit & 1.0 & 1.0 & 1.0 & 1.0 \\ \hline Total Production Need & 16188 & 41591 & 37371 & \multirow[t]{7}{*}{60040} \\ \hline Desired Ending Inventory & 11315 & 29072 & 26122 & \\ \hline Total Materials Needed & 27503 & 70663 & 63493 & \\ \hline \multicolumn{4}{|l|}{ Beginning Inventory } & \\ \hline \multicolumn{4}{|l|}{\begin{tabular}{l} Total Materials Needed to be \\ Purchased \end{tabular}} & \\ \hline \multicolumn{4}{|l|}{ Cost per Unit of Material } & \\ \hline Total Material Cost & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Material/unit & \\ \hline Cost per Unit of Material & \\ \hline Cost of Material per Product & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
