| Online Accounting Service – Reports Completed by Integra Accounting Outsourcing | |||||||||||||||||||
| BLUE BELL DIAMOND LTD | |||||||||||||||||||
| Sales by Item Summary | |||||||||||||||||||
| As of December 2009 | |||||||||||||||||||
| Qty | Amount | % of Sales | Avg Price | COGS | Avg COGS | Gross Margin | Gross Margin % | ||||||||||||
| Stock | |||||||||||||||||||
| Chairs | |||||||||||||||||||
| Oak chair | 58.00 | 2,320.00 | 5.96% | 40.00 | 1,450.00 | 25.00 | 870.00 | 37.5% | |||||||||||
| Pine chair | 120.00 | 2,904.00 | 7.46% | 24.20 | 1,726.01 | 14.38 | 1,177.99 | 40.56% | |||||||||||
| Total Chairs | 5,224.00 | 13.42% | 3,176.01 | 2,047.99 | 39.2% | ||||||||||||||
| Dressers | |||||||||||||||||||
| Oak Welsh dresser | 7.00 | 2,240.00 | 5.76% | 320.00 | 1,330.00 | 190.00 | 910.00 | 40.63% | |||||||||||
| Pine Welsh dresser | 7.00 | 2,088.00 | 5.36% | 298.29 | 1,085.00 | 155.00 | 1,003.00 | 48.04% | |||||||||||
| Total Dressers | 4,328.00 | 11.12% | 2,415.00 | 1,913.00 | 44.2% | ||||||||||||||
| Pine Kitchen Cabinets | |||||||||||||||||||
| Pine base cabinet | 29.00 | 3,696.00 | 9.5% | 127.45 | 1,798.00 | 62.00 | 1,898.00 | 51.35% | |||||||||||
| Pine base with drawer | 20.00 | 2,958.00 | 7.6% | 147.90 | 1,600.00 | 80.00 | 1,358.00 | 45.91% | |||||||||||
| Pine double wall | 19.00 | 2,625.00 | 6.74% | 138.16 | 1,633.27 | 85.96 | 991.73 | 37.78% | |||||||||||
| Pine single wall | 25.00 | 1,561.00 | 4.01% | 62.44 | 750.00 | 30.00 | 811.00 | 51.95% | |||||||||||
| Total Pine Kitchen Cabinets | 10,840.00 | 27.85% | 5,781.27 | 5,058.73 | 46.67% | ||||||||||||||
| Sinks | |||||||||||||||||||
| Butler's sink | 12.00 | 816.00 | 2.1% | 68.00 | 480.00 | 40.00 | 336.00 | 41.18% | |||||||||||
| Double sink | 21.00 | 1,309.00 | 3.36% | 62.33 | 714.00 | 34.00 | 595.00 | 45.46% | |||||||||||
| Total Sinks | 2,125.00 | 5.46% | 1,194.00 | 931.00 | 43.81% | ||||||||||||||
| Tables | |||||||||||||||||||
| Oak table | 12.00 | 2,400.00 | 6.17% | 200.00 | 1,440.00 | 120.00 | 960.00 | 40.0% | |||||||||||
| Pine table | 30.00 | 4,840.00 | 12.43% | 161.33 | 2,700.00 | 90.00 | 2,140.00 | 44.22% | |||||||||||
| Total Tables | 7,240.00 | 18.6% | 4,140.00 | 3,100.00 | 42.82% | ||||||||||||||
| Taps | |||||||||||||||||||
| Mixer taps | 25.00 | 759.50 | 1.95% | 30.38 | 400.00 | 16.00 | 359.50 | 47.33% | |||||||||||
| Silver taps | 8.00 | 175.00 | 0.45% | 21.88 | 96.00 | 12.00 | 79.00 | 45.14% | |||||||||||
| Total Taps | 934.50 | 2.4% | 496.00 | 438.50 | 46.92% | ||||||||||||||
| Work Tops | |||||||||||||||||||
| Granite worktop | 3.00 | 255.00 | 0.66% | 85.00 | 129.00 | 43.00 | 126.00 | 49.41% | |||||||||||
| Steel worktop | 24.00 | 1,482.00 | 3.81% | 61.75 | 720.00 | 30.00 | 762.00 | 51.42% | |||||||||||
| Total Work Tops | 1,737.00 | 4.46% | 849.00 | 888.00 | 51.12% | ||||||||||||||
| Total Stock | 32,428.50 | 83.31% | 18,051.28 | 14,377.22 | 44.34% | ||||||||||||||
| Service | |||||||||||||||||||
| Fitting | 98.00 | 4,705.00 | 12.09% | 48.01 | |||||||||||||||
| Plumbing | 31.00 | 1,785.00 | 4.59% | 57.58 | |||||||||||||||
| Total Service | 6,490.00 | 16.67% | |||||||||||||||||
| Other Charges | |||||||||||||||||||
| Post and packing | 1.00 | 6.23 | 0.02% | 6.23 | |||||||||||||||
| Total Other Charges | 6.23 | 0.02% | |||||||||||||||||
| TOTAL | 38,924.73 | 100.0% | |||||||||||||||||
| Accounting outsourcing services | |||||||||||||||||||