{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","BI Worksheet","Extra Expense","Definitions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Introduction\nThe objective of this worksheet is to support the reporting of accurate business interruption values at the account and/or location level, using standard financial income statements. The Business Income worksheet is constructed using two columns. The first column is the previous fiscal year actual values and the second column is where you enter the estimated values for the policy period beginning on the prospective effective date of the policy and estimating values out for 12 months from that date. Your estimate should be based on both your previous fiscal year results and also overall business conditions and budget/plan.  It is important to be realistic in your projections.  \n\nNote: Enter only positive values for each line item so Excel formulas will work properly. \n\nThroughout the worksheet there are comments provided to assist in explaining various aspects of the worksheet. Red Flag comments can be viewed by placing cursor over the red flag.  This information is designed to assist you as you complete the worksheet. "]
[]
["Section A Net Sales\nNet Sales is the starting point for determining the Business Income value. The Business Income worksheet is a deduction based form where non-continuing expenses are deducted from Sales in sections B and C."]
[]
["Section B Cost of Good Sold\nEnter the estimated 12 month figure for Materials and Direct Labor-Payroll. The “other” categories can be used to capture any additional line items that are not contemplated in the Materials or Direct Labor-Payroll category.  Most expenses in this section will be non-continuing; however you may adjust these expenses by entering the approximate percentage of that line item which will continue during the time of loss."]
[]
["Section C Administration and Operating Expenses\nEnter the estimated 12 month figures for all applicable expenses.  Most expenses will be fixed and continuing; however there are several categories that reflect expenses that may not continue at the time of loss.  Adjust these expenses by entering the approximate percentage that will continue during loss. Use the “other” category to capture additional line items not contemplated in the pre-filled categories."]
[]
["Section D Pre-Tax Income"]
[]
["Section E Limit of Business Income Coverage\nThis section calculates your 12 month limit of business income coverage based on the inputs applied in sections A, B and C. The form defaults to an annual number, but you can adjust the Business Income value for up to 3 years by changing the percentage from 100% (annual) up to 300% (3 year) based on expected level of business interruption exposure. Business Income coverage can be adjusted to the desired amount."]
[]
["Section F Extended Income and Future Earnings\nThe amount calculated is represented as a percentage of the annual Business Income Limit. The Extended Income provision provides a continuation of coverage from the Period of Restoration until the business has regained the same level of business activity that existed prior to the loss. The Future Earnings provision applies to any subsequent loss of income incurred after the period of restoration and extended income period ends. Future Earnings loss of income must occur within two years of the date of the physical loss."]
[]
["Section G Payroll- Direct Labor\nPrefills from section B above.  Default coverage for Payroll-Direct Labor (Ordinary Payroll) provides full coverage of ordinary payroll. Options to limit or exclude Payroll-Direct Labor are included in the drop down in this section where insured’s can select 0 – 90 – 180 days to limit payroll coverage."]
[]
["Section H Extra Expense\nValues for this section prefill once entered in the Extra Expense Tab. There are two columns where your information can be entered in. The first is for one-time expenses and the other for expected re-occurring monthly expenses. Select the number of months EE would be needed to finalize the calculation of extra expense amount needs."]
[]
["Section I Total Business Income Coverage Requested\nProvides the total limit of {Business Income, Payroll – Direct Labor, Extended Income and Future Earnings and Extra Expense) requested from the inputs and compares this to the Unadjusted Business Income Limit {Including Payroll – Direct Labor, Business Income and Extra Expense}. The insurance to value percentage is determined for assistance in developing appropriate rating for exposure."]
[]
["Remember to contemplate seasonality as you complete the worksheet. Additional information on contingency planning and business resiliency can also be provided."]
[]
["Copyright © 2018, Bankers Insurance LLC. All rights reserved."]

{"sheet":"BI Worksheet","index":1,"n_rows":88,"n_cols":11,"rows_kept":88,"cut":false,"hidden":false,"merged":[[81,0,81,8],[2,0,2,8],[4,0,4,2],[4,6,4,7],[16,2,16,3],[74,1,74,6],[36,2,36,3],[37,2,37,3],[68,1,72,7],[17,2,17,3],[6,6,6,8]]}
[]
[]
["Business Income Coverage Worksheet: MANUFACTURING"]
[]
["Name of Insured",null,null,null,null,null,"Effective Date"]
[]
[null,null,null,null,"Last Fiscal Year",null,"Next Fiscal Year"]
[null,null,null,null,"Actual",null,"Estimate","% Continuing During Loss","BI Value"]
["A","Net Sales",null,null,null,null,null,null,{"$f":"G9","v":0}]
["B","Cost of Goods Sold"]
[null,null,"Materials ",null,null,null,null,0,{"$f":"G11*-(1-H11)","v":0}]
[null,null,"Payroll - Direct Labor (see section G below)"]
[null,null,null,"Salaries and Wages"]
[null,null,null,"Employee Benefits"]
[null,null,null,"Employer Payroll Taxes"]
[null,null,null,"Total Ordinary Payroll",{"$f":"SUM(E13:E15)","v":0},null,{"$f":"SUM(G13:G15)","v":0},0,{"$f":"G16*-(1-H16)","v":0}]
[null,null,"Other (not included above - include description)",null,null,null,null,0,{"$f":"G17*-(1-H17)","v":0}]
[null,null,"Other (not included above - include description)",null,null,null,null,0,{"$f":"G18*-(1-H18)","v":0}]
[null,null,"Total Cost of Goods Sold",null,{"$f":"+E11+E16+SUM(E17:E18)","v":0},null,{"$f":"+G11+G16+SUM(G17:G18)","v":0},null,{"$f":"SUM(I11:I18)","v":0}]
["C","Operating and Admin Expenses"]
[null,null,"Payroll - Indirect Labor"]
[null,null,null,"Salaries and Wages"]
["&[Picture]",null,null,"Employee Benefits"]
[null,null,null,"Employer Payroll Taxes"]
[null,null,null,"Total Non-Ordinary Payroll",{"$f":"SUM(E22:E24)","v":0},null,{"$f":"SUM(G22:G24)","v":0},1,{"$f":"G25*-(1-H25)","v":0}]
[null,null,"Professional Services",null,null,null,null,1,{"$f":"G26*-(1-H26)","v":0}]
[null,null,"Repairs and Maintenance",null,null,null,null,1,{"$f":"G27*-(1-H27)","v":0}]
[null,null,"Bad Debts",null,null,null,null,0,0]
[null,null,"Rental Expense",null,null,null,null,0.5,0]
[null,null,"Taxes and Licenses (excluding income tax)",null,null,null,null,1,0]
[null,null,"Interest Expense",null,null,null,null,1,0]
[null,null,"Depreciation & Depletion",null,null,null,null,0.5,0]
[null,null,"Pension, profit-sharing, etc. plans",null,null,null,null,1,0]
[null,null,"Employee benefit programs",null,null,null,null,1,0]
[null,null,"Insurance Expenses",null,null,null,null,1,0]
[null,null,"Utilities",null,null,null,null,0.5,0]
[null,null,"Other (not included above - include description)",null,null,null,null,1,0]
[null,null,"Other (not included above - include description)",null,null,null,null,1,0]
[null,null,"Total Operating and Admin Expenses",null,{"$f":"SUM(E25:E38)","v":0},null,{"$f":"SUM(G25:G38)","v":0},null,{"$f":"SUM(I25:I38)","v":0}]
["D","Pre-tax Income (A-B-C)",null,null,{"$f":"E9-E19-E39","v":0},null,{"$f":"G9-G19-G39","v":0}]
["E","Limit of Business Income Coverage"]
[null,null,"Annual Business Income Value (A+B+C)",null,null,null,null,null,{"$f":"I9+I19+I39","v":0}]
[null,null,"% of Business Income Value Insured",null,null,null,null,null,1]
[null,null,"Total Limit of Business Income Coverage",null,null,null,null,null,{"$f":"I42*I43","v":0}]
["F","Extended Income and Future Earnings"]
[null,null,"Extended Income and Future Earnings - as % of Total Limit Business Income Coverage (section E)",null,null,null,null,null,0]
[null,null,"Total Extended Income and Future Earnings",null,null,null,null,null,{"$f":"I46*I42","v":0}]
["G","Payroll - Direct Labor"]
[null,null,"Payroll - Direct Labor (from Section B above)",null,null,null,{"$f":"G16","v":0}]
[null,null,"Days of Coverage for Payroll",null,null,null,365]
[null,null,"Ordinary Payroll included in Business Income Value",null,null,null,null,null,{"$f":"G49*G50/365","v":0}]
["H","Extra Expense Limit"]
[null,null,"Costs associated with temporary locations/facilities",null,null,null,null,null,{"$f":"SUM('Extra Expense'!I10:I20)+('Extra Expense'!H38)*SUM('Extra Expense'!J10:J20)","v":0}]
[null,null,"Additional Employee Expenses",null,null,null,null,null,{"$f":"SUM('Extra Expense'!I23:I26)+('Extra Expense'!H38)*SUM('Extra Expense'!J23:J26)","v":0}]
[null,null,"Costs incurred for processing or manufacturing externally",null,null,null,null,null,{"$f":"SUM('Extra Expense'!I29:I31)+('Extra Expense'!H38)*SUM('Extra Expense'!J29:J31)","v":0}]
[null,null,"Advertising and Publicity (only reasonable and necessary)",null,null,null,null,null,{"$f":"'Extra Expense'!I34+'Extra Expense'!H38*'Extra Expense'!J34","v":0}]
[null,null,"Other",null,null,null,null,null,{"$f":"'Extra Expense'!I36+'Extra Expense'!H38*'Extra Expense'!J36","v":0}]
[null,null,"Total Extra Expense Limit",null,null,null,null,null,{"$f":"SUM(I53:I57)","v":0}]
[]
["I","Total Limit of Business Income Coverage (E+F+G+H)",null,null,null,null,null,null,{"$f":"I44+I47+I51+I58","v":0}]
[null,null,"Unadjusted Limit of Business Income Coverage with Ordinary Payroll & Extra Expense",null,null,null,null,null,{"$f":"I42+I58+IF(G50=0,I51,G49)","v":0}]
[null,null,"Insurance to Value % (Limit of insurance requested / Unadjusted Business Income limit)",null,null,null,null,null,{"$f":"I60/I61","v":{"$error":"#DIV/0!"}}]
[]
[null,"Seasonality:",null,null,null,null,"Does the account have seasonality to consider?","No"]
[null,null,"If yes, please consider seasonality when determining the appropriate limits."]
[]
[null,"Contingency Planning:",null,null,null,null,"Is there a formal contingency plan in place?","No"]
[null,"If yes, please provide details:"]
[]
[]
[]
[]
[]
[]
["Signature",null,null,null,null,null,null,"Date"]
[]
["This worksheet does not constitute a part of the policy. The purpose of this worksheet is to assist the insured in developing its "]
["desired limit of insurance.  Review or acceptance of this worksheet does not constitute any representation by The Hartford that it"]
["is accurate or properly completed. It does not affect the limit of insurance on the policy. The limits of insurance, terms and "]
["conditions of the policy control and prevail over this worksheet."]
[]
["Copyright © 2018, Bankers Insurance LLC. All rights reserved."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,90]
[null,null,null,null,null,null,null,null,null,null,180]
[null,null,null,null,null,null,null,null,null,null,365]

{"sheet":"Extra Expense","index":2,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,0,45,9],[2,0,2,9],[4,8,4,9],[4,2,4,5],[4,0,4,1],[4,6,4,7],[28,1,28,7],[33,1,33,7],[43,8,43,9],[43,1,43,6],[6,0,6,9],[7,0,7,6]]}
[]
[]
["Extra Expense Worksheet"]
[]
["Name of Insured:",null,null,null,null,null,"Effective Date:"]
[]
["Estimate the additional monthly costs that would be incurred, beyond normal, to remain in operation in the event of an insured business interruption loss. "]
["Extra Expenses following a loss:",null,null,null,null,null,null,null,"One-time Expense","Recurring Monthly Expenses"]
["Costs Associated with temporary locations/facilities:"]
["1.","Rental of temporary premises (includes broker fees/on-site trailers)"]
["2.","Rental of temporary equipment, fixtures, machinery (includes computers)"]
["3.","Expense of moving equipment, etc. to temporary location"]
["4.","Installation of operations at temporary location"]
["5.","Light, power, & heat at temporary location"]
["6.","Maintenance at temporary locations"]
["7.","Telephone & communications at temporary location"]
["8.","Emergency facilities and security costs"]
["9.","Transporting supplies and raw materials to temporary location"]
["10.","Rental and use of cars"]
["11.","Removal or de-installation of operations at temporary location"]
[]
["Additional employee expenses:"]
["&[Picture]","Transportation/travel costs to a temporary location"]
["2.","Lodging and meals cost for temporary location employees"]
["3.","Overtime Costs"]
["4.","Temporary Staffing"]
[]
["Costs incurred for processing or manufacturing externally:"]
["1.","Net amount paid for outsourced processing/manufacturing, minus discontinued costs such as payroll, raw materials, power, etc."]
["2.","Differentials in freight rates from different shipping points"]
["3.","Additional cost of other purchased services"]
[]
["Advertising and Publicity (only reasonable and necessary)"]
["1.","Advertisement Expenses (but not any related to recovery of operations outside the insured restoration period)"]
[]
["Other (list on separate sheet)"]
["TOTALS",null,null,null,null,null,null,null,{"$f":"SUM(I10:I20,I23:I26,I29:I31,I34,I36)","v":0},{"$f":"SUM(J10:J20,J23:J26,J29:J31,J34,J36)","v":0}]
[null,null,null,null,null,null,"Expected TOTAL Period of Interruption (in months)"]
[null,null,null,null,null,null,null,null,"Total Amount of Extra Expenses for Covered Policy Period --->",{"$f":"I37+J37*H38","v":0}]
[]
[]
[]
[]
["Signature",null,null,null,null,null,null,"Date"]
[]
["Copyright © 2018, Bankers Insurance LLC. All rights reserved."]

