Final Exam (Comprehensive) Flashcards

1
Q

What are the three responsibilities of managers? (CHP 1) (Exam 1)

A

Planning - Setting goals and objectives for the company and determining how to achieve them.

Directing - Overseeing the company’s day-to-day operations. They use sales and cost information to run daily business operations.

Controlling - Evaluating the results of business operations against the plan and making adjustments to keep the company pressing toward it’s goal.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the differences between managerial and Financial Accounting? (CHP 1) (Exam 1)

A

Managerial Accounting
- For Internal users like managers.
- Can be prepared whenever it’s needed.
- Doesn’t need to follow a strict format like GAAP since it’s not for external users

Financial Accounting
- For external users like lenders and stockholders
- Is prepared annually and quarterly
- Must follow GAAP

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the four ethical standards of the IMA? (CHP 1) (Exam 1)

A

IMA (Institute of Management Accountants)
1 - Maintain their professional COMPETENCE
- Maintain an appropriate level of professional leadership and expertise by enhancing knowledge and skills
- Perform professional duties in accordance with relevant laws, regulations, and technical standards
- Provide decision-support informational recommendations that are accurate, clear, concise, and timely
2 - Preserve the CONFIDENTIALITY of the information they handle
- Keep information confidential except when disclosure is authorized or legally required.
- Inform all relevant parties regarding the appropriate use of confidential information.
- Refrain from using confidential information for unethical or illegal advantages
3 - Uphold their INTEGRITY
- Mitigate actual conflicts of interest.
- Refrain from engaging in any conduct that would prejudice carrying out duties ethically
- Abstain from engaging in or supporting any activity that might discredit the profession
4 - Perform their duties with CREDIBILITY
- Communicate information fairly and objectively.
- Provide all relevant information that could reasonably be expected to influence an intended user’s understanding of the reports, analyses, or recommendations
- Report delays or deficiencies in information, timeliness, processing, or internal controls in conformance with organization policy and/or applicable law.
- Communicate professional limitations or other constraints that would preclude responsibility judgment or successful performance of an activity.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are data analytics? (CHP 1) (Exam 1)

A

Data analytics is the process of turning raw data into actionable insights that lead to good business decisions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are the different types of data? (CHP 1) (Exam 1)

A

Structured Data
- Data that are highly organized into predefined categories and are fairly easy to search and manipulate.
- EX - Sales records contain data organized into predefined categories such as date of sale, invoice number, customer name, customer number, product sold, quantity sold, etc.

Unstructured Data
- Data that are not organized into predefined categories.
- EX - Social media posts, digital photos, videos, etc. This data is messy compared to structured data.

Semi-Structured Data
- Data that do not have predefined categories but have tags or makers to add some structure.
- EX - A “Like” on an Instagram or Facebook post adds an element of structure to what would otherwise be considered unstructured.

Numerical Data
- Discrete data - Can be counted
- Continuous data - Measurements

Categorical Data
- Has no numerical value or natural order.
- Can also be called nominal Data
- EX - country, distribution channel, product type.

Ordinal Data
- Data that has a clearly defined order and may mix numerical and categorical data.
- EX - Customer satisfaction rating. 1-5 in user experience, where 2 is better than 1.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

In Excel, to select a whole data set, place the cursor on ________ and hold down the Ctrl + A keys simultaneously

A

Any cell within the data set

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What does the “Triple Bottom Line” Refer to?

A

The concept that a company’s performance should be viewed not only in terms of its ability to generate economic profits for its owners, as has traditionally been the case, but also in terms of its impact on people and the planet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

In Excel, when you want to select a whole column of data, place the cursor on the top cell of the column and hold down which keys simultaneously?

A

Ctrl + Shift + arrow down key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the benefits of data analytics? (CHP 1) (Exam 1)

A

