Answered step by step
Verified Expert Solution
Question
1 Approved Answer
fill in the blanks on this spreadsheet Copy Paste Clipboard Undo A 35 S S S s S S s s S S S S
fill in the blanks on this spreadsheet
Copy Paste Clipboard Undo A 35 S S S s S S s s S S S S S S Font Budget 480,000 550,000 100,000 650,000 670,000 125,000 795,000 145,000 30,000 80,000 92,000 55,000 39,000 441,000 220,000 18,000 70,000 308,000 c 30.1% 20.8% Allgnment 490,000 556,000 102,000 684,000 128,000 144,000 20,000 82,000 91,500 55,000 23,000 220,000 18,000 70,000 Number arjahc (Vftanc 3 4 5 6 7 8 9 Sales Food Total Sales Cost of Sales Food Cost Beverage Cost 10 Total Cost of Goods Sold 11 Gross Profit 12 'Labor 13 Salaries and Wages 14 Employee Benefits 15 'Total Labor Cost 16 Prime Cost 17 Controllable Expenses 18 Direct Operating Expenses 19 Music and Entertainment 20 Marketing 21 'Utilities 22 'General and Administrative 23 ,Repairs and Maintenance 24 Total Controllable Expenses 2S Income before Fixed Costs 26 Fixed Costs 27 Occupancy Costs 28 Interest 29 Depreciation 30 1 Total Fixed Costs 31 Profit Before Taxes 32 Sheetl Edit S S s S s s S S
Step 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