Answer All multiple choice question

CajunFast, an independently owned restaurant chain, specializes in Cajun cuisine fast food. Requirements for the Excel analysis 1. Using the Excel file provided in MyLab Accounting, complete the VARIANCE column. Use the absolute reference function so that the variance displays as a positive number. 2. In that same Excel worksheet, complete "F or U" column using the IF function. If the variance in a given row is favorable, an " F " should display in the variance's row in Column E. If the variance is unfavorable, a "U" should display in the variance's row in Column E. 3. Which revenue variances are favorable? 4. Which expense variances are favorable? 5. If the company has a policy that all variances greater than $2,000 should be evaluated, which variances should be investigated? This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the questions until you have asked for assistance from your instructor. Using the Excel file you created for CajunFast, what is the variance of Uber Eats? A. $5,949 B. $28,937 C. $8,427 D. $13,440 Using the Excel file you created for CajunFast, what is the variance of the server wages? A. $5,418 B. $4,030 C. $18,842 D. $16,307 Using the Excel file you created for CajunFast, what is the variance of insurance? A. $1,117 B. $18,842 C. $490 D. $5,477 Using the Excel file you created for CajunFast, which revenue has the largest unfavorable variance? A. In-house delivery B. Food truck sales C. Corporate catering D. In - house dining Using the Excel file you created for CajunFast, which expense has the largest favorable variance? A. Ingredients B. Electricity C. Kitchen wages D. License for truck Using the Excel file you created for CajunFast, how many variances should be investigated if the company has a policy that all variances greater than $2,000 should be evaluated? A. 15 B. 8 C. 18 D. 10