1 - Data-Driven decisions
- Gathering data like the time it takes kids to do their homework you can come up with an average timeframe to give. You use information to base your decisions on.
2 - Helps make quicker decisions
- Using information from the past can help businesses have a starting point instead of going from the beginning which saves time.
3 - Can increase the efficiency of internal operations
- Some companies use sensors to detect people in a room to save money on the light bill the lights turn off whenever there’s no one nearby.
4 - Can help companies better adapt and respond to customer’s individual preferences by more specifically tailoring marketing efforts.
- A company gives you coupons after your purchase, behind those coupons there’s a system that analyses what you buy to give you coupons for what you buy often to keep you coming back.
5 - Can drive company innovation and have a disruptive effect on existing industries.
- Things like Uber, Drones, and Amazon have had a big impact on existing industries.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is the purpose of data analytics? (CHP 1) (Exam 1)

A

At its core, data analytics is all about using data to make good business decisions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are the three types of businesses? (CHP 2) (Exam 1)

A

1 - Service Company
- A Company that sells intangible services rather than tangible products.
- EX - Accounting Firm
2 - Merchandising Company
- A company that resells tangible products previously bought from suppliers
- EX - Walmart, Retailers, Whole salers
3 - Manufacturing Company
- A company that uses labor, plant, and equipment to convert raw materials into new finished products.
- EX - Toyota, incurs the cost to build the car then sells to a Merchandiser for them to sell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the Value Chain? and what is its purpose? (CHP 2) (Exam 1)

A

The value chain are the activities that add value to a firm’s products and services; includes
- R&D (Research and Design)
- Production or Purchases
- Design
- Marketing
- Distribution
- Customer Service

(((It’s important because all the activities in the value chain are important, yet each costs money to perform. Managers must understand how decisions made in one area of the value chain will affect the costs incurred in other areas of the value chain.)))

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Describe and differentiate direct and indirect costs. (CHP 2) (Exam 1)

A

Direct Cost - A cost that can be traced to a cost object; a cost that is readily identifiable or associated with the cost object
- EX - Tires of a car, Wages of assembly line workers

Indirect Cost - A cost that relates to the cost object but cannot be traced specifically to it; a cost that is jointly used or shared by more than one cost object
- EX - Utilities for the plant, It is needed to build a car but you cannot trace how much was used for 1 car specifically

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Describe and differentiate Product Costs and Period Costs. (CHP 2) (Exam 1)

A

Product Costs - The costs incurred by manufacturers to produce their products or incurred by merchandisers to purchase their products. (Costs incurred by making or acquiring the product)
- EX - COGS

Period Costs - The costs incurred by the company to operate the business that do not get treated as inventory but rather are expensed immediately in the period in which they are incurred. (““Often called operating expenses””)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Describe and differentiate Prime Costs and Conversion Costs.
(CHP 2) (Exam 1)

A

Prime Costs - The combination of material and direct labor costs.
(DL + DM = Prime Costs)

Conversion Costs - The combination of direct labor and manufacturing overhead costs.
(DL + MOH = Conversion Costs)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is the Formula for a service company’s income statement. (CHP 2)

A

Revenue
(-) Operating Expenses
——————————–
Operating Income

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is the formula for a merchandiser’s income statement? (CHP 2)

A

Revenue
(-) COGS
————————
Gross profit
(-) Operating Expenses
————————————-
Operating Income

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is the formula used to get the income statement of a manufacturer’s company? (CHP 2)

A

Sales Revenue
(-) COGS
—————————
Gross Profit
(-) Operating Expenses
——————————-
Operating Income

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

How do you sort and filter in Excel explain the process of each. (CHP 2) (Exam 1)

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What is the process of getting Direct Materials Used? Give the formula (CHP 2) (Exam 1)

A

Beginning Raw Materials
(+) Purchases of Direct Materials, Freight-In, and Import Duties
——————————————–
Materials Available for use
(-) Ending Raw Materials Inventory
———————————————–
Direct Materials Used

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What is the process of getting the Cost of Goods Manufactured? Give the formula (CHP 2) (Exam 1)

A

Beginning Work-In-Process
(+) Manufacturing Costs Incurred
DL
DM
MOH
——————————————
Total manufacturing costs to account for
(-) Ending Work-In-Process Inventory
——————————————-
Cost of Goods Manufactured (CGM)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

