Store Dept Date Weekly_Sales IsHoliday 1 1 2/5/2020 24924.5 FALSE 1 1 2/12/2020 46039.49 TRUE 1 1 2/19/2020 41595.55 FALSE 1 1 1 1 1 2/26/2020 1 3/5/2020 1 3/12/2020 1 3/19/2020 19403.54 FALSE 21827.9 FALSE 21043.39 FALSE 22136.64 FALSE 1 1 3/26/2020 26229.21 FALSE 1 1 4/2/2020 57258.43 FALSE 1 1 1 4/9/2020 42960.91 FALSE 1 1 4/16/2020 1 4/23/2020 17596.96 FALSE 16145.35 FALSE

Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter5: Operating Activities: Purchases And Cash Payments
Section: Chapter Questions
Problem 2.1C
icon
Related questions
Question

In Column F, Row 1, develop a formula that calculates fraud expenses at 5 % of weekly sales.

Store
Dept
Date
Weekly_Sales IsHoliday
1
1
2/5/2020
24924.5 FALSE
1
1 2/12/2020
46039.49 TRUE
1
1 2/19/2020
41595.55 FALSE
1
1
1
1
1 2/26/2020
1 3/5/2020
1 3/12/2020
1 3/19/2020
19403.54 FALSE
21827.9 FALSE
21043.39 FALSE
22136.64 FALSE
1
1 3/26/2020
26229.21 FALSE
1
1 4/2/2020
57258.43 FALSE
1
1
1 4/9/2020
42960.91 FALSE
1
1 4/16/2020
1 4/23/2020
17596.96 FALSE
16145.35 FALSE
Transcribed Image Text:Store Dept Date Weekly_Sales IsHoliday 1 1 2/5/2020 24924.5 FALSE 1 1 2/12/2020 46039.49 TRUE 1 1 2/19/2020 41595.55 FALSE 1 1 1 1 1 2/26/2020 1 3/5/2020 1 3/12/2020 1 3/19/2020 19403.54 FALSE 21827.9 FALSE 21043.39 FALSE 22136.64 FALSE 1 1 3/26/2020 26229.21 FALSE 1 1 4/2/2020 57258.43 FALSE 1 1 1 4/9/2020 42960.91 FALSE 1 1 4/16/2020 1 4/23/2020 17596.96 FALSE 16145.35 FALSE
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage