📋 Case Summary
Case Number: 10049
Attorney Case #:
Status: ["Active Case"]
Created: 10/09/2025
Activated: 11/04/2025
PWD Deadline: 06/30/2026 (195 days)
Case Age: 68 days
🏢 Client Information
Company: Andrew Patrick Merron
Beneficiary: ,
Contact: Andrew Merron (Business/Farm Owner)
Phone: 515-320-2305
Email:
FEIN: 56-2306553
NAICS: 112210
💼 Job Details
Job Title: Farm Manager
Salary: $0/year
Experience:
Education:
📍 Location Information
Job Site: 3606 140th Avenue
Bancroft, IA 50517
Company:
,
📊 Case Progress
30% Overall Progress - 5 services tracked
📋 Services Status
Main News
Place Ad
Local
Place Ad
Radio
Place Ad
SWA
Info Request
Online
Pending
🗓️ Key Dates
Ads Approved: 11/04/2025
PWD Deadline: 06/30/2026
PWD Expiry: N/A
News Dates: N/A - N/A
Local Dates: N/A - N/A
Radio Dates: N/A - N/A
SWA Dates: N/A - N/A
🌐 Media Details
Main News: Fort Dodge Messenger (Fort Dodge, IA)
Local: Bancroft Register (Bancroft, IA)
Radio: KSTZ 102.5 FM ()
SWA: Iowa SWA - Iowa Works
Online: Job-Search-Board.com
📝 Notes & Comments
Case Notes:
SWA Comment:
Action Notes:
SWA Comment:
Action Notes:
📊 Financial Summary
TOTAL REVENUE
$1,718
NET PROFIT
$1,435
PROFIT MARGIN
83.5%
💵 Revenue Breakdown
Media Costs (Quote):
$1,718
Service Fee:
$0
TOTAL REVENUE:
$1,718
Actual Media Costs:
$283
NET PROFIT:
$1,435
📈 Service Costs
Main News:
$170
Local News:
$23
Radio:
$90
SWA:
$0
EWP:
$0
JSBP:
$0
Online:
$0
TOTAL COSTS:
$283
🎯 Quick Metrics
Quote Status: ["Converted"]
Case Age: 68 days
Days to Deadline: 195 days
On Track: ✓ Yes
📊 Performance Indicators
Completion:
75%
Budget Status:
On Budget
Timeline Status:
On Time
Risk Level:
Low
