In 2019, Jack and his wife Diane, started a lawn mowing business in West Melbourne After canvassing potential customers, Jack and Diane determined that their business would focus on providing both basic mowing and premium gardening services On online presence quickly provided a steady pipeline of job enquiries from potential customers Diane managed a simple website and all enquiries while Jack resigned from his employment as a building manager and focused on performing all booked mowing and gardening jobs for the business Following increased demand and the establishment of some repeat business, in 2020 Jack and Diane began employing additional gardeners to help meet business needs Jack and Diane are now seeking your assistance in evaluating the data that they have captured across their first 3 years of trading 2 Portfolio Activities Case Data Fees Charged Jack's Mowing provides 2 services charged at different rates The rates reflect the level of skill and care provided with the premium service including precision edging, hedge trimming, weeding and complementary soil boosters Base fees charged by Jack's Mowing Standard service $70 per hour Premium service $120 per hour All work carried out (both Standard and Premium) is subject to a surcharge when performed in areas outside of West Melbourne These surcharges have been set to compensate for the additional travel time and distance necessary Surcharges are currently applied to the total base fee charged for a job Northern Suburbs and Central Melbourne an additional 10 Eastern Suburbs and Southern Suburbs an additional 20 For example, a 2 hour Premium service undertaken in the Eastern Suburbs would be billed at 2 hours x $120 x 120 $288 PHASE 1 OCTOBER 2019 to APRIL 2020 Throughout Phase 1, all jobs were completed by Jack with management of business operations provided by Diane Diane managed all inbound calls and collated all job details completed by Jack and maintained the following records Exhibit A Phase 1 Enquiries Register Diane recorded the Name and Location of each customer who made an enquiry regarding the services provided by Jack's Mowing Diane then assigned a unique, sequential customer ID to each customer recorded There were 523 unique customer enquiries, not all of which proceeded with job bookings Exhibit B Phase 1 Job Completion Register From details provided by Jack, Diane recorded details for each job completed including Customer ID Date of completion Service type provided (Standard or Premium) Number of hours Payment method (Cash or Card) Amount paid by customer Business concerns Diane is concerned with understanding how well the business is performing in converting enquiries into chargeable jobs, and how well the business retains customers Jack is concerned with understanding the seasonality (if any) of the business, as well as the mix of services provided, which regions the business is generating its revenue from and identifying the drivers of business growth PHASE 2 MAY 2020 to JANUARY 2022 Due to an increased workload and a substantial advertising campaign, Jack and Diane commenced employing additional lawnmowing staff initially their son Barry, followed by additional subsequent hires With the increased volume of work, Jack (and the new employees) found that job estimates provided to customers sometimes varied from the time necessary for completion As result, Diane collated additional details in maintaining the following Exhibit C Phase 2 Enquiries Register In addition to the information recorded in the Phase 1 Enquiries Register (Exhibit A) , Diane also noted whether the customer was requesting work for a private residence (Private) or for business premises (Business) This additional detail was applied to both new and existing customers Exhibit D Job Completion Register Diane continued to maintain a job completion register with the same data as in Phase 1 Job Completion Register (Exhibit B) with additional or amended fields for Hours Billed Hours Worked Staff Name (who completed the job) Payment method (expanded to include Bank Transfers as well as Cash or Card)) Exhibit E Payroll Register Due to the rapid growth of the business, a payroll register was maintained summarising monthly time and wage records Each employee was responsible for submitting claims for hours worked Wages paid to employees were calculated from claims submitted and the applicable hourly rate All staff were to be paid at the same hourly rate ($45 in 2020, increased to $50 in 2021 with no further changes) The register included the following fields Date (last day of the month) Staff Name Hours Claimed Hourly Rate Wages Paid Business concerns Diane has concerns about the current payroll process, but Jack insists that their staff are all trustworthy Diane's specific concerns relate to discrepancies in hourly rates as well as the hours claimed relative to the hours worked As the business has grown so quickly, Jack is interested in the services, locations, and types of clients responsible for revenue and revenue growth Cust ID Cust Name Cust Location 4001 William Patterson West 4002 Alfred Perez Central 4003 William Martinez West 4004 Sandra Harris West 4005 Brenda Vasquez East 4006 Danny White West 4007 Clara Smith West 4008 Brian Hill Central 4009 Victoria Johnston Central 4010 Betty Cook West 4011 Marjorie Coleman West 4012 Florence Cruz North 4013 George Barnes West 4014 Shannon Cunningham Central 4015 Pauline Bishop North 4016 Dennis Torres South Cust ID Cust Name Cust Location 4017 William Patterson West 4018 Alfred Perez Central 4019 William Martinez West 4020 Sandra Harris West 4021 Brenda Vasquez East 4022 Danny White West 4023 Clara Smith West 4024 Brian Hill Central 4025 Victoria Johnston Central 4026 Betty Cook West 4027 Marjorie Coleman West 4028 Florence Cruz North 4029 George Barnes West 4030 Shannon Cunningham Central 4031 Pauline Bishop North 4032 Dennis Torres South Cust ID Cust Name Cust Location 4033 William Patterson West 4034 Alfred Perez Central 4035 William Martinez West 4036 Sandra Harris West 4037 Brenda Vasquez East 4038 Danny White West 4039 Clara Smith West 4040 Brian Hill Central 4041 Victoria Johnston Central 4042 Betty Cook West 4043 Marjorie Coleman West 4044 Florence Cruz North 4045 George Barnes West 4046 Shannon Cunningham Central 4047 Pauline Bishop North 4048 Dennis Torres South Cust ID Cust Name Cust Location 4049 William Patterson West 4050 Alfred Perez Central 4051 William Martinez West 4052 Sandra Harris West 4053 Brenda Vasquez East 4054 Danny White West 4055 Clara Smith West 4056 Brian Hill Central 4057 Victoria Johnston Central 4058 Betty Cook West 4059 Marjorie Coleman West 4060 Florence Cruz North 4061 George Barnes West 4062 Shannon Cunningham Central 4063 Pauline Bishop North 4064 Dennis Torres South Cust ID Cust Name Cust Location 4065 William Patterson West 4066 Alfred Perez Central 4067 William Martinez West 4068 Sandra Harris West 4069 Brenda Vasquez East 4070 Danny White West 4071 Clara Smith West 4072 Brian Hill Central 4073 Victoria Johnston Central 4074 Betty Cook West 4075 Marjorie Coleman West 4076 Florence Cruz North 4077 George Barnes West 4078 Shannon Cunningham Central 4079 Pauline Bishop North 4080 Dennis Torres South Cust ID Cust Name Cust Location 4081 William Patterson West 4082 Alfred Perez Central 4083 William Martinez West 4084 Sandra Harris West 4085 Brenda Vasquez East 4086 Danny White West 4087 Clara Smith West 4088 Brian Hill Central 4089 Victoria Johnston Central 4090 Betty Cook West 4091 Marjorie Coleman West 4092 Florence Cruz North 4093 George Barnes West 4094 Shannon Cunningham Central 4095 Pauline Bishop North 4096 Dennis Torres South Cust ID Cust Name Cust Location 4097 William Patterson West 4098 Alfred Perez Central 4099 William Martinez West 4100 Sandra Harris West 4101 Brenda Vasquez East 4102 Danny White West 4103 Clara Smith West 4104 Brian Hill Central 4105 Victoria Johnston Central 4106 Betty Cook West 4107 Marjorie Coleman West 4108 Florence Cruz North 4109 George Barnes West 4110 Shannon Cunningham Central 4111 Pauline Bishop North 4112 Dennis Torres South Cust ID Cust Name Cust Location 4113 William Patterson West 4114 Alfred Perez Central 4115 William Martinez West 4116 Sandra Harris West 4117 Brenda Vasquez East 4118 Danny White West 4119 Clara Smith West 4120 Brian Hill Central 4121 Victoria Johnston Central 4122 Betty Cook West 4123 Marjorie Coleman West 4124 Florence Cruz North 4125 George Barnes West 4126 Shannon Cunningham Central 4127 Pauline Bishop North 4128 Dennis Torres South Cust ID Cust Name Cust Location 4129 William Patterson West 4130 Alfred Perez Central 4131 William Martinez West 4132 Sandra Harris West 4133 Brenda Vasquez East 4134 Danny White West 4135 Clara Smith West 4136 Brian Hill Central 4137 Victoria Johnston Central 4138 Betty Cook West 4139 Marjorie Coleman West 4140 Florence Cruz North 4141 George Barnes West 4142 Shannon Cunningham Central 4143 Pauline Bishop North 4144 Dennis Torres South Cust ID Cust Name Cust Location 4145 William Patterson West 4146 Alfred Perez Central 4147 William Martinez West 4148 Sandra Harris West 4149 Brenda Vasquez East 4150 Danny White West 4151 Clara Smith West 4152 Brian Hill Central 4153 Victoria Johnston Central 4154 Betty Cook West 4155 Marjorie Coleman West 4156 Florence Cruz North 4157 George Barnes West 4158 Shannon Cunningham Central 4159 Pauline Bishop North 4160 Dennis Torres South Cust ID Cust Name Cust Location 4161 William Patterson West 4162 Alfred Perez Central 4163 William Martinez West 4164 Sandra Harris West 4165 Brenda Vasquez East 4166 Danny White West 4167 Clara Smith West 4168 Brian Hill Central 4169 Victoria Johnston Central 4170 Betty Cook West 4171 Marjorie Coleman West 4172 Florence Cruz North 4173 George Barnes West 4174 Shannon Cunningham Central 4175 Pauline Bishop North 4176 Dennis Torres South Cust ID Cust Name Cust Location 4177 William Patterson West 4178 Alfred Perez Central 4179 William Martinez West 4180 Sandra Harris West 4181 Brenda Vasquez East 4182 Danny White West 4183 Clara Smith West 4184 Brian Hill Central 4185 Victoria Johnston Central 4186 Betty Cook West 4187 Marjorie Coleman West 4188 Florence Cruz North 4189 George Barnes West 4190 Shannon Cunningham Central 4191 Pauline Bishop North 4192 Dennis Torres South Cust ID Cust Name Cust Location 4193 William Patterson West 4194 Alfred Perez Central 4195 William Martinez West 4196 Sandra Harris West Cust ID Cust Name Cust Location 4017 William Patterson West 4018 Alfred Perez Central 4019 William Martinez West 4020 Sandra Harris West 4021 Brenda Vasquez East 4022 Danny White West 4023 Clara Smith West 4024 Brian Hill Central 4025 Victoria Johnston Central 4026 Betty Cook West 4027 Marjorie Coleman West 4028 Florence Cruz North 4029 George Barnes West 4030 Shannon Cunningham Central 4031 Pauline Bishop North 4032 Dennis Torres South Cust ID Cust Name Cust Location 4033 William Patterson West 4034 Alfred Perez Central 4035 William Martinez West 4036 Sandra Harris West 4037 Brenda Vasquez East 4038 Danny White West 4039 Clara Smith West 4040 Brian Hill Central 4041 Victoria Johnston Central 4042 Betty Cook West 4043 Marjorie Coleman West 4044 Florence Cruz North 4045 George Barnes West 4046 Shannon Cunningham Central 4047 Pauline Bishop North 4048 Dennis Torres South Cust ID Cust Name Cust Location 4049 William Patterson West 4050 Alfred Perez Central 4051 William Martinez West 4052 Sandra Harris West 4053 Brenda Vasquez East 4054 Danny White West 4055 Clara Smith West 4056 Brian Hill Central 4057 Victoria Johnston Central 4058 Betty Cook West 4059 Marjorie Coleman West 4060 Florence Cruz North 4061 George Barnes West 4062 Shannon Cunningham Central 4063 Pauline Bishop North 4064 Dennis Torres South Cust ID Cust Name Cust Location 4065 William Patterson West 4066 Alfred Perez Central 4067 William Martinez West 4068 Sandra Harris West 4069 Brenda Vasquez East 4070 Danny White West 4071 Clara Smith West 4072 Brian Hill Central 4073 Victoria Johnston Central 4074 Betty Cook West 4075 Marjorie Coleman West 4076 Florence Cruz North 4077 George Barnes West 4078 Shannon Cunningham Central 4079 Pauline Bishop North 4080 Dennis Torres South Cust ID Cust Name Cust Location 4081 William Patterson West 4082 Alfred Perez Central 4083 William Martinez West 4084 Sandra Harris West 4085 Brenda Vasquez East 4086 Danny White West 4087 Clara Smith West 4088 Brian Hill Central 4089 Victoria Johnston Central 4090 Betty Cook West 4091 Marjorie Coleman West 4092 Florence Cruz North 4093 George Barnes West 4094 Shannon Cunningham Central 4095 Pauline Bishop North 4096 Dennis Torres South Cust ID Cust Name Cust Location 4097 William Patterson West 4098 Alfred Perez Central 4099 William Martinez West 4100 Sandra Harris West 4101 Brenda Vasquez East 4102 Danny White West 4103 Clara Smith West 4104 Brian Hill Central 4105 Victoria Johnston Central 4106 Betty Cook West 4107 Marjorie Coleman West 4108 Florence Cruz North 4109 George Barnes West 4110 Shannon Cunningham Central 4111 Pauline Bishop North 4112 Dennis Torres South Cust ID Cust Name Cust Location 4113 William Patterson West 4114 Alfred Perez Central 4115 William Martinez West 4116 Sandra Harris West 4117 Brenda Vasquez East 4118 Danny White West 4119 Clara Smith West 4120 Brian Hill Central 4121 Victoria Johnston Central 4122 Betty Cook West 4123 Marjorie Coleman West 4124 Florence Cruz North 4125 George Barnes West 4126 Shannon Cunningham Central 4127 Pauline Bishop North 4128 Dennis Torres South Cust ID Cust Name Cust Location 4129 William Patterson West 4130 Alfred Perez Central 4131 William Martinez West 4132 Sandra Harris West 4133 Brenda Vasquez East 4134 Danny White West 4135 Clara Smith West 4136 Brian Hill Central 4137 Victoria Johnston Central 4138 Betty Cook West 4139 Marjorie Coleman West 4140 Florence Cruz North 4141 George Barnes West 4142 Shannon Cunningham Central 4143 Pauline Bishop North 4144 Dennis Torres South Cust ID Cust Name Cust Location 4145 William Patterson West 4146 Alfred Perez Central 4147 William Martinez West 4148 Sandra Harris West 4149 Brenda Vasquez East 4150 Danny White West 4151 Clara Smith West 4152 Brian Hill Central 4153 Victoria Johnston Central 4154 Betty Cook West 4155 Marjorie Coleman West 4156 Florence Cruz North 4157 George Barnes West 4158 Shannon Cunningham Central 4159 Pauline Bishop North 4160 Dennis Torres South Cust ID Cust Name Cust Location 4161 William Patterson West 4162 Alfred Perez Central 4163 William Martinez West 4164 Sandra Harris West 4165 Brenda Vasquez East 4166 Danny White West 4167 Clara Smith West 4168 Brian Hill Central 4169 Victoria Johnston Central 4170 Betty Cook West 4171 Marjorie Coleman West 4172 Florence Cruz North 4173 George Barnes West 4174 Shannon Cunningham Central 4175 Pauline Bishop North 4176 Dennis Torres South Cust ID Cust Name Cust Location 4177 William Patterson West 4178 Alfred Perez Central 4179 William Martinez West 4180 Sandra Harris West 4181 Brenda Vasquez East 4182 Danny White West 4183 Clara Smith West 4184 Brian Hill Central 4185 Victoria Johnston Central 4186 Betty Cook West 4187 Marjorie Coleman West 4188 Florence Cruz North 4189 George Barnes West 4190 Shannon Cunningham Central 4191 Pauline Bishop North 4192 Dennis Torres South Cust ID Cust Name Cust Location 4193 William Patterson West 4194 Alfred Perez Central 4195 William Martinez West 4196 Sandra Harris West 4197 Brenda Vasquez East 4198 Danny White West 4199 Clara Smith West 4200 Brian Hill Central 4201 Victoria Johnston Central 4202 Betty Cook West 4203 Marjorie Coleman West 4204 Florence Cruz North 4205 George Barnes West 4206 Shannon Cunningham Central 4207 Pauline Bishop North 4208 Dennis Torres South Cust ID Cust Name Cust Location 4197 William Patterson West 4198 Alfred Perez Central 4199 William Martinez West 4200 Sandra Harris West Cust ID Cust Name Cust Location 4033 William Patterson West 4034 Alfred Perez Central 4035 William Martinez West 4036 Sandra Harris West 4037 Brenda Vasquez East 4038 Danny White West 4039 Clara Smith West 4040 Brian Hill Central 4041 Victoria Johnston Central 4042 Betty Cook West 4043 Marjorie Coleman West 4044 Florence Cruz North 4045 George Barnes West 4046 Shannon Cunningham Central 4047 Pauline Bishop North 4048 Dennis Torres South Cust ID Cust Name Cust Location 4049 William Patterson West 4050 Alfred Perez Central 4051 William Martinez West 4052 Sandra Harris West 4053 Brenda Vasquez East 4054 Danny White West 4055 Clara Smith West 4056 Brian Hill Central 4057 Victoria Johnston Central 4058 Betty Cook West 4059 Marjorie Coleman West 4060 Florence Cruz North 4061 George Barnes West 4062 Shannon Cunningham Central 4063 Pauline Bishop North 4064 Dennis Torres South Cust ID Cust Name Cust Location 4065 William Patterson West 4066 Alfred Perez Central 4067 William Martinez West 4068 Sandra Harris West 4069 Brenda Vasquez East 4070 Danny White West 4071 Clara Smith West 4072 Brian Hill Central 4073 Victoria Johnston Central 4074 Betty Cook West 4075 Marjorie Coleman West 4076 Florence Cruz North 4077 George Barnes West 4078 Shannon Cunningham Central 4079 Pauline Bishop North 4080 Dennis Torres South Cust ID Cust Name Cust Location 4081 William Patterson West 4082 Alfred Perez Central 4083 William Martinez West 4084 Sandra Harris West 4085 Brenda Vasquez East 4086 Danny White West 4087 Clara Smith West 4088 Brian Hill Central 4089 Victoria Johnston Central 4090 Betty Cook West 4091 Marjorie Coleman West 4092 Florence Cruz North 4093 George Barnes West 4094 Shannon Cunningham Central 4095 Pauline Bishop North 4096 Dennis Torres South Cust ID Cust Name Cust Location 4097 William Patterson West 4098 Alfred Perez Central 4099 William Martinez West 4100 Sandra Harris West 4101 Brenda Vasquez East 4102 Danny White West 4103 Clara Smith West 4104 Brian Hill Central 4105 Victoria Johnston Central 4106 Betty Cook West 4107 Marjorie Coleman West 4108 Florence Cruz North 4109 George Barnes West 4110 Shannon Cunningham Central 4111 Pauline Bishop North 4112 Dennis Torres South Cust ID Cust Name Cust Location 4113 William Patterson West 4114 Alfred Perez Central 4115 William Martinez West 4116 Sandra Harris West 4117 Brenda Vasquez East 4118 Danny White West 4119 Clara Smith West 4120 Brian Hill Central 4121 Victoria Johnston Central 4122 Betty Cook West 4123 Marjorie Coleman West 4124 Florence Cruz North 4125 George Barnes West 4126 Shannon Cunningham Central 4127 Pauline Bishop North 4128 Dennis Torres South Cust ID Cust Name Cust Location 4129 William Patterson West 4130 Alfred Pe Central 4131 William Martinez West Both Jack and Diane are interested in identifying growth opportunities to be pursued over the next 2 to 5

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Nov 07, 2024

