INSURANCE PLAN - Prompt¶
Dataset 1: Client Profile and Business Summary¶
*This table (visualized as a detailed infographic and pie chart of revenue distribution) contains the core business details.
| Field | Details |
|---|---|
| Client Name | Sarah Barnes |
| Business Type | Bakery/Café |
| Location | Tampa, Florida |
| Number of Employees | 12 |
| Annual Revenue | $850,000 |
| Years in Operation | 8 |
| Key Concerns | Hurricane damage, slip-and-fall liability, workers’ compensation, cyber threats from digital payment systems, cost management |
| Business Premises Details | 2500 sq. ft. storefront with an adjacent kitchen area |
Dataset 2: Risk Management Audit and Safety Reports¶
*This dataset is presented as a series of bar charts and tables showing risk scores and incident frequencies.
| Risk Category | Risk Score (1-10) | Recent Incidents (Past 2 Years) |
|---|---|---|
| Hurricane/Weather Damage | 9 | 2 (minor roof leaks, window damage) |
| Slip-and-Fall Liability | 7 | 4 (employee and customer incidents) |
| Workers’ Compensation | 6 | 3 (non-severe injuries reported) |
| Cybersecurity | 5 | 1 (attempted phishing attack) |
Dataset 3: Florida State Insurance Regulations¶
*This dataset (shown as a text extract with callouts and highlighted clauses) includes excerpts on mandatory coverages and exclusions for businesses in hurricane-prone areas.
Key Excerpts: - Commercial Flood Insurance is not automatically included in standard policies in Florida. - Policies must detail hurricane deductibles and may require additional endorsements for windstorm damage. - Certain coverage limits for workers’ compensation are mandated by state law.
Dataset 4: Premium Cost Benchmarks and Underwriting Quotes¶
*Presented as a table and line graph showing average premium ranges and policy limits for similar small businesses (core coverage quotes vs. add-ons).
| Coverage Type | Recommended Policy Limit | Estimated Annual Premium Range |
|---|---|---|
| Commercial Property | $1.5 million - $2 million | $4,000 - $7,000 |
| General Liability | $1 million per occurrence | $2,500 - $5,000 |
| Workers’ Compensation | Statutory limits | $3,500 - $6,000 |
| Cyber Liability | $500,000 | $1,000 - $2,500 |
| Commercial Flood (Add-on) | $1 million | $1,500 - $3,000 |
| Business Interruption (Add-on) | 3-6 months of revenue coverage | $2,000 - $4,000 |
Dataset 5: Inventory of Bakery Ingredients DS¶
*This dataset (displayed as a colorful bar chart) lists monthly ingredient usage which is not directly relevant to the insurance recommendation.
| Ingredient | Monthly Usage (lbs) |
|---|---|
| Flour | 800 |
| Sugar | 300 |
| Eggs | 500 |
| Milk | 400 |
Dataset 6: Local Market Sales Figures DS¶
*This dataset (visualized as a line graph) shows competitor sales metrics in the local area.
| Month | Competitor A Sales ($) | Competitor B Sales ($) |
|---|---|---|
| Jan | 750,000 | 800,000 |
| Feb | 780,000 | 820,000 |
| Mar | 770,000 | 810,000 |
The analysis must be highly interpretable, transparent in reasoning, and reference dataset elements directly. Specifically:
- Identify necessary core coverages (e.g., Commercial Property, General Liability, Workers’ Compensation) and appropriate limits using dataset references.
- Recommend optional add-on policies relevant to the client's hurricane-exposed environment and cyber risk profile, citing state regulations and risk scores.
- Estimate realistic premium ranges using underwriting quotes, considering the specific business profile and past incidents.
- Propose concrete cost-reduction strategies tied to incident history and Florida-specific compliance requirements.
- Summarize final recommendations with explicit references to the most critical dataset insights.