Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Related questions
Question
This week, your assignment will involve creating dashboards using Power BI and identifying audit data requirements using Microsoft Excel.
The Critical Thinking assignment opens at the start of the week in which it is scheduled. The assignment is due by 11:59 PM MT Sunday of the same week. Please refer to CSU Global's late policy for Critical Thinking assignments if you have any questions on due dates.
Required
Complete the following activities:
- Using Connect, follow the instructions to complete Lab 5.2 Create a Dashboard Based on Common Data Model with Microsoft Power BI (pp. 267 - 271) and Lab 5.4 Identify Audit Data Requirements with Excel (pp. 275 – 277) in your textbook.
- Assignment Instructions and Questions: Login to Connect, follow the instructions, video, and download the data files. Save all screenshots (label each screenshot as noted in the assignment)
- Objective Questions: Complete in Connect. This assignment has no time limit; however, you have two attempts to complete the assignment before the due date. For each attempt, you will revise your previous attempt. Your highest score will be recorded in the rubric for this assignment.
- Lab 5.4 Part 1 and Part 2 Analysis Questions: Using a Word document, provide responses to the questions found on pp. 276-277. Make sure to include a detailed explanation for each question to support your answers.
SAVE
AI-Generated Solution
info
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
to generate a solution
Click the button to generate
a solution
a solution
Knowledge Booster
Similar questions
- GenX is a career training company that offers both online and on-campus weekend training courses on web development, data science, coding, and digital marketing. The accompanying data file shows the courses that will be offered next month by GenX. The data set contains course name (Course), whether the course is offered online or on-campus (Mode), current enrollment (Enrollment), tuition per student (Tuition), cost of instructors (Instructor costs), facility costs (Facility costs), technical service costs (Technical services), and historical cancellation rate for the course (Cancellation rate). Only on-campus courses incur facility costs. Online courses carry much higher costs for technical services than on-campus courses. The historical cancellation rate is used to project the actual enrollments of the courses. GenX would like to develop a spreadsheet model that calculates the projected revenue and profit for the month. Course Mode Enrollment Tuition Instructor costs Facility…arrow_forwardPerfect Parties, Inc. has several divislons, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you prepare the Birthday Party Dlvislon Budget Performance Report. Use the Information Included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=E11" was entered, the formula would output the result from cell E11, or 80 In this example. • Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: - (plus sign to add), - (minus sign to subtract). * (asterisk sign to multiply), and (forward slash to divide). From the Excel Simulation below, If in a blank cell "=E13-F13" was entered, the formula would add the values from those cells and output…arrow_forwardSubmit your final work via moodle.gusto-education.com by 10th February 2024 (Saturday) 23:59 PM Submit your declaration form and Assignment Brief within 3 school days after Hand- in. Unit Learning Outcomes LO1: Explore the nature, source, and purpose of management accounting information. LO2: Evaluate management accounting techniques to inform optimal resource allocation and decision-making. LO3: Analyse actual and standard costs to control and correct variances. LO4: Evaluate how the management accounting function contributes to performance measurement and monitoring. Transferable skills and competencies developed Vocational scenario You have been hired as a Junior Management Accountant by a manufacturing company called Columbus Canopy Company (CCC) is a leading player in the industry and is constantly striving to maintain its competitive advantage. The company is experiencing rapid growth and facing various challenges in resource allocation, decision-making, and performance…arrow_forward
- Marketing system provides some useful insights regarding the sales order. Different departments use this information. For instance, the production process uses this information to forecast the expected sale for next month. The production clerk uses this to create an online production schedule. From this schedule, the system automatically prepares weekly online work orders to be used by the production department. The production supervisor assesses the work orders from his terminal and prepares the necessary paper-based move tickets and materials requisitions. Then, the move tickets and two copies of the materials requisitions are distributed to each work centre. Later, work centre employees submit the two copies of the materials requisitions to the warehouse in exchange for materials and sub-assemblies. If additional new materials are needed beyond the standard quantity, the supervisor issues additional materials requisitions. Work centre employees record their work hours on paper-based…arrow_forwardMarketing system provides some useful insights regarding the sales order. Different departments use this information. For instance, the production process uses this information to forecast the expected sale for next month. The production clerk uses this to create an online production schedule. From this schedule, the system automatically prepares weekly online work orders to be used by the production department.The production supervisor assesses the work orders from his terminal and prepares the necessary paper-based move tickets and materials requisitions. Then, the move tickets and two copies of the materials requisitions are distributed to each work centre. Later, work centre employees submit the two copies of the materials requisitions to the warehouse in exchange for materials and sub-assemblies. If additional new materials are needed beyond the standard quantity, the supervisor issues additional materials requisitions.Work centre employees record their work hours on paper-based…arrow_forwardMarketing system provides some useful insights regarding the sales order. Different departments use this information. For instance, the production process uses this information to forecast the expected sale for next month. The production clerk uses this to create an online production schedule. From this schedule, the system automatically prepares weekly online work orders to be used by the production department. The production supervisor assesses the work orders from his terminal and prepares the necessary paper-based move tickets and materials requisitions. Then, the move tickets and two copies of the materials requisitions are distributed to each work centre. Later, work centre employees submit the two copies of the materials requisitions to the warehouse in exchange for materials and sub-assemblies. If additional new materials are needed beyond the standard quantity, the supervisor issues additional materials requisitions. Work centre employees record their work hours on paper-based…arrow_forward
- to create a model for a production cost report using the weighted average method for the month of May. Following good Excel design techniques, you should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. As always, you should have only formulas or references in your output area. You should also include directions (in a text box) for users. After completion of the production cost report using the weighted average method, create a new worksheet and label the tab “FIFO”. Create a production cost report using the same information using the FIFO method. Spartans Bakery has two department: mixing and baking. All products start in the Mixing Department, where materials are added and conversion costs (labor, overhead) are incurred. Once the product is “finished” with regards to the Mixing, it moves to the Baking Department where additional conversion costs are incurred before moving to Finished…arrow_forwardThe general ledger of Jay Consulting shows the following balances at July 31: Jay has asked you to develop a worksheet that will serve as a trial balance (file name PTB). Use the data provided as input for your model. Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete. Print the worksheet when done. Check figure: Total debits, 17,731. To test your model, use the following balances at August 31: Print the worksheet when done. Check figure: Total debits, 18,810. CHART (optional) Using the test data worksheet, prepare a pie chart showing the percentage of each asset to total assets. Print the chart when done.arrow_forwardStudents are required to provide a piece of writing (with a word limit of 400) on how the MYOB software can contribute to the various kinds of business management decision-making through using some of the specific special-purpose-reports generated by its software.arrow_forward
- Until a year ago, Dagwood Printing Company had always operated in a centralized computer environment. Now, 75 percent of the office employees have a PC. Users have been able to choose their own software packages, and no documentation of end-user-developed applications has been required. Next month, each PC will be linked into a local area network and to the company’s mainframe. Required a. Outline a plan of action for Dagwood Printing Company to ensure that the proper controls over hardware, software, data, people, procedures, and documentation are in place. b. Discuss any exposures the company may face if the devised plan is not implemented.arrow_forwardPrior midnight March 11, post at least once about this week's Wiley assignment. You may post asking your fellow learners for help or share your own insight as you work through the assignment. Some guiding points: - - What is the first step you will take to successfully complete a budget for yourself ? - What are some of the challenges in creating a budget for a company?arrow_forwardCan anyone help with the general journal entries for this? #3 shows three entries on the template I have and I'm lost.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,
Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,