What is the process of getting the Cost of Goods Sold? Give the formula (CHP 2) (Exam 1)

A

Beginning Finished Goods Inv
(+) Cost of Goods Manufactured (CGM)
———————————————–
Cost of Goods available for sale
(-) Ending Finished Goods Inventory
————————————————–
Cost of Goods Sold

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

How do you calculate the Product Cost? (CHP 2)

A

Direct Labor + Direct Materials + MOH = Product Cost

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Differentiate Job costing and Process costing. (CHP 3) (Exam 1)

A

Process Costing = Mass production
- A system for assigning costs to a large number of identical units that typically pass through a series of uniform production steps. Costs are averaged over the units produced such that each unit bears the same unit costs.
- EX - Every product goes through the same steps thus cost the same. (Marinara sauce)(Mustard)

Job Costing = Unique Production
- A system for assigning costs to products or services that differ in the amount of materials, labor, and overhead required.
- EX - Unique Houses, Unique Furniture, Unique jewelry.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

What are allocations? What are they used for? (In what process are they used?) (CHP 3) (Exam 1)

A

Allocating manufacturing overhead to jobs simply means that we will be “Splitting up” or “Dividing” the total manufacturing overhead costs among the jobs we produced during the year.
- EX - We would put a “Piece” of the price of MOH to each product to make up for the costs.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

How do you get the Predetermined MOH Allocation Rate? Give formula. (CHP 3)

A

Predetermined MOH rate =

Total Estimated amount of the allocation base (Cost Driver)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

What are the steps to allocate Manufacturing Overhead? (CHP 3)

A

Step 1 - The company estimates its total manufacturing overhead costs for the coming year

Step 2 - The company selects an allocation base and estimates the total amount that will be used during the year.

Step 3 - The company calculates its predetermined manufacturing overhead (MOH) rate using the information estimated in steps 1 and 2.

Step 4 - The company allocates some manufacturing overhead to each individual job as follow:
MOH allocated to a job =
Predetermined MOH rate X Actual amount of allocation based by the job.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

What does it mean to have an Overallocated or Underallocated manufacturing overhead? Also, when do these events occur? (CHP 3) (Exam 1)

A

Overallocated manufacturing overhead
- The amount of manufacturing overhead allocated to jobs is more than the amount of manufacturing overhead costs actually incurred; results in jobs being overcosted
- Occurs when jobs have been overcosted. The estimated is greater than the actual MOH incurred and distributed to products.

Underallocating manufacturing overhead
- The amount of manufacturing overhead allocated to jobs is less than the amount of manufacturing overhead costs actually incurred; this results in jobs being undercosted.
- Occurs when jobs have been undercosted. The estimated is less than the actual MOH incurred and distributed to products.

These Over and Under allocations are fixed when pricing the COGS. We would either increase COGS for underallocation or Decrease COGS for overallocation.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

What is the RPA? What does it do? (CHP 3) (Exam 1)

A

Robotic process automation (RPA)
- A software system that observes a person or user performing a task, recognizes patterns in that user activity, and creates a “bot” tp replicate that person’s task processes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

What are pivot tables? what do they do and how do you make them? (CHP 3) (Exam 1)

A

Pivot tables are tables made in Excel these tables have the ability to sort, filter, and graph data.

To make a pivot table you would select any cell in the data set and go to the ribbon then go to “Insert” and click “Pivot Table” Then you would drags what you wants columns and rows you want as well as values.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

How do you acquire the Plant-wide manufacturing Overhead Allocation rate? Give the formula (CHP 3) (Exam 1)

A

Plantwide overhead rate
- when overhead is allocated to every product using the same manufacturing overhead rate.

You would use the predetermined MOH rate formula
Total Estimated MOH / Cost driver

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

How do you calculate the cost of a job? Give the formula (CHP 3) (Exam 1)

A

Direct Materials + Direct Labor + MOH = Total Job Cost

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

What is Activity-based costing? (CHP 4) (Exam 2)

