Minimum Version Required: 25.01
Pre-Conditions
Setting 553: Enable Manufacturing, Production Orders & Job Costing = 1, True
Tax Entities exist for the Distilled Spirits Plant (DSP) permit being reported
Tax Entities are properly applied to Product Types for those Products that are participating in DRO reporting.
Steps
Report Foundation:
Calculations are based on data from a chosen Location and its related Tax Entity.
Invoice Load Sheets must be in Loaded, Returned, Balanced or Verified status
Production Orders must be in Confirmed or Verified status
FIFO Adjustment and Inventory Adjustment Invoices created without a Customer TTB Tax Code are omitted.
FORM 5110.28 - MONTHLY REPORT OF PROCESSING OPERATIONS
PART III -PUERTO RICAN AND VIRGIN ISLANDS SPIRITS (RUM) AND "OTHER" IMPORTED RUM¹
48. PROOF GALLONS REMOVED TAXPAID OR TAX DETERMINED
a. PUERTO RICAN SPIRITS: Not Supported
b. VIRGIN ISLANDS SPIRITS: Not Supported
c. "OTHER" IMPORTED RUM: Not Supported
PART IV-PROCESSING OF BEVERAGE (Nonindustrial use) SPIRITS
Note: Columns (c), (e), and (f) are not supported for rows 49 through 65
49. ALCOHOL AND NEUTRAL SPIRITS (Other than vodka):
Bulk (b): Products with Brand TTB Category: NOT Unfinished Spirit and Brand TTB Category: Alcohol and Spirits and Product Types TTB Process Type: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brand TTB Category: Alcohol and Spirits and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
50. BLENDED STRAIGHT WHISKEY
Bulk (b): Products with Brand TTB Category: Non Unfinished Spirit and Brand TTB Category: Straight and Product Types TTB Process Type: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brand TTB Category: Straight and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
51. BLENDED WHISKEY:
a. With neutral spirits:
Bulk (b): Products with Brands TTB Category: Blended Whiskey with Neutral Spirits and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brands TTB Category: Blended Whiskey with Neutral Spirits and ProductTypes.TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
b. With light whiskey:
Bulk (b): Products with Brands TTB Category: Blended Whiskey with Light Whiskey and Product Types TTB Process Category: WIP were consumed through Blending-type Production Orders
Bottled (d): Products with Brand TTB Category: Blended Whiskey with Light Whiskey and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
52. BLENDED LIGHT WHISKEY:
Bulk (b): Products with Brands TTB Category: Light and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brands TTB Category: Light and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
53. ANY OTHER BLENDS OF 100% WHISKEY: Not Supported
54. IMPORTED WHISKEY:
a. Scotch:
Bulk (b): Products with Brands TTB Category: Scotch and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brands TTB Category: Scotch and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
b. Canadian:
Bulk (b): Products with Brands TTB Category: Canadian and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brands TTB Category: Canadian and Product Types.TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
c. Irish and Others:
Bulk (b): Products with Brands TTB Category: Irish and Others and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brands TTB Category: Irish and Others and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
55. DOMESTIC WHISKEY DISTILLED AT 160° AND UNDER:
Bulk (b): Products with Brand TTB Category: Domestic Whiskey at 160 and under and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brand TTB Category: Domestic Whiskey at 160 and under and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
56. DOMESTIC WHISKEY DISTILLED AT OVER 160°:
Bulk (b): Products with Brand TTB Category: Domestic Whiskey over 160 and ProductTypes.TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brand TTB Category: Domestic Whiskey over 160 and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
57. BRANDY DISTILLED AT 170° AND UNDER:
Bulk (b): Products with Brand TTB Category: Brandy at 170 and under and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders.
Bottled (d): Products with Brands.TTB Category: Brandy at 170 and under Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
58. BRANDY DISTILLED AT OVER 170:
Bulk (b): Products with Brand TTB Category: Brandy over 170 and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brand TTB Category: Brandy over 170 and under and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
59. SPIRITS (Rum)
a. Puerto Rican:
Bulk (b): Products with Brand TTB Category: Puerto Rico and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brand TTB Category: Puerto Rico and under and ProductTypes.TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
b. Virgin Island:
Bulk (b): Products with Brand TTB Category: Virgin Islands and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brand TTB Category: Virgin Islands and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
60. RUM
a. Domestic :
Bulk (b): Products with Brand TTB Category: Domestic and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brand TTB Category: Domestic and ProductTypes TTB Process Type: Produced were consumed through Packaging-type Production Orders with ProductTypes TTB Process Type: Bottled
b. "Other" lmported:
Bulk (b): Products with Brand TTB Category3: Other Imported and ProductTypes TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brand TTB Category: Other Imported and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
61. GIN :
Bulk (b): Products with Brand TTB Category: Gin and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brands TTB Category: Gin and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
62. VODKA:
Bulk (b): Products with Brand TTB Category: Vodka and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brand TTB Category: Vodka and ProductTypes TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
63. CORDIALS, LIQUEURS, AND SPECIALTIES:
Bulk (b): Products with Brand TTB Category: Cordials, Liqueurs and Specialties and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brand TTB Category: Cordials ,Liqueurs and Specialties and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
64. COCKTAILS AND MIXED DRINKS :
Bulk (b): Products with Brand TTB Category: Cocktails and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brands TTB Category: Cocktails and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
65. TEQUILA:
Bulk (b): Products with Brand TTB Category 3: TEQUILA and Product Types TTB Process Category: WIP were consumed through Packaging-type Production Orders
Bottled (d): Products with Brands.TTB Category: TEQUILA and Product Types TTB Process Type: Produced were consumed through Packaging-type Production Orders with Product Types TTB Process Type: Bottled
66. Blank
67. TOTAL - LINES 49 THROUGH 66