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.

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

aste B I UV UVAv .00 Cell Styles v Format v Editing 16 X V fx 6% A B C E G H K L M N O Pro-NET Completed Job Summary for 2018 Total Revenue Date Quoted Price Job No. Started Date Completed Location Production Price Before Discount Amount less discount) Discount % Gross Profit Material Cost Labour Cost Overhead COGS Discount JOB_3799 04/03/19 14/03/19 $ Sydney Margin % $32,350.00 6% $25,320.86 $2,391.61 $640.00 JOB_3800 08/04/19 17/04/19 Sydney $50,950.00 4% $39,354.71 $3,194.57 $576.00 JOB_3801 19/03/19 31/03/19 Melbourne $19,300.00 7% $13, 717.30 $1,664.28 $768.00 JOB_3802 18/04/19 27/04/19 Sydney $64,250.00 4% $45,161.93 $5,037.98 $576.00 JOB_3803 08/04/19 21/04/19 Sydney $30,450.00 3% $16,760.16 $2,239.10 $832.00 JOB_3804 08/04/19 21/04/19 Perth $22,200.00 8% $12,018.55 $1,114.30 $832.00 JOB_3805 25/04/19 14/05/19 Perth $43,800.00 5% $24,433.85 $2,611.66 $1,216.00 JOB_3806 21/05/19 03/06/19 Melbourne $64,400.00 8% $56,197.44 $5,477.47 $832.00 JOB_3807 28/04/19 06/05/19 Sydney $26,150.00 6% $14,022.84 $1,849.50 $512.00 JOB_3808 08/06/19 18/06/19 Perth $75,300.00 3% $46,018.56 $5,776.82 $640.00 JOB_3809 04/06/19 19/06/19 Perth $42, 700.00 7% $23,950.59 $2,263.02 $960.00 JOB_3810 07/07/19 19/07/19 Melbourne $2,69,00 3% $1,53,384.98 $36,548.76 $768.00 JOB_3811 02/06/19 15/06/19 Perth $9,500.00 4% $6,096.38 $862.22 $832.00 JOB_3812 24/06/19 29/06/19 Perth $35,800.00 6% $21,848.40 $2,467.48 $320.00 JOB_3813 05/08/19 22/08/19 Sydney $57,850.00 7% $52,295.76 $4,731.48 $1,088.00 JOB_3814 09/08/19 15/08/19 Perth $38,000.00 6% $28,724.68 $3,168.20 $384.00 JOB_3815 23/08/19 29/08/19 Melbourne $46,700.00 5% $38,265.70 $4,493.28 $384.00 JOB_3816 04/08/19 24/08/19 Perth $19,400.00 8% $12,899.14 $1,632.96 $1,280.00 JOB_3817 07/10/19 21/10/19 Melbourne $51,650.00 6% $38,880.27 $4,228.22 $896.00 JOB_3818 26/09/19 11/10/19 Perth $14,450.00 5% $9,607.84 $793.07 $960.00 JOB_3819 22/10/19 26/10/19 Sydney $75,050.00 6% $54,093.31 $5,176.08 $256.00