Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

asap plz SouthFast, an independently owned restaurant chain, specializes in Southern cuisine fast food. Following is a partial performance report that as (Click the icon

asap plz
image text in transcribed
image text in transcribed
SouthFast, an independently owned restaurant chain, specializes in Southern cuisine fast food. Following is a partial performance report that as (Click the icon to view the partial performance report.) Read the requirements. 1. What formula would be entered in Cell D3 to calculate the difference between the ACTUAL total in Cell 83 and the BUDGET fotal in Cell C3? Partial performance report A B D E For U F F F U F U 8 F 1 ACTUAL BUDGET VARIANCE 2 Sales Revenue: 3 In-house dining $ 800,671 $ 741,000 $ 59,671 4 Customer pick-up $ 140,198 $ 124,000 $ 16,198 Uber Eats $ 65,394 $ 73,000 $ $ 7,606 6 In-house delivery $ 22,514 $ 22,000 $ 514 7 Food truck sales $ 94,209 $ 105,000 $ 10,791 Event catering $ 64,334 $ 51,000 $ 13,334 9 Expenses: 10 Ingredients $ 735,975 $ 750,000 $ 14,025 11 Server wages $ 140,656 $ 136,000 $ 4,656 12 Kitchen wages 48,138 $ 52,000 $ 3,862 13 Manager salary $ 12,716 $ 16,000 $ 3,284 14 Credit/debit card fees $ 43,275 $ 44,000 $ 725 15 Restaurant lease $ 12,684 $ 2,000 $ 10,684 16 Advertising 13,364 $ 6,000 $ 7,364 17 Lease/gas on trucks 9,228$ 12,300 $ 3,072 18 Insurance S 8.48415 1.500ls 6.984 F U $ F TI F on AWN F U U $ $ F F Print Done

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

Step: 3

blur-text-image

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

Accounting Information Systems Understanding Business Processes

Authors: Brett Considine, Alison Parkes, Karin Olesen, Michael Lee, Derek Speer

3rd Edition

1742165559, 978-1742165554

More Books

Students also viewed these Accounting questions