Financial Accounting Tools For Business Decision Making Canadian 9Th Kimmel Solutions Manual

CT1.7 The Purpose and Use of Financial Statements

Comparative Statements of Income

PART ONE:

(a) How many hours of cleaning service did each company provide to its clients? Divide revenue by the hourly rate charged to clients:

(b) What is the average rate of pay per hour that each company pays its employees? Knowing the hours worked from the above, we can derive the hourly salary by dividing total salary expense for each company by the hours worked as follows:

$900,000 60,000 hours $15 per hour

$480,000 30,000 hours $16 per hour

Collaborative Learning Activity to accompany Financial Accounting: Tools for Business Decision-Making by Kimmel, Weygandt, Mitchell, Trenholm, Irvine and Burnley

I. How to Use this Guide

This document has been created to provide information and guidance pertaining to the Data Analysis Technology Bootcamps. We provide instructions on how to view and assign the bootcamps in a few different ways, ideas to consider for how to use the bootcamps, as well as a detailed list of the topics covered for each technology tool and the estimated time it would take a student to complete each module. Additionally, we know that technology is ever-evolving and that there are limitations when it comes to usage on specific device types. Therefore, we have provided a section dedicated to information on how you and your students go about gaining access to these tools. Please note that as a publisher, Wiley cannot provide any technology licenses.

For additional questions about WileyPLUS, please reach out to your local Digital Learning Executive and Customer Success Manager.

II. How to Access these Technologies

We recommend that you consider asking your college’s IT staff for guidance and to know what functionalities are included in their virtual servers as well as when virtual server updates will happen.

A. Excel

Most students have all the functionalities needed through Office 365. To use the Power Query Excel tool, MAC users will need to use the Boot Camp Assistant to install the Microsoft Windows operating system. While operating in the Microsoft Windows operating system, they will have all the Power Query functionality. If they do not have Boot C amp, they will need access to a virtual server or a PC computer in the university computer labs.

Check your virtual server to make sure that it has Excel Pro 2019 or the current Office 365 version. These versions provide the needed Power Query functionality for viewing column statistics.

B. Power BI Desktop

It can be downloaded for free by both instructors and students, no license is required. Power BI Desktop runs in a Microsoft Windows operating system. MAC users will need to use the Boot Camp Assistant to install the Microsoft Windows operating system and then Power BI Desktop. An alternative is to have access to a virtual server or a PC computer in the university computer labs.

C. Tableau

Instructors can apply for a semester license and then pass the codes to their students, or students individually can apply for a license on their own for a year license. Instructors need to clarify which approach will be used in their syllabus. Getting the approval may take a few days, so start early, and work with your IT staff if it will be on a virtual server.

• Tableau: https://www.tableau.com/academic/teaching

D. Tableau Public

It is a possible solution but has the following significant restrictions: students’ work is publicly shared, and they will not be able to download their solutions (they could take a screenshot which they could submit as evidence of their work). Tableau Online (now called Tableau Cloud) does not have the same functionality as a downloaded Tableau student license or a university server license.

E. Alteryx

Can be downloaded for free by both instructors and students. Like Power BI, Alteryx runs on a Windows Operating system. MAC users will need to have an alternative solution if they do not have Bootcamp to be able to run Alteryx, such as a college server, or a PC computer in a computer lab. Alteryx works great on a virtual server, and they are willing to work with your

III. General Bootcamp Format

Each of the data analysis technology bootcamps follow the same general structure:

• Overview Video

• 10+ Topics o 1 How-To Video per Topic o 5-10 Multiple Choice questions per topic o 1 Application Exercise per topic

o 1-2 Follow up Questions to the Application Exercise o 1

Solution Walkthrough video per topic:

 The solution walkthrough videos will only automatically appear to students as question feedback to the 1-2 follow up questions of the Application Exercise. If these questions are removed, the solution walkthrough videos will not be available to students wi thout manual grading.