Answered step by step
Verified Expert Solution
Question
1 Approved Answer
with the given data compute eaxh budgeting process. compute the following chart: begin{tabular}{|rrr|} hline Units sold & 105000 & 102000 hline Sales $ &
with the given data compute eaxh budgeting process.
compute the following chart:
\begin{tabular}{|rrr|} \hline Units sold & 105000 & 102000 \\ \hline Sales $ & $652,000 & $622,000 \\ \hline Variable Mfe-costs & $358,000 & $340,000 \\ \hline Fixed Mfe-costs & $109,000 & $121,000 \\ \hline Fed SG\&A Expenses & $122,000 & $140,000 \\ \hline \end{tabular} Complete chart below Show all computations Units sold Sales \$ \begin{tabular}{|c|c|c|c|c|c|} \hline & \multirow[b]{2}{*}{\begin{tabular}{c} Master \\ Plan/ \\ Budget \end{tabular}} & \multirow[b]{2}{*}{\begin{tabular}{l} Flexible \\ Budget \end{tabular}} & \multirow[b]{2}{*}{\begin{tabular}{c} Master \\ Plan \\ Variance \\ Total \\ Difference \end{tabular}} & \multirow[b]{2}{*}{\begin{tabular}{c} Sales \\ Volume \\ Variance \end{tabular}} & \multirow[b]{2}{*}{\begin{tabular}{c} Flex \\ Budget \\ Variance \\ QtylUsage \end{tabular}} \\ \hline Actual & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} Variable Mfg. costs Variable SG\&A Expenses Contribution Margin \begin{tabular}{|l|l|l|l|l|l|} \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} Fixed Mfg. Costs Fixed SG\&A Expenses Total Fixed Costs \& Expenses \begin{tabular}{|l|l|l|l|l|l|} \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} Operating Income CH 14 Excel Ch 14HW Sheet3 \begin{tabular}{|rrr|} \hline Units sold & 105000 & 102000 \\ \hline Sales $ & $652,000 & $622,000 \\ \hline Variable Mfe-costs & $358,000 & $340,000 \\ \hline Fixed Mfe-costs & $109,000 & $121,000 \\ \hline Fed SG\&A Expenses & $122,000 & $140,000 \\ \hline \end{tabular} Complete chart below Show all computations Units sold Sales \$ \begin{tabular}{|c|c|c|c|c|c|} \hline & \multirow[b]{2}{*}{\begin{tabular}{c} Master \\ Plan/ \\ Budget \end{tabular}} & \multirow[b]{2}{*}{\begin{tabular}{l} Flexible \\ Budget \end{tabular}} & \multirow[b]{2}{*}{\begin{tabular}{c} Master \\ Plan \\ Variance \\ Total \\ Difference \end{tabular}} & \multirow[b]{2}{*}{\begin{tabular}{c} Sales \\ Volume \\ Variance \end{tabular}} & \multirow[b]{2}{*}{\begin{tabular}{c} Flex \\ Budget \\ Variance \\ QtylUsage \end{tabular}} \\ \hline Actual & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} Variable Mfg. costs Variable SG\&A Expenses Contribution Margin \begin{tabular}{|l|l|l|l|l|l|} \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} Fixed Mfg. Costs Fixed SG\&A Expenses Total Fixed Costs \& Expenses \begin{tabular}{|l|l|l|l|l|l|} \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} Operating Income CH 14 Excel Ch 14HW Sheet3 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