Scribd
Upload
10 views1 page

Monthly Ajax Warranty Analysis FY10

This document contains warranty data for a company from October to September of FY09 and FY10. It shows the monthly percentage of warranty claims to unit sales revenue for both years, as well as the total monthly warranty costs and monthly unit sales revenue for FY10. The overall average percentage of warranty claims to unit sales revenue increased from 0.30% in FY09 to 0.66% in FY10.

Uploaded by

Ricardo Frank Cordeiro
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
10 views1 page

Monthly Ajax Warranty Analysis FY10

This document contains warranty data for a company from October to September of FY09 and FY10. It shows the monthly percentage of warranty claims to unit sales revenue for both years, as well as the total monthly warranty costs and monthly unit sales revenue for FY10. The overall average percentage of warranty claims to unit sales revenue increased from 0.30% in FY09 to 0.66% in FY10.

Uploaded by

Ricardo Frank Cordeiro
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Monthly % of Warranty Monthly % of Total Monthy Monthly Unit

to Unit Sales Revenue Warranty to Unit Warranty Cost (US Sales Revenue
Month FY09 Sales Revenue FY10 $ / FY10 ) ** (US $ / FY10)
Oct 0.30% 0.41% $6,273.00 $1,533,182.00
Nov 0.30% 0.92% $15,071.00 $1,637,422.00
Dec 0.27% 0.77% $14,857.00 $1,919,387.00
Jan 0.25% 0.34% $4,456.00 $1,327,130.00
Feb 0.17% 0.49% $7,923.80 $1,630,611.00
March 0.22% 0.64% $11,828.37 $1,836,965.00
April 0.11% #DIV/0!
May 0.54% #DIV/0!
June 0.10% #DIV/0!
July 0.14% #DIV/0!
August 0.13% #DIV/0!
Sept 0.42% #DIV/0!
Overall FY % Average: 0.30% 0.66% $60,409.17 $9,884,697.00 :Year to Date Totals

** Total Monthy Warranty Cost includes: All Standard Factory Warranty


(c /w: 1 year parts / 5 year compressor / 10 year heat exchanger / 30 Day D.O.A. Labor) **

Warranty Calculations
Description OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP TOTAL

Enter Warranty here


TOTAL WARRANTY 981 436 15,196 2,976 7,924 11,838 39,352
(monthly) ----->

Enter $ COS here


COST OF SALES ($) 1,539,167 1,637,422 2,022,639 1,384,357 1,630,611 1,836,965 10,051,161
(monthly) ----->

FY10 % COS 0.06% 0.03% 0.75% 0.21% 0.49% 0.64% - - - - - - 0.39%


FY10 Goal 0.15% 0.15% 0.15% 0.14% 0.14% 0.14% 0.13% 0.13% 0.13% 0.12% 0.12% 0.12% 0.14%
FY09 % COS 1.23% 1.23% 1.23% 1.21% 1.21% 1.21% 1.18% 1.18% 1.18% 1.16% 1.16% 1.16%

Comments:

You might also like