Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A helloos. Cel Chu X 9. Share Noutral 2. Autosum File Home Insert Page Layout Formulas Data Review View Help Tell me what you want

image text in transcribedimage text in transcribed

A helloos. Cel Chu X 9. Share Noutral 2. Autosum File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do X cut Calin - 11 - A = = - - AA 15 Wapat General Normal Bad | Good Paste Copy Cansitional mata BIU. U- A. = = = Mergo &: Center - $ . * , 42 * Calculation Check CellExplanatory Format Painter Formatting Table Clpen F ront Minnen unbe! Styles AGET GENUINE OFFICE You license in one, and you make a vitim plote counter is intention and her fatherine Office to Get genuine Office Leam more Input Insert Ddete Format Sort & Find a Filter Stect Clear Editing p21 f A B D D E F F G I J K K M N 0 P Q menu $ tot s/cost #sold 700 356 327 498 Onno Std cost 2.25 2 2 2.25 tot s/cost tot sales std cost % 37.5% 40.0% 40.0% 37.5% Food Fried Chicken Kebob Steak Frites Crab Cakes Meatloaf Veggie Pot Pie Turkey Club Cobb Salad Total #sold 1700 987 1289 865 962 988 960 812 menu $ Std cost 11.95 4 9.95 3 15.95 5.4 15.95 4.5 12.95 3.15 11.95 4 4 9.95 3.2 9.95 2.95 tot sales std cost % % 33% 30% 34% 28% 24% 33% % 32% 30% 0.9 2 3 Beer 4 Tsing Tao 5 Stella 6 Lug Tread 7 Creemore 8 9 Spirits 10 Rum 11 Gin 12 Vodka 13 Scotch 14 15 Wine 16 Sauv/Bla 17 Chard 18 Shiraz 19 Cab 20 total 21 22 23 789 654 589 665 ini 0.9 0.9 1.65 18.0% 18.0% 18.0% 27.5% 98 96 123 129 25 30 35 40 10 12 14 40.0% 40.0% 40.0% 40.0% 16 Instructions Feb Inc Stent Feb Menu Mix + Ready 150 helloooooooo.xlsx - Excel File Home Insert Page Layout Formulas Data Review View Help Picture Format Tell me what you want to do X Cut 2 Wrap Text General Nisi Normal Bad De Copy Paste E Merge & Center Conditional Format as Formatting Table. Calculation Check Cell Format Painter Clipboard Font Number Styles Learn more Get genuine Office Alignment O GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Picture 11 | :X fx B H D E F G K M N P 5 Sales 6 Food 7 Beverage 8 9 Cost of Sales 10 Food 11 Beverage 12 13 Salaries & Wages 34% 14 Rent 12500 15 Office & General 6589 16 Utilities 3789 17 Repairs & Maintenance 3654 18 Rest & Kitchen supplies 3298 19 Advertising 3854 20 Professional fees 2500 21 Insurance 1748 22 Entertainment 2000 23 Car 2448 24 25 Net Profit? 26 Net Profit %? 27 Prime cost % for Feb? 28 Potential saving for food for Feb? 29 Potentail saving for beverage for Feb? 30 Net Profit % for Feb? 31 Rent %? 32 Instructions Closing Bev Inventory Feb 28 Closing Bev Inventory Jan 31 Beverage Purchases Closing Food Inventory Feb 28 Closing Food Inventory Jan 31 Food Purchases Food to Bar Bar to Kitchen Staff Meals Staff Beverages 12254 15587 12933 14654 16258 33658 1369 2654 775 852 Feb Inc Stmt Feb Menu Mix + Ready A helloos. Cel Chu X 9. Share Noutral 2. Autosum File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do X cut Calin - 11 - A = = - - AA 15 Wapat General Normal Bad | Good Paste Copy Cansitional mata BIU. U- A. = = = Mergo &: Center - $ . * , 42 * Calculation Check CellExplanatory Format Painter Formatting Table Clpen F ront Minnen unbe! Styles AGET GENUINE OFFICE You license in one, and you make a vitim plote counter is intention and her fatherine Office to Get genuine Office Leam more Input Insert Ddete Format Sort & Find a Filter Stect Clear Editing p21 f A B D D E F F G I J K K M N 0 P Q menu $ tot s/cost #sold 700 356 327 498 Onno Std cost 2.25 2 2 2.25 tot s/cost tot sales std cost % 37.5% 40.0% 40.0% 37.5% Food Fried Chicken Kebob Steak Frites Crab Cakes Meatloaf Veggie Pot Pie Turkey Club Cobb Salad Total #sold 1700 987 1289 865 962 988 960 812 menu $ Std cost 11.95 4 9.95 3 15.95 5.4 15.95 4.5 12.95 3.15 11.95 4 4 9.95 3.2 9.95 2.95 tot sales std cost % % 33% 30% 34% 28% 24% 33% % 32% 30% 0.9 2 3 Beer 4 Tsing Tao 5 Stella 6 Lug Tread 7 Creemore 8 9 Spirits 10 Rum 11 Gin 12 Vodka 13 Scotch 14 15 Wine 16 Sauv/Bla 17 Chard 18 Shiraz 19 Cab 20 total 21 22 23 789 654 589 665 ini 0.9 0.9 1.65 18.0% 18.0% 18.0% 27.5% 98 96 123 129 25 30 35 40 10 12 14 40.0% 40.0% 40.0% 40.0% 16 Instructions Feb Inc Stent Feb Menu Mix + Ready 150 helloooooooo.xlsx - Excel File Home Insert Page Layout Formulas Data Review View Help Picture Format Tell me what you want to do X Cut 2 Wrap Text General Nisi Normal Bad De Copy Paste E Merge & Center Conditional Format as Formatting Table. Calculation Check Cell Format Painter Clipboard Font Number Styles Learn more Get genuine Office Alignment O GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Picture 11 | :X fx B H D E F G K M N P 5 Sales 6 Food 7 Beverage 8 9 Cost of Sales 10 Food 11 Beverage 12 13 Salaries & Wages 34% 14 Rent 12500 15 Office & General 6589 16 Utilities 3789 17 Repairs & Maintenance 3654 18 Rest & Kitchen supplies 3298 19 Advertising 3854 20 Professional fees 2500 21 Insurance 1748 22 Entertainment 2000 23 Car 2448 24 25 Net Profit? 26 Net Profit %? 27 Prime cost % for Feb? 28 Potential saving for food for Feb? 29 Potentail saving for beverage for Feb? 30 Net Profit % for Feb? 31 Rent %? 32 Instructions Closing Bev Inventory Feb 28 Closing Bev Inventory Jan 31 Beverage Purchases Closing Food Inventory Feb 28 Closing Food Inventory Jan 31 Food Purchases Food to Bar Bar to Kitchen Staff Meals Staff Beverages 12254 15587 12933 14654 16258 33658 1369 2654 775 852 Feb Inc Stmt Feb Menu Mix + Ready

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

Introduction To Accounting And Finance

Authors: Geoff Black

2nd Edition

0273711628, 978-0273711629

More Books

Students also viewed these Accounting questions