BDO FMA budget worksheet for personnel expenses, detailing full-time and part-time staff allocations across various programs and departments.

It looks like you've uploaded a BDO FMA (Financial Management Application) Budget Worksheet template, specifically the "Budget Worksheet" tab. The task appears to be related to entering budget data into the yellow cells, as indicated by the instruction: *"Enter data into yellow cells only."*

However, no actual data has been entered yet, and there's no specific question or problem stated in your message.

Let me walk through what this worksheet is for and how to use it properly — this will help you understand how to solve the task if you're supposed to fill it out.

---

🔍 Understanding the Worksheet

This is a nonprofit or organizational budgeting tool used to allocate personnel costs across different programs and functional areas (like administration, fundraising, etc.).

#### Key Components:
1. Personnel Section
- Divided into Full Time and Part Time staff.
- For each employee:
- `% of full time` – e.g., 100% for full-time, 50% for half-time.
- Budget column – where you enter salary/wage amounts.
- Then allocation percentages across Programs 1–7, Administration, Fundraising.
- Total % must sum to 100% per person.

2. Fringe Rates
- You are prompted to enter fringe rates for:
- Full-Time Staff (cell B10)
- Part-Time Staff (cell B66)
- Fringe benefits include health insurance, retirement, payroll taxes, etc.
- These are typically expressed as a percentage of salary.

3. Totals
- The sheet calculates:
- Total Full Time Salaries/Wages
- Total Full Time Fringe
- Similar totals for part-time
- And allocates them across programs based on the percentage allocations.

4. Yellow Cells
- As instructed, only enter data in yellow cells.
- This includes:
- Position names (column A)
- % of full time (column B)
- Salary amount (column C)
- Allocation percentages (% in columns D through Q)
- Fringe rate inputs (B10 and B66)

---

✔ How to Use This Template

#### Step-by-Step Instructions:

1. Enter Fringe Rates
- In cell B10: Enter the fringe benefit rate for full-time staff (e.g., 30%).
- In cell B66: Enter the fringe rate for part-time staff (e.g., 25%).

2. List Staff Positions
- In column A (under "Full Time"), list all full-time positions.
- In column B, enter the percentage of full-time effort (usually 100%, but could be less).
- In column C, enter the annual salary for each position.

3. Allocate Time Across Programs
- In columns D through Q (Program 1 to Fundraising), enter the percentage of time each staff member spends on each program.
- Example: If an employee works 50% on Program 1 and 50% on Administration, enter 50% in both columns.
- Ensure that the total percentage across all categories equals 100%.

4. Repeat for Part-Time Staff
- Do the same below the "Part Time" section.

5. Let Excel Calculate
- The formulas will automatically calculate:
- Total salaries
- Fringe costs
- Allocations to each program
- Grand totals

---

🧮 Example Calculation

Suppose:
- Employee: Director of Program 1
- Salary: $80,000
- 100% full-time
- Works 70% on Program 1, 30% on Administration

You would enter:
- Cell A12: "Director of Program 1"
- Cell B12: `100%`
- Cell C12: `$80,000`
- Cell D12: `70%`
- Cell J12: `30%`

Then the system will:
- Allocate $56,000 to Program 1 (70% × $80,000)
- Allocate $24,000 to Administration (30% × $80,000)
- Add fringe (e.g., 30%) to both

---

⚠️ Important Notes

- Do not edit non-yellow cells — they contain formulas.
- Make sure your total percentages per row add up to 100%.
- Check that fringe rates are accurate for your organization.
- The "SUPPLEMENT--Fringe Calculation" tab may have more detailed breakdowns — refer to it if needed.

---

❓ What Is the Task?

Since you said “solve the problem,” but didn’t specify one, here are possible interpretations:

#### Possible Tasks:
1. Fill out sample data for a hypothetical organization.
2. Calculate fringe costs given a fringe rate.
3. Allocate a staff member’s time across programs.
4. Identify errors in the current setup (but currently it's blank).

If you can provide:
- Specific instructions
- Sample data
- Or a particular question (e.g., “How do I allocate a part-time staff member?”)

I can give a detailed solution tailored to your needs.

---

✔ Final Answer Summary

> To complete this worksheet:
>
> 1. Enter fringe rates in B10 (full-time) and B66 (part-time).
> 2. List positions in column A.
> 3. Enter % of full time in column B.
> 4. Enter salary in column C.
> 5. Distribute time percentages across programs (D to Q).
> 6. Ensure each row sums to 100%.
> 7. Only input data in yellow cells — others are formulas.

Would you like me to fill in a sample scenario? For example, adding two staff members with allocations? Let me know!