X Assignment 4 - Excel alex duong Share File Home Insert Page Layout Formulas Data Review View Tell me what you want to do. AutoSum & Cut - 11 AA Wrap Text Normal Bad Good Calibri General Fill AY O Insert Delete Format Sort & Find & Paste Copy Format Painter BIU. . QAB= Merge & Center $ ~ % " 00 $.0 Conditional Format as Neutral Calculation Check Cell 2 Clear ~ Formatting * Table 41 Filter - Select - Styles Cells Editing Clipboard Font Alignment Number M60 X Y K M N O P Q R A B D E G H 31 32 Total 96580 102568 105997 99838 119242 144808 302171 122064 106870 102042 92326 86663 1481169 33 34 Expenses age 25179 26825 27565 25964 31148 46251 40550 32228 28484 27227 24626 22693 358740 35 Food Purchases 36 Beverage Purchase- A 1014 1495 1495 428: 4965 6060 56 524 541 4340 3925 3617 65545 Beverage Purchase- NA 1274 1365 1397 1331 1576 1918 1767 1630 1441 1377 1246 1148 17470 37 38 Total Beverage Purchases 5288 586 892 5612 6541 7978 7333 6876 5982 $717 $171 4765 73015 39 Wages 34861 37171 38263 36103 43125 52507 48345 14723 39437 37696 34096 31420 477747 40 Superannuateon 3311 3531 3634 3429 4096 4856 4471 4248 3746 3581 3239 2984 45126 480 4800 480 480 4800 4800 4800 1800 1800 4800 4800 4800 57600 1 Rent Other 7163 7943 828 7319 688 1093 10993 980 8805 8468 7192 5421 103008 42 43 Total 80602 86130 88435 83227 99398 127325 116492 102677 91254 87489 79124 73083 1115236 44 45 Net Profit 15978 6438 17562 16611 19844 17483 185679 19387 15616 14553 13202 13580 365933 46 Profitability Percentages 47 July Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun net profit/total Net Profit % 16.54% 16.03% 16.57% 16.64% 16.64% 12.07% 61.45% 15.88% 14.61% 14.26% 14.30% 15.67% Sales*100 48 Assignment 4 Worksheet + + 110% Ready 2:37 PM Type here to search O D 9 ~ V () ENG 26/10/2020Assignment 4 - Excel X alex duong Share File Home Insert Page Layout Formulas Data Review View Tell me what you want to do. & Cut - 11 AA Wrap Text General Normal Bad Good AutoSum Calibri Fill AY O Paste Copy $ ~ % " 00 .0 Conditional Format as Neutral Calculation Check Cell 41 Insert Delete Format BIU . . LAB= Merge & Center 2 Clear ~ Sort & Find & Filter - Select - Format Painter Formatting * Table Font Alignment Number Styles Cells Editing Clipboard M60 X Y fx M V O P Q R S T U V A B July Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 50 Food Food Cost % 30.51% 30.54% 30.55% 30.53% 30.60% 37.42% 14.36% 31.31% 31.59% 31.82% 31.80% 31.08% purchases/Total Food Sales*100 51 Beverage A Beverage A Cost % 38.50% 40.24% 38.50% 38.49% 38.49% 38.50% 38.50% 38.50% 38.50% 38.50% 38.49% 38.49% purchases/Beverag A Sales*100 52 Beverage NA Cost % 35.11% 38.30% 34.07% 36.38% 34.52% 35.09% 33.00% 53 29.5306 0 Beverage NA 26.40% 26.58% 26.95% |purchases/Beverag e NA Sales*100 Total Beverag Total Beverage Cost % 37.62% 39.77% 37.35% 37.97% 37.45% 37.62% 37.01% 35.91% 35.84% 34.67% 34.74% 34.89% purchases/Total Beverage Sales*100 54 Wage+ Labour Cost % 39.52% 39.68% 39.53% 39.60% 39.60% 39.61% 17.48% 40.12% 40.41% 40.45% 40.44% 39.70% Superannuateon)/ Total Sales $100 55 36.10% 36.10% 36.90% 36.94% 36.26% Wage/ Total Sales Wages Cost % 36.24% 36.16% 36.17% 36.26% 16.00% 36.64% 36.93% $100 56 Superannuateon Cost % 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% Superannuateon/wa ges*100 57 Rent/ Total Sales Rent Cost % 4.97% 4.68% 4.53% 4.81% 4.03% 3.31% 1.59% 3.93% 4.49% 4.70% 5.20% 5.54% $100 58 7:55%e 43.64% 8.24% 8.30% 7.79% 7.41% Other Cost/ Total Other Cost % 7.42% 7.74% 7.81% 7.33% 8.12% 8.03% Sales*100 59 Assignment 4 Worksheet + B - + 90% Ready 2:37 PM Type here to search O D 9 ~ V ( ENG 26/10/2020