Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hamish is building a performance report and wishes to have the amount in the variance column, computed as ACTUAL - BUDGET, expressed as a positive
Hamish is building a performance report and wishes to have the amount in the variance column, computed as ACTUAL - BUDGET, expressed as a positive number. Which function should Hamish use to make sure that all variances are displayed as positive numbers?
1) ABS 2) DECIMAL 3) SUM 4) IF
D VARIANCE E E For U A B 1 ACTUAL BUDGET 2 Sales Revenue: 3 In-house dining $ 795,240 $ 745,000 4 Customer pick-up $ 135,320 $ 130,000 5 Uber Eats $ 57,892 $ 40,000 6 In-house delivery $ 15,670 $ 25,000 7 Food truck sales $ 85,620 $ 75,000 8 Event catering $ 58,720 $ 55,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started