A

Separate manufacturing overhead rates are established for each department.
You would pick this way of costing to get a more accurate cost for manufacturing.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

What is Activity-based management? (CHP 4) (Exam 2)

A

(ABM) Using activity-based cost information to make decisions that increase profits while satisfying customers’ needs.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

What is Lean production? (CHP 4) (Exam 2)

A

Lean thinking is having A philosophy and business strategy of operating without waste

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

What are “The Eight Wastes” in lean thinking? (CHP 4)

A

D - Defects
O - Overprotection
W - Waiting
N - Not utilizing people to their full potential
T - Transportation
I - Inventory
M - Movement
E - Excess processing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

What are the four categories of quality costs? (CHP 4) (Exam 2)

A

Prevention costs
- Costs incurred to avoid poor-quality goods or services.
-EX- Training personnel, Evaluating potential suppliers, Using better materials

Appraisal costs
- Costs incurred to detect poor-quality goods or services
-EX- Inspection of incoming materials, Inspection at various stages of production, Product testing, cost of inspection.

Internal failure costs
- Costs incurred when the company detects and corrects poor-quality goods or services before making delivery to customers.
-EX- Cost of rework, Cost of making rejected units, disposal of rejected units, breakdown

External failure costs
- Costs incurred when the company does not detect poor-quality goods or services until after delivery is made to customers
-EX- Lost profits from reputation for poor quality, Warranty costs, Sales returns and allowances due to defects, cost of recalls.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

What is the Data cleaning process? What are the steps?
(CHP 4) (Exam 2)

A

1 - Remove Irrelevant data
2 - Remove duplicate records
3 - Standardize data
4 - Deal with missing data
5 - Filter out data outliers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

In Excel what is “Correlation” what does it do how do you initiate the formula? (CHP 4) (Exam 2)

A

Notated as R, this statistical measure indicates the degree of correlation between two variables.

It’s value can range from -1 to 1. A negative value means the variables move in opposite directions, where as positive means that variables move in the same direction.

The closer to 1 the most correlation it has.

TO USE THE FORMULA
In the ribbon go to formulas –> more functions -> Statistical –> CORREL then select the two variables of interest

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

How do you calculate the Departmental overhead rate? Give the formula. (CHP 4) (Exam 2)

A

Departmental overhead rate =

Total estimated departmental
overhead cost pool
——————÷———————-
Total estimated amount of the departmental allocation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

How do you calculate the Activity-Based cost allocation rate? Give formula. (CHP 4) (Exam 2)

A

Activity cost allocation rate =

Total estimated activity cost pool
——————÷———————-
Total estimated activity allocation
base

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

How do you calculate Allocations using departmental rate or ABC Rate? Give formula. (CHP 4) (Exam 2)

A

You would get the total estimated amount of the cost pool then divide it by the allocation base/cost driver

Total estimated allocation base

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

Differentiate between Variable costs, Fixed costs, and Mixed costs. Give examples of each. (CHP 6) (Exam 2)

A

Variable cost - Costs incurred for every unit of activity. As a result, total variable costs change in direct proportion to changes in volume.

Fixed costs - Costs that do not change in total despite wide changes in volume.

Mixed costs - Costs that change but not in direct proportion to changes in volume. Mixed costs have both variable cost and fixed cost components.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

What is Relevant range? how is it useful? (CHP 6) (Exam 2)

A

Relevant range - The band of volume where total fixed costs remain constant at a certain level and where the variable cost per unit remains constant at a certain level.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

What is the cost equation? (CHP 6) (Exam 2)

A

y= Vx + f

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

What are the ways to analyze cost behavior?
(CHP 6) (Exam 2)

A

1 - Scatterplot Analysis
2 - High-Low Method
3 - Regression Analysis
4 - Cost-Volume-Profit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

What is Variable Costing? How is it different from absorption costing?Give formula. (CHP 6) (Exam 2)

A

Variable Costing

  • The costing method that assigns only variable manufacturing costs to products. All fixed manufacturing costs (Fixed MOH) are expensed as period costs. Also known as direct costing.

