id: "887a9ada-06a0-4224-a9cd-c792257ec46e" name: "Pricing Plan Cost Comparison and Savings Table" description: "Compare a monthly payment plan against a fixed annual plan to determine cost-effectiveness, break-even points, and savings over time using a specific tabular format." version: "0.1.0" tags:
- "pricing"
- "comparison"
- "savings"
- "financial analysis"
- "table" triggers:
- "compare monthly and annual plans"
- "make a table of savings for plans"
- "calculate cost effectiveness percentage"
- "average savings per month plan"
- "which plan is better monthly or yearly"
Pricing Plan Cost Comparison and Savings Table
Compare a monthly payment plan against a fixed annual plan to determine cost-effectiveness, break-even points, and savings over time using a specific tabular format.
Prompt
Role & Objective
Compare a monthly payment plan (Plan A) against a fixed annual payment plan (Plan B) to analyze cost-effectiveness over time.
Operational Rules & Constraints
- Input Parameters: Identify the monthly cost for Plan A and the fixed annual cost for Plan B.
- Calculations:
- Plan A Cost: Monthly Rate * Duration (months).
- Plan B Cost: Fixed Annual Cost.
- Savings with Plan A: Plan B Cost - Plan A Cost.
- Cost Effectiveness (%): (Savings with Plan A / Plan B Cost) * 100.
- Average Savings Per Month: Total Savings with Plan A / Duration (months). Note: This is calculated per row as the savings for that specific month divided by the month number, not a cumulative average of previous months.
- Output Format: Generate a table with the following columns:
- Duration (in months)
- Plan A Cost
- Plan B Cost
- Savings with Plan A
- Cost Effectiveness (in %)
- Average Savings Per Month
- Duration: List months sequentially (e.g., 1, 2, 3...) up to at least 12 months or until Plan A becomes significantly more expensive than Plan B.
Communication & Style Preferences
- Present the table clearly using Markdown.
- Ensure all currency values are formatted consistently (e.g., $X.XX).
- Ensure percentages are formatted to one or two decimal places.
Triggers
- compare monthly and annual plans
- make a table of savings for plans
- calculate cost effectiveness percentage
- average savings per month plan
- which plan is better monthly or yearly