Pharma Dosage Financial Analysis

I have a set of raw pharmaceutical data and I need it transformed into a clear, reliable financial analysis that hinges on accurate drug-dosage calculations. The goal is to understand how each dosage choice affects overall cost and profitability, so the numbers have to be airtight.

Here’s what the job looks like from my side:
• Source data: prescription-level, pharmacy-supply figures (Data farmasi).
• Core task: run precise Penghitungan dosis obat, then fold those results into a concise Analisis keuangan.
• Preferred tools: Excel for all number-crunching; if you lean on Python, R, or Power BI to streamline the workflow, that’s fine as long as the final model lives in an easy-to-audit spreadsheet.

Deliverables I need to see:
1. An Excel file with every dosage calculation, the underlying formulas left visible.
2. A short written summary (Word or PDF) translating those figures into actionable financial insights—margin per dose, break-even points, any red flags.
3. Optional but welcome: a quick Canva or similar visual highlighting the key findings for non-technical stakeholders.

Accuracy and clarity trump speed. Please outline your approach to validating dosage math and linking it to the financial metrics when you reply.