File sales. java contains a java program that prompts for and reads in the sales for each of 5 salespeople in a company. it then prints out the id and amount of sales for each salesperson and the total sales. study the code, then compile and run the program to see how it works. now modify the program as follows:

1. compute and print the average sale. (you can compute this directly from the total; no loop is necessary.)
2. find and print the maximum sale. print both the id of the salesperson with the max sale and the amount of the sale, e. g., "salesperson 3 had the highest sale with $4500." note that you don’t need another loop for this; you can do it in the same loop where the values are read and the sum is computed.
3. do the same for the minimum sale.
4. after the list, sum, average, max and min have been printed, ask the user to enter a value. then print the id of each salesperson who exceeded that amount, and the amount of their sales. also, print the total number of salespeople whose sales exceeded the value entered.
5. the salespeople are objecting to having an id of 0—no one wants that designation. modify your program so that the ids run from 1-5 instead of 0-4. do not modify the array—just make the information for salesperson 1 reside in array location 0, and so on.
6. instead of always reading in 5 sales amounts, at the beginning ask the user for the number of salespeople and then create an array that is just the right size. the program can then proceed as before.

//
// sales. java
//
// reads in and stores sales for each of 5 salespeople. displays
// sales entered by salesperson id and total sales for all salespeople.
//
//
import java. util. scanner;
public class sales
{
public static void main(string[] args)
{
final int salespeople = 5;
int[] sales = new int[salespeople];
int sum;
scanner scan = new scanner(system. in);
for (int i=0; i {
system. out. print("enter sales for salesperson " + i + ": ");
sales[i] = scan. nextint();
}
system. out. println("\nsalesperson sales");
system. out. println(" ");
sum = 0;
for (int i=0; i {
system. out. println(" " + i + " " + sales[i]);
sum += sales[i];
}
system. out. println("\ntotal sales: " + sum);
}
}

import java.util.Scanner;

public class Sales

{

public static void main(String[] args) {

   int sum;

   Scanner input = new Scanner(System.in);

   System.out.print("Enter number of salespeople: ");

   int salespeople = input.nextInt();

   int[] sales = new int[salespeople];

   for (int i=0; i<sales.length; i++)

    {

     System.out.print("Enter sales for salesperson " + (i+1) + ": ");

     sales[i] = input.nextInt();

    }

   System.out.println("\nSalesperson   Sales");

   System.out.println("");

   sum = 0;

       int maxSale = sales[0];

       int minSale  = sales[0];

       int minId=1;

       int maxId=1;

    for (int i=0; i<sales.length; i++)

    {

               System.out.println("     " + (i+1) + "         " + sales[i]);

 sum += sales[i];

  if(maxSale < sales[i])

           {

               maxSale = sales[i];

               maxId = i+1;

           }

           if(minSale > sales[i])

           {

               minSale = sales[i];

               minId = i+1;

           }

   }

System.out.println("Total sales: " + sum);

       System.out.println("The average sale is: " + sum / salespeople );

       System.out.println("Salesperson "+ maxId + " had the highest sale with "+ maxSale + ".");

       System.out.println("Salesperson "+ minId + " had the lowest sale with "+ minSale + ".");

       int amount = 0;

       int counter = 0;

       System.out.print("Enter an amount: ");

       amount = input.nextInt();

       for (int i=0; i<sales.length; i++)

    {

     if(sales[i] > amount) {

         counter++;

         System.out.println("Salesperson "+ (i+1) + " exceeded given amount. (Number of sales: " + sales[i] +")");

     }

    }

       System.out.println("Number of salespeople exceeded given amount is: "+ counter);

}

}

Explanation:

- Ask the user for the number of salesperson

- According to entered number, create an array called sales to hold sale number for each person

- In the first for loop, assign the given sales numbers

-  In the second for loop, print all the sales people with sales, calculate the total sales. Also, find the minimum and maximum sales numbers with associated individuals.

- Print total, average, highest, and lowest sales.

- Ask user enter an amount

- In the third for loop, find the sales people who exceeded this amount.

- Print number of sales people who exceeded the amount.

yes you can contact there email

a macro is a tool that allows you to automate tasks and add functionality to your forms, reports, and controls. for example, if you add a command button to a form, you associate the button's onclick event to a macro, and the macro contains the commands that you want the button to perform each time it is clicked.