Answered step by step
Verified Expert Solution
Link Copied!

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
up like image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
\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}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions