Amazon Quick for AnyLab executive decisions and strategy

<role>You are the finance analyst reporting directly to the CEO.</role>
<task>
Using the lab-revenue-monthly dataset, summarise the fiscal year Oct-2025 to Sep-2026:
1. Total revenue and gross margin.
2. The 12-month revenue trend.
3. The two fastest-growing product lines and customer segments, and any that are shrinking (second half vs first half).
</task>
<output_format>
- First line: a one-sentence conclusion for the CEO.
- A line chart of monthly revenue.
- A short table, maximum 6 rows.
- State the dataset and period for every number.
</output_format>
<constraints>Do not estimate anything that is not in the data. If the data is insufficient, say so.</constraints>

• CopyWhich region grew fastest?
• CopyExcluding PCR, how much did revenue grow?

<role>You are the CFO answering the Chair's question on "quality of growth".</role>
<context>The board is concerned that revenue growth comes from low-margin business.</context>
<task>
Build a revenue and gross margin bridge comparing H1 (Oct-2025 to Mar-2026) with H2 (Apr to Sep-2026):
1. Split by product_line and by customer_segment.
2. Show incremental revenue and H2 gross margin % for each group.
3. Identify groups that "grow but dilute total margin" and groups that "grow and lift margin".
</task>
<output_format>A bridge table, a bar chart, and 3 bullet conclusions for the board.</output_format>
<constraints>Calculate margin as gross_profit_thb / revenue_thb. Do not average percentages directly.</constraints>

• CopyWhich segment buys most Wellness Packages?
• CopyIf Wellness margin reached the 36% target, how much gross profit would we add?

<role>You are the Chief Commercial Officer preparing a board paper on government tender pricing.</role>
<task>
1. From lab-revenue-monthly, calculate the average price per test (revenue_thb / tests) for Routine Chemistry in the Government Hospital segment for every month, and this segment's H2 gross margin.
2. From the "Pricing and Contract Policy" document in the Space, extract the floor-price rule and the CFO escalation threshold.
3. State whether the government segment is already below the CFO escalation threshold, and when it would reach the floor if prices keep falling at the current rate.
4. Propose 3 options with pros and cons.
</task>
<output_format>1-paragraph summary, a table, 3 options, and citations to the documents used.</output_format>
<constraints>Clearly separate what comes from data, what comes from policy, and what is an assumption.</constraints>

• CopyIf we skip government bids below 30% margin, how much revenue do we lose?

<role>You are the COO presenting Northeast capacity options to the board.</role>
<context>The board asked for an interim plan, not only a long-term capex request.</context>
<task>
1. From lab-operations-monthly, show utilisation, avg TAT and tat_breach_pct for Khon Kaen Regional Lab over 12 months, compared with the other labs.
2. Read "Capex Proposal - Northeast Lab Capacity" and "TAT SLA and Quality Policy" in the Space.
3. Test each assumption behind Option A's 3.1-year payback: does the data support or contradict it?
4. Compare Options A / B / C, propose a combination if appropriate, and give a first-90-days plan.
5. List affected Northeast key accounts from key-accounts.
</task>
<output_format>Open with a one-sentence recommendation, then a comparison table, an assumption-check table, a 90-day plan and risks.</output_format>
<constraints>Do not conclude beyond the data. If you need more data, say exactly what.</constraints>

• CopyWould Option B breach the 24-hour SLA? Cite the policy.

<role>You are the Chief Commercial Officer preparing a key account risk register for the Audit Committee.</role>
<task>
1. From key-accounts, rank accounts by churn_risk_score and annual revenue; show the top 5.
2. Calculate annual revenue for accounts with churn_risk_score >= 60 and renewal within 90 days.
3. For the #1 account, read the escalation document in the Space and summarise the true root cause and what the customer is asking for.
4. Propose a retention plan that stays within the discount authority in the Pricing and Contract Policy.
</task>
<output_format>A risk register table, the revenue-at-risk figure, and a 1-page retention plan naming the approver.</output_format>
<constraints>State which figures come from the dataset and which statements come from documents.</constraints>

• CopyDraft the reply to the hospital's Medical Director

<role>You are the "Strategy Challenger", an independent strategy advisor to the executive team. Your job is to find the weaknesses in the plan before the board does.</role>
<task>
Read "Strategy FY2027 - Draft v0.9" in the Space, then:
1. Test assumptions A1-A5 one by one against the datasets: supported / contradicted / not yet provable, with numbers.
2. Assess whether the +14% revenue target and 42% gross margin remain realistic if the contradicted assumptions hold.
3. Write the 5 hardest questions the board is likely to ask.
4. Propose 3 changes to the plan.
</task>
<output_format>Assumption table (assumption | evidence | status | impact) → 5 board questions → 3 recommendations</output_format>
<constraints>Be direct. Do not agree to please. Every point needs evidence.</constraints>
<example>A1 "PCR flat" → contradicted: PCR H2 fell vs H1 (insert the actual figure)</example>

• CopyIf we must stop 3 initiatives to fund the pillars, which ones?

<role>You are a strategy analyst for a medical laboratory network in Thailand.</role>
<task>
Research credible public sources (government reports, professional associations, listed-company filings, business media) on:
1. The outlook for clinical laboratory diagnostics in Thailand and ASEAN over the next 3 years.
2. Genetic testing (hereditary cancer, pharmacogenomics, NIPT): players, pricing models, reimbursement.
3. Digital pathology: real adoption in the region and relevant requirements.
4. Regulations that matter, such as PDPA and ISO 15189.
</task>
<output_format>5-bullet executive summary → detail per topic → 3 "implications for our strategy" → source list with dates</output_format>
<constraints>Every number needs a source and year. If sources disagree, show both. Never invent figures.</constraints>

• CopySummarise only competitors offering digital pathology

<role>You are the FP&A lead.</role>
<task>
Create a new Excel file named AnyLab-FY2027-Scenarios.xlsx from lab-revenue-monthly.csv and the assumptions in the Strategy FY2027 document:
- Inputs sheet: growth rate and gross margin per product line, government price change (yellow editable cells).
- Scenarios sheet: Base (per plan), Downside (PCR and government price keep falling at the H2 trend), Upside.
- Summary sheet: revenue, gross profit and GM% per scenario vs the 4.20 bn / 42% targets, plus a chart.
</task>
<validation>Every number in Scenarios/Summary must be a formula referencing Inputs, never a typed value. Check that FY2026 totals match the CSV.</validation>
<edge_cases>Never overwrite an existing file; append the date if the name exists.</edge_cases>

• CopyAdd a scenario: we lose Rattana Hospital

<role>You are the CEO's Chief of Staff.</role>
<task>
Create a new PowerPoint named AnyLab-Board-Pack-Nov2026.pptx for the November 2026 board meeting, answering actions B1-B4 from the Q3 minutes:
1. Executive summary + decisions requested (first slide)
2. FY2026 performance and growth quality (B1)
3. Government tender pricing (B2)
4. Northeast capacity + interim plan (B3)
5. Key accounts at risk (B4)
6. Proposed FY2027 strategy adjustments
</task>
<output_format>Max 10 slides + appendix · slide titles are conclusion sentences · charts from real data · speaker notes on every slide · source footnotes</output_format>
<validation>Check every number against the CSVs before saving · never overwrite an existing file</validation>

• CopyMake an English version for foreign directors

<role>You are the COO.</role>
<task>Write a one-page decision memo as a Word file named AnyLab-Decision-Memo-Northeast.docx on the Northeast capacity options.</task>
<output_format>
Headings: Decision requested (first paragraph) · Situation (3 numbers) · Options considered · Recommendation · Budget and timeline · Risks and mitigation · CEO / CFO signature block
</output_format>
<constraints>Max one A4 page · formal tone · cite sources for numbers · never overwrite an existing file</constraints>

Use the margin-bridge-analyst skill on lab-revenue-monthly.csv, H1 vs H2, by product line and customer segment.

• CopyDo the same by region

Use the capex-proposal-reviewer skill to review 02-khon-kaen-capacity-proposal.pdf against lab-operations-monthly.csv and key-accounts.csv.

• CopyIf Option C is used as a bridge first, how does payback change?

Use the account-retention-planner skill for Rattana Hospital with key-accounts.csv, sales-pipeline.csv and 05-escalation-rattana-hospital.pdf.

• CopyRun the same skill for Isan Karun Hospital

Use the strategy-assumption-tester skill on 01-strategy-fy2027-draft.pdf with all 4 datasets.

Use the board-paper-writer skill to turn the Khon Kaen review above into a Word board paper. Decision requested: approve the Northeast capacity plan with conditions.

• CopyMake it a 6-slide PowerPoint instead

<role>You design workflows for the sales team.</role>
<task>
Create a Flow named "Key Account Renewal Prep" that:
1. Takes input: account name.
2. Pulls the account from key-accounts and its open deals from sales-pipeline.
3. Searches the Space for the Pricing and Contract Policy, the TAT SLA policy and any related escalation.
4. Produces a renewal brief: 6-month service status, open issues, retention offer, proposed discount and the approver required by policy.
</task>
<edge_cases>
- Account not found: say so and suggest the closest names.
- Required discount above 25%: state that CEO + CFO approval is needed and do not promise a price.
- Renewal more than 90 days away: say it is not yet due.
</edge_cases>
<output_format>A 1-page brief starting with "Risk: High/Medium/Low"</output_format>

• CopyTry Isan Karun Hospital

<role>You are the executive assistant preparing the weekly brief.</role>
<trigger>Every Monday at 07:30</trigger>
<task>
From the latest CSV files in the data folder:
1. Labs with tat_breach_pct > 5% or utilisation > 85% (cite the TAT SLA policy).
2. Accounts renewing within 90 days with churn_risk_score >= 60.
3. Pipeline deals expected to close this month, ranked by weighted value.
4. The 3 decisions needed this week.
</task>
<output_format>Save as Exec-Brief-YYYY-MM-DD.md · max one page · red/amber/green signals</output_format>
<edge_cases>If data files are more than 7 days old, warn on the first line · never send email or messages externally without approval</edge_cases>

<role>You design apps for C-level executives.</role>
<task>
Build an app "AnyLab Executive Command Center" with 4 sections:
1. Headline KPIs: FY revenue, GM%, tests, revenue at risk within 90 days.
2. Network health: lab table with utilisation, TAT breach and status colours per the TAT SLA policy.
3. Growth mix: revenue and margin by product line, H1 vs H2.
4. Ask AI box: answers from the datasets and Space documents with citations.
</task>
<constraints>Readable on a tablet · large numbers, max 3 colours · every KPI shows its data date · read-only, never modifies source data</constraints>