Data Analysis Research Paper Example | Topics and Well Written Essays - 2750 words

Data Analysis - Research Paper Example The period under study is from 1997 to 2001, a five year period. The basis for this particular study is the fact that the company promises to replace the copiers if the service personnel are not in a position to rectify or resolve service complaints within a period of 72 hours and the service commitment given to the customer is that the non-functional or problematic copier would be replaced within a period of 48 hours. Exhibit 1 below shows the sales figures for the five years under study across the different geographic locations and the annual growth rate. The sales across were achieved by deploying extensive sales force in the marketplace. One of the principles that were used to increase revenues was to increase the sales force. The following table and graphs give the number of sales personnel during the study period. While sales is one of the parameters for increasing the revenues, it was found that the commitment of replacing un-serviceable photocopiers was eating directly into the bottom-lines of the company. The number of complaints received is captured as under - Exhibit 4 and graph 4: While measuring the effectiveness of the sales personnel, similar data is captured for service personnel. Service personnel are people who attend to customer complaints once the product is sold and placed at the customer site. Exhibit 5 and Graph 5 show the number of service personnel. Exhibit 6 andExhibit 5 Number of service personnel Geo Dec-97 Dec-98 Dec-99 Dec-00 Dec-01 1 USA 70 84 100 122 125 2 UK 36 44 34 40 50 3 Europe 40 48 58 70 70 4 Asia 24 30 35 42 45 5 Australia 30 56 44 53 55 Graph 5 number of service personnel Exhibit 6 and graph 6 show the average number of service call

Peyton Budget and Analyzing Assignment Example | Topics and Well Written Essays - 1250 words

Peyton Budget and Analyzing - Assignment Example The sales budget for Peyton Approved shows that the company forecasts sales to be $1,080,000 for the quarter ending September 2015. To cover the sales and the required ending inventory, the company needs to produce 60,000 units. That would require 27,380 units of raw material at a cost of $212,195. The total labor requirement is 30,000 hours at a cost of $480,000. While the budget estimate for direct material for the period is 36,320 units, the actual amount of direct labor is 31,000 units. The budgeted price per unit of direct material is $7.75. It is also the actual price. Given the difference is only on the number of units of direct material, the direct material price variance is zero. As for the direct material efficiency variance, the company records a favorable efficiency variance of $41,230. That gives a favorable total material variance of $41,230. There was no material price variance as the budget price and the actual price were the same. As for the favorable efficiency variance, there may have been several causes. As the actual production shows, there was less direct material usage than the budget estimates. That may have been a result of efficiency in utilizing material in the production process. The procurement process may also have contributed to the favorable efficiency variance. Where there is purchase of high quality material, there would probably be no wastage and the production may use up less material than the estimates (Nobles, Mattison and Matsumura, 2014).