Specification for Profit/Loss Project -- version 5

• SIMPLIFICATION:   (No strings.)
  • Use month number instead of name, but change to 24 months.
  • Omit the "month name" array and all String I/O.
  • Increase the number of months to 24 (for all arrays),
  • Add an int[] array containing the month number (from 1 to 24); initialize it with a new function, e.g.

  	final int SIZE=24;
  	int monthnumber[SIZE];
  	int many=SIZE;
  	fillmonths( monthnumber, many );

• INPUT:
  • Input the following values (some of which were specified in previous versions).

        int price;       // Price per unit sold (first month).
        double pinc3;    // Quarterly price increase (%), in months 4, 7, 10, etc.
    
        double fixed;    // Fixed expenses (for first month).
        double expPct;   // Percentage increase in fixed expenses, month-to-month.
        double expIncr;  // Additional monthly increase amount ($) for fixed expenses.
                         ////    fixed=   fixed * (100+expPct)/100.  +  expIncr; 
    
        double mat;      // Materials cost per item (first month).
        double matinc;   // Materials cost increase (%), monthly.
    
        double labor;    // Labor cost per item (first month)
        double labinc;   // Expected labor cost incr(%) after months 6 & 18.
    
        String f;        // Name of file containing the  monthly sales data.
    
        /*  (NOTE: The above code is given for illustration only.) */  

  • Also, read data into the sales[] array, from a file (whose name was specified by the input).
    (Remove any previous code that filled the sales and expense arrays.)

• PROCESSING:
• Calculate each month's revenues as follows  (using a separate method to compute and store the array values):
  • Adjust the unit price, if necessary.
  • Multiply number of sales times price, to compute revenues for the month.

• Calculate each month's expenses as the sum of fixed cost, labor cost per item sold, and materials cost per item sold:
  • adjust the fixed cost, if necessary.
  • adjust the labor cost per unit, if necessary.
  • adjust the materials cost per unit if necessary.
  • then calculate and store the expense amount for that month  (using a separate method)

• Calculate the profit for each month, as follows:  (Use a separate method to compute and store the array values):
  • profit is equal to revenues minus expenses.   (Negative profit is called a "loss".)

• OUTPUT:  Produce the following reports  (using a separate method for each report):

  • Standard report, as in version 1 (but with 24 month numbers)

  • A similar report with rows rearranged by profit, from highest to lowest.

  • A similar report with rows rearranged from highest to lowest expense amounts.

  • A similar report, arranged back into month order, but showing only the profitable months (> 0).

  • A similar report (in month order), showing information only for those months where sales increased by at least 10% over previous month.

  • A summary, giving only the mean average and variance for each array:   sales, revenues, expenses.
         (See below for a discussion of how to compute variance, etc.):

• MAIN:   Your "main(...)" method might look something like the following:

         /*  (NOTE: The following code is given for illustration only.) */
	public static void
	main( String[] z ) {
	  //DECLARATIONS:
	  ...
	  //INPUT:  Get sales data from file.
          String f=  asks( "Please enter the file name for the sales data.  " );
	  many=  readarray( sales );		// Read sales data into array.  

	  //INPUT:  Get scalar parameters.
          double price=  askd( "Price per unit sold (first month)" );
          double pinc3=  askd( "Quarterly price increase (%)" );

          double fixed=  askd( "Fixed expense (first month)" );
          double expPct=  askd( "% increase in fixed expenses, month-to-month." );
          double expIncr=  askd( "Additional monthly increase ($) for fixed exp." );
 
          double mat=  askd( "Materials cost per item (first month)" );
          double matinc=  askd( "Materials cost increase (%), monthly" );

          double labor=  askd( "Labor cost per item (first month)");
          double labinc=  askd( "Labor cost incr(%) after months 6 & 18. );


	  //PROCESSING:  Fill arrays (revenues & expenses) with generated values
	  fillrev( rev, many, sales, price, pinc3 );		// Calculate the revenues,
	  fillexp( exp, many, sales, fixed, exppct, expIncr, mat, matinc, labor, labinc );	// Calculate expenses,
	  calcprofit( profit, many, rev, exp );			// Calculate expenses,

	  //OUTPUT:  Produce reports, as required.
	  standardReport( many, month, sales, rev, exp, profit );		// 24 months
	  Summary( many, sales, rev, exp, profit, ... );

	  sort( many, month, sales, rev, exp, profit, ... );
	  ...
	}
	

Mean Average, Variance, and Standard Deviation

	sum=  0;
	for (j=0; j<m; j++) {
		dif   =   a[j] - avg;	// Difference
		difsq =   dif * dif;	// Square it.
		sum   +=  difsq;	// Sum the squares of the differences.
	}
	variance=  difsq / (double) m;	// Divide by number of values.
					// (NOTE:  m-1 is used, in some cases.) 

Specification for Profit/Loss Statement -- versions 1, 2, 3, and 4