Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the SCF and Rations.. Paulo's Cucina Paulo's Cucina Comparitive Balance Sheets Actual 12/31/2020 $ Prior Yr. 12/31/2019 $ % of Sls % of

What is the SCF and Rations..

image text in transcribedimage text in transcribedimage text in transcribed

Paulo's Cucina Paulo's Cucina Comparitive Balance Sheets Actual 12/31/2020 $ Prior Yr. 12/31/2019 $ % of Sls % of Sls 12/31/2020 12/31/2019 12/31/2018 Assets Food Sales Wine/Beer Sales Liquor Sales Catering Sales Total Sales $3,520,000 756,000 285,000 498,000 5,059,000 69.6% $3,460,000 14.9% 722,000 5.6% 274,000 9.8% 435,000 100.0% 4,891,000 70.7% 14.8% 5.6% 8.9% 100.0% Cash Accounts Receivalble Food Inventory Wine Inventory Liquor Inventory Total Inventories Prepaid Assets Current Assets $282,005 75,000 25,000 40,000 8,000 73,000 45,000 475,005 $381,500 50,000 19,500 39,500 6,500 65,500 25,000 522,000 $189,000 35,000 20,500 38,500 7,000 66,000 20,000 310,000 Food Cost Wine/Beer Cost Liquor Cost Catering Cost of Goods Total Cost of Goods 968,000 247,212 57,000 128,700 1,400,912 27.5% 32.7% 20.0% 25.8% 27.7% 958,420 234,500 61,650 121,800 1,376,370 27.7% 32.5% 22.5% 28.0% 28.1% Plant Property and Equip - Net Other Long-Term Assets Total Long-Term Assets 2,168,000 125,000 2,293,000 1,678,000 125,000 1,803,000 2,128,000 125,000 2,253,000 Labor Costs Kitchen Labor Front of House Management 359,189 505,900 362,000 7.1% 10.0% 7.2% 355,800 505,000 353,000 7.3% 10.3% 7.2% Total Assets $2,768,005 $2,325,000 $2,563,000 H M Total Assets $2,768,005 K $2,325,000 $2,563,000 A Front of House Management Total Payroll Payroll Related Total Labor B 505,900 362,000 1,227,089 347,338 1,574,427 10.0% 7.2% 24.3% 6.9% 31.1% F 505,000 353,000 1,213,800 335,400 1,549,200 G 10.3% 7.2% 24.8% 6.9% 31.7% Liabilities and Stockholder's Equity Current Liabilities Prime Costs 2,975,339 58.8% 2,925,570 59.8% 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Accounts Payable Accrued Expenses Current Maturities of Long-Term Debt Current Liabilities $35,000 15,000 145,000 195,000 $25,000 25,000 125,000 175,000 $30,500 22,000 125,000 177,500 Supplies Outside Services Repairs and Maint. Utilities Smallwares Total Controllable 77,493 151,600 59,300 145,000 21,400 454,793 1.5% 3.0% 1.2% 2.9% 0.4% 9.0% 78,500 155,400 57,600 139,600 20,000 451,100 1.6% 3.2% 1.2% 2.9% 0.4% 9.2% Long-Term Debt 1,375,000 1,250,000 1,375,000 Total Liabilities 1,570,000 1,425,000 1,552,500 Controllable Earnings 1,628,868 32.2% 1,514,330 31.0% Common Stock Retained Earnings Total Owner's Equity 950,000 248,005 1,198,005 750,000 150,000 900,000 800,000 210,500 1,010,500 Credit Card Charge Advertising/Promo Non-Controllables 96,799 145,000 241,799 1.9% 2.9% 4.8% 98,400 123,500 221,900 2.0% 2.5% 4.5% Total Liabiltiies and Owner's Equity $2,768,005 $2,325,000 $2,563,000 248,000 175,000 59,800 482,800 4.9% 3.5% 1.2% 9.5% 196,800 193,000 55,000 444,800 4.0% 3.9% 1.1% 9.1% $904,269 280,574 $623,695 17.9% 5.5% 12.3% $847,630 263,000 $584,630 42 43 Rent 44 Depreciation 45 Other 46 Occupancy 47 48 Pre-Tax 49 Taxes 50 Net Income 51 52 Number of Shares Outstanding 53 Stock Price 54 55 Hotel Information 56 355 Room Hotel 57 Room Revenue 58 Room Nights 59 17.3% 5.4% 12.0% 300,000 $15.50 290,000 $14.00 $13,751,906 108,843 $13,423,360 111,434 Paulo's Cucina Paulo's Cucina Comparitive Balance Sheets Actual 12/31/2020 $ Prior Yr. 12/31/2019 $ % of Sls % of Sls 12/31/2020 12/31/2019 12/31/2018 Assets Food Sales Wine/Beer Sales Liquor Sales Catering Sales Total Sales $3,520,000 756,000 285,000 498,000 5,059,000 69.6% $3,460,000 14.9% 722,000 5.6% 274,000 9.8% 435,000 100.0% 4,891,000 70.7% 14.8% 5.6% 8.9% 100.0% Cash Accounts Receivalble Food Inventory Wine Inventory Liquor Inventory Total Inventories Prepaid Assets Current Assets $282,005 75,000 25,000 40,000 8,000 73,000 45,000 475,005 $381,500 50,000 19,500 39,500 6,500 65,500 25,000 522,000 $189,000 35,000 20,500 38,500 7,000 66,000 20,000 310,000 Food Cost Wine/Beer Cost Liquor Cost Catering Cost of Goods Total Cost of Goods 968,000 247,212 57,000 128,700 1,400,912 27.5% 32.7% 20.0% 25.8% 27.7% 958,420 234,500 61,650 121,800 1,376,370 27.7% 32.5% 22.5% 28.0% 28.1% Plant Property and Equip - Net Other Long-Term Assets Total Long-Term Assets 2,168,000 125,000 2,293,000 1,678,000 125,000 1,803,000 2,128,000 125,000 2,253,000 Labor Costs Kitchen Labor Front of House Management 359,189 505,900 362,000 7.1% 10.0% 7.2% 355,800 505,000 353,000 7.3% 10.3% 7.2% Total Assets $2,768,005 $2,325,000 $2,563,000 H M Total Assets $2,768,005 K $2,325,000 $2,563,000 A Front of House Management Total Payroll Payroll Related Total Labor B 505,900 362,000 1,227,089 347,338 1,574,427 10.0% 7.2% 24.3% 6.9% 31.1% F 505,000 353,000 1,213,800 335,400 1,549,200 G 10.3% 7.2% 24.8% 6.9% 31.7% Liabilities and Stockholder's Equity Current Liabilities Prime Costs 2,975,339 58.8% 2,925,570 59.8% 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Accounts Payable Accrued Expenses Current Maturities of Long-Term Debt Current Liabilities $35,000 15,000 145,000 195,000 $25,000 25,000 125,000 175,000 $30,500 22,000 125,000 177,500 Supplies Outside Services Repairs and Maint. Utilities Smallwares Total Controllable 77,493 151,600 59,300 145,000 21,400 454,793 1.5% 3.0% 1.2% 2.9% 0.4% 9.0% 78,500 155,400 57,600 139,600 20,000 451,100 1.6% 3.2% 1.2% 2.9% 0.4% 9.2% Long-Term Debt 1,375,000 1,250,000 1,375,000 Total Liabilities 1,570,000 1,425,000 1,552,500 Controllable Earnings 1,628,868 32.2% 1,514,330 31.0% Common Stock Retained Earnings Total Owner's Equity 950,000 248,005 1,198,005 750,000 150,000 900,000 800,000 210,500 1,010,500 Credit Card Charge Advertising/Promo Non-Controllables 96,799 145,000 241,799 1.9% 2.9% 4.8% 98,400 123,500 221,900 2.0% 2.5% 4.5% Total Liabiltiies and Owner's Equity $2,768,005 $2,325,000 $2,563,000 248,000 175,000 59,800 482,800 4.9% 3.5% 1.2% 9.5% 196,800 193,000 55,000 444,800 4.0% 3.9% 1.1% 9.1% $904,269 280,574 $623,695 17.9% 5.5% 12.3% $847,630 263,000 $584,630 42 43 Rent 44 Depreciation 45 Other 46 Occupancy 47 48 Pre-Tax 49 Taxes 50 Net Income 51 52 Number of Shares Outstanding 53 Stock Price 54 55 Hotel Information 56 355 Room Hotel 57 Room Revenue 58 Room Nights 59 17.3% 5.4% 12.0% 300,000 $15.50 290,000 $14.00 $13,751,906 108,843 $13,423,360 111,434

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

Payroll Accounting 2021

Authors: Bernard J. Bieg, Judith A. Toland

31st Edition

0357358287, 9780357358283

More Books

Students also viewed these Accounting questions

Question

business industry overview for solar panel

Answered: 1 week ago

Question

Whats My Comfort with Change?

Answered: 1 week ago