Localization Academy

Correct & optimize budget

Submitted by Sanida Palavra

on January 27, 2025

Assignment
This challenge tasked students with reviewing and correcting a budget with several issues. Attention to details was required. After that, the students had to figure out how to change the budget in order to fit into the client’s approved amount.
  • budgeting
  • excel
  • finances
My solution

Firstly, I compared rates within the spreadsheet to the rates provided in the description. I fixed a few typos in the rates column. Then, I checked the formulas and ensured those were correct. After that, given all of the limitations, I ran numbers for a few possible scenarios to fit the budget and client constraints and decided to suggest to the client to eliminate the Korean language from the project budget to stay within the approved budget of $10,000. The math and explanation are shown in the attached spreadsheet.