Chapter 7 Labs
pdf
keyboard_arrow_up
School
Humber College *
*We aren’t endorsed by this school
Course
3504
Subject
Accounting
Date
Apr 3, 2024
Type
Pages
5
Uploaded by BailiffMusicParrot37
Chapter 7 Labs
Name:
- N01442610
Nghi Dung Dao
Professor: Hatem Shashaa
Course name: Data Analytics for Accountants - ACCT-3504
Due date: Mar 17/ 2024
Lab 7-1 Evaluate Job Costs —Sláinte:
Lab 7-1 Part 1 Objective Questions (LO 7-2)
OQ1. How much profit as a percentage of revenue does management hope to make from
each product?
Target profit margin: 20%
OQ2. What is the calculation for the budgeted direct labor cost?
27500
OQ3. When is a cost favorable?
When expenses/cost are lower than expected.
Lab 7-1 Part 1 Analysis Questions:
AQ1. Why do we need to set up calculated fields and measures before we can create a
visualization?
Because it is allow to create new data from already existing data, so creating
visualizations for that new data.
AQ2. What is the purpose of an IF . . . THEN . . . statement for this lab?
enable the use of
color on the graphs to show favorable and unfavorable analyses.
AQ3. Which other measures might be useful for analyzing job cost variance?
Possibly some measures that break down the job cost in manageable and definable categories
such as labor and materials.
Lab 7-1 Part 2 Objective Questions (LO 7-2)
OQ1. Which job has the highest revenue?
Job 3217
OQ2. Which job has negative profit?
Job 3210
OQ3. Which job has the highest profit?
Job 3214
OQ4. On average, do the Premium jobs make more profit or less profit than the Standard
jobs?
make less profit than standard jobs.
OQ5. On average, what is the largest revenue component measure?
1,772 for job number
3214.
Lab 7-1 Part 2 Analysis Questions:
AQ1. Why don’t we include revenue in this visualization?
-
The visualization shows profit and cost , therefore it is basically there just not calculated
AQ2. What additional information might a manager want to add to complement this
visual?
Revenue calculated.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Lab 7-2 Create a Balanced Scorecard Dashboard— Sláinte:
Lab 7-2 Part 1 Objective Questions
OQ1. What is management’s expected profit margin for each product?
13%
OQ2. What is the average revenue threshold for our best customers?
600
OQ3. What color should you use to show favorable metrics?
Blue
Lab 7-2 Part 1 Analysis Questions:
AQ1. What KPIs would you consider using to evaluate sales financial performance?
-
Monthly Sales, profit margin, cost per lead, lead to sale conversion.
AQ2. What KPIs would you consider using to evaluate process efficiency?
-
Quality indicators, order fulfillment cycle, the waste level in production.
AQ3. What KPIs would you consider using to evaluate employee growth?
-
Employee engagement level and revenue per employee.
AQ4. What KPIs would you consider using to evaluate customer relationships?
-
Customer complaints and customer satisfaction index.
AQ5. For each KPI, identify a benchmark value or KPI goal that you think management
might use.
-
Customer relationships: management will want to minimize customer complaints.
-
Financial performance: a goal will be for them to increase over the years.
-
Employee growth: they will want to look at employee turnover and limit that.
-
Process efficiency: they will want to minimize waste.
AQ6. Using the available fields, identify some calculations or relationships that would
support your KPIs from AQ1 to AQ4?
-
It would be useful to find relationships between sales & employees. This helps to identify
who the top salesperson is. It would also be helpful to find a relationship between sales
and locations to see which region has the most sales and who the top salesperson is, in
that region.
AQ7. Are there any KPIs you selected that don’t have supporting data fields?
-
When looking at customer relationships, there is no data for customer satisfaction or
complaints. There’s also no data for the amount of waste in each production. Lastly, there
is no way to calculate employee engagement level
Lab 7-2 Part 2 Objective Questions:
OQ1. Which product(s) has (have) fallen below the profit goal of 13 percent in February
2020?
Wheat and Pale Ale
OQ2. Which state takes the most time to ship to in February 2020?
Oklahoma
OQ3. Which salesperson is leading the rest for overall sales in February 2020?
Tatiana Shah
OQ4. Which customer is our best customer in February 2020?
Sooner Beer Co
Lab 7-2 Part 2 Analysis Questions:
AQ1. How does the balanced scorecard dashboard help management quickly identify
issues?
-
The balanced scorecard dashboard helps management quickly identify issues by
providing a comprehensive view of an organization's performance across multiple KPIs.
By presenting these critical KPIs in one dashboard, management can quickly identify
issues that require attention. It does this by presenting information in a visually accessible
format, with color-coded indicators, graphs, and charts.
AQ2. What category of visualizations did you produce in this lab?
-
I produced visualizations that will represent KPIs from each perspective. By making a bar
chart, line chart, scatter plot, and a map, these offer financial, process, growth, and
customer perspectives.
AQ3. What additional visualizations might you include on your dashboard?
-
Trendlines and Forecasts - Predicts future trends based on historical data. Comparison
Visualizations - Shows how data points compare to benchmarks, goals, or competitors.
Distribution Visualizations - Shows the spread and distribution of data points, such as
histograms or density plots.
Related Documents
Related Questions
b
Preview File Edit View Go Tools Window
♥
mgt120h-a17.pdf
Page 4 of 10
Cost-Volume-Profit Analysis
Help
40
The Effect Of Prepaid Taxes On Assets
And Liabili...
O
13. Goodwill can be recorded
a. When customers keep returning because they are satisfied with the company's products.
b. When the company acquires a good location for its business.
c. When the company has exceptional management.
d.
Only when there is an exchange transaction involving the purchase of an entire
business.
Debenture Valuation
CC
7
Www
D
mi popisiva
V
Search
-------
(Cª
Ơ
www
Sat Apr 15 3:05 PM
Page 4 of 11
www
arrow_forward
2. What is the variable costing net operating income in Year 1 and in Year 2?
arrow_forward
5
arrow_forward
Problems 5.1-5.3 relate to Goods and Services Selection
the life cycle, identify a reasonable operations strategy for
each:
... 5.1
ing products, and given the position in its life cycle, identify the
issues likely to confront the operations manager and his or her
possible actions. Product Alpha has annual sales of 1,000 units
and a contribution of $2,500; it is in the introductory stage.
Prepare a product-by-value analysis for the follow-
COMPANY
CONTRIBUTION
(%: TOTAL ANNUAL
CONTRIBUTION
PRODUCT
CONTRIBUTION
(% OF SELLING
PRICE)
DIVIDED BY TOTAL
ANNUAL SALES)
POSITION IN
LIFE CYCLE
Product Bravo has annual sales of 1,500 units and a contribu-
PRODUCT
tion of $3,0003; it is in the growth stage. Product Charlie has
annual sales of 3,500 units and a contribution of $1,750; it is in
the decline stage.
Smart watch
30
40
Introduction
Tablet
30
50
Growth
Hand
calculator
• 5.2
Given the contribution made on each of the
50
10
Decline
three products in the following table and their position in
arrow_forward
Business
arrow_forward
Question 1 Not yet answered Marked
out of 10.00 Flog question Answer the
following questions: -1 What is the
major forces in the company's
Macroenvironment? -2 Explain why
the aim of customer relationship
management is to create not just
customer satisfaction, but also
customer pleasure. -3 Name the four
major factors that influence consumer
buyer behavior? -3 Name the four
major factors that influence consumer
buyer behavior?
arrow_forward
Please answer completely and correctly with explanation computation formula steps answer in text no copy paste show explanation and computation clearly for numbers provide full working for all steps with explanation answer in text form
arrow_forward
A1
arrow_forward
Plz solve this in 30 min and take a thumb up plz plz i need it urgently plz
arrow_forward
Financial accounting MCQ 3 point
arrow_forward
9 MyPath Home
Content
O Managerial Accounting, Fifteenth x
My Questions | bartleby
х
O File | C:/Users/pse/Documents/managerial-accounting-15th-edition.pdf
Managerial Accounting, Fifteenth Edition
96/ 795
2,000
2,100
2,200
Fixed cost
Variable cost
Total cost ..
Average cost per cup of coffee served .....
2. Does the average cost per cup of coffee served increase, decrease, or remain the same as the
number of cups of coffee served in a week increases? Explain.
EXERCISE 2-5 High-Low Method [LO2-5]
The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs
of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a
room rented out for one day. The hotel's business is highly seasonal, with peaks occurring during
the ski season and in the summer.
Month
Occupancy-Days
Electrical Costs
January .
February
$4,127
$4,207
$5,083
$2,857
$1,871
$2,696
$4,670
$5,148
$2,691
$1,588
$2,454
1,736
1,904
March
2,356
April
960
May
360…
arrow_forward
TOPIC 3 FORECASTING, SALES & OPERATIONS PLANNING|Calculate the available-to-promise for periods 1,3 and 5 for the Table below
arrow_forward
General accounting MCQ 3 pts
arrow_forward
Please help with this question
arrow_forward
Q1
Please provide justified answer asap
arrow_forward
I Just need the direct answer no need explanation
arrow_forward
MANUFACTORING
Investigate
%
A packaging employee making $18
per hour can package 90 items
during that hour. The direct material
cost is $1.20 per item. What is the
total direct cost of 1 item?
A. $1.20
C. $1.40
o'
F5
^
F6
&
F7
S
F8
B. $0.20
a
D. $1.00
DELL
F9
I=
ACC
prtsc
F10
home
F11
end
F12
arrow_forward
content/qualsims/accounting/cost_volume_profit/v2/player/#/891e73d6eefafa67438268e177eaa497_qualsimsaccountingcost_volume_profitmiller_nobles_mattis
75 Tumblers Sora per month
Sales Revenue
Less: Variable Expenses
Contribution Margin
Less: Fixed Expenses
Operating Income
Total
Per Unit
$ 2,250
$ 30
1,350
18
$ 900
$ 12
250
$ 650
In order to determine how much contribution margin is earned for each $1 of sales, what is the contribution
margin ratio on your tumbler sales? Round to the nearest whole number.
Select an option from the choices below and click Submit.
○ 29%
○ 40%
○ 250%
Submit
arrow_forward
Safari File Edit View
L
100
History Bookmarks Window Help
Week 3 Overview - MGT6017_X70_Operations Management
JUL
26
===
Problems
1. A manufacturing company has the following financial information (in millions of $):
Sales
Cost of goods sold
Direct labor
Purchased materials
Overhead
All other costs
Pretax earnings
Administrative costs.
Pretax earnings
$823
85
Criteria
310
tv
94
a. What is the profit leverage effect of purchasing in this company?
b. What is the increase in earnings from an 8 percent savings in purchasing?
2. A service company has the following financial information (in millions of $)
Sales
Cost of outsourced facilitating goods
Cost of in-house services provided
250
84
$510
210
199
77
prod.reader-ui.prod.mheducation.com
24
a. What is the profit leverage effect of reducing the cost of the facilitating goods in this company?
b. It has been suggested that the in-house services costs could be reduced by 10 percent in the coming year by implementing lean
systems. What effect…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Related Questions
- b Preview File Edit View Go Tools Window ♥ mgt120h-a17.pdf Page 4 of 10 Cost-Volume-Profit Analysis Help 40 The Effect Of Prepaid Taxes On Assets And Liabili... O 13. Goodwill can be recorded a. When customers keep returning because they are satisfied with the company's products. b. When the company acquires a good location for its business. c. When the company has exceptional management. d. Only when there is an exchange transaction involving the purchase of an entire business. Debenture Valuation CC 7 Www D mi popisiva V Search ------- (Cª Ơ www Sat Apr 15 3:05 PM Page 4 of 11 wwwarrow_forward2. What is the variable costing net operating income in Year 1 and in Year 2?arrow_forward5arrow_forward
- Problems 5.1-5.3 relate to Goods and Services Selection the life cycle, identify a reasonable operations strategy for each: ... 5.1 ing products, and given the position in its life cycle, identify the issues likely to confront the operations manager and his or her possible actions. Product Alpha has annual sales of 1,000 units and a contribution of $2,500; it is in the introductory stage. Prepare a product-by-value analysis for the follow- COMPANY CONTRIBUTION (%: TOTAL ANNUAL CONTRIBUTION PRODUCT CONTRIBUTION (% OF SELLING PRICE) DIVIDED BY TOTAL ANNUAL SALES) POSITION IN LIFE CYCLE Product Bravo has annual sales of 1,500 units and a contribu- PRODUCT tion of $3,0003; it is in the growth stage. Product Charlie has annual sales of 3,500 units and a contribution of $1,750; it is in the decline stage. Smart watch 30 40 Introduction Tablet 30 50 Growth Hand calculator • 5.2 Given the contribution made on each of the 50 10 Decline three products in the following table and their position inarrow_forwardBusinessarrow_forwardQuestion 1 Not yet answered Marked out of 10.00 Flog question Answer the following questions: -1 What is the major forces in the company's Macroenvironment? -2 Explain why the aim of customer relationship management is to create not just customer satisfaction, but also customer pleasure. -3 Name the four major factors that influence consumer buyer behavior? -3 Name the four major factors that influence consumer buyer behavior?arrow_forward
- Please answer completely and correctly with explanation computation formula steps answer in text no copy paste show explanation and computation clearly for numbers provide full working for all steps with explanation answer in text formarrow_forwardA1arrow_forwardPlz solve this in 30 min and take a thumb up plz plz i need it urgently plzarrow_forward
- Financial accounting MCQ 3 pointarrow_forward9 MyPath Home Content O Managerial Accounting, Fifteenth x My Questions | bartleby х O File | C:/Users/pse/Documents/managerial-accounting-15th-edition.pdf Managerial Accounting, Fifteenth Edition 96/ 795 2,000 2,100 2,200 Fixed cost Variable cost Total cost .. Average cost per cup of coffee served ..... 2. Does the average cost per cup of coffee served increase, decrease, or remain the same as the number of cups of coffee served in a week increases? Explain. EXERCISE 2-5 High-Low Method [LO2-5] The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented out for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer. Month Occupancy-Days Electrical Costs January . February $4,127 $4,207 $5,083 $2,857 $1,871 $2,696 $4,670 $5,148 $2,691 $1,588 $2,454 1,736 1,904 March 2,356 April 960 May 360…arrow_forwardTOPIC 3 FORECASTING, SALES & OPERATIONS PLANNING|Calculate the available-to-promise for periods 1,3 and 5 for the Table belowarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning

Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning