# could you help me to work out these instructions and what formulas to use in excel would be greatly

could you help me to work out these instructions and what formulas to use in excel would be greatly appreciated

B C Information 1 2 3 Hourly Wage Rates: 4 Department 5 Engineering 6 Programming 7 Assembly Rate/Hour \$20.00 \$24.00 \$24.00 8 Manufacturing overhead is applied to jobs using a pre-determined factory-wide rate per direct labour hour based on the following annual budgets: 9 \$70,000.00 \$7,400.00 10 Budgeted manufacturing overhe ad 11 Budgeted direct labour hours 12 13 During September Job 4971 was started and completed 14 Job 4971 was invoiced on 18 September for the quoted price of: \$36,000.00 15 16 Journal Accounts 17 Accounts Payable 18 Accounts Receivable 19 Manufacturing Overhead 20 Cost of Goods Sold 21 Finished Goods Inventory 22 Materials Inventory 23 Sales 24 Wages Payable 25 Work in Process Inventory 26 This sheet contains a list of completed jobs for the year. Column B containing the Manger information has been hidden, unhide column B In E4 use a formula to calculate the number of days between date started and date completed. For example, if the job started on the 4th and finished on the 24th of January, the days taken would be 20. Copy the formula down to E24 A1 A2 Change the formatting of Days Taken values to be General (number with no АЗ decimals) In 14:124, use the Man Hours provided along with the information on overheads in the Information sheet, to calculate the manufacturing overhead for each job In J4:J24 calculate the total costs for each job. A4 А5 Widen column J so that all the values are clearly visible. Аб In L4:L24 calculate the profit margin (\$) for each job A7 In M4:M24 calculate the Gross Profit Margin for each job. (Note: in some cases there may be a loss which will give a negative answer.) Format the Gross Profit Margin figures to show as a percentage А8 A9 Convert the data in A3:M24 to a Table. Name the table Jobs. (NB name the table, not the range) A10 B A C E F G н J K L М Completed Job Summary for 2019 1 2 \$Margin 3 Job No. Manager Date Started Date Completed Days Taken Man Hours Material Cost Labour Cost Overhead Total Cost GP Percent Invoice Amount 20/2/19 2/3/19 19/2/19 22/2/19 29/3/19 16/3/19 11/4/19 4/3/19 24/3/19 6/4/19 8/5/19 5/5/19 6/6/19 5/5/19 26/6/19 9/7/19 13/7/19 23/6/19 1/8/19 14/8/19 27/8/19 2/1/19 25/1/19 26/1/19 26/1/19 11/2/19 16/2/19 20/2/19 22/2/19 6/3/19 19/3/19 2/4/19 15/4/19 17/4/19 27/4/19 12/5/19 5/6/19 7/6/19 13/6/19 26/7/19 1/8/19 3/8/19 \$77,077.00 \$71,352.00 \$31,104.00 \$25,974.00 \$18,032.00 \$105,570.00 \$79,110.00 4 Martin JOB_4950 784 \$6,974.00 \$11,520.00 \$7,128.00 5 JOB_4951 317 Toni \$53,280.00 6 JOB_4952 Martin 384 7 JOB_4953 \$42,040.00 Toni 324 8 JOB_4954 9 JOB_4955 \$43,930.00 \$16,008.00 \$56,940.00 Amir 552 381 \$55,356.00 \$8,763.00 \$61,550.00 Amir 10 JOB_4956 11 JOB 4957 12 JOB 4958 13 JOB_4959 14 JOB_4960 15 JOB_4961 \$49,200.00 \$13,730.00 \$17,154.00 \$29,682.00 \$46,152.00 \$16,720.00 \$2,400.00 \$6,993.00 \$7,511.00 \$9,504.00 \$85,700.00 \$19,030.00 \$28,250.00 \$40,540.00 Amir 760 Martin 120 Toni 259 259 Toni \$55,660.00 \$40,710.00 \$132,710.00 \$14,880.00 Amir 432 \$25,480.00 \$11,200.00 Amir 400 16 JOB_4962 17 JOB_4963 18 JOB_4964 19 JOB_4965 \$93,150.00 \$12,896.00 \$84,1 50.00 \$19,320.00 Toni 920 \$1,980.00 90 Amir \$19,656.00 \$109,000.00 Amir 756 \$58,310.00 \$13,230.00 \$10,881.00 \$4,480.00 \$70,110.00 \$51,590.00 490 Amir 20 JOB_4966 21 JOB_4967 22 JOB_4968 23 JOB 4969 24 JOB_4970 \$37,332.00 Amir 403 \$14,970.00 \$25,670.00 Toni 160 \$9,370.00 \$7,146.00 \$1,296.00 Toni 48 \$14,768.00 \$4,050.00 \$22,020.00 \$55,980.00 Toni 135 \$40,344.00 \$7,500.00 Toni 250 25

### Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now
0 replies