Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the data sheet up like begin{tabular}{|c|c|} hline multicolumn{2}{|l|}{ Sales Projections in Units } hline January & 20.916 hline February & 41,661
Use the data sheet
\begin{tabular}{|c|c|} \hline \multicolumn{2}{|l|}{ Sales Projections in Units } \\ \hline January & 20.916 \\ \hline February & 41,661 \\ \hline March & 38,890 \\ \hline April & 55,701 \\ \hline May & 35,506 \\ \hline Projected Sales Price/Unit & 107 \\ \hline \multicolumn{2}{|c|}{ Monthly Projected Selling \& Administrative Expenses } \\ \hline Variable Cost/Unit & 21 \\ \hline Fixed Costs & 710 \\ \hline \multicolumn{2}{|l|}{ Production: } \\ \hline Desired Ending Inventory & 12.1% \\ \hline Beginning Inventory (new business) & 0 \\ \hline \multicolumn{2}{|l|}{ Materials } \\ \hline Desired Ending Inventory & 71.4% \\ \hline Number of Materials per Unit & 14 \\ \hline Projected CostMaterial Unit & 14 \\ \hline Beginning Inventory (new business) & 0 \\ \hline \multicolumn{2}{|l|}{ Direct Labor } \\ \hline Time per Unit (in hours) & 1 \\ \hline Cost per Hour & 14 \\ \hline \multicolumn{2}{|l|}{ Manufacturing Overhead } \\ \hline Variable Cost/Unit & 4 \\ \hline Fixed Costs & 6,865 \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|c|} \hline & January & February & March & April \\ \hline Projected Sales in Units & & & & \\ \hline Selling Price per Unit & & & & \\ \hline Anticipated Sales Dollars & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|c|} \hline \multicolumn{4}{|c|}{ SELLING \& ADMINISTRATIVE (S\&A) EXPENSE BUDG } \\ \hline \multicolumn{2}{|c|}{ January } & February & March \\ \hline Sales in Units & & & \\ \hline Variable S\&A Rate/Unit & & & \\ \hline Anticipated Variable Costs & & & \\ \hline Fixed S\&A Costs & & & \\ \hline \begin{tabular}{l} Total Anticipated Selling \& \\ Administrative Costs \end{tabular} & & & \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|c|} \hline \multicolumn{5}{|c|}{ PRODUCTION BUDGET } \\ \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} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ MATERIALS REQUIREMENTS BUDGET } \\ \hline & January & February & March & April \\ \hline \multicolumn{5}{|l|}{ Units to be Produced } \\ \hline \multicolumn{5}{|l|}{ Materia/Unit } \\ \hline \multicolumn{5}{|c|}{ Total Production Need } \\ \hline \multicolumn{4}{|c|}{ Desired Ending Inventory } & \\ \hline \multicolumn{4}{|c|}{ Total Materials Needed } & \\ \hline \multicolumn{4}{|l|}{ Beginning Inventory } & \\ \hline \multicolumn{4}{|c|}{\begin{tabular}{l} Total Materials Needed to be \\ Purchased \end{tabular}} & \\ \hline \multicolumn{4}{|c|}{ 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} \begin{tabular}{|l|c|l|l|} \hline & January & February & March \\ \hline Number of Units Produced & & & \\ \hline Direct Labor Hours/Unit & & & \\ \hline Total Direct Labor Hours Needed & & & \\ \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} Predetermined OH Rate PRODUCT COST PER UNIT \begin{tabular}{|l|c|c|c|} \hline & January & February & March \\ \hline Sales in Units & & & \\ \hline Sales Revenue & & & \\ \hline Cost of Goods Sold: & & & \\ \hline Gross Profit (Margin) & & & \\ \hline \begin{tabular}{l} Selling and Administrative \\ (Operating) Expenses \end{tabular} & & & \\ \hline Operating Income & & & \\ \hline \end{tabular} up like
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