{"sheet":"Definitions","index":3,"n_rows":54,"n_cols":2,"rows_kept":54,"cut":false,"hidden":false,"merged":[[38,1,38,9],[46,1,46,9],[49,1,49,9],[6,1,6,9],[8,1,8,9],[35,1,35,9],[15,1,15,9],[19,1,19,9]]}
["Definitions of terms used in the BI Worksheet:"]
[]
["Section A","Net Sales"]
[null,"Gross Sales less Sales Taxes, Discounts, Returns, and Prepaid Freight if included in sales"]
[]
["Section B","Materials "]
[null,"Raw Materials: Goods purchased for use as an ingredient or component part of a product.\nIndirect Materials and Supplies: Cost of materials not entering directly into a product.\nExamples: shipping supplies, cleaning supplies, etc.\nConsidered a non-continuing expense"]
[null,"Payroll - Direct Labor (see section G below)"]
[null,"Payroll for employees whose services are not guaranteed under contract or whose services must not necessarily be continued. The cost of this labor should include taxes and charges dependent on the payment of wages."]
[null,"Other (not included above - include description)"]
[null,"Ex: Supplies, outsourcing/contract work, business overhead (continuing and non-continuing), etc."]
[]
["Section C","Payroll - Indirect Labor"]
[null,"Typically considered continuing expense as it reflects the salaried employees"]
[null,"Professional Services"]
[null,"Accounting, Legal, Consulting fees\nTypically a continuing expense"]
[null,"Repairs and Maintenance"]
[null,"Typically a continuing expense, although a portion may be non-continuing"]
[null,"Bad Debts"]
[null,"Typically a non-continuing expense.\nOnly input here if not already excluded in \"Net Sales\" above."]
[null,"Rental Expense"]
[null,"May be continuing or non-continuing depending on the loss situation"]
["&[Picture]","Taxes and Licenses (excluding income tax)"]
[null,"Typically a continuing expense"]
[null,"Interest Expense"]
[null,"Typically a continuing expense"]
[null,"Depreciation & Depletion"]
[null,"May be continuing or non-continuing depending on the loss situation"]
[null,"Pension, profit-sharing, etc. plans"]
[null,"Typically a continuing expense; should follow payroll"]
[null,"Employee benefit programs"]
[null,"Typically a continuing expense"]
[null,"Insurance Expenses"]
[null,"Typically a continuing expense"]
[null,"Utilities"]
[null,"Includes telecommunications, electrical, water, gas, sewer, etc.\nTypically a semi-continuing expense"]
[]
["Section F","Extended Income and Future Earnings"]
[null,"Extended Income:  A continuation of coverage from the Period of Restoration until the business has regained the same level of business activity that existed before the loss.  In essence, this covers the reduction of income from the likely slow startup of the business until productivity and or sales are back to pre-loss levels.\nFuture Earnings:  Future Earnings provides business income coverage for a subsequent loss of income that occurs after the insured’s operations are fully restored to the level that existed before the loss.  Future Earnings provision applies to any subsequent loss of income incurred after the period of restoration and extended income period ends.\n"]
[]
["Section G","Payroll - Direct Labor"]
[null,"Default reflects full annual payroll.  Options to limit or exclude payroll are available in the drop-down."]
[]
["Section I","Total Limit of BI Coverage with Ordinary Payroll & Extra Expense"]
[null,"Selected coverage based on inputs above.  This is the amount used for rating."]
[null,"Unadjusted Limit of BI Coverage with Ordinary Payroll & Extra Expense"]
[null,"Full annual BI amount\nUses the Annual BI Value, Extra Expense, and Direct Labor Payroll"]
[]
[null,"Contingency Planning"]
[null,"Extent of plans to replace property or conduct operations at alternate sites. Note plans for overtime, additional shifts, back up suppliers, agreements with friendly competitors, machinery replacement plans."]
[]
["*Note: these are what are in the comments of cells on the BI Worksheet"]
[]
["Copyright © 2018, Bankers Insurance LLC. All rights reserved."]