Can someone help provide the formulas for a managerial accounting project using the data sheet below?

The numbers CANNOT be typed into the budget sheets.

You must Utilize cell references to transfer numbers from the data sheet to the worksheets.

.

Sales Projections in Units \begin{tabular}{|lr|} \hline January & 11,977 \\ \hline February & 45,231 \\ \hline March & 37,597 \\ \hline April & 54,163 \\ \hline May & 47,730 \\ \hline \end{tabular} Production: \begin{tabular}{lc} Desired Ending Inventory & 96.1% \\ \cline { 2 - 2 } Beginning Inventory (new business) & 0 \\ \cline { 2 - 2 } & \end{tabular} Materials \begin{tabular}{lrr} Desired Ending Inventory & \multicolumn{2}{c}{13.2%} \\ \cline { 2 - 3 } Number of Materials per Unit & 12.0 \\ \cline { 2 - 3 } Projected Cost/Material Unit & $10.00 \\ \cline { 2 - 3 } Beginning Inventory (new business) & 0 \\ \cline { 2 - 2 } & \end{tabular} Direct Labor Time per Unit (in hours) Cost per Hour \begin{tabular}{rr} 1.00 \\ \hline$23.00 \\ \hline \end{tabular} Manufacturing Overhead Variable Cost/Unit Fixed Costs \begin{tabular}{rr} $ & 5.00 \\ \hline$8,534 \\ \hline \end{tabular} SALES BUDGET \begin{tabular}{|l|l|l|l|l|} \hline & January & February & March & April \\ \hline Projected Sales in Units & & & & \\ \hline Selling Price per Unit & & & & \\ \hline Anticipated Sales Dollars & & & & \\ \hline \end{tabular} SELLING \& ADMINISTRATIVE (S\&A) EXPENSE BUDGET \begin{tabular}{|l|l|l|l|} \hline \multicolumn{1}{l|}{ January } & February & March \\ \hline Sales in Units & & & \\ \hline Variable S\&A Rate/Unit & & & \\ \hline Anticipated Variable Costs & & & \\ \hline Fixed S\&A Costs & & & \\ \hline TotalAnticipatedSelling&AdministrativeCosts & & & \\ \hline \end{tabular} PRODUCTION BUDGET \begin{tabular}{|l|l|l|l|l|} \hline & January & February & March & April \\ \hline Sales in Units & & & & \\ \hline Desired Ending Inventory & & & & \\ \hline Total Units Needed & & & & \\ \hline Beginning Inventory & & & & \\ \hline Total Production in Units & & & & \\ \hline \end{tabular} A MATERIALS REQUIREMENTS BUDGET \begin{tabular}{|l|l|l|l|l|} \hline & January & February & March & April \\ \hline Units to be Produced & & & & \\ \hline Material/Unit & & & & \\ \hline Total Production Need & & & & \\ \hline Desired Ending Inventory & & & & \\ \hline Total Materials Needed & & & & \\ \hline Beginning Inventory & & & & \\ \hline TotalMaterialsNeededtobePurchased & & & & \\ \hline 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} DIRECT LABOR BUDGET \begin{tabular}{|l|l|l|l|} \hline & January & February & March \\ \hline Number of Units Produced & & & \\ \hline Direct Labor Hours/Unit & & & \\ \hline TotalDirectLaborHoursNeeded & & & \\ \hline Cost/Direct Labor Hour & & & \\ \hline Total Direct Labor Cost & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Direct Labor Hours/Unit & \\ \hline Cost/Direct Labor Hour & \\ \hline Cost of Direct Labor per Product & \\ \hline \end{tabular} MANUFACTURING OVERHEAD BUDGET \begin{tabular}{|l|c|c|c|} \hline & January & February & March \\ \hline Production in Units & & & \\ \hline Variable OH Rate/Unit & & & \\ \hline Anticipated VOH Costs & & & \\ \hline Fixed OH Costs & & & \\ \hline Total Anticipated OH Costs & & & \\ \hline \end{tabular} Predetermined OH Rate \begin{tabular}{r|} Total Estimated OH Costs \\ Total Estimated DLHs \end{tabular}= per DLH MOH per Unit: Predetermined MOH rate DLHs per Unit MOH per Unit of Product \begin{tabular}{|l|} \hline \\ \hline \\ \hline \\ \hline \end{tabular} PRODUCT COST PER UNIT \begin{tabular}{|l|c|} \hline Item & Amount \\ \hline Direct Materials & \\ \hline Direct Labor & \\ \hline Manufacturing Overhead & \\ \hline Total Unit Cost & \\ \hline \end{tabular} A PROJECTED INCOME STATEMENT \begin{tabular}{|l|l|l|l|} \hline & January & February & March \\ \hline Sales in Units & & & \\ \hline Sales Revenue & & & \\ \hline Cost of Goods Sold: & & & \\ \hline Gross Profit (Margin) & & & \\ \hline SellingandAdministrative(Operating)Expenses & & & \\ \hline Operating Income & & & \\ \hline \end{tabular}