BA In class Wk 6
xlsx
keyboard_arrow_up
School
Alexander College *
*We aren’t endorsed by this school
Course
102
Subject
Accounting
Date
Nov 24, 2024
Type
xlsx
Pages
13
Uploaded by LieutenantCrownLeopard27
City
Sum - Order Amount
Calgary
$3,364
Hamilton
$5,489
Montreal
$4,534
Oshawa
$5,917
Saskatoon
$5,479
Torento
$8,814
Vancouver
$2,279
Total Result
$35,876
Calgary
Hamil
ton
Montr
eal
Oshaw
a
Sask
0
5000
10000
15000
20000
25000
30000
35000
40000
askato
on
Tor
ento
Vancouver
Tota
l R
esult
Total
Sum - Order Amount
Sum - Order Amount
Month
Salesperson
January
February March April June
Total Result
Colins, Chris
$2,276
$1,403 $1,182
###
$5,917
Davis, Tia
$1,064
$890
$325
$2,279
Flores, Richard
$2,074
$2,460
$4,534
Georgia, Sara
$1,366 $1,184
###
###
$5,489
Jordan, Melissa
$1,509
$1,509
$346
$3,364
Sipmson, William
$2,822
$1,390 $2,085
###
###
$8,814
Walters, Shannon
$2,071 $2,044
###
$5,479
Total Result
$9,745
$11,089 $6,495
###
###
$35,876
Colins, Chris
Da
0
2000
4000
6000
8000
10000
12000
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
Davis,
T
ia
Flores
, Richard
Geor
gi
a, Sara
Jor
dan, Melis
sa
Sipmson, Wi
lliam
Walt
ers, Shannon
Tot
al
R
esult
Month January
February
March
April
June
Sum - Order Amount
Month
City
January
February March April June
Total Result
Calgary
$1,509
$1,509
$346
$3,364
Hamilton
$1,366 $1,184
###
###
$5,489
Montreal
$2,074
$2,460
$4,534
Oshawa
$2,276
$1,403 $1,182
###
$5,917
Saskatoon
$2,071 $2,044
###
$5,479
Torento
$2,822
$1,390 $2,085
###
###
$8,814
Vancouver
$1,064
$890
$325
$2,279
Total Result
$9,745
$11,089 $6,495
###
###
$35,876
Calgary
Ha
0
2000
4000
6000
8000
10000
12000
Hamil
ton
Mon
tr
eal
Oshaw
a
Saskato
on
Tor
ento
Vancouv
er
Tot
al
R
esult
Month January
February
March
April
June
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
Month
Sum - Order Amount
March
$6,495
April
$5,713
June
$2,834
Total Result
$15,042
March
April
0
2000
4000
6000
8000
10000
12000
14000
16000
June
Total Result
Total
Sum - Order Amount
T
S
2
I
a
i
E
s
This shape represents a slicer. Slicers are supported in Excel 2010 or later.
If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2003 or earlier, the slicer cannot be used.
This shape represents a slicer. Slicers are supported in Excel 2010 or later.
If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2003 or earlier, the slicer cannot be used.
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
Salesperson
City
Account
Order Amount
Month
Colins, Chris
Oshawa
76763
$256
March
Colins, Chris
Oshawa
70686
$264
January
Colins, Chris
Oshawa
16440
$605
January
Colins, Chris
Oshawa
24908
$926
March
Colins, Chris
Oshawa
13787
$1,056
April
Colins, Chris
Oshawa
12996
$1,403
February
Colins, Chris
Oshawa
24859
$1,407
January
Davis, Tia
Vancouver
65609
$325
April
Davis, Tia
Vancouver
77084
$389
January
Davis, Tia
Vancouver
41954
$675
January
Davis, Tia
Vancouver
48881
$890
February
Flores, Richard
Montreal
48112
$686
January
Flores, Richard
Montreal
30661
$1,006
February
Flores, Richard
Montreal
83817
$1,388
January
Flores, Richard
Montreal
48838
$1,454
February
Georgia, Sara
Hamilton
64852
$700
April
Georgia, Sara
Hamilton
74466
$1,101
April
Georgia, Sara
Hamilton
31255
$1,138
June
Georgia, Sara
Hamilton
54309
$1,184
March
Georgia, Sara
Hamilton
42162
$1,366
February
Jordan, Melissa
Calgary
34550
$346
June
Jordan, Melissa
Calgary
64256
$437
January
Jordan, Melissa
Calgary
70739
$698
February
Jordan, Melissa
Calgary
70060
$811
February
Jordan, Melissa
Calgary
35882
$1,072
January
Sipmson, William
Torento
57516
$259
January
Sipmson, William
Torento
84076
$370
January
A retailer sells items in different cities. The sales manager aims to analyze the number of sales in each city by e
sales.
You are required to:
1- In the following table, find the location of 13787 in the Account column (use the MATCH function); (10%)
2- In the following table, start from Account 70686, move 3 rows below and 1 column forward and return the 3-Name the Table area as "Customer data"; (5%)
4- Create a new column that gives customer ID in the format: name/account. Example Colins, Chris/76763.
Us
5. Sort data by Order Amount in descending order (5%)
Use Pivot tables and charts for the following tasks. Please create a new sheet for q6, q7, q8 and q9-11 (total 4
6- Calculate the Summation of Order Amount in each City; (10%)
7- Calculate the Summation of Order Amount by each Salesperson in different Months; (15%)
8- Calculate the Summation of Order Amount in each City in different Months; (10%)
9- Insert a chart to show the Summation of Order Amount in each month; (10%)
10- Insert Data Lable and Chart Title for the chart; (5%)
11- Insert a Filter for the Chart to show the Order Amount for each Month based on different Cities; (10%)
**Please insert a New Sheet to respond to each question and Rename the sheets as the number of the questi
Sipmson, William
Torento
41103
$813
March
Sipmson, William
Torento
70829
$946
January
Sipmson, William
Torento
15872
$1,167
April
Sipmson, William
Torento
19084
$1,247
January
Sipmson, William
Torento
15819
$1,272
March
Sipmson, William
Torento
73776
$1,350
June
Sipmson, William
Torento
57747
$1,390
February
Walters, Shannon
Saskatoon
10875
$827
February
Walters, Shannon
Saskatoon
71599
$976
March
Walters, Shannon
Saskatoon
21843
$1,068
March
Walters, Shannon
Saskatoon
65306
$1,244
February
Walters, Shannon
Saskatoon
36025
$1,364
April
Month Order
Customer Id
3
Colins, Chris, 76763
1
Colins, Chris, 70686
Q1 --->
5
1
Colins, Chris, 16440
Q2--->
926
3
Colins, Chris, 24908
4
Colins, Chris, 13787
2
Colins, Chris, 12996
1
Colins, Chris, 24859
4
Davis, Tia, 65609
1
Davis, Tia, 77084
1
Davis, Tia, 41954
2
Davis, Tia, 48881
1
Flores, Richard, 48112
2
Flores, Richard, 30661
1
Flores, Richard, 83817
2
Flores, Richard, 48838
4
Georgia, Sara, 64852
4
Georgia, Sara, 74466
6
Georgia, Sara, 31255
3
Georgia, Sara, 54309
2
Georgia, Sara, 42162
6
Jordan, Melissa, 34550
1
Jordan, Melissa, 64256
2
Jordan, Melissa, 70739
2
Jordan, Melissa, 70060
1
Jordan, Melissa, 35882
1
Sipmson, William, 57516
1
Sipmson, William, 84076
each sales person to get a general understanding of the performance in output (use OFFSET function); (10%)
se Concatnate function (10%)
4 additional sheets). Please rename the sheets properly
tions**
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
3
Sipmson, William, 41103
1
Sipmson, William, 70829
4
Sipmson, William, 15872
1
Sipmson, William, 19084
3
Sipmson, William, 15819
6
Sipmson, William, 73776
2
Sipmson, William, 57747
2
Walters, Shannon, 10875
3
Walters, Shannon, 71599
3
Walters, Shannon, 21843
2
Walters, Shannon, 65306
4
Walters, Shannon, 36025
Related Documents
Related Questions
Q22
Washington Arts allocates marketing and administrative costs to its three schools based on total annual tuition revenue for the schools:
School
Longview Campus
Springhill Campus
Center Saint Campus
Total
Tuition revenue
$ 1,400,000
$ 1,200,000
$ 1,400,000
$ 4,000,000
Marketing and administrative
$ 1,600,000
Using revenue as an allocation base, the amount of costs allocated to the Springhill Campus is calculated to be:
Multiple Choice
$640,000.
$560,000.
$400,000.
$480,000.
$760,000.
arrow_forward
Kindly answer the 6 and 7 thank you
arrow_forward
4
arrow_forward
BDF limited as the following supplies:
Supplies at standard rate $5,000,000
Supplies at Zero percent $3,000,00
Supplies at 25% $2,000,000
Exempt Supplies $5,000,000
The GCT threshold is $10,000,000.
Which of the following statement is correct?
O a. BDF limited total supplies is $9,000,000. The company is required to register for
VAT.
• b. BDF limited taxable has exempt supplies. The company is not required to register for VAT.
O c. BDF limited total supplies is $15,000,000. The company is required to register for
VAT.
O d. BDF limited taxable supplies is $7,000,000. The company is not required to register
for VAT.
arrow_forward
Find the commission
#
Sales Position
8 Real Estate
9 Computers
10 Major Appliances
11 Clothing
12 Computer Supplies
13 Siding Contract
14 Auto
Total Sales
X Straight Commission
$198,000
18,100 X
9,598
X
1,311
X
929
68,417
X
X
X
X
Rate
8%
2%
6%
9%
16%
12%
=
=
=
=
=
=
Commission
690.48
2,052.51
arrow_forward
BDF limited as the following supplies:
Supplies at standard rate $5,000,000
Supplies at Zero percent $3,000,00
Supplies at 25% $2,000,000
Exempt Supplies $5,000,000
The GCT threshold is $10,000,000.
Which of the following statement is correct?
Question 17Answer
a.
BDF limited total supplies is $9,000,000 . The company is required to register for VAT.
b.
BDF limited total supplies is $15,000,000 . The company is required to register for VAT.
c.
BDF limited taxable has exempt supplies . The company is not required to register for VAT.
d.
BDF limited taxable supplies is $7,000,000 . The company is not required to register for VAT.
arrow_forward
Percentage Service Provided to Department Cost S1 S2 P1 P2 Service 1 (S1) $ 122,000 0 % 40 % 40 % 20 % Service 2 (S2) 54,000 25 0 25 50 Production 1 (P1) 445,000 Production 2 (P2) 316,000 Total $ 937,000 What percentage of S1’s costs is allocated to P1 and to P2 under the direct method?
arrow_forward
9. Sender, Inc. estimates parcel mailing costs using data shown on the chart next page:
arrow_forward
Count of Postal Code
Low
Medium
5.71K
High
3.07K
Critical
0.78K
Count of Postal Code by Segment
6K
OK
Consumer
Corporate
Segment
Home Office
7.6%
Count of Postal Code by Order Priority
100%
POSTAL CODE DASHBORD
MANDHR
0.43K
California
New York
Texas
Pennsylvania
Washington
Illinois
Ohio
Florida
Michigan
Arizona
North Carolina
State
Virginia
Georgia
Tennessee
Colorado
Count of Postal Code by State
Indiana
Kentucky
Massachusetts
New Jersey
Oregon
Wisconsin
Maryland
Delaware
Minnesota
Connecticut
Missouri
Oklahoma
Alabama
Arkansas■
arrow_forward
Total Manufacturing Costs
₱325,000
Applied Overhead Costs, 75% of direct labor cost
₱075,000
Selling expenses
₱316,000
Administrative expenses
₱314,000
What is the cost of direct materials? Show solution
Group of answer choices
₱175,000
₱193,750
₱220,000
₱150,000
arrow_forward
Using the following information, determine the activity rate for the purchasing activity.
Activity
Estimated Activity Cost
Estimated Activity-Base Usage
Setup
$80,000
1,000
Purchasing
130,000
10,000
Inspecting
50,000
2,000
a.$2.00
b.$8.00
c.$130.00
d.$13.00
arrow_forward
60.000 units
$75,000
$120,000
$65,000
90,000 units
$75,000
$180,000
$80,000
$335,000
Cost A
Cost B
Cost C
$260,000
Total Costs
cost
Cost C is a
О А. fixed
О В. mixed
O C. variable
O D. sunk
arrow_forward
ABFHRL437 Corporation’s info is bel ow:
Sales $509,000
VC $101,800
FC $22,730
NOI $384,470 Q. How much is ABFHRL437’s Contribution Margin?
A. $
arrow_forward
Nottage Company has four separate operating segments:
East
West
North
South
Sales to outsiders
$188000
$126000
$65000
$43000
Inter segment transfers
16000
6000
13000
8000
What revenue amount must one customer generate before it must be identified as a major customer? Choose the correct.a. $39,600b. $42,200c. $46,500d. $49,200
arrow_forward
Direct materials: Beginning inventory
$50,000
Purchases 154,000
Ending inventory 26,000
Direct manufacturing labour 40,000
Manufacturing overhead 30,000
Ending work-in-process inventory
10,000
Beginning work-in-process inventory
2,000
Ending finished goods inventory
40,000
Beginning finished goods inventory
60,000
What is Montreal's cost of goods sold
during the year?
Question 13 options:
A) $260,000
B) $232,000
C) $220,000
D) $200,000
arrow_forward
Accounting
Year 5
Year 6
ww
АВ
ww
AB
120,000
30,000
90,000
90,000
Direct Material Requirements
2 Cuble Foot
All Wood All Bark
Cubic Yards
Cubic Feet
Bags
Bins
Bins
Raw Material Cost per Cubic
Dumpster containers hold
20
540
270
Ft (Yr 5)
Raw Material Cost per Cubic
0.15
0.3
Temporary Sorting Collection
Bins/Bags
5
135
67.5
Ft (Yr 6)
0.1
0.35
Direct material cost
Year 5
Year 6
ww
AB
ww
AB
ww
АВ
Total bins processed
Actual price paid per usable cubic yard of
input
Average direct labor time per bin
120,000
$4.05
30,000
$8.10
4 hours
What is the Direct Material Costs for Years 5
& 6 of WW and AB?
arrow_forward
h5
arrow_forward
Using the data from Terrace Industries:
District 1
District 2
Sales
$300,000
$600,000
Cost of goods sold
120,000
150,000
Selling expenses
55,000
75,000
Support department expenses:
Purchasing
$70,000
Payroll accounting
80,000
Allocate support department expenses proportional to the sales of each district. Determine the divisional operating income for Districts 1 and 2. For interim calculations, do not round. For all other amounts, round to the nearest whole dollar.
District 1 Operating Income
$fill in the blank 1
District 2 Operating Income
$fill in the blank 2
arrow_forward
Q.No.23 Financial accounting
arrow_forward
j coare
P 435,000
215,000
190,000
185,000
The following costs relate to Antonio Industries for the last quarter:
Conversion cost
Direct materials
Manufacturing overhead
Selling and administrative expense
1. What is Antonio's prime cost for last quarter?
a. P460,000
b. P 410,000
c. P 405,000
d. P 375,000
2. Antonio's total manufacturing cost is
P 460,000
b. P 645,000
P 650,000
d. P 840,000
a.
C.
3. Antonio's total period cost is
P 185,000
b. P 275,000
P 400,000
d.
a.
с.
P 620,000
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Q22 Washington Arts allocates marketing and administrative costs to its three schools based on total annual tuition revenue for the schools: School Longview Campus Springhill Campus Center Saint Campus Total Tuition revenue $ 1,400,000 $ 1,200,000 $ 1,400,000 $ 4,000,000 Marketing and administrative $ 1,600,000 Using revenue as an allocation base, the amount of costs allocated to the Springhill Campus is calculated to be: Multiple Choice $640,000. $560,000. $400,000. $480,000. $760,000.arrow_forwardKindly answer the 6 and 7 thank youarrow_forward4arrow_forward
- BDF limited as the following supplies: Supplies at standard rate $5,000,000 Supplies at Zero percent $3,000,00 Supplies at 25% $2,000,000 Exempt Supplies $5,000,000 The GCT threshold is $10,000,000. Which of the following statement is correct? O a. BDF limited total supplies is $9,000,000. The company is required to register for VAT. • b. BDF limited taxable has exempt supplies. The company is not required to register for VAT. O c. BDF limited total supplies is $15,000,000. The company is required to register for VAT. O d. BDF limited taxable supplies is $7,000,000. The company is not required to register for VAT.arrow_forwardFind the commission # Sales Position 8 Real Estate 9 Computers 10 Major Appliances 11 Clothing 12 Computer Supplies 13 Siding Contract 14 Auto Total Sales X Straight Commission $198,000 18,100 X 9,598 X 1,311 X 929 68,417 X X X X Rate 8% 2% 6% 9% 16% 12% = = = = = = Commission 690.48 2,052.51arrow_forwardBDF limited as the following supplies: Supplies at standard rate $5,000,000 Supplies at Zero percent $3,000,00 Supplies at 25% $2,000,000 Exempt Supplies $5,000,000 The GCT threshold is $10,000,000. Which of the following statement is correct? Question 17Answer a. BDF limited total supplies is $9,000,000 . The company is required to register for VAT. b. BDF limited total supplies is $15,000,000 . The company is required to register for VAT. c. BDF limited taxable has exempt supplies . The company is not required to register for VAT. d. BDF limited taxable supplies is $7,000,000 . The company is not required to register for VAT.arrow_forward
- Percentage Service Provided to Department Cost S1 S2 P1 P2 Service 1 (S1) $ 122,000 0 % 40 % 40 % 20 % Service 2 (S2) 54,000 25 0 25 50 Production 1 (P1) 445,000 Production 2 (P2) 316,000 Total $ 937,000 What percentage of S1’s costs is allocated to P1 and to P2 under the direct method?arrow_forward9. Sender, Inc. estimates parcel mailing costs using data shown on the chart next page:arrow_forwardCount of Postal Code Low Medium 5.71K High 3.07K Critical 0.78K Count of Postal Code by Segment 6K OK Consumer Corporate Segment Home Office 7.6% Count of Postal Code by Order Priority 100% POSTAL CODE DASHBORD MANDHR 0.43K California New York Texas Pennsylvania Washington Illinois Ohio Florida Michigan Arizona North Carolina State Virginia Georgia Tennessee Colorado Count of Postal Code by State Indiana Kentucky Massachusetts New Jersey Oregon Wisconsin Maryland Delaware Minnesota Connecticut Missouri Oklahoma Alabama Arkansas■arrow_forward
- Total Manufacturing Costs ₱325,000 Applied Overhead Costs, 75% of direct labor cost ₱075,000 Selling expenses ₱316,000 Administrative expenses ₱314,000 What is the cost of direct materials? Show solution Group of answer choices ₱175,000 ₱193,750 ₱220,000 ₱150,000arrow_forwardUsing the following information, determine the activity rate for the purchasing activity. Activity Estimated Activity Cost Estimated Activity-Base Usage Setup $80,000 1,000 Purchasing 130,000 10,000 Inspecting 50,000 2,000 a.$2.00 b.$8.00 c.$130.00 d.$13.00arrow_forward60.000 units $75,000 $120,000 $65,000 90,000 units $75,000 $180,000 $80,000 $335,000 Cost A Cost B Cost C $260,000 Total Costs cost Cost C is a О А. fixed О В. mixed O C. variable O D. sunkarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you