First we must calculate the percent change between 1999 and 2015. To accomplish this, using the data in Worksheet 1 “Data” we use the formula =(($3,702,000-$-527,000)/-$527,000)*100. This calculation provides a result of 802%. This tell us that sales grew 802% between 1999 and 2015.
To calculate the average percentage growth per year, 802% needs to be divided by the number of years – 1. This this case that gives …show more content…
This simplest manner to accomplish this is to multiple 2015 by 150.13%. (Taking 100% of 2015 and adding 50.13% of 2015). The expected sales for 2016 are calculated to be $5,557,812.60. To calculate for 2017, we repeat the equation using the estimated 2016 sales summary. Given these numbers we can expected sales, based on an average percentage growth of 50.13% to be $8,343,944.06. (2016 …show more content…
More than 2/3 of employees are male with approximately 60 percent of those employees being Caucasian. These numbers may be driven by the demographics of the regions from which employees are being hired, or there may be a diversity concern. Over half of the company employees only poses a high school diploma. With the largest share of those employees being classified as “Machine”. As this is a significant component of the workforce, it would appear they possess relevant work experience, but not higher educational attainment. This may be a result of job requirements, or based on the current company pay structure, determination of if this is a problem is not identifiable through the