Non Book Spreadsheet with Unit Price Specification Replacement.xlsx
XLSX spreadsheet 28 KB Posted
- Attached to
- Library - Non Book Materials
- Solicitation number
- 24ITBC1288213B-PS
- Issued by
- Fulton County, Georgia
About this file
This document is a Non-Book Spreadsheet with Unit Price Specification for a library materials contract in Georgia, specifically for shelf-ready non-book materials for adults, teens, and children. The contract covers the procurement of 7,200 total items, including DVDs and audiobooks across various age categories and formats from multiple publishers. The product mix includes juvenile and adult DVDs from studios like Universal Home Studio, N'Circle, Fox Home Entertainment, and adult spoken word titles from publishers such as Macmillan Audio, Random House, and Simon & Schuster.
The pricing structure includes tiered percentage discounts ranging from 2% to 13% across different product categories, with an overall project total of $57,637.21. Additional services are included in the pricing, such as monthly new release lists, EDI ordering, cataloging services (both copy and original), and physical processing. The contract appears to be designed for comprehensive media acquisition, covering everything from feature films and TV series to spoken word materials, with specific pricing breakdowns for each category and a detailed accounting of discounts, total costs, and per-item pricing.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| ADDENDUM LETTER NO. 2.pdf | ||
| Q&A Document 3.pdf | ||
| 24ITBC1288213B-PS, Library - Non Book Materials.pdf | ||
| Q&A Document 1.pdf | ||
| ADDENDUM LETTER NO. 3.pdf | ||
| Q&A Document 2.pdf | ||
| ADDENDUM LETTER NO. 1.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sample Vendor Place Discount Here
| ISBN | Title | Author | Format | Age | Publisher | % Discount Offered | Avg. Price | Discount Price | Estimated Purchase Quantity | Total | Per Item Discount Amount | Overall Discount Amount | Overall Discount Amount | |
| 9786318261869 | Curious George 30 Adventure Collection | DVD | Juvenile | Universal Home Studio | 10% | 10 | $ 9.00 | 2000 | $ 18,000.00 | $ 1.00 | $ 1,800.00 | $ 16,200.00 | ||
| 9786318058964 | Giganosaurus | DVD | Juvenile | N'Circle | 13% | 20 | $ 17.40 | 500 | $ 8,700.00 | $ 2.60 | $ 1,131.00 | $ 7,569.00 | ||
| 9786317757981 | Wonder Dogs | DVD | Juvenile | Gravitas | 13% | 21 | $ 18.27 | 500 | $ 9,135.00 | $ 2.73 | $ 1,187.55 | $ 7,947.45 | ||
| 9786318044905 | Ford V Ferrari | DVD | Adult | Fox Home Entertainment | 13% | 10 | $ 8.70 | 500 | $ 4,350.00 | $ 1.30 | $ 565.50 | $ 3,784.50 | ||
| 9786318075312 | Like A Boss | DVD | Adult | Paramount | 13% | 10 | $ 8.70 | 500 | $ 4,350.00 | $ 1.30 | $ 565.50 | $ 3,784.50 | ||
| 9786318060998 | Betty: They Say I'm Different | DVD | Adult | Video Music, Inc | 10% | 10 | $ 9.00 | 500 | $ 4,500.00 | $ 1.00 | $ 450.00 | $ 4,050.00 | ||
| 9786317845558 | Game Thrones, the complete 8th season | DVD | Adult | HBO/Warner | 9% | 6 | $ 5.46 | 500 | $ 2,730.00 | $ 0.54 | $ 245.70 | $ 2,484.30 | ||
| 9781681437187 | The Great Escapte | DVD | Adult | Criterion Distribution | 8% | 5 | $ 4.60 | 500 | $ 2,300.00 | $ 0.40 | $ 184.00 | $ 2,116.00 | ||
| 9786318009058 | Handmaid's Tale, season 3 | DVD | Adult | MGM Entertainment | 7% | 4 | $ 3.72 | 500 | $ 1,860.00 | $ 0.28 | $ 130.20 | $ 1,729.80 | ||
| 9781250752321 | Hello Summer | Mary Kay Andrews | SWA | Adult | Macmillan Audio | 7% | 6.00 | $ 5.58 | 75 | $ 418.50 | $ 0.42 | $ 29.30 | $ 389.21 | |
| 9780525494843 | Water Dancer | Ta-Nehisi Coates | SWA | Adult | Random House | 5% | 7.00 | $ 6.65 | 75 | $ 498.75 | $ 0.35 | $ 24.94 | $ 473.81 | |
| 9781478901075 | City of Bones | Michael Connelly | SWA | Adult | Hachette Audio | 8% | 8.00 | $ 7.36 | 75 | $ 552.00 | $ 0.64 | $ 44.16 | $ 507.84 | |
| 9781549157271 | City We Became | N.K. Jemisin | SWA | Adult | Blackstone Audio | 8% | 6.00 | $ 5.52 | 75 | $ 414.00 | $ 0.48 | $ 33.12 | $ 380.88 | |
| 9780593212820 | Book of Longings | Sue Monk Kidd | SWA | Adult | Penguin Group USA | 6% | 5.00 | $ 4.70 | 75 | $ 352.50 | $ 0.30 | $ 21.15 | $ 331.35 | |
| 9781797107264 | On Ocean Boulevard | Mary Alice Monroe | SWA | Adult | Simon & Schuster | 9% | 5.00 | $ 4.55 | 75 | $ 341.25 | $ 0.45 | $ 30.71 | $ 310.54 | |
| 9780553550603 | Just Mercy | Bryan Stevenson | SWA | Adult | Random House | 9% | 5.00 | $ 4.55 | 75 | $ 341.25 | $ 0.45 | $ 30.71 | $ 310.54 | |
| 9781797104737 | Near Dark | Brad Thor | SWA | Adult | Simon & Schuster | 10% | 7.00 | $ 6.30 | 75 | $ 472.50 | $ 0.70 | $ 47.25 | $ 425.25 | |
| 9780063012646 | One and Only Ivan | Katherine Applegate | SWA | Juvenile | Harpercollins Children | 12% | 7.00 | $ 6.16 | 250 | $ 1,540.00 | $ 0.84 | $ 184.80 | $ 1,355.20 | |
| 9780062972774 | Pax | Sara Pennypacker | SWA | Juvenile | Balzer & Bray | 10% | 5.00 | $ 4.50 | 250 | $ 1,125.00 | $ 0.50 | $ 112.50 | $ 1,012.50 | |
| SWA | Young Adult | 2% | 4.00 | $ 3.92 | 100 | $ 392.00 | $ 0.08 | $ 7.84 | $ 384.16 | |||||
| Grand Total | 161 | 145 | 7,200 | 61,980.8 | - 0 | 16.3 | 6,818.1 | 55,162.7 | ||||||
| Vendor is to input any charges for services in the shaded sections below if applicable |
| A. | Charge for monthly new release/prepub lists (one list for each format in J, YA and adult: total of 9 monthly lists x 18 months) | Young Adult | Category | % Discount Offered | Average Price | Discount Price | Purchase Quantity | Total | Per Item Discount Amount | Overall Discount Amount | Overall Discount Amount | |
| Adult | 150 | Adult feature film DVD | 10% | $10.00 | $ 9.00 | 2,000 | $ 18,000.00 | $ 1.00 | $ 1,800.00 | $ 16,200.00 | ||
| Juvenile | Adult tv series DVD | 8% | $5.00 | $ 4.60 | 1,000 | $ 4,600.00 | $ 0.40 | $ 368.00 | $ 4,232.00 | |||
| B. | Charge for EDI or 9xx ordering: | Adult spoken word | 8% | $6.13 | $ 5.65 | 600 | $ 3,390.19 | $ 0.47 | $ 262.74 | $ 3,127.45 | ||
| Cataloging Costs | YA spoken word | 2% | $4.00 | $ 3.92 | 100 | $ 392.00 | $ 0.08 | $ 7.84 | $ 384.16 | |||
| Per record charge for copy cataloging: | Juvenile feature film DVD | 10% | $10.00 | $ 9.00 | 2,000 | $ 18,000.00 | $ 1.00 | $ 1,800.00 | $ 16,200.00 | |||
| C. | Total Charges for copy cataloging of 6,000 items | 2,000 | Juvenile tv series DVD | 13% | $17.00 | $ 14.79 | 1,000 | $ 14,790.00 | $ 2.21 | $ 1,922.70 | $ 12,867.30 | |
| Per record charge for original cataloging: | Juvenile spoken word | 11% | $6.00 | $ 5.34 | 500 | $ 2,670.00 | $ 0.66 | $ 293.70 | $ 2,376.30 | |||
| D. | Total Charge for original cataloging of 1,200 items: | TOTAL COST OF MATERIALS | 7,200 | $ 61,842.19 | $ 5.82 | $ 6,454.98 | $ 55,387.21 | |||||
| Processing Costs | ||||||||||||
| Per unit charge for physical processing: | ||||||||||||
| E. | Per unit charge for physical processing of 7,200 items | 100 | ||||||||||
| Total Costs for ABCD&E and Additional Costs | 2,250 | |||||||||||
| Additional Costs |
Total Cost plus Additional Cost 2,250
TOTAL COST OF PROJECT(Materials + Services) 57,637.21
Sheet1 Vendor Place Discount Here
| ISBN | Title | Author | Format | Age | Publisher | % Discount Offered | Avg. Price | Discount Price | Estimated Purchase Quantity | Total | Per Item Discount Amount | Overall Discount Amount | Overall Discount Amount | |
| 9786318261869 | Curious George 30 Adventure Collection | DVD | Juvenile | Universal Home Studio | $ - 0 | 2000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 9786318058964 | Giganosaurus | DVD | Juvenile | N'Circle | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 9786317757981 | Wonder Dogs | DVD | Juvenile | Gravitas | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 9786318044905 | Ford V Ferrari | DVD | Adult | Fox Home Entertainment | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 9786318075312 | Like A Boss | DVD | Adult | Paramount | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 9786318060998 | Betty: They Say I'm Different | DVD | Adult | Video Music, Inc | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 9786317845558 | Game Thrones, the complete 8th season | DVD | Adult | HBO/Warner | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 9781681437187 | The Great Escapte | DVD | Adult | Criterion Distribution | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 9786318009058 | Handmaid's Tale, season 3 | DVD | Adult | MGM Entertainment | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 9781250752321 | Hello Summer | Mary Kay Andrews | SWA | Adult | Macmillan Audio | $ - 0 | 75 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 9780525494843 | Water Dancer | Ta-Nehisi Coates | SWA | Adult | Random House | $ - 0 | 75 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 9781478901075 | City of Bones | Michael Connelly | SWA | Adult | Hachette Audio | $ - 0 | 75 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 9781549157271 | City We Became | N.K. Jemisin | SWA | Adult | Blackstone Audio | $ - 0 | 75 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 9780593212820 | Book of Longings | Sue Monk Kidd | SWA | Adult | Penguin Group USA | $ - 0 | 75 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 9781797107264 | On Ocean Boulevard | Mary Alice Monroe | SWA | Adult | Simon & Schuster | $ - 0 | 75 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 9780553550603 | Just Mercy | Bryan Stevenson | SWA | Adult | Random House | $ - 0 | 75 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 9781797104737 | Near Dark | Brad Thor | SWA | Adult | Simon & Schuster | $ - 0 | 75 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 9780063012646 | One and Only Ivan | Katherine Applegate | SWA | Juvenile | Harpercollins Children | $ - 0 | 250 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 9780062972774 | Pax | Sara Pennypacker | SWA | Juvenile | Balzer & Bray | $ - 0 | 250 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| SWA | Young Adult | $ - 0 | 100 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Grand Total | - 0 | - 0 | 7,200 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
| Vendor is to input any charges for services in the shaded sections below if applicable |
| A. | Charge for monthly new release/prepub lists (one list for each format in J, YA and adult: total of 9 monthly lists x 18 months) | Young Adult | Category | % Discount Offered | Average Price | Discount Price | Purchase Quantity | Total | Per Item Discount Amount | Overall Discount Amount | Overall Discount Amount | |
| Adult | Adult feature film DVD | $ - 0 | 2,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Juvenile | Adult tv series DVD | $ - 0 | 1,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| B. | Charge for EDI or 9xx ordering: | Adult spoken word | $ - 0 | 600 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Cataloging Costs | YA spoken word | $ - 0 | 100 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Per record charge for copy cataloging: | Juvenile feature film DVD | $ - 0 | 2,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| C. | Total Charges for copy cataloging of 6,000 items | Juvenile tv series DVD | $ - 0 | 1,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Per record charge for original cataloging: | Juvenile spoken word | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| D. | Total Charge for original cataloging of 1,200 items: | TOTAL COST OF MATERIALS | 7,200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Processing Costs | ||||||||||||
| Per unit charge for physical processing: | ||||||||||||
| E. | Per unit charge for physical processing of 7,200 items | |||||||||||
| Total Costs for ABCD&E and Additional Costs | 0 | |||||||||||
| Additional Costs |
Total Cost plus Additional Cost 0
TOTAL COST OF PROJECT(Materials + Services) - 0
Sheet2-
| Category | % Discount Offered | Average Price | Discount Price | Purchase Quantity | Total | Per Item Discount Amount | Overall Discount Amount | Overall Discount Amount |
| Adult feature film DVD | $ - 0 | 2,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Adult tv series DVD | $ - 0 | 1,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Adult spoken word | $ - 0 | 600 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| YA spoken word | $ - 0 | 100 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Juvenile feature film DVD | $ - 0 | 2,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Juvenile tv series DVD | $ - 0 | 1,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Juvenile spoken word | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| TOTAL COST OF MATERIALS | 7,200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Sheet2
Sheet3
File details come from the government source that posted it. Updated .