Accounting_Specialist_Assessment_Jan_2024

Task 1 A new project will have regular reimbursable expenses that will be billed to us by work A spreadsheet needs to be set up to track these. Design that spreadsheet using the space below.

kers periodically.

Task 3 Current Rates Language Client Rate QC Rate Margin en-us $ 432.501 $ 350.000 $ 270.000 $ 80.000 19.08% pt-br $ 389.755 $ 296.000 $ 222.000 $ 74.000 24.05% Increased Rates Language Client Rate QC Rate Margin en-us pt-br What is the new margin? Internal Rate (total) Transcriber Rate Internal Rate (total) Transcriber Rate

Task 4 Reconcile the following projects, making sure to indicate if there are any errors. PROJECT DETAILS - NOT RECONCILED Client Language Project TypePricing Category Volume Client Rate Overages Total nl-nl Shortform 28 1,900,432 0.456 0 $866,596.99 tr-tr Shortform 29 800,869 0.387 120 $310,056.30 vi-vn Longform 23 45.6 356.199 500 0 yi-us GCP 26 12.76 566.142 22 $ 4,567.10 TOTAL ### Vendor Language Project TypePricing Category Volume Vendor Rate Overages Total nl-nl Shortform 28 1,909,432 0.312 0 $595,742.78 tr-tr Shortform 29 900,869 0.287 120 $258,669.40 vi-vn Longform 23 2736 3.13 500 $ 9,063.68 yi-us GCP 26 770 5.83 22 $ 4,511.10 TOTAL $867,986.97 PROJECT DETAILS - CORRECTED Client Language Project TypePricing Category Volume Client Rate Overages Total nl-nl Shortform 28 1,900,432 0.456 0 $866,596.99 tr-tr Shortform 29 800,869 0.387 120 $310,056.30 vi-vn Longform 23 45.6 356.199 500 0 yi-us GCP 26 12.76 566.142 22 $ 4,567.10 TOTAL ### Vendor Language Project TypePricing Category Volume Vendor Rate Overages Total nl-nl Shortform 28 1,909,432 0.312 0 $595,742.78 tr-tr Shortform 29 900,869 0.287 120 $258,669.40 vi-vn Longform 23 2736 3.13 500 $ 9,063.68 yi-us GCP 26 770 5.83 22 $ 4,511.10 TOTAL $867,986.97