Question: Activity Four: High-Low Method and Contribution Margin Format Income Statement Part A (High-Low Method): Reichow Company produces widgets using an automated system. Jaiden is preparing

 Activity Four: High-Low Method and Contribution Margin Format Income Statement PartA (High-Low Method): Reichow Company produces widgets using an automated system. Jaidenis preparing financial statements for the Jaiden is preparing financial statements for

Activity Four: High-Low Method and Contribution Margin Format Income Statement Part A (High-Low Method): Reichow Company produces widgets using an automated system. Jaiden is preparing financial statements for the Jaiden is preparing financial statements for the upcoming year and needs to forecast monthly utilit experience, she knows that total utility expenses ar a function of machine-hours (Note: machine-hours are the activity level). Utility expense data from the previous year \begin{tabular}{|l|c|r|} \hline Month & Machine Hours & \multicolumn{1}{c|}{\begin{tabular}{l} Cost of \\ Utilities \end{tabular}} \\ \hline January & 408 & $3,182 \\ \hline February & 372 & $3,420 \\ \hline March & 254 & $3,009 \\ \hline April & 251 & $3,053 \\ \hline May & 371 & $3,337 \\ \hline June & 412 & $2,572 \\ \hline July & 305 & $2,843 \\ \hline August & 375 & $3,184 \\ \hline September & 370 & $3,319 \\ \hline October & 431 & $3,766 \\ \hline November & 399 & $3,341 \\ \hline December & 298 & $3,407 \\ \hline \end{tabular} Using the high-low method, calculate the following: 1) Variable cost per machine hour. 2) Monthly fixed costs (round to the nearest dollar). 3) Write a formula that can be used to predict utility costs for any different activity levels. You will use this formula in Part B. Part B (Contribution Margin Format Income Statement): Using this information prepare a Contribution Format Income Statement based on the following: For the month of March in the upcoming year, Jaiden predicts the company will use 285 machinehours to produce 5,000 widgets. Widgets sell for $10 each. Variable costs other than utilities total $22,000. Fixed costs other than utilities are $8,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!