The difference between both ways of costing is in the way Fixed MOH is treated. Variable costing treats FMOH as a period cost unlike Absorption that treats it like part of the product through COGS by allocating the cost into products.

FORMULA
Product Cost = DM + DL + Variable manufacturing cost

Sales
(-) Variable cost
——————————
Contribution Margin
(-) Fixed Costs
———————————
Net Operating Income

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

What is Absorption costing? How is it different from Variable costing? Give formula. (CHP 6) (Exam 2)

A

Absorption Costing
- The costing method where products “absorb” both fixed and variable manufacturing costs

Absorption costing allocates fixed MOH into the product and treats it as product costs through COGS.

Sales
(-) COGS
———————–
Gross margin
(-) Operating costs
—————————
Net operating income

49
Q

Differentiate between Linear regression and Multiple Regression. What are they used for? (CHP 6) (Exam 2)

A

Linear Regression
- Is commonly used to analyze relationships between one cost driver (Independent Variable) and total costs (Dependent variable)

Multiple Regression
- Is used when multiple cost drivers affect total costs or other outcomes, making it essential for more complex cost behavior analysis.

In summary, linear regression is suitable for analyzing one cost driver, while multiple regression is ideal when several factors affect costs. These tools enhance managerial accounting by providing insights into cost behavior, budgeting, and strategic decision-making.

50
Q

Scatterplots and Regression in Excel. How do you calculate it using excel? (CHP 6) (Exam 2)

A

Select both variables (x)(y) then in the ribbon on excel click quick layout then scatterplot then add tredline, select display R-Square

51
Q

How do you calculate the Cost Equation using the High-Low method? Give formula. (CHP 6) (Exam 2)

A

High-Low Method

X(High) - X(Low)

Gives Slope or our (V)
for the equation
Y = V(X) + F

Then we solve for F

By using either the high or low numbers insert them into the formula then solve for F

Then we get our equation

52
Q

How do you calculate Product cost and Operating income under Absorption costing? Give formula. (CHP 6) (Exam 2)

A

Product Cost
DM + DL + V MOH + F MOH

Operating Income
Sales
(-) COGS
——————–
Gross profit
(-) op expenses
——————-
Operating income

53
Q

How do you calculate Product cost and Operating income under Variable costing? Give formula. (CHP 6) (Exam 2)

A

Product Cost
DM + DL + VMOH

Operating Income
Sales
(-) Variable costs
——————————-
Contribution Margin
(-) Fixed costs
—————————–
Operating income

54
Q

How do you calculate the Contribution Margin? What does it mean and what is it used for? (CHP 7) (Exam 2)

A

Contribution Margin =
Sales - Variable costs

Its used for many things some being break-even point(Units), required sales (Units), etc.

55
Q

How do you calculate Cost-volume-profit? What does it mean and what is it used for? (CHP 7) (Exam 2)

A

Cost-Volume-Profit analysis
- (CVP) Expresses the relationships among costs, volume, and profit or loss.

  • Managers use it to determine the sales volume that will be needed just to break even or to cover costs. They also use it to determine the sales volume that will be needed to earn a target profit.
56
Q

How do you calculate the Margin of Safety? What does it mean and what is it used for? (CHP 7) (Exam 2)

A

Margin of safety
- Excess of expected sales over breakeven sales; the drop in sales a company can absorb without incurring an operating loss.

The margin of safety =
Expected sales ($ or units) - BEP($ or units)

The margin of safety (%) =

Expected (or actual) sales (Units or $)

Gives us a number we would have to hit to incur a loss.

57
Q

How do you calculate Operating Leverage? What does it mean and what is it used for? (CHP 7) (Exam 2)

A

Operating Leverage
- The relative amount of fixed and variable costs that make up a firm’s total costs

Operating Leverage Factor =

Operating Income

It means
The operating leverage factor, at a given level of sales, indicates the percentage change in operating income that will occur from 1% change in sales volume. In other words, it tells us how responsive a company’s operating income is to changes in sales volume.

