[go: up one dir, main page]

0% found this document useful (0 votes)
9 views14 pages

Masterclass - 4 July - Practice File

The document contains a list of items with their quantities and dates, along with employee information including names, roles, and hire dates. It also includes sales data for bags over the last 12 months. Some sections of the document contain placeholder text or incomplete data.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
9 views14 pages

Masterclass - 4 July - Practice File

The document contains a list of items with their quantities and dates, along with employee information including names, roles, and hire dates. It also includes sales data for bags over the last 12 months. Some sections of the document contain placeholder text or incomplete data.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 14

Date Item Qty

11/25/2025 Windex 1
6/19/2026 Cleats 0
11/13/2025 Boomerangs 2
1/8/2025 BMX Bikes 2
3/27/2025 Baseball Bats 1
1/24/2026 Full Face Helmet 3
Date Item Qty
9/3/2025 Phone 3
4/9/2026 Car 0
6/11/2025 Hangers 3
3/5/2026 Skateboard 0
6/9/2026 Bench 0
3/14/2025 Hammer 1
Date Item Qty
2/27/2026 Football 3
1/11/2026 Baseball 1
7/21/2026 Shoes 0
2/10/2026 Socks 0
3/31/2025 Rose Bush 3
12/18/2025 Tape Measure 0
Date Item Qty
1/11/2025 Pencils 0
11/18/2026 Pens 1
12/6/2026 White Board 0
5/31/2026 Chairs 1
1/31/2025 Hamock 0
8/24/2025 Bike Tires 1
Date Item Qty
5/14/2025 Soap 0
1/31/2025 Towel 1
10/14/2026 Cabnet 2
2/21/2025 Bed Sheets 3
11/13/2025 Note Pad 3
4/20/2026 Envelopes 3
Name
Elijah Walker
Isaiah Long
Leo Ward
Gus Fring
Mia Taylor
Hannah Perez
Alexander Adams
Dylan Gray
Mason Collins
Ella Lewis
Paisley Kelly
Maya Griffin
Nora Cox
Lillian Lee
#NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
Emp ID Role
LPH001 Cashier Unique Role
LPH002 Assistant Manager #NAME?
LPH003 Shift Supervisor #NAME?
LPH005 Cook #NAME?
LPH006 Maintenance Technician #NAME?
LPH007 Manager #NAME?
LPH008 Cook #NAME?
LPH009 Cashier #NAME?
LPH012 Manager #NAME?
LPH013 Cleaner
LPH014 Cook
LPH015 Shift Supervisor
LPH016 Maintenance Technician
Driver
Everyone
Employee ID Name Role Hire Date Salary
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
Staff
Employee ID Name Role Hire Date Salary
LPH026 James ThomasAssistant 6/13/2008 35000
LPH049 Jack Clark Assistant 5/31/2018 22000
LPH002 Dylan Gray Assistant Manage 7/25/2016 35000
LPH059 Mason Collins Assistant Manage 10/5/2021 35000
LPH001 Ella Lewis Cashier 7/6/2023 22000
LPH052 Paisley Kelly Cashier 4/24/2013 22000
LPH055 Scarlett King Cashier 2/13/2006 22000
LPH013 Thomas StewarCleaner 8/17/2018 21000
LPH020 David Morgan Cleaner 10/13/2021 21000
LPH041 Grace Hall Cleaner 9/13/2017 21000
LPH005 Lincoln WatsonCook 6/24/2023 24000
LPH008 Charlie Robert Cook 6/20/2006 24000
LPH046 Maya Griffin Cook 10/25/2010 24000
LPH047 Nora Cox Cook 9/27/2020 24000
LPH057 Lillian Lee Cook 2/26/2018 24000
LPH023 Ryan Barnes Driver 12/4/2020 27000
LPH058 Stella Butler Driver 4/26/2013 27000
LPH006 Hazel Bennett Maintenance Tech 6/21/2014 28000
LPH016 Lucas Turner Maintenance Tech12/11/2019 28000
Management
Employee ID Name Role Hire Date Salary
LPH007 Elijah Walker Manager 3/8/2006 45000
LPH029 Isaiah Long Manager 6/3/2021 90000
LPH043 Leo Ward Manager 9/15/2019 45000
LPH004 Gus Fring Owner 1/6/2006 100000
LPH003 Mia Taylor Shift Supervisor 2/1/2019 30000
LPH015 Hannah Perez Shift Supervisor 6/6/2018 30000
LPH032 Alexander AdaShift Supervisor 3/14/2008 30000
LPH049 Walter White Manager 3/10/2025 80000
Last 12 Months!
OLD WAY
Bags (000 LAST 12 MONTHS
Date units) Period Bags
May-24 125 Jul-24 135
Jun-24 140 Aug-24 150
Jul-24 135 Sep-24 145
Aug-24 150 Oct-24 155
Sep-24 145 Nov-24 160
Oct-24 155 Dec-24 165
Nov-24 160 Jan-25 170
Dec-24 165 Feb-25 150
Jan-25 170 Mar-25 110
Feb-25 150 Apr-25 120
Mar-25 110 May-25 180
Apr-25 120 Jun-25 210
May-25 180
Jun-25 210
LAST 12NEW-OLD WAY LAST 12 NEW WAY
MONTHS MONTHS
Period Bags Period Bags
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?

Bags
1
0.9
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0
E? E? E? E? E? E? E? E? E? E? E? E?
AM AM AM AM AM AM AM AM AM AM AM AM
N N N N N N N N N N N N
# # # # # # # # # # # #
E? E?
M AM
N
#

You might also like