You work for a company called Pro-NET that design and install network solutions. You are required to provide a spreadsheet that will help cost 'individual jobs and provide a summary of completed jobs for the year. Download the instruction sheet and follow all instructions carefully.
PLEASE NOTE:
Do not use any rounding functions in formulas unless specifically requested.
Do not change the values or structure of the workbook in any way, i.e. do not move/add/remove sheets, columns or rows.
Only the contents of the light green cells should be changed and with the exception of the journal names, these should all contain formulas
Formulas should be flexible enough to work with different values and regardless of sort order
Do not create formulas or paste values in cells other than the ones indicated

fx B15 Information Overhead is applied to jobs using a pre-determined rate per direct labour hour based on the following annual budgets: 48,000.00 4 Budgeted overhead 5 Budgeted direct labour hours 6,000 6. 2,50,000.00 7 Job 3820 was invoiced on 26 November for the quoted price of: 10 Journal Accounts 11 Accounts Payable 12 Accounts Receivable 13 Admin Overhead 14 Cost of Goods Sold 15 Finished Goods Inventory 16 Materials Inventory 17 Sales 18 Wages Payable 19 Work in Process Inventory 20 21 22 23 fx B15 Information Overhead is applied to jobs using a pre-determined rate per direct labour hour based on the following annual budgets: 48,000.00 4 Budgeted overhead 5 Budgeted direct labour hours 6,000 6. 2,50,000.00 7 Job 3820 was invoiced on 26 November for the quoted price of: 10 Journal Accounts 11 Accounts Payable 12 Accounts Receivable 13 Admin Overhead 14 Cost of Goods Sold 15 Finished Goods Inventory 16 Materials Inventory 17 Sales 18 Wages Payable 19 Work in Process Inventory 20 21 22 23