58
Q

What is Scenario Analysis? What is it used for? (CHP 7) (Exam 2)

A

Scenario Analysis
- The process of experimenting with different scenarios to see wat would happen to company profits under those conditions, frequently using three scenarios: Base case, Best case, and Worst case.

59
Q

What is the formula for Contribution Margin? Give formula. (CHP 7) (Exam 2)

A

Sales Revenue
(-) Variable costs
—————————
Contribution Margin

60
Q

What is the formula for Contribution Margin ratio (CMR) Give formula. (CHP 7) (Exam 2)

A

Sales revenue

61
Q

How do you calculate Sales in units to achieve a target profit (Breakeven or a positive amount) Give formula. (CHP 7) (Exam 2)

A

Sales in Units =

    Contribution Margin

EX - Fixed exp 7,000, CM 14. Breakeven

  14 = 500 posters to breakeven
62
Q

How do you calculate Sales in dollars to achieve a target profit (Breakeven or a positive amount) Give formula. (CHP 7) (Exam 2)

A

BEP($)=
Fixed expenses + Operating Income
—————————————————-
Contribution Margin Ratio

63
Q

How do you calculate the weighted average contribution margin per unit? And what does it mean? Give formula. (CHP 7) (Exam 2)

A
64
Q

How do you calculate the Indifference between two options? Give the process. (CHP 7) (Exam 2)

A
65
Q

What is Relevant information? Give examples. (CHP 8) (Exam 3)

A
66
Q

What is Irrelevant information? Give examples. (CHP 8) (Exam 3)

A
67
Q

What is Target Costing? When is it used? What is the Formula? (CHP 8) (Exam 3)

A
68
Q

What is Cost-Plus Pricing? When is it used? What is the formula? (CHP 8) (Exam 3)

A
69
Q

What are the four types of data analytics? (CHP 8) (Exam 3)

A
70
Q

What does VLOOKUP do in Excel? What is it used for? (CHP 8) (Exam 3)

A
71
Q

How do you calculate the financial impact of a “Special Order” Give Formulas / Explain the process? (CHP 8) (Exam 3)

A
72
Q

How do you calculate the financial impact of discontinuing a product/department/store? Give formula / Explain the process. (CHP 8) (Exam 3)

A
73
Q

How do you calculate the Contribution Margin of a constrained resource? When would you use this? How do you use it? Explain the process.
(CHP 8) (Exam 3)

A
74
Q

How do you calculate the impact that outsourcing or insourcing a product/material will have on a company? Explain the process.

A
75
Q

How do you calculate the financial impact of selling a product “as is” vs. “Processing Further” How do you do either, Explain the process.
(CHP 8) (Exam 3)

A
76
Q

Differentiate between Participative budgeting and Top-Down Budgeting. (CHP 9) (Exam 3)

A
77
Q

How do you build a Comprehensive budget? What is it used for? Explain the process.
(CHP 9) (Exam 3)

A
78
Q

How do you build an Operating Budget? What is it used for? Explain the process.
(CHP 9) (Exam 3)

A
79
Q

How do you build a Financial Budget? What is it used for? Explain the process.
(CHP 9) (Exam 3)

A
80
Q

How do you come up with the Budgeted Units to be produced? Explain the process.
(CHP 9) (Exam 3)

A
81
Q

How do you calculate the Budgeted direct materials purchases? Explain the process.
(CHP 9) (Exam 3)

A
82
Q

How do you build the Cash Collections (Receipts) Explain the process.
(CHP 9) (Exam 3)

A
83
Q

How do you build the Cash Payments (disbursements) Explain the process.
(CHP 9) (Exam 3)

A
84
Q

How do you build the Cash budget? What does it consist of? Explain the components and process.
(CHP 9) (Exam 3)

A
85
Q

How do you build the Cost of Goods Sold Budget? Explain the process.
(CHP 9) (Exam 3)

A
86
Q

How do you build the Inventory Budget? Explain the process.
(CHP 9) (Exam 3)

A
87
Q