In 2019, Jack and his wife Diane, started a lawn mowing business in West Melbourne. After canvassing potential customers, Jack and Diane determined that their

In 2019, Jack and his wife Diane, started a lawn mowing business in West Melbourne. After canvassing potential customers, Jack and Diane determined that their business would focus on providing both basic mowing and premium gardening services. On online presence quickly provided a steady pipeline of job enquiries from potential customers. Diane managed a simple website and all enquiries while Jack resigned from his employment as a building manager and focused on performing all booked mowing and gardening jobs for the business. Following increased demand and the establishment of some repeat business, in 2020 Jack and Diane began employing additional gardeners to help meet business needs.

Jack and Diane are now seeking your assistance in evaluating the data that they have captured across their first 3 years of trading.

2 Portfolio Activities - Case Data

Fees Charged

Jack's Mowing provides 2 services charged at different rates. The rates reflect the level of skill and care provided with the premium service including precision edging, hedge trimming, weeding and complementary soil boosters. Base fees charged by Jack's Mowing:

Standard service - $70 per hour

Premium service - $120 per hour

All work carried out (both Standard and Premium) is subject to a surcharge when performed in areas outside of West Melbourne. These surcharges have been set to compensate for the additional travel time and distance necessary. Surcharges are currently applied to the total base fee charged for a job.

