Attachment J4 - Production Capacity Form.xlsx

XLSX spreadsheet 17 KB Posted

Attached to
Braille Magazine Transcription and Duplication – Library of Congress
Solicitation number
030ADV25R0039
Issued by

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

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 StageUnitDescription of Machine

/ Employee

/ ContractorOutput/year per person, machine etcNumber of Persons, Machines etcCurrent Production
(percentage of total capacity)Available for this

Contract

(percentage of total capacity)Output/year available for this contractCapacity of average issues available for this contract
Scanning / text Entrybraille pages0%0%0braille pages0(240 br pages/issue)
Translationbraille pages0%0%0braille pages0(240 br pages/issue)
Proofreadingbraille pages0%0%0braille pages0(240 br pages/issue)
Platebraille pages0%0%0braille pages0(240 br pages/issues)
Pressingbraille pages0%0%0braille pages0(72,000 pressed pages/issues)
Embossingbraille pages0%0%0braille pages0(72,000 embossed pages/issues)
Collatingbraille pages0%0%0braille pages0(72,000 pressed pages/issues)
Bindingvolumes0%0%0volumes0(600 volumes/issues)
Shippingcopies0%0%0copies0(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 StageUnitMachine

/ Employee

/ ContractorOutput/year per person, machine etcNumber of Persons, Machines etcCurrent Production Commitments
(percentage of total capacity)Available for this

Contract

(percentage of total capacity)Output/year available for this contractCapacity of average titles available for this contract
Scanning / text Entrybraille pagesFlatbed scanner120,000415%55%264,000braille pages1,100(240 br pages/issue)
Scanning / text Entrybraille pagesscanner operator (employee)120,000230%50%120,000braille pages500(240 br pages/issue)
Translationbraille pagesDuxbury software and certified transcriber (employee)30,000340%40%36,000braille pages150(240 br pages/issue)
Translationbraille pagesDuxbury software and certified transcriber (contractor)24,00060%80%115,200braille pages480(240 br pages/issue)
Proofreadingbraille pagescertified proofreader (employee)24,000730%50%84,000braille pages350(240 br pages/issue)
Platesbraille pagesPED & operator (employee)24,000230%50%24,000braille pages100(240 br pages/issue)
Pressingbraille pagesHeidelberg press and operator (employee)2,400,0002.530%50%3,000,000braille pages139(72,000 pressed pages/issue)
Embossingbraille pagesBraillo 8001,900,000450%30%2,280,000braille pages106(72,000 embossed pages/issue)
Embossingbraille pagesBraillo 300800,00020%80%1,280,000braille pages59(72,000 embossed pages/issue)
Collatingbraille pagesemployee1,500,0003.530%50%2,625,000braille pages122(72,000 pressed pages/issue)
Bindingvolumesemployee24,000230%50%24,000volumes40(600 volumes/issue)
Shippingcopiesemployee35,000120%60%21,000copies70(300 copies/issue)

Sheet2

Sheet3

File details come from the government source that posted it. Updated .