How do you build the Purchases Budget? Explain the process.
(CHP 9) (Exam 3)

A
88
Q

Explain the effects debit card and credit card sales have on Budgets. Give an example.
(CHP 9) (Exam 3)

A
89
Q

What does Decentralization mean? What effect does it have on a company? Explain.
(CHP 10) (Additional Chapter)

A
90
Q

What are Responsibility Centers? How many are there and what are they?
(CHP 10) (Additional Chapter)

A
91
Q

How do you calculate variances? Give formula. Also, what does it mean for a variance to be Favorable (F) or Unfavorable (U) Explain how to distinguish them.
(CHP 10) (Additional Chapter)

A
92
Q

What does “Management by exception” Mean and how does it affect a company?
(CHP 10) (Additional Chapter)

A
93
Q

What is a Flexible budget? explain.
(CHP 10) (Additional Chapter)

A
94
Q

What does having a “Balanced scorecard” Mean and how does it affect business?
(CHP 10) (Additional Chapter)

A
95
Q

What are the Data visualization types and uses? Explain.
(CHP 10) (Additional Chapter)

A
96
Q

What does the “ABS” function do in Excel and what is it useful for?
(CHP 10) (Additional Chapter)

A
97
Q

What does the “IF” Function do in Excel and what is it useful for?
(CHP 10) (Additional Chapter)

A
98
Q

How do you calculate “Return on Investment” (ROI) Give the formula. Explain what it means.
(CHP 10) (Additional Chapter)

A
99
Q

How do you calculate “Sales Margin” Give the formula. and Explain what it means.
(CHP 10) (Additional Chapter)

A
100
Q

How do you calculate “Capital Turnover” Give the formula. Explain what it means.
(CHP 10) (Additional Chapter)

A
101
Q

How do you calculate “Residual Income” (RI) Give the formula. Explain what it means.
(CHP 10) (Additional Chapter)

A
102
Q

How do you calculate the Comprehensive budget variance? Explain the process. What does it mean and how is it useful.
(CHP 10) (Additional Chapter)

A
103
Q

How do you calculate Volume Variance? Explain the process and how is it useful.
(CHP 10) (Additional Chapter)

A
104
Q

How do you calculate the Flexible budget variance? Explain the process and how is it useful.
(CHP 10) (Additional Chapter)

A
105
Q

Explain what “Standard Costs”
(CHP 11) (Additional Chapter)

A
106
Q

Explain both “Ideal Standards” and “Practical Standards” and explain how they are different.
(CHP 11) (Additional Chapter)

A
107
Q

Explain what “Responsible parties for variances” are and how it impacts business.
(CHP 11) (Additional Chapter)

A
108
Q

What are the Data analytics used to detect fraud?
(CHP 11) (Additional Chapter)

A
109
Q

What are “IFS” Functions on Excel and what do they do?

A
110
Q

What is “Conditional Formatting in Excel”?
(CHP 11) (Additional Chapter)

A
111
Q

How do you calculate “Direct materials Price Variance” Explain the process and give the formula.
(CHP 11) (Additional Chapter)

A
112
Q

How do you calculate “Direct materials quantity variance” Explain the process and give the formula.
(CHP 11) (Additional Chapter)

A
113
Q

How do you calculate “Direct Labor Rate Variance” Explain the process and give the formula.
(CHP 11) (Additional Chapter)

A
114
Q

How do you calculate “Direct Labor Efficiency Variance” Explain the process and give the formula.
(CHP 11) (Additional Chapter)

A
115
Q

How do you calculate “Variable overhead rate Variance” Explain the process and give the formula.
(CHP 11) (Additional Chapter)

A
116
Q

How do you calculate “Variable overhead efficiency Variance” Explain the process and give the formula.
(CHP 11) (Additional Chapter)

A
117
Q

How do you calculate “Fixed overhead budget Variance” Explain the process and give the formula.
(CHP 11) (Additional Chapter)

A
118
Q

How do you calculate “Fixed overhead volume Variance” Explain the process and give the formula.
(CHP 11) (Additional Chapter)

A