Northern Suburbs and Central Melbourne - an additional 10%

Eastern Suburbs and Southern Suburbs - an additional 20%

For example, a 2-hour Premium service undertaken in the Eastern Suburbs would be billed at: 2 hours x $120 x 120% = $288

PHASE 1 - OCTOBER 2019 to APRIL 2020

Throughout Phase 1, all jobs were completed by Jack with management of business operations provided by Diane. Diane managed all inbound calls and collated all job details completed by Jack and maintained the following records: Exhibit A - Phase 1 Enquiries Register

Diane recorded the Name and Location of each customer who made an enquiry regarding the services provided by Jack's Mowing. Diane then assigned a unique, sequential customer ID to each customer recorded. There were 523 unique customer enquiries, not all of which proceeded with job bookings.

Exhibit B - Phase 1 Job Completion Register

From details provided by Jack, Diane recorded details for each job completed including:

Customer ID

Date of completion

Service type provided (Standard or Premium)

Number of hours

Payment method (Cash or Card)

Amount paid by customer

Business concerns

Diane is concerned with understanding how well the business is performing in converting enquiries into chargeable jobs, and how well the business retains customers.

Jack is concerned with understanding the seasonality (if any) of the business, as well as the mix of services provided, which regions the business is generating its revenue from and identifying the drivers of business growth.

