The Ivy Toy Company manufactures a variety of toys. The controller is trying to determine what the

Question:

The Ivy Toy Company manufactures a variety of toys. The controller is trying to determine what the best allocation base for its utility costs would be and has gathered the company’s utility cost data and other information over the past four years. The following is a sample of the records in that Excel file. Access the full data set online in the MyLab Accounting exercise.


Requirements
Use the CORRELL function in Excel to analyze whether number of units produced, sales revenue, machine hours, or labor hours would be the appropriate cost allocation base for the company’s utility costs. Rank the four variables from the most highly correlated with utility costs to the least correlated. Which variable would you recommend be used as the allocation base for utility costs?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: