Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Project #2 begin{tabular}{|c|c|c|} hline multicolumn{3}{|l|}{ Sales Projections in Units } hline begin{tabular}{|l|l|} January end{tabular} & & 20,916 hline February & & 41,661
Project \#2 \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|l|}{ Sales Projections in Units } \\ \hline \begin{tabular}{|l|l|} January \\ \end{tabular} & & 20,916 \\ \hline February & & 41,661 \\ \hline March & & 38,890 \\ \hline April & & 55,701 \\ \hline May & & 35,506 \\ \hline Projected Sales Price/Unit & $ & 107.00 \\ \hline \multicolumn{3}{|c|}{ Monthly Projected Selling \& Administrative Expenses } \\ \hline Variable Cost/Unit & $ & 21.00 \\ \hline Fixed Costs & $ & 710.00 \\ \hline \multicolumn{3}{|l|}{ Production: } \\ \hline Desired Ending Inventory & \multicolumn{2}{|c|}{12.1%} \\ \hline Beginning Inventory (new business) & \multicolumn{2}{|r|}{0} \\ \hline \multicolumn{3}{|l|}{ Materials } \\ \hline Desired Ending Inventory & \multicolumn{2}{|c|}{71.4%} \\ \hline Number of Materials per Unit & \multicolumn{2}{|r|}{14.0} \\ \hline Projected Cost/Material Unit & $ & 14.00 \\ \hline Beginning Inventory (new business) & \multicolumn{2}{|r|}{0} \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|l|}{ Direct Labor } \\ \hline Time per Unit (in hours) & & 1.00 \\ \hline Cost per Hour & $ & 14.00 \\ \hline \multicolumn{3}{|l|}{ Manufacturing Overhead } \\ \hline Variable Cost/Unit & $ & 4.00 \\ \hline Fixed Costs & $ & 6,865 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|l|}{ Direct Labor } \\ \hline Time per Unit (in hours) & & 1.00 \\ \hline Cost per Hour & $ & 14.00 \\ \hline \multicolumn{3}{|l|}{ Manufacturing Overhead } \\ \hline Variable Cost/Unit & $ & 4.00 \\ \hline Fixed Costs & $ & 6,865 \\ \hline \end{tabular} 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 \begin{tabular}{l} Total Materials Needed to be \\ Purchased \end{tabular} & & & & \\ \cline { 1 - 4 } 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started