PHASE 2 - MAY 2020 to JANUARY 2022

Due to an increased workload and a substantial advertising campaign, Jack and Diane commenced employing additional lawnmowing staff - initially their son Barry, followed by additional subsequent hires. With the increased volume of work, Jack (and the new employees) found that job estimates provided to customers sometimes varied from the time necessary for completion. As result, Diane collated additional details in maintaining the following:

Exhibit C - Phase 2 Enquiries Register In addition to the information recorded in the Phase 1 Enquiries Register (Exhibit A), Diane also noted whether the customer was requesting work for a private residence (Private) or for business premises (Business). This additional detail was applied to both new and existing customers. Exhibit D - Job Completion Register Diane continued to maintain a job completion register with the same data as in Phase 1 Job Completion Register (Exhibit B) with additional or amended fields for:

Hours Billed

Hours Worked

Staff Name (who completed the job)

Payment method (expanded to include Bank Transfers as well as Cash or Card))

Exhibit E - Payroll Register

Due to the rapid growth of the business, a payroll register was maintained summarising monthly time and wage records. Each employee was responsible for submitting claims for hours worked. Wages paid to employees were calculated from claims submitted and the applicable hourly rate. All staff were to be paid at the same hourly rate ($45 in 2020, increased to $50 in 2021 with no further changes). The register included the following fields:

