HOW TO REACH E7-F1 IN EXCEL FUNTIONS?

.. . dham41cvk158c.cloudfront.net Unit: ACCG2000 M... Video: VLOOKUP -.. https://dham41cvk... how to use v looku... Excel Timesheet C.. Assignment How to correct a #... Search Results | Co... Course Hero + Menu table. Formula should copy down. E3 In G14 enter a formula to look up the Category for the Menu code in C14 from the 2 Menu table. Formula should copy down. E4 In H14 enter a formula to look up the Cost for the Menu code in C14 and size in E14 W O from the Menu table. Formula should copy down. ES In 114 enter a formula to calculate the Total Cost for that Menu item. Include a check W O in the calculation to see if the menu item is Off Menu, if it is return a cost of 0. (Items with a cost of 0 will automatically highlighted in orange to alert the user that they have selected an item that is not available.) E6 In the labour costs section in H49 enter a calculation to return the name of the day N of the week for the date shown in C49. The formula should copy down. E7 In 149 calculate the labour cost for that labour type and quantity using the values in P O the Cost Overview sheet. (Ensure you apply weekend rates for Saturdays and Sundays. Your calculations must take this into account even if your data does not contain weekend dates as the dates could change.) E8 Overheads are calculated by taking the total overheads (see Cost Sheet) and 2 apportioning them over the days worked in the year (see Cost Sheet). In H65 calculate the difference between the first and last date in C49:C55 to work out how many days they worked on this job. (Do not use NETWORKDAYS as it excludes weekends and the company does work weekends. Do a simple subtraction and then add 1 as Excel assumes midnight to midnight which is not the case.) E9 In 165 use the value in H65 and the overheads information in the Cost Overview O sheet to calculate the production overheads. E10 In D69 calculate the total costs. O E11 In 170 calculate the gross profit margin. 1 Section F The following are to be completed in the Journals Worksheet F1 Complete the journal entries for Job_4155. 6 TOTAL MARKS 78ACCG2000 2020 S2 Assessment Acrobat 8 # iF# 3D F65 X Vfx C D E F G H I M O P Q R S T V W x Z AA AB AC AD AE AF Catering Job Costs Client Parmis Technologies Job Number Contact Hannanch Hojiseyedjavodi 4155 Job Descriptions Conference 2020/8/11 10 12 FOOD COSTS (MATERIALS) 13 Menu Code Quantity Sire Description Category Cost/Unh Total Cost 14 3341 Large Lasagna Vegetarian Mains 63.00 189.0 15 269 Medium Garlic Prawns and Pasta Mains 58 00 58 00 16 1873 Medium Roast Vegetables Mains 30.0 60 07 2257 Large Chicken Coccistore Mains 53.07 53.07 178 WNW Medium Herb Crusted Leg of Lamb Main 65.00 195 00 19 1915 Large Roast Chicken Roll Plotter Main 63.0 189.00 20 1650 Vegetable Kebobs Finger Foods 56 00 112.00 3523 Large Sushi Finger Foods 65.00 195.00 22 2965 Medium Mini Quiches Finger Foods 45.0 90.00 23 1793 2557 Large Foccacia Plotter - Vegetation Finger Foods 63.07 25 3776 Medium Crumbed Calamari Plotter Finger Foods 45.0 45.00 Medium Fresh Seafood Plotter Finger Foods 58.0 174,00 26 2841 45.00 27 2135 Medium Antipasto (Mixed Meat, Cheese and Olive Platte Finger Foods 1350 Finger Foods 28 Medium Lemon Chicken Fingers Platter 34.00 68.00 3693 Large Vegetarian Platter Finger Foods 42.0 42.00 3923 Mini Spring Rolls Finger Foods 57.00 57 07 2518 31 Medium Cheesy Tomato Basil Mussels Finger Foods 41.00 82 00 32 2992 Large Glazed Chicken Bites Finger Foods 56.07 56.00 65 00 98.0 33 1181 Finger Foods 3262 Choose & Herb Potato Croquettes 34 3436 Large Bocconcini Tomato Skewers Salod 47.00 47.00 Medium Garden Green Solod Salod 20 00 35 3810 Medium glads 307 2874 Greek Salad 30 00 Medium Desserts 37 00 37.00 37 1721 Italian Fruit Torte 38 3361 Tiramisu Desserts 56.00 168.0 Desserts 56.00 39 2570 Lemon and Lime Tart 168.00 Large Apple Pie Desserts 41.00 41.00 40 TOTAL FOOD COSTS 2,707.00 47 LABOUR COSTS Date Hours 2020/8/17 Temp Staff Staff Numbe Details/Description Con Temp Chef Prepare Ingredients Monday 50 2120/8/18 Town Chef Prenomtion and Cooking July Job List Cost Overview Client Database Menu JOB_4155 Journals + + 79%ACCG2000 2020 S2 Assessment Acrobat 3D F65 X V fx C D E F G H I J K L M N O P Q R S T 41 42 43 44 TOTAL FOOD COSTS $ 2,707.00 46 LABOUR COSTS Date Temp Staff Staff Numbe Details/Description Hours Day Cost 2020/8/17 Temp Chef Prepare Ingredients Monday 2020/8/18 Temp Chef Preparation and Cooking Tuesday 2020/8/19 Temp Chef Cooking Wednesday 2020/8/19 General Help Set-up at venue Wednesday 2020/8/20 Temp Chef Cooking and Plating Thursday 2020/8/20 Wait Staff Table Service Thursday 21/08/2020 General Help WNNNNE Pack up and clean-up aaboou Friday TOTAL LABOUR $ PRODUCTION OVERHEADS Days Cost TOTAL OVERHEADS SUMMARY TOTAL COST Quoted Price (before GST) $ 12,050.00 Gross Profit Margin (%) 71 73 74 75 July Job List Cost Overview Client Database Menu JOB_4155 Journals + + 116%ACCG2000 2020 S2 Assessment Acrobat 3D B12 X V fx A B C D E F G H I J K L M N O P Q R S T U W N Journal Entries for JOB_4155 5 Account Debit Credit Available Journal Account Accounts Payable 8 Purchase of Direct Materials (on Account) Accounts Receivable Materials Inventory $2,707.00 Manufacturing Overhead 9 Accounts Payable $2,707.00 Cost of Goods Sok 10 Finished Goods Inventory 11 Issue of direct materials to production Materials Inventory 12 Sales 13 Wages Payable 14 Work in Process Inventory 15 Direct labour incurred 16 17 18 19 Overhead applied to production Cost of finished production transferred to Finished Goods store Cost of finished product sold 30 31 August Sales 32 33 34 35 36 37 July Job List Cost Overview Client Database Menu JOB_4155 Journals + + 100%ACCG2000 2020 S2 Assessment Acrobat 8 # iF# My 3D G19 4 X V fx A B C D E F G H I J K L Overhead and Staff Costs Indirect Costs Monthly Annual Weekend Extra: 45% Rent $3,000.00 $36,000.00 Wages for permanent staff $4,500.00 $54,000.00 Temporary Staff Standard Rate Weekend Rate 8 Insurance $245.00 $2,940.00 Temp Chef 68.29 99.0205 Advertising $100.00 $1,200.00 Wait Staff 51.54 74.733 10 Kitchen Equipment $105.00 $1,260.00 General Help 31.37 45.4865 11 Total $7,950.00 $95,400.00 Cleaning Staff 28.2 40.89 12 13 Services and Utilities Monthly Annual 14 Electriricty and Gas $145.00 $1,740.00 15 Internet and Phone $55.00 $660.00 16 POS Fees $40.00 $480.00 17 Total $240.00 $2,880.00 18 Supplies Monthly Annual 20 Cleaning Equipment $91.67 $1,100.00 21 General Kitchen Supplies $162.50 $1,950.00 22 Stationery and Office Suppies $38.75 $465.00 23 Total $292.92 $3,515.00 July Job List Cost Overview Client Database Menu JOB_4155 Journals + + 150%