Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribed
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

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Financial Accounting Theory And Analysis Text And Cases

Authors: Richard G. Schroeder, Myrtle W. Clark, Jack M. Cathey

9th Edition

9780470128817

More Books

Students also viewed these Accounting questions

Question

What is a (a) dichotomous variable? (b) binary variable?

Answered: 1 week ago

Question

What benefit or advantage does your organization offer each public?

Answered: 1 week ago