Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

All the parts need to be answered Funberry Amusements is an owner/operator of several amusement parks. Following is a performance report that a Funberry manager

All the parts need to be answeredimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Funberry Amusements is an owner/operator of several amusement parks. Following is a performance report that a Funberry manager built in Excel. (Click the icon to view the performance report.) Read the requirements. 1. What formula would be entered in Cell D3 to calculate the difference between the ACTUAL total in Cell B3 and the BUDGET total in Cell C3? 2. How would the formula in Question 1 be modified to make the result in Cell D3 an absolute value? 3. What steps would be performed in Cell E3 to display an "F" if the variance in Cell D3 is favorable and a "U" if the variance is unfavorable? A. Select Cell E3. Click on the Formulas tab on the Ribbon, then click the drop-down arrow below Logical and select TRUE. Type D3>0 in the Logical Test field, Type F in the Value if True field, and Type U in the Value if False field. B. Select Cell E3. Click on the Formulas tab on the Ribbon, then click the drop-down arrow below Text and select VALUE. Type B3>=C3 in the Logical Test field, Type F in the Value if True field, and Type U in the Value if False field. C. Select Cell E3. Click on the Formulas tab on the Ribbon, then click the drop-down arrow below Logical and select IF. Type B3>=C3 in the Logical Test field, Type F in the Value if True field, and Type U in the Value if False field. Performance report Performance report Requirements Using the performance report shown, answer the following questions. 1. What formula would be entered in Cell D3 to calculate the difference between the ACTUAL total in Cell B3 and the BUDGET total in Cell C3? 2. How would the formula in Question 1 be modified to make the result in Cell D3 an absolute value? 3. What steps would be performed in Cell E3 to display an "F" if the variance in Cell D3 is favorable and a "U" if the variance is unfavorable? 4. How could the contents of Cells D3 and E3 be copied to the remaining rows containing revenues? 5. How would the steps for calculating the "F" or "U" for expenses differ from the steps for "F" or "U" for revenues? 6. Specify the formula that would be entered in each of the following cells: a. Cell B9 to calculate ACTUAL total sales revenue b. Cell C9 to calculate BUDGET total sales revenue c. Cell D9 to calculate VARIANCE for total sales revenue d. Cell B23 to calculate ACTUAL operating income e. Cell C23 to calculate BUDGET operating incomes f. Cell D23 to calculate the VARIANCE for operating income 7. What steps would be performed in cell E23 to display an "F" if the variance in cell D23 is favorable and a "U" if the variance is unfavorable

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Hotel Finance

Authors: Anand Iyengar

1st Edition

0195694465, 978-0195694468

More Books

Students also viewed these Finance questions

Question

=+Is this metric really applicable to what I want to accomplish?

Answered: 1 week ago

Question

=+How does this metric connect to my objectives?

Answered: 1 week ago