Attachment J4 - Production Capacity Form.xlsx
XLSX spreadsheet 17 KB Posted
- Solicitation number
- 030ADV25R0039
- Issued by
-
Library of Congress
About this file
Attachment J4 is a Production Capacity Form for a Braille Magazine Transcription and Duplication contract with the Library of Congress. The document details the comprehensive production capabilities across multiple stages of braille magazine production, including scanning, text entry, translation, proofreading, plate preparation, pressing, embossing, collating, binding, and shipping. The form provides a detailed breakdown of current production commitments, available capacity, and potential output for each production stage, utilizing various machines, software, and employees/contractors.
The capacity analysis is based on producing 300 copies of an average magazine containing 240 braille pages in 2 volumes, with specific metrics for each production stage. The form demonstrates significant production potential, with capabilities such as 264,000 braille pages for scanning/text entry, 115,200 braille pages for translation by contractors, and multiple embossing machines capable of processing between 1,280,000 to 2,280,000 braille pages. The document includes a caveat about downtime, noting that current production plus contract availability cannot exceed 85% due to potential interruptions from personnel illness or equipment failures.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 030ADV25R0039 0002.pdf | ||
| Attachment J6 - QA Document - 030ADV25R0039 - 7.23.2025.pdf | ||
| 030ADV25R0039 0001.pdf | ||
| 030ADV25R0039.pdf | ||
| Attachment J2 - Spec801.pdf | ||
| Attachment J3 - Magazine Titles and Pricing.xlsx | XLSX spreadsheet | |
| Attachment J5 - Past-Performance Questionnaire.docx | DOCX document | |
| Attachment J1- Consolidated List of Magazines.xlsx | XLSX spreadsheet |
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
Sheet1
| J.2 | ||
| Statement of Production Capacity (SPC) | ||
| Production Stage | Unit | Description of Machine |
/ Employee
| / Contractor | Output/year per person, machine etc | Number of Persons, Machines etc | Current Production |
| (percentage of total capacity) | Available for this |
Contract
| (percentage of total capacity) | Output/year available for this contract | Capacity of average issues available for this contract | |||||||
| Scanning / text Entry | braille pages | 0% | 0% | 0 | braille pages | 0 | (240 br pages/issue) | ||
| Translation | braille pages | 0% | 0% | 0 | braille pages | 0 | (240 br pages/issue) | ||
| Proofreading | braille pages | 0% | 0% | 0 | braille pages | 0 | (240 br pages/issue) | ||
| Plate | braille pages | 0% | 0% | 0 | braille pages | 0 | (240 br pages/issues) | ||
| Pressing | braille pages | 0% | 0% | 0 | braille pages | 0 | (72,000 pressed pages/issues) | ||
| Embossing | braille pages | 0% | 0% | 0 | braille pages | 0 | (72,000 embossed pages/issues) | ||
| Collating | braille pages | 0% | 0% | 0 | braille pages | 0 | (72,000 pressed pages/issues) | ||
| Binding | volumes | 0% | 0% | 0 | volumes | 0 | (600 volumes/issues) | ||
| Shipping | copies | 0% | 0% | 0 | copies | 0 | (300 copies/issues) | ||
| Calculation is based on 300 copies of an average magazine containing 240 braille pages in 2 volumes. | |||||||||
| When employees work in more than one area, the model must reflect this by prorating the number of persons or hours accordingly | |||||||||
| If downtime equals 15% for example, current production plus that available for this contract cannot exceed 85%. Downtime can be due to illness of personnel, failure or equipment, etc. |
| Statement of Production Capacity (example for illustration only) | ||
| Production Stage | Unit | Machine |
/ Employee
| / Contractor | Output/year per person, machine etc | Number of Persons, Machines etc | Current Production Commitments |
| (percentage of total capacity) | Available for this |
Contract
| (percentage of total capacity) | Output/year available for this contract | Capacity of average titles available for this contract | |||||||||
| Scanning / text Entry | braille pages | Flatbed scanner | 120,000 | 4 | 15% | 55% | 264,000 | braille pages | 1,100 | (240 br pages/issue) | |
| Scanning / text Entry | braille pages | scanner operator (employee) | 120,000 | 2 | 30% | 50% | 120,000 | braille pages | 500 | (240 br pages/issue) | |
| Translation | braille pages | Duxbury software and certified transcriber (employee) | 30,000 | 3 | 40% | 40% | 36,000 | braille pages | 150 | (240 br pages/issue) | |
| Translation | braille pages | Duxbury software and certified transcriber (contractor) | 24,000 | 6 | 0% | 80% | 115,200 | braille pages | 480 | (240 br pages/issue) | |
| Proofreading | braille pages | certified proofreader (employee) | 24,000 | 7 | 30% | 50% | 84,000 | braille pages | 350 | (240 br pages/issue) | |
| Plates | braille pages | PED & operator (employee) | 24,000 | 2 | 30% | 50% | 24,000 | braille pages | 100 | (240 br pages/issue) | |
| Pressing | braille pages | Heidelberg press and operator (employee) | 2,400,000 | 2.5 | 30% | 50% | 3,000,000 | braille pages | 139 | (72,000 pressed pages/issue) | |
| Embossing | braille pages | Braillo 800 | 1,900,000 | 4 | 50% | 30% | 2,280,000 | braille pages | 106 | (72,000 embossed pages/issue) | |
| Embossing | braille pages | Braillo 300 | 800,000 | 2 | 0% | 80% | 1,280,000 | braille pages | 59 | (72,000 embossed pages/issue) | |
| Collating | braille pages | employee | 1,500,000 | 3.5 | 30% | 50% | 2,625,000 | braille pages | 122 | (72,000 pressed pages/issue) | |
| Binding | volumes | employee | 24,000 | 2 | 30% | 50% | 24,000 | volumes | 40 | (600 volumes/issue) | |
| Shipping | copies | employee | 35,000 | 1 | 20% | 60% | 21,000 | copies | 70 | (300 copies/issue) |
Sheet2
Sheet3
File details come from the government source that posted it. Updated .