Date (last day of the month)

Staff Name

Hours Claimed

Hourly Rate

Wages Paid

Business concerns

Diane has concerns about the current payroll process, but Jack insists that their staff are all trustworthy. Diane's specific concerns relate to discrepancies in hourly rates as well as the hours claimed relative to the hours worked.

As the business has grown so quickly, Jack is interested in the services, locations, and types of clients responsible for revenue and revenue growth.

Cust_ID	Cust_Name	Cust_Location
4001	William Patterson	West
4002	Alfred Perez	Central
4003	William Martinez	West
4004	Sandra Harris	West
4005	Brenda Vasquez	East
4006	Danny White	West
4007	Clara Smith	West
4008	Brian Hill	Central
4009	Victoria Johnston	Central
4010	Betty Cook	West
4011	Marjorie Coleman	West
4012	Florence Cruz	North
4013	George Barnes	West
4014	Shannon Cunningham	Central
4015	Pauline Bishop	North
4016	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4017	William Patterson	West
4018	Alfred Perez	Central
4019	William Martinez	West
4020	Sandra Harris	West
4021	Brenda Vasquez	East
4022	Danny White	West
4023	Clara Smith	West
4024	Brian Hill	Central
4025	Victoria Johnston	Central
4026	Betty Cook	West
4027	Marjorie Coleman	West
4028	Florence Cruz	North
4029	George Barnes	West
4030	Shannon Cunningham	Central
4031	Pauline Bishop	North
4032	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4033	William Patterson	West
4034	Alfred Perez	Central
4035	William Martinez	West
4036	Sandra Harris	West
4037	Brenda Vasquez	East
4038	Danny White	West
4039	Clara Smith	West
4040	Brian Hill	Central
4041	Victoria Johnston	Central
4042	Betty Cook	West
4043	Marjorie Coleman	West
4044	Florence Cruz	North
4045	George Barnes	West
4046	Shannon Cunningham	Central
4047	Pauline Bishop	North
4048	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4049	William Patterson	West
4050	Alfred Perez	Central
4051	William Martinez	West
4052	Sandra Harris	West
4053	Brenda Vasquez	East
4054	Danny White	West
4055	Clara Smith	West
4056	Brian Hill	Central
4057	Victoria Johnston	Central
4058	Betty Cook	West
4059	Marjorie Coleman	West
4060	Florence Cruz	North
4061	George Barnes	West
4062	Shannon Cunningham	Central
4063	Pauline Bishop	North
4064	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4065	William Patterson	West
4066	Alfred Perez	Central
4067	William Martinez	West
4068	Sandra Harris	West
4069	Brenda Vasquez	East
4070	Danny White	West
4071	Clara Smith	West
4072	Brian Hill	Central
4073	Victoria Johnston	Central
4074	Betty Cook	West
4075	Marjorie Coleman	West
4076	Florence Cruz	North
4077	George Barnes	West
4078	Shannon Cunningham	Central
4079	Pauline Bishop	North
4080	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4081	William Patterson	West
4082	Alfred Perez	Central
4083	William Martinez	West
4084	Sandra Harris	West
4085	Brenda Vasquez	East
4086	Danny White	West
4087	Clara Smith	West
4088	Brian Hill	Central
4089	Victoria Johnston	Central
4090	Betty Cook	West
4091	Marjorie Coleman	West
4092	Florence Cruz	North
4093	George Barnes	West
4094	Shannon Cunningham	Central
4095	Pauline Bishop	North
4096	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4097	William Patterson	West
4098	Alfred Perez	Central
4099	William Martinez	West
4100	Sandra Harris	West
4101	Brenda Vasquez	East
4102	Danny White	West
4103	Clara Smith	West
4104	Brian Hill	Central
4105	Victoria Johnston	Central
4106	Betty Cook	West
4107	Marjorie Coleman	West
4108	Florence Cruz	North
4109	George Barnes	West
4110	Shannon Cunningham	Central
4111	Pauline Bishop	North
4112	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4113	William Patterson	West
4114	Alfred Perez	Central
4115	William Martinez	West
4116	Sandra Harris	West
4117	Brenda Vasquez	East
4118	Danny White	West
4119	Clara Smith	West
4120	Brian Hill	Central
4121	Victoria Johnston	Central
4122	Betty Cook	West
4123	Marjorie Coleman	West
4124	Florence Cruz	North
4125	George Barnes	West
4126	Shannon Cunningham	Central
4127	Pauline Bishop	North
4128	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4129	William Patterson	West
4130	Alfred Perez	Central
4131	William Martinez	West
4132	Sandra Harris	West
4133	Brenda Vasquez	East
4134	Danny White	West
4135	Clara Smith	West
4136	Brian Hill	Central
4137	Victoria Johnston	Central
4138	Betty Cook	West
4139	Marjorie Coleman	West
4140	Florence Cruz	North
4141	George Barnes	West
4142	Shannon Cunningham	Central
4143	Pauline Bishop	North
4144	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4145	William Patterson	West
4146	Alfred Perez	Central
4147	William Martinez	West
4148	Sandra Harris	West
4149	Brenda Vasquez	East
4150	Danny White	West
4151	Clara Smith	West
4152	Brian Hill	Central
4153	Victoria Johnston	Central
4154	Betty Cook	West
4155	Marjorie Coleman	West
4156	Florence Cruz	North
4157	George Barnes	West
4158	Shannon Cunningham	Central
4159	Pauline Bishop	North
4160	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4161	William Patterson	West
4162	Alfred Perez	Central
4163	William Martinez	West
4164	Sandra Harris	West
4165	Brenda Vasquez	East
4166	Danny White	West
4167	Clara Smith	West
4168	Brian Hill	Central
4169	Victoria Johnston	Central
4170	Betty Cook	West
4171	Marjorie Coleman	West
4172	Florence Cruz	North
4173	George Barnes	West
4174	Shannon Cunningham	Central
4175	Pauline Bishop	North
4176	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4177	William Patterson	West
4178	Alfred Perez	Central
4179	William Martinez	West
4180	Sandra Harris	West
4181	Brenda Vasquez	East
4182	Danny White	West
4183	Clara Smith	West
4184	Brian Hill	Central
4185	Victoria Johnston	Central
4186	Betty Cook	West
4187	Marjorie Coleman	West
4188	Florence Cruz	North
4189	George Barnes	West
4190	Shannon Cunningham	Central
4191	Pauline Bishop	North
4192	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4193	William Patterson	West
4194	Alfred Perez	Central
4195	William Martinez	West
4196	Sandra Harris	West
Cust_ID	Cust_Name	Cust_Location
4017	William Patterson	West
4018	Alfred Perez	Central
4019	William Martinez	West
4020	Sandra Harris	West
4021	Brenda Vasquez	East
4022	Danny White	West
4023	Clara Smith	West
4024	Brian Hill	Central
4025	Victoria Johnston	Central
4026	Betty Cook	West
4027	Marjorie Coleman	West
4028	Florence Cruz	North
4029	George Barnes	West
4030	Shannon Cunningham	Central
4031	Pauline Bishop	North
4032	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4033	William Patterson	West
4034	Alfred Perez	Central
4035	William Martinez	West
4036	Sandra Harris	West
4037	Brenda Vasquez	East
4038	Danny White	West
4039	Clara Smith	West
4040	Brian Hill	Central
4041	Victoria Johnston	Central
4042	Betty Cook	West
4043	Marjorie Coleman	West
4044	Florence Cruz	North
4045	George Barnes	West
4046	Shannon Cunningham	Central
4047	Pauline Bishop	North
4048	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4049	William Patterson	West
4050	Alfred Perez	Central
4051	William Martinez	West
4052	Sandra Harris	West
4053	Brenda Vasquez	East
4054	Danny White	West
4055	Clara Smith	West
4056	Brian Hill	Central
4057	Victoria Johnston	Central
4058	Betty Cook	West
4059	Marjorie Coleman	West
4060	Florence Cruz	North
4061	George Barnes	West
4062	Shannon Cunningham	Central
4063	Pauline Bishop	North
4064	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4065	William Patterson	West
4066	Alfred Perez	Central
4067	William Martinez	West
4068	Sandra Harris	West
4069	Brenda Vasquez	East
4070	Danny White	West
4071	Clara Smith	West
4072	Brian Hill	Central
4073	Victoria Johnston	Central
4074	Betty Cook	West
4075	Marjorie Coleman	West
4076	Florence Cruz	North
4077	George Barnes	West
4078	Shannon Cunningham	Central
4079	Pauline Bishop	North
4080	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4081	William Patterson	West
4082	Alfred Perez	Central
4083	William Martinez	West
4084	Sandra Harris	West
4085	Brenda Vasquez	East
4086	Danny White	West
4087	Clara Smith	West
4088	Brian Hill	Central
4089	Victoria Johnston	Central
4090	Betty Cook	West
4091	Marjorie Coleman	West
4092	Florence Cruz	North
4093	George Barnes	West
4094	Shannon Cunningham	Central
4095	Pauline Bishop	North
4096	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4097	William Patterson	West
4098	Alfred Perez	Central
4099	William Martinez	West
4100	Sandra Harris	West
4101	Brenda Vasquez	East
4102	Danny White	West
4103	Clara Smith	West
4104	Brian Hill	Central
4105	Victoria Johnston	Central
4106	Betty Cook	West
4107	Marjorie Coleman	West
4108	Florence Cruz	North
4109	George Barnes	West
4110	Shannon Cunningham	Central
4111	Pauline Bishop	North
4112	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4113	William Patterson	West
4114	Alfred Perez	Central
4115	William Martinez	West
4116	Sandra Harris	West
4117	Brenda Vasquez	East
4118	Danny White	West
4119	Clara Smith	West
4120	Brian Hill	Central
4121	Victoria Johnston	Central
4122	Betty Cook	West
4123	Marjorie Coleman	West
4124	Florence Cruz	North
4125	George Barnes	West
4126	Shannon Cunningham	Central
4127	Pauline Bishop	North
4128	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4129	William Patterson	West
4130	Alfred Perez	Central
4131	William Martinez	West
4132	Sandra Harris	West
4133	Brenda Vasquez	East
4134	Danny White	West
4135	Clara Smith	West
4136	Brian Hill	Central
4137	Victoria Johnston	Central
4138	Betty Cook	West
4139	Marjorie Coleman	West
4140	Florence Cruz	North
4141	George Barnes	West
4142	Shannon Cunningham	Central
4143	Pauline Bishop	North
4144	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4145	William Patterson	West
4146	Alfred Perez	Central
4147	William Martinez	West
4148	Sandra Harris	West
4149	Brenda Vasquez	East
4150	Danny White	West
4151	Clara Smith	West
4152	Brian Hill	Central
4153	Victoria Johnston	Central
4154	Betty Cook	West
4155	Marjorie Coleman	West
4156	Florence Cruz	North
4157	George Barnes	West
4158	Shannon Cunningham	Central
4159	Pauline Bishop	North
4160	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4161	William Patterson	West
4162	Alfred Perez	Central
4163	William Martinez	West
4164	Sandra Harris	West
4165	Brenda Vasquez	East
4166	Danny White	West
4167	Clara Smith	West
4168	Brian Hill	Central
4169	Victoria Johnston	Central
4170	Betty Cook	West
4171	Marjorie Coleman	West
4172	Florence Cruz	North
4173	George Barnes	West
4174	Shannon Cunningham	Central
4175	Pauline Bishop	North
4176	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4177	William Patterson	West
4178	Alfred Perez	Central
4179	William Martinez	West
4180	Sandra Harris	West
4181	Brenda Vasquez	East
4182	Danny White	West
4183	Clara Smith	West
4184	Brian Hill	Central
4185	Victoria Johnston	Central
4186	Betty Cook	West
4187	Marjorie Coleman	West
4188	Florence Cruz	North
4189	George Barnes	West
4190	Shannon Cunningham	Central
4191	Pauline Bishop	North
4192	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4193	William Patterson	West
4194	Alfred Perez	Central
4195	William Martinez	West
4196	Sandra Harris	West
4197	Brenda Vasquez	East
4198	Danny White	West
4199	Clara Smith	West
4200	Brian Hill	Central
4201	Victoria Johnston	Central
4202	Betty Cook	West
4203	Marjorie Coleman	West
4204	Florence Cruz	North
4205	George Barnes	West
4206	Shannon Cunningham	Central
4207	Pauline Bishop	North
4208	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4197	William Patterson	West
4198	Alfred Perez	Central
4199	William Martinez	West
4200	Sandra Harris	West
Cust_ID	Cust_Name	Cust_Location
4033	William Patterson	West
4034	Alfred Perez	Central
4035	William Martinez	West
4036	Sandra Harris	West
4037	Brenda Vasquez	East
4038	Danny White	West
4039	Clara Smith	West
4040	Brian Hill	Central
4041	Victoria Johnston	Central
4042	Betty Cook	West
4043	Marjorie Coleman	West
4044	Florence Cruz	North
4045	George Barnes	West
4046	Shannon Cunningham	Central
4047	Pauline Bishop	North
4048	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4049	William Patterson	West
4050	Alfred Perez	Central
4051	William Martinez	West
4052	Sandra Harris	West
4053	Brenda Vasquez	East
4054	Danny White	West
4055	Clara Smith	West
4056	Brian Hill	Central
4057	Victoria Johnston	Central
4058	Betty Cook	West
4059	Marjorie Coleman	West
4060	Florence Cruz	North
4061	George Barnes	West
4062	Shannon Cunningham	Central
4063	Pauline Bishop	North
4064	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4065	William Patterson	West
4066	Alfred Perez	Central
4067	William Martinez	West
4068	Sandra Harris	West
4069	Brenda Vasquez	East
4070	Danny White	West
4071	Clara Smith	West
4072	Brian Hill	Central
4073	Victoria Johnston	Central
4074	Betty Cook	West
4075	Marjorie Coleman	West
4076	Florence Cruz	North
4077	George Barnes	West
4078	Shannon Cunningham	Central
4079	Pauline Bishop	North
4080	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4081	William Patterson	West
4082	Alfred Perez	Central
4083	William Martinez	West
4084	Sandra Harris	West
4085	Brenda Vasquez	East
4086	Danny White	West
4087	Clara Smith	West
4088	Brian Hill	Central
4089	Victoria Johnston	Central
4090	Betty Cook	West
4091	Marjorie Coleman	West
4092	Florence Cruz	North
4093	George Barnes	West
4094	Shannon Cunningham	Central
4095	Pauline Bishop	North
4096	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4097	William Patterson	West
4098	Alfred Perez	Central
4099	William Martinez	West
4100	Sandra Harris	West
4101	Brenda Vasquez	East
4102	Danny White	West
4103	Clara Smith	West
4104	Brian Hill	Central
4105	Victoria Johnston	Central
4106	Betty Cook	West
4107	Marjorie Coleman	West
4108	Florence Cruz	North
4109	George Barnes	West
4110	Shannon Cunningham	Central
4111	Pauline Bishop	North
4112	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4113	William Patterson	West
4114	Alfred Perez	Central
4115	William Martinez	West
4116	Sandra Harris	West
4117	Brenda Vasquez	East
4118	Danny White	West
4119	Clara Smith	West
4120	Brian Hill	Central
4121	Victoria Johnston	Central
4122	Betty Cook	West
4123	Marjorie Coleman	West
4124	Florence Cruz	North
4125	George Barnes	West
4126	Shannon Cunningham	Central
4127	Pauline Bishop	North
4128	Dennis Torres	South
Cust_ID	Cust_Name	Cust_Location
4129	William Patterson	West
4130	Alfred Pe	Central
4131	William Martinez	West