Write In Java The purpose of this project is to give students exposure to object
ID: 3706059 • Letter: W
Question
Write In Java
The purpose of this project is to give students exposure to object-oriented design and programming using classes and polymorphism in an application that involves arrays of objects and sorting arrays containing objects.
You will write several classes for this lab exam. Submit all classes coded along with the outputted report.
Assignment:
Office Supplies Inc., an office supply store, services many customers. As customers’ orders for office supplies are shipped, information is entered into a file. Office Supplies bills their customers once each month. At the end of each month, the Chief Executive Officer requests a report of all customers sorted by their customer id (from lowest to highest). The report includes their bill balance and tax liability.
Write a program to produce the outstanding balance report sorted by customer ID number for each customer from the data in the text file. You must use the text file provided for the report in Canvas.
Below is a description of the information on the text file:
The first line on the file contains the number of customers on the file (numeric)
The fields below repeat for each customer:
Customer name (String)
Customer ID (numeric integer)
Bill balance (numeric)
EmailAddress (String)
Tax liability (numeric or String)
The customers served by the office supply store are of two types: tax-exempt or non-tax-exempt. For a tax-exempt customer, the tax liability field on the file is the reason for the tax exemptions: education, non-profit, government, other (String). For a non-tax exempt customer, the tax liability field is the percent of tax that the customer will pay (numeric) based on the state where the customer’s business resides.
Program requirements:
From the information provided, write a solution that includes the following:
A suitable inheritance hierarchy that represents the customers serviced by the office supply company. It is up to you how to design the inheritance hierarchy. I suggest a Customer class and appropriate subclasses..
For all classes include the following:
Instance variables
Constructors
Accessor and mutator methods
Suitable toString( ) methods
Any other appropriate methods
Write a class LabExam which utilizes the following:
An Array of Customer objects
A method that reads the input file provided and stores the objects in the array of Customers.
A method that sorts the array of Customers in ascending order by the customer ID. (you may use Arrays.sort(custList))
A method that formats and prints the output report. The report should include the following requirements:
Report header at the start of each page showing the name of the company, report and page number.
Report headers for each column of information.
One Customer per line.
At most 45 Customers per page.
All money amounts and percentages should be displayed with 2 decimal places and commas after each thousand.
A sample report is shown at the end of the assignment. The report produced does not have to exactly match the sample output provided, but must contain all required components listed above.
Any other helper methods used to meet the requirements of the assignment.
The main method will call all the other methods that will:
Read the text file and store the objects in the array
Sort the objects
Format and print the report
The program must only be tested using the file posted on Canvas. You should not use another input text file.
Sample Report Output: Note that lines have been omitted to show page headers. Your output does not have to match exactly, but all information should be properly labeled, report headers and column headers displayed.
Office Supplies Inc. Customer Report Page 1 =======================
Customer ID Email Address Balance Tax Type Tax Amount
======== == ============= ====== ====== ==========
Threads2 001 purchasing@threads2.com 29,000.00 tax liable 1,450.00
DAV2 002 purchasing@dav2.org 4,860.20 non-profit
DAV3 003 purchasing@dav3.org 4,860.20 non-profit
StopandShop3 004 purchasing@stopandshop2.com 8,100.00 tax liable 486.00
Office Supplies Inc. Customer Report Page 2 =======================
Customer ID Email Address Balance Tax Type Tax Amount
======== == ============= ====== ====== ==========
Threads 349 purchasing@threads.com 29,000.00 tax liable 1,450.00
DAV 358 purchasing@dav.org 4,860.20 non-profit
DAV2 359 purchasing@dav2.org 4,860.20 non-profit
StopandShop 377 purchasing@stopandshop.com 8,100.00 tax liable 486.00
Please Use the following text file for input data
100
Amazon 900 20000.00 purchasing@amazon.com 0.08
Nordstrom 210 50000.00 purchasing@nordstrom.com 0.07
Rutgers 010 32000.00 purchasing@rutgers.edu education
Alamo 520 23000.00 purchasing@alamo.com 0.05
Kean 001 158000.50 purchasing@kean.edu education
Allied 100 85300.00 purchasing@allied.com 0.06
JoesInc 950 999999.00 purchasing@joesinc.com 0.03
BostonU 697 340020.23 purchasing@tufts.edu education
TruckersInc 310 55000.00 purchasing@truckersinc.com 0.10
Clothiers 820 20044.00 purchasing@clothiers.com 0.05
RedCross 849 48900.20 purchasing@redcross.org non-profit
ChocolateRus 125 3000.50 purchasing@chocolate.com 0.1
CareBear 535 6000.00 purchasing@carebear.com 0.08
BalloonInc 331 5100.50 purchasing@balloon.com 0.06
TiresInc 345 25000.00 purchasing@tires.com 0.07
JeweleryInc 211 52000.00 purchasing@jewelery.com 0.08
Vassar 002 53000.00 purchasing@vassar.edu education
Hertz 521 22200.00 purchasing@hertz.com 0.07
JCU 009 135678.50 purchasing@jcu.edu education
Enterprise 120 75300.00 purchasing@enterprise.com 0.06
Avis 958 89999.00 purchasing@avis.com 0.03
Tufts 699 340020.23 purchasing@tufts.edu education
Truckers2Corp 910 55000.00 purchasing@truckers2corp.com 0.10
LandsEnd 825 20054.00 purchasing@landsend.com 0.04
TheFutureProject 853 48920.20 purchasing@tfp.org other
Bromilows 225 3300.50 purchasing@bromilows.com 0.5
Thrifty 539 6600.00 purchasing@thrify.com 0.07
FlowersRus 339 59300.50 purchasing@flowers.com 0.08
Prudential 660 28900.00 purchasing@prudential.com 0.07
MassMutual 567 5890.00 purchasing@massmutual.com 0.08
Montclair 111 39800.00 purchasing@montclair.edu education
SaveTheChildren 578 28760.00 purchasing@savechildren.com non-profit
NJDOE 154 158000.50 purchasing@njdoe.gov other
ShopRite 333 82100.00 purchasing@shoprite.com 0.07
Turtles 943 88888.00 purchasing@turtles.com 0.08
Brandeis 901 340020.23 purchasing@brandeis.edu education
TruckersRus 610 54000.00 purchasing@truckersrus.com 0.08
Clothier&Son 821 20044.00 purchasing@clothiersson.com 0.05
MLH 823 900.20 purchasing@mlh.org other
Calandras 725 43000.50 purchasing@calandra.com 0.7
PinkElephant 536 600.00 purchasing@pinkelephant.com 0.05
Essie 338 5000.50 purchasing@essie.com 0.07
Uber 348 1500.00 purchasing@uber.com 0.05
NYDOE 157 12000.50 purchasing@nydoe.gov other
Zales 213 54300.00 purchasing@zales.com 0.07
Columbia 322 54500.00 purchasing@columbia.edu education
CheapCars 555 23210.00 purchasing@cheapcars.com 0.09
NJIT 099 13978.50 purchasing@NJIT.edu education
DAV 358 4860.20 purchasing@dav.org non-profit
LLBean 852 2234.00 purchasing@llbean.com 0.03
ArthritisREU 238 4890.20 purchasing@arthritisreu.org other
Etsy 902 20400.00 purchasing@etsy.com 0.03
BedBath 212 55000.00 purchasing@Bedbath.com 0.05
UPenn 011 350000.00 purchasing@upenn.edu education
EnginesRus 522 23500.00 purchasing@enginesrus.com 0.06
SetonHall 008 158090.50 purchasing@setonhall.edu education
TiresToGo 108 8300.00 purchasing@tirestogo.com 0.06
BillShop 956 9999.00 purchasing@billshop.com 0.08
NorthEastern 798 40020.23 purchasing@northeastern.edu education
Chocolatiers 318 59000.00 purchasing@chocolatiers.com 0.03
DunkinDonuts 819 2044.00 purchasing@dunkingdonuts.com 0.06
DiabetesOrg 850 4900.20 purchasing@diabetes.org non-profit
Beans 126 1000.50 purchasing@beans.com 0.03
BabyGap 538 6100.00 purchasing@babygap.com 0.07
PartyStore 334 500.50 purchasing@partystore.com 0.03
Threads 349 29000.00 purchasing@threads.com 0.05
ColorsInc 218 2000.00 purchasing@colorsinc.com 0.06
CountyCollege1 12 5000.00 purchasing@cc1.edu education
BusinessRUs 531 1200.00 purchasing@businessrus.com 0.08
CountyCollege2 109 1678.50 purchasing@cc2.edu education
Business2 128 5300.00 purchasing@business2.com 0.02
Oleander 959 2999.00 purchasing@oleander.com 0.04
Harvard 698 34020.23 purchasing@harvard.edu education
TaxisInc 914 5000.00 purchasing@taxisinc.com 0.09
Jjill 829 2054.00 purchasing@jjill.com 0.05
CSTA 859 4820.20 purchasing@csta.org other
Godiva 229 3100.50 purchasing@godiva.com 0.06
DryCleaners 540 6800.00 purchasing@drycleaners.com 0.05
Macys 332 58200.50 purchasing@macys.com 0.07
CADOE 669 2900.00 purchasing@cadoe.gov.com other
Prudential 561 58290.00 purchasing@prudential.com 0.07
Linden 112 3800.00 purchasing@linden.gov other
FoodPantry 579 25760.00 purchasing@foodpantry.org non-profit
WADOE 159 18000.50 purchasing@wadoe.gov other
StopandShop 377 8100.00 purchasing@stopandshop.com 0.06
WholeFoods 953 8888.00 purchasing@wholefoods.com 0.06
FIT 907 30020.23 purchasing@fit.edu education
CarRental1 690 5400.00 purchasing@carrental1.com 0.04
Office1 851 2044.00 purchasing@office1.com 0.05
CodeHS 822 1000.20 purchasing@codehs.org other
Bakery1 727 4000.50 purchasing@bakery1.com 0.07
BabyToys 539 6000.00 purchasing@babytoys.com 0.04
Google 003 500.50 purchasing@google.com 0.01
NYYankees 019 15500.00 purchasing@nyyankees.com 0.07
Census 155 102000.50 purchasing@census.gov other
Fridays 110 5300.00 purchasing@fridays.com 0.06
CUNY 328 5500.00 purchasing@cuny.edu education
CheapFood 551 2210.00 purchasing@cheapfood.com 0.04
LegoInc 018 1978.50 purchasing@lego.com 0.02
DAV2 359 4860.20 purchasing@dav2.org non-profit
Explanation / Answer
Below is your code. Please make sure there are no blanks in text file at last.
Customer.java
//Customer.java
public class Customer implements Comparable<Customer> {
// Instance variables
private int custId;
private String name;
private double billBalance;
private String email;
/**
* Parameterized constructor
*
* @param custId
* - customer id
* @param name
* - customer name
* @param billBalance
* - bill balance
* @param email
* - email id
*/
public Customer(int custId, String name, double billBalance, String email) {
this.custId = custId;
this.name = name;
this.billBalance = billBalance;
this.email = email;
}
/**
* This method returns the customer id
*
* @return the custId
*/
public int getCustId() {
return custId;
}
/**
* This method returns the customer name
*
* @return the name
*/
public String getName() {
return name;
}
/**
* This method returns the bill balance
*
* @return the billBalance
*/
public double getBillBalance() {
return billBalance;
}
/**
* This method returns the email address
*
* @return the email
*/
public String getEmail() {
return email;
}
/**
* This method sets the customer id
*
* @param custId
* the custId to set
*/
public void setCustId(int custId) {
this.custId = custId;
}
/**
* This method sets the customer name
*
* @param name
* the name to set
*/
public void setName(String name) {
this.name = name;
}
/**
* This method sets the bill balance
*
* @param billBalance
* the billBalance to set
*/
public void setBillBalance(double billBalance) {
this.billBalance = billBalance;
}
/**
* This method sets the email address
*
* @param email
* the email to set
*/
public void setEmail(String email) {
this.email = email;
}
@Override
public String toString() {
return String.format("%-20s%-6d%-30s%-,12.2f", name, custId, email, billBalance);
}
@Override
public int compareTo(Customer c) {
return this.getCustId() - c.getCustId();
}
}
TaxExempt.java
//TaxExempt.java
public class TaxExempt extends Customer {
// Instance variables
private String reasonForExemption;
/**
* Parameterized constructor
*
* @param custId
* - customer id
* @param name
* - customer name
* @param billBalance
* - bill balance
* @param email
* - email id
* @param reasonForExemption
* - reason for tax exemption
*/
public TaxExempt(int custId, String name, double billBalance, String email, String reasonForExemption) {
super(custId, name, billBalance, email);
this.reasonForExemption = reasonForExemption;
}
/**
* This method returns the reason for tax exemption
*
* @return the reasonForExemption
*/
public String getReasonForExemption() {
return reasonForExemption;
}
/**
* This method sets the reason for tax exemption
*
* @param reasonForExemption
* the reasonForExemption to set
*/
public void setReasonForExemption(String reasonForExemption) {
this.reasonForExemption = reasonForExemption;
}
@Override
public String toString() {
return super.toString() + String.format("%-12s", reasonForExemption);
}
}
NonTaxExempt.java
//NonTaxExempt.java
public class NonTaxExempt extends Customer {
// Instance variables
private double taxLiability;
/**
* Parameterized constructor
*
* @param custId
* - customer id
* @param name
* - customer name
* @param billBalance
* - bill balance
* @param email
* - email id
* @param taxLiability
* - tax liability
*/
public NonTaxExempt(int custId, String name, double billBalance, String email, double taxLiability) {
super(custId, name, billBalance, email);
this.taxLiability = taxLiability;
}
/**
* This method returns the tax liability
*
* @return the taxLiability
*/
public double getTaxLiability() {
return taxLiability;
}
/**
* This method sets the tax liability
*
* @param taxLiability
* the taxLiability to set
*/
public void setTaxLiability(double taxLiability) {
this.taxLiability = taxLiability;
}
@Override
public String toString() {
return super.toString() + String.format("%-12s%,.2f", "tax liable", taxLiability);
}
}
LabExam.java
//LabExam.java
public class LabExam {
// Instance variables
private Customer[] cust;
/**
* This method reads the input file and store the data as Customer objects
* in the array
*
* @param fileName
* - input file name
* @throws FileNotFoundException
*/
private void readFile(String fileName) throws FileNotFoundException {
// Scanner to read from the file
Scanner inFile = new Scanner(new File(fileName));
// Read the number of customers from the file
int n = inFile.nextInt();
// Initialize array
this.cust = new Customer[n];
// Consume the newline
inFile.nextLine();
// Read data from the file
int i = 0;
while (inFile.hasNextLine()) {
// Read data
String name = inFile.next();
// Read customer id
int custId = inFile.nextInt();
// Read bill balance
double billBalance = inFile.nextDouble();
// Read email address
String email = inFile.next();
// Check if this is a tax-exempt or non tax-exempt customer
if (inFile.hasNextDouble())
this.cust[i++] = new NonTaxExempt(custId, name, billBalance, email, inFile.nextDouble());
else
this.cust[i++] = new TaxExempt(custId, name, billBalance, email, inFile.next());
}
// Close file
inFile.close();
}
/**
* This method sorts the customer array in ascending order by the customer
* id.
*/
private void sort() {
Arrays.sort(this.cust);
}
/**
* This method formats and prints the output report.
*/
private void printReport() {
// Scanner to get user enter
Scanner in = new Scanner(System.in);
int pageCount = 1;
int customerPerPage = 45;
int i = 0;
// While there are customers in array
while (i < this.cust.length) {
// Print header
System.out.println(String.format("%59s%27s%4d", "Office Supplies Inc. Customer Report", "Page", pageCount));
System.out.println(String.format("%90s", " ").replaceAll("\s", "="));
System.out.println(" ");
// Print column header
System.out.println(String.format("%-20s%-6s%-30s%-12s%-12s%s", "Customer", "ID", "Email Address", "Balance",
"Tax Type", "Tax Amount"));
System.out.println(String.format("%-20s%-6s%-30s%-12s%-12s%s", "========", "==", "=============", "=======",
"========", "=========="));
// Display customer details
do {
System.out.println(this.cust[i++]);
} while (((i % customerPerPage) != 0) && (i < this.cust.length));
// Get user enter
if (i < this.cust.length) {
System.out.println("Press enter to get next page...");
in.nextLine();
System.out.println(" ");
}
// Increment pageCount
pageCount += 1;
}
// Close scanner
in.close();
}
public static void main(String[] args) {
// Input file name
String fileName = "customer.txt";
try {
// Create LabExam object
LabExam e = new LabExam();
// Read input file
e.readFile(fileName);
// Sort array
e.sort();
// Print report
e.printReport();
} catch (FileNotFoundException fnfe) {
System.out.println(fnfe.getMessage());
}
}
}
customer.txt
100
Amazon 900 20000.00 purchasing@amazon.com 0.08
Nordstrom 210 50000.00 purchasing@nordstrom.com 0.07
Rutgers 010 32000.00 purchasing@rutgers.edu education
Alamo 520 23000.00 purchasing@alamo.com 0.05
Kean 001 158000.50 purchasing@kean.edu education
Allied 100 85300.00 purchasing@allied.com 0.06
JoesInc 950 999999.00 purchasing@joesinc.com 0.03
BostonU 697 340020.23 purchasing@tufts.edu education
TruckersInc 310 55000.00 purchasing@truckersinc.com 0.10
Clothiers 820 20044.00 purchasing@clothiers.com 0.05
RedCross 849 48900.20 purchasing@redcross.org non-profit
ChocolateRus 125 3000.50 purchasing@chocolate.com 0.1
CareBear 535 6000.00 purchasing@carebear.com 0.08
BalloonInc 331 5100.50 purchasing@balloon.com 0.06
TiresInc 345 25000.00 purchasing@tires.com 0.07
JeweleryInc 211 52000.00 purchasing@jewelery.com 0.08
Vassar 002 53000.00 purchasing@vassar.edu education
Hertz 521 22200.00 purchasing@hertz.com 0.07
JCU 009 135678.50 purchasing@jcu.edu education
Enterprise 120 75300.00 purchasing@enterprise.com 0.06
Avis 958 89999.00 purchasing@avis.com 0.03
Tufts 699 340020.23 purchasing@tufts.edu education
Truckers2Corp 910 55000.00 purchasing@truckers2corp.com 0.10
LandsEnd 825 20054.00 purchasing@landsend.com 0.04
TheFutureProject 853 48920.20 purchasing@tfp.org other
Bromilows 225 3300.50 purchasing@bromilows.com 0.5
Thrifty 539 6600.00 purchasing@thrify.com 0.07
FlowersRus 339 59300.50 purchasing@flowers.com 0.08
Prudential 660 28900.00 purchasing@prudential.com 0.07
MassMutual 567 5890.00 purchasing@massmutual.com 0.08
Montclair 111 39800.00 purchasing@montclair.edu education
SaveTheChildren 578 28760.00 purchasing@savechildren.com non-profit
NJDOE 154 158000.50 purchasing@njdoe.gov other
ShopRite 333 82100.00 purchasing@shoprite.com 0.07
Turtles 943 88888.00 purchasing@turtles.com 0.08
Brandeis 901 340020.23 purchasing@brandeis.edu education
TruckersRus 610 54000.00 purchasing@truckersrus.com 0.08
Clothier&Son 821 20044.00 purchasing@clothiersson.com 0.05
MLH 823 900.20 purchasing@mlh.org other
Calandras 725 43000.50 purchasing@calandra.com 0.7
PinkElephant 536 600.00 purchasing@pinkelephant.com 0.05
Essie 338 5000.50 purchasing@essie.com 0.07
Uber 348 1500.00 purchasing@uber.com 0.05
NYDOE 157 12000.50 purchasing@nydoe.gov other
Zales 213 54300.00 purchasing@zales.com 0.07
Columbia 322 54500.00 purchasing@columbia.edu education
CheapCars 555 23210.00 purchasing@cheapcars.com 0.09
NJIT 099 13978.50 purchasing@NJIT.edu education
DAV 358 4860.20 purchasing@dav.org non-profit
LLBean 852 2234.00 purchasing@llbean.com 0.03
ArthritisREU 238 4890.20 purchasing@arthritisreu.org other
Etsy 902 20400.00 purchasing@etsy.com 0.03
BedBath 212 55000.00 purchasing@Bedbath.com 0.05
UPenn 011 350000.00 purchasing@upenn.edu education
EnginesRus 522 23500.00 purchasing@enginesrus.com 0.06
SetonHall 008 158090.50 purchasing@setonhall.edu education
TiresToGo 108 8300.00 purchasing@tirestogo.com 0.06
BillShop 956 9999.00 purchasing@billshop.com 0.08
NorthEastern 798 40020.23 purchasing@northeastern.edu education
Chocolatiers 318 59000.00 purchasing@chocolatiers.com 0.03
DunkinDonuts 819 2044.00 purchasing@dunkingdonuts.com 0.06
DiabetesOrg 850 4900.20 purchasing@diabetes.org non-profit
Beans 126 1000.50 purchasing@beans.com 0.03
BabyGap 538 6100.00 purchasing@babygap.com 0.07
PartyStore 334 500.50 purchasing@partystore.com 0.03
Threads 349 29000.00 purchasing@threads.com 0.05
ColorsInc 218 2000.00 purchasing@colorsinc.com 0.06
CountyCollege1 12 5000.00 purchasing@cc1.edu education
BusinessRUs 531 1200.00 purchasing@businessrus.com 0.08
CountyCollege2 109 1678.50 purchasing@cc2.edu education
Business2 128 5300.00 purchasing@business2.com 0.02
Oleander 959 2999.00 purchasing@oleander.com 0.04
Harvard 698 34020.23 purchasing@harvard.edu education
TaxisInc 914 5000.00 purchasing@taxisinc.com 0.09
Jjill 829 2054.00 purchasing@jjill.com 0.05
CSTA 859 4820.20 purchasing@csta.org other
Godiva 229 3100.50 purchasing@godiva.com 0.06
DryCleaners 540 6800.00 purchasing@drycleaners.com 0.05
Macys 332 58200.50 purchasing@macys.com 0.07
CADOE 669 2900.00 purchasing@cadoe.gov.com other
Prudential 561 58290.00 purchasing@prudential.com 0.07
Linden 112 3800.00 purchasing@linden.gov other
FoodPantry 579 25760.00 purchasing@foodpantry.org non-profit
WADOE 159 18000.50 purchasing@wadoe.gov other
StopandShop 377 8100.00 purchasing@stopandshop.com 0.06
WholeFoods 953 8888.00 purchasing@wholefoods.com 0.06
FIT 907 30020.23 purchasing@fit.edu education
CarRental1 690 5400.00 purchasing@carrental1.com 0.04
Office1 851 2044.00 purchasing@office1.com 0.05
CodeHS 822 1000.20 purchasing@codehs.org other
Bakery1 727 4000.50 purchasing@bakery1.com 0.07
BabyToys 539 6000.00 purchasing@babytoys.com 0.04
Google 003 500.50 purchasing@google.com 0.01
NYYankees 019 15500.00 purchasing@nyyankees.com 0.07
Census 155 102000.50 purchasing@census.gov other
Fridays 110 5300.00 purchasing@fridays.com 0.06
CUNY 328 5500.00 purchasing@cuny.edu education
CheapFood 551 2210.00 purchasing@cheapfood.com 0.04
LegoInc 018 1978.50 purchasing@lego.com 0.02
DAV2 359 4860.20 purchasing@dav2.org non-profit
Output
Office Supplies Inc. Customer Report Page 1
==========================================================================================
Customer ID Email Address Balance Tax Type Tax Amount
======== == ============= ======= ======== ==========
Kean 1 purchasing@kean.edu 158,000.50 education
Vassar 2 purchasing@vassar.edu 53,000.00 education
Google 3 purchasing@google.com 500.50 tax liable 0.01
SetonHall 8 purchasing@setonhall.edu 158,090.50 education
JCU 9 purchasing@jcu.edu 135,678.50 education
Rutgers 10 purchasing@rutgers.edu 32,000.00 education
UPenn 11 purchasing@upenn.edu 350,000.00 education
CountyCollege1 12 purchasing@cc1.edu 5,000.00 education
LegoInc 18 purchasing@lego.com 1,978.50 tax liable 0.02
NYYankees 19 purchasing@nyyankees.com 15,500.00 tax liable 0.07
NJIT 99 purchasing@NJIT.edu 13,978.50 education
Allied 100 purchasing@allied.com 85,300.00 tax liable 0.06
TiresToGo 108 purchasing@tirestogo.com 8,300.00 tax liable 0.06
CountyCollege2 109 purchasing@cc2.edu 1,678.50 education
Fridays 110 purchasing@fridays.com 5,300.00 tax liable 0.06
Montclair 111 purchasing@montclair.edu 39,800.00 education
Linden 112 purchasing@linden.gov 3,800.00 other
Enterprise 120 purchasing@enterprise.com 75,300.00 tax liable 0.06
ChocolateRus 125 purchasing@chocolate.com 3,000.50 tax liable 0.10
Beans 126 purchasing@beans.com 1,000.50 tax liable 0.03
Business2 128 purchasing@business2.com 5,300.00 tax liable 0.02
NJDOE 154 purchasing@njdoe.gov 158,000.50 other
Census 155 purchasing@census.gov 102,000.50 other
NYDOE 157 purchasing@nydoe.gov 12,000.50 other
WADOE 159 purchasing@wadoe.gov 18,000.50 other
Nordstrom 210 purchasing@nordstrom.com 50,000.00 tax liable 0.07
JeweleryInc 211 purchasing@jewelery.com 52,000.00 tax liable 0.08
BedBath 212 purchasing@Bedbath.com 55,000.00 tax liable 0.05
Zales 213 purchasing@zales.com 54,300.00 tax liable 0.07
ColorsInc 218 purchasing@colorsinc.com 2,000.00 tax liable 0.06
Bromilows 225 purchasing@bromilows.com 3,300.50 tax liable 0.50
Godiva 229 purchasing@godiva.com 3,100.50 tax liable 0.06
ArthritisREU 238 purchasing@arthritisreu.org 4,890.20 other
TruckersInc 310 purchasing@truckersinc.com 55,000.00 tax liable 0.10
Chocolatiers 318 purchasing@chocolatiers.com 59,000.00 tax liable 0.03
Columbia 322 purchasing@columbia.edu 54,500.00 education
CUNY 328 purchasing@cuny.edu 5,500.00 education
BalloonInc 331 purchasing@balloon.com 5,100.50 tax liable 0.06
Macys 332 purchasing@macys.com 58,200.50 tax liable 0.07
ShopRite 333 purchasing@shoprite.com 82,100.00 tax liable 0.07
PartyStore 334 purchasing@partystore.com 500.50 tax liable 0.03
Essie 338 purchasing@essie.com 5,000.50 tax liable 0.07
FlowersRus 339 purchasing@flowers.com 59,300.50 tax liable 0.08
TiresInc 345 purchasing@tires.com 25,000.00 tax liable 0.07
Uber 348 purchasing@uber.com 1,500.00 tax liable 0.05
Press enter to get next page...
Office Supplies Inc. Customer Report Page 2
==========================================================================================
Customer ID Email Address Balance Tax Type Tax Amount
======== == ============= ======= ======== ==========
Threads 349 purchasing@threads.com 29,000.00 tax liable 0.05
DAV 358 purchasing@dav.org 4,860.20 non-profit
DAV2 359 purchasing@dav2.org 4,860.20 non-profit
StopandShop 377 purchasing@stopandshop.com 8,100.00 tax liable 0.06
Alamo 520 purchasing@alamo.com 23,000.00 tax liable 0.05
Hertz 521 purchasing@hertz.com 22,200.00 tax liable 0.07
EnginesRus 522 purchasing@enginesrus.com 23,500.00 tax liable 0.06
BusinessRUs 531 purchasing@businessrus.com 1,200.00 tax liable 0.08
CareBear 535 purchasing@carebear.com 6,000.00 tax liable 0.08
PinkElephant 536 purchasing@pinkelephant.com 600.00 tax liable 0.05
BabyGap 538 purchasing@babygap.com 6,100.00 tax liable 0.07
Thrifty 539 purchasing@thrify.com 6,600.00 tax liable 0.07
BabyToys 539 purchasing@babytoys.com 6,000.00 tax liable 0.04
DryCleaners 540 purchasing@drycleaners.com 6,800.00 tax liable 0.05
CheapFood 551 purchasing@cheapfood.com 2,210.00 tax liable 0.04
CheapCars 555 purchasing@cheapcars.com 23,210.00 tax liable 0.09
Prudential 561 purchasing@prudential.com 58,290.00 tax liable 0.07
MassMutual 567 purchasing@massmutual.com 5,890.00 tax liable 0.08
SaveTheChildren 578 purchasing@savechildren.com 28,760.00 non-profit
FoodPantry 579 purchasing@foodpantry.org 25,760.00 non-profit
TruckersRus 610 purchasing@truckersrus.com 54,000.00 tax liable 0.08
Prudential 660 purchasing@prudential.com 28,900.00 tax liable 0.07
CADOE 669 purchasing@cadoe.gov.com 2,900.00 other
CarRental1 690 purchasing@carrental1.com 5,400.00 tax liable 0.04
BostonU 697 purchasing@tufts.edu 340,020.23 education
Harvard 698 purchasing@harvard.edu 34,020.23 education
Tufts 699 purchasing@tufts.edu 340,020.23 education
Calandras 725 purchasing@calandra.com 43,000.50 tax liable 0.70
Bakery1 727 purchasing@bakery1.com 4,000.50 tax liable 0.07
NorthEastern 798 purchasing@northeastern.edu 40,020.23 education
DunkinDonuts 819 purchasing@dunkingdonuts.com 2,044.00 tax liable 0.06
Clothiers 820 purchasing@clothiers.com 20,044.00 tax liable 0.05
Clothier&Son 821 purchasing@clothiersson.com 20,044.00 tax liable 0.05
CodeHS 822 purchasing@codehs.org 1,000.20 other
MLH 823 purchasing@mlh.org 900.20 other
LandsEnd 825 purchasing@landsend.com 20,054.00 tax liable 0.04
Jjill 829 purchasing@jjill.com 2,054.00 tax liable 0.05
RedCross 849 purchasing@redcross.org 48,900.20 non-profit
DiabetesOrg 850 purchasing@diabetes.org 4,900.20 non-profit
Office1 851 purchasing@office1.com 2,044.00 tax liable 0.05
LLBean 852 purchasing@llbean.com 2,234.00 tax liable 0.03
TheFutureProject 853 purchasing@tfp.org 48,920.20 other
CSTA 859 purchasing@csta.org 4,820.20 other
Amazon 900 purchasing@amazon.com 20,000.00 tax liable 0.08
Brandeis 901 purchasing@brandeis.edu 340,020.23 education
Press enter to get next page...
Office Supplies Inc. Customer Report Page 3
==========================================================================================
Customer ID Email Address Balance Tax Type Tax Amount
======== == ============= ======= ======== ==========
Etsy 902 purchasing@etsy.com 20,400.00 tax liable 0.03
FIT 907 purchasing@fit.edu 30,020.23 education
Truckers2Corp 910 purchasing@truckers2corp.com 55,000.00 tax liable 0.10
TaxisInc 914 purchasing@taxisinc.com 5,000.00 tax liable 0.09
Turtles 943 purchasing@turtles.com 88,888.00 tax liable 0.08
JoesInc 950 purchasing@joesinc.com 999,999.00 tax liable 0.03
WholeFoods 953 purchasing@wholefoods.com 8,888.00 tax liable 0.06
BillShop 956 purchasing@billshop.com 9,999.00 tax liable 0.08
Avis 958 purchasing@avis.com 89,999.00 tax liable 0.03
Oleander 959 purchasing@oleander.com 2,999.00 tax liable 0.04
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.