Accounting // Pounds of Trouble: Analyzing Exchange Rate Variances
Pounds of Trouble: Analyzing Exchange Rate Variances
Author’s Name
Institutional Affiliation
Pounds of Trouble: Analyzing Exchange Rate Variances
One important knowledge to note is that a charge variance is based solely on the difference between the budgeted price and actual price. To analyze this concept, one can understand the exchange variance to observe the difference between budgeted exchange rate and the exchange rate essentially used in disbursing the proof of purchase.
- Static Budget Variance
The static budget variance mentioned in the article for the EAPC Conference is the difference between the original budgets and actual results for the dinner. Based on the given data, the actual attendees reached 1,234. However, the expected number of attendees was 1,220. For example, one can obtain the result of the Static Budget Variance by subtracting the actual spend from the planned budget for each: 1220 – 1234 = -14 (Static Budget Variance). To get the percentate, divide the original budget to estimate the percentage variance considering the actual cost per dinner with EAPC’s budget cost of €60.00 from the actual cost of ₤58.00.
| Actual Attendees | Expected Attendees | Exchange Rates | Budgeted Cost Per Dinner | Actual Cost Per Dinner | Difference |
| 1,234 | 1,220 | €60.00 | £58.00 | ||
| ₤1 = € 1.40346 | €84.21 | € 80.48 | A) € 2.78 | ||
| ₤1 = € 1.38764 | €83.26 | € 80.48 | B) € 2.81 | ||
| 1,234 | 1,220 | ₤81.40068 | £58.00 | ||
| 14 = Difference | Can be A or B | ||||
| 1,234 | |||||
£1.00 = € 1.25789 on December 01, 2014
€ 1.28261 on December 31, 2014
€ 1.38764 on May 19, 2015
€ 1.40346 on May 21, 2015
Therefore, the static budget variance can either be £23.40 or £22.48. However, the dinner costs were invoiced and paid (in euros) on May 21 from EAPC accounts, which would calculate the budget cost per dinner at € 103,912.18 from the actual cost per dinner at €100,448.44. In addition, if the dinner was invoiced and paid on May 21st and if transactions occurred on May 19 but incurred on the day of the event, it would be possible that the EAPC coordinators managed to pay €99,316.17 instead of €102,740.87. Regardless, something was not right. Something was lost, maybe around €3,424.70 or €3,463.74.
- Static Budget Variance, Volume Variance, and a Flexible Budget Variance
Based on analyzing the volume variance, an accounting error or fraud exists in the data and the calculation. The difference between the actual quantity consumed and the budgeted quantity or amount expected to be consumed, multiplied by the standard price per unit. In this case, fraud may exist if the EAPC organizers manage to fabricate the transactions. As this variance measures whether or not businesses generate the amount of unit volume, EAPC organizers may have the chance to manipulate the pricing and conversion or exchange rates. One significant idea to note is that a charge variance is based solely on the difference between the budgeted price and actual price. To analyze this concept, one can study and understand the exchange variance to observe the difference between budgeted exchange rate and the exchange rate actually used in paying the invoice.
- Flexible Budget Variance and Price and Efficiency Variances
To analyze this data, a flexible budget shows different levels of revenue and expenses. For example, one can use the formula: the actual attendees (1, 234) x the actual cost per dinner (€81.40), attaining the result (€100,447.60) for May 19th or dependening on the actual date of payment in the manner of having a receipt (1234) x (€84.21) = (€103, 915.14) on May 21st. However, these levels of revenue and expenses are based on the amount of sales activity that really happens. If actual revenues are inserted into a flexible budget model, this means that any variance will arise between budgeted and actual expenses, not revenues.
- Price Variance, Charge Variance, and Exchange Variance
The variances of these prices, charges, and exchanges compelled other financial experts to think that something bad happened to orchestrate and operate within the transactions. The charge variance would be based solely on the difference between the budgeted price and actual price (€84.21 – €81.40) (Harris, Smith, Swain, & Tayler, 2016, p. 1). What happened in this computation would not be good since these variances called for review and scrutiny. The budget and the currency rate used by the organization reflected questions why the issuance of receipt took place on the 21st of May, not on the 19th of May. The charge variance would simply explain that fraud emerged in the process. Moreover, the difference between the budgeted exchange rate and the exchange rate used in paying the invoice differed, leaving the exchange variance.
- Personal Calculations. The primary source of the problems with the dinner would probably focus on the exchange rates and the current catastrophes of underestimating prices. Some could think that EAPC organizers and members failed to determine the exact budget and that they were responsible for the failure (Harris, Smith, Swain, & Tayler, 2016, p. 1). On the other hand, it would be difficult to pinpoint who was the culprit of the failure. If the EAPC organizers were responsible for the financial dilemma that year, perhaps, their accounting, budget, and financial managers should oversee the exchange rates since these parts would aslo add the probems. The EAPC officials had to consider these ideas to avoid further problems regardless of the exchange rates (Harris, Smith, Swain, & Tayler, 2016, p. 3). On the contrary, something was not right about the transactions. EAPC organizers faced the pounds of trouble to analyze the situations. For example, if EAPC officials did finalize, fix, and negotiate exchange rates, they could transact their businesses free from hassles. .
- An exchange rate variance (ERV) in the case happened due to the use of different currency units for the invoice. The invoice for the acquired item was in a different currency rather than using the currency of the business (Harvey, 1993). As the exchange rates between the two currencies change between the time of purchase of the product orders and the time of voucher of the invoice, the EAPC organizers faced their pounds of trouble explaining what happened. Perhaps, these organizers would use the revenue variance analysis or the daily exchange rate variance to make it favorable. If the situation did not link to any fraud, then the organization could use other exchange rates to avoid further misinterpretations. However, I did not expect to see Duval in the Northwest region conference this August since they was concerned about some major conference failures in London. On the contrary, if EAPC priced the dinners at €60 per plate as the budget, it could extimate its actual cost in August. If the price of dinner cost £58 with 100 attendees, price variance appeared.
References
Harvey, J. T. (1993). Daily exchange rate variance. Journal of Post Keynesian Economics, 15(4), 515-540.
Harris, M. A., Smith, S. D., Swain, M. R., & Tayler, W. B. (2016). Pounds of trouble: Analyzing exchange rate variances. IMA Educational Case Journal, Vol. 9, No. 4, ART. 3, pp. 1-5.
2019/1029