DA$18\mathrm{.}1$ Data analytics can be used to evaluate performance against targets.

Problem

Rafe's Restaurant has recently had difficulty with low sales and low profits. Management has decided to implement a balanced scorecard. The company has designed a card with four perspectives with two measures within each perspective. Managers from the respective departments have established targets. Rafe wants to see an analysis of where the company stands as it relates to the targets. Management has gathered the respective data on performance during each quarter of the past year.

$\backslash$table$[[$Targets and actual performance for the past four quarters by perspective,,,,$],[$Financial Perspective$],[$Objectives$,$Initiatives,Measures,Targets,Actual Q$1,$Actual Q$2,$Actual Q$3,$Actual Q$4],[$Increase revenues,Serve more customers,Total revenue,$$1,250,000,$$$750,000,$$$745,000,$$$850,000,$$$875,000$