Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

hi, I want to now why I got same number for all my GP percent here? wanna know the formula N4 X =(M4/B4)*100 A B

hi, I want to now why I got same number for all my GP percent here? wanna know the formula

image text in transcribed
N4 X =(M4/B4)*100 A B D E F G H K M N O P Q R W N Job No. Amount Quoted Date Completed Date Due Days Late Material Cost Labour Cost Overhead Cost Before Penalties Penalties Total Cost Margin | GP Percent Jobs Quoted Summary 4 JOB_4570 $20,340.00 9/01/2020 7/01/2020 2 $9,245.45 $2,773.64 $2,471.21 $14,490.30 $244.08 $9,489.53 $10,850.47 $ 53.35 Total $636,110.00 5 JOB_4571 $22,140.00 14/01/2020 16/01/2020 0 $10,063.64 $2,616.55 $2,305.20 $14,985.39 $265.68 $10,329.32 $11,810.68 $ 53.35 Maximum $66,780.00 6 JOB_4572 $35,820.00 23/01/2020 21/01/2020 2 $16,281.82 $3,419.18 $2,943.07 $22,644.07 $429.84 $16,711.66 $19,108.34 $ 53.35 Minimum $15,880.00 7 JOB_4573 $20,650.00 29/01/2020 30/01/2020 $9,386.36 $2,651.65 $2,760.84 $14,798.85 $247.80 $9,634.16 $11,015.84 $ 53.35 Average $41,330.00 8 JOB_4574 $30,870.00 7/02/2020 5/02/2020 2 $14,031.82 $3,122.08 $2,593.82 $19,747.72 $370.44 $14,402.26 $16,467.74 $ 53.35 9 JOB_4575 $56,810.00 21/02/2020 19/02/2020 2 $25,822.73 $7,036.69 $7,673.26 $40,532.68 $681.72 $26,504.45 $30,305.55 $ 53.35 Penalty Rate 0.012 10 JOB_4576 $16,600.00 27/02/2020 28/02/2020 0 $7,545.45 $1,942.95 $1,907.03 $11,395.43 $199.20 $7,744.65 $8,855.35 $ 53.35 11 JOB_4577 $20,650.00 2/03/2020 2/03/2020 o $9,386.36 $1,924.20 $2,042.83 $13,353.39 $247.80 $9,634.16 $11,015.84 $ 53.35 12 JOB_4578 $15,880.00 6/03/2020 4/03/2020 IN $7,218.18 $1,479.73 $1,482.73 $10,180.64 $190.56 $7,408.74 $8,471.26 $ 53.35 13 JOB_4579 $22,080.00 13/03/2020 16/03/2020 $10,036.36 $2,860.36 $2,662.92 $15,559.64 $264.96 $10,301.32 $11,778.68 $ 53.35 14 JOB_4580 $27,580.00 20/03/2020 19/03/2020 1 $12,536.36 $3,353.48 $3,255.79 $19,145.63 $330.96 $12,867.32 $14,712.68 $ 53.35 15 JOB_4581 $27,860.00 27/03/2020 25/03/2020 2 $12,663.64 $3,134.25 $3,419.60 $19,217.49 $334.32 $12,997.96 $14,862.04 $ 53.35 16 JOB_4582 $37,800.00 7/04/2020 6/04/2020 1 $17,181.82 $5,283.41 $5,392.14 $27,857.37 $453.60 $17,635.42 $20,164.58 $ 53.35 17 JOB_4583 $60,970.00 21/04/2020 19/04/2020 2 $27,713.64 $8,591.23 $8,078.58 $44,383.45 $731.64 $28,445.28 $32,524.72 $ 53.35 18 JOB_4584 $46,800.00 5/05/2020 6/05/2020 o $21,272.73 $5,052.27 $4,954.16 $31,279.16 $561.60 $21,834.33 $24,965.67 $ 53.35 19 JOB_4585 $59,280.00 19/05/2020 15/05/2020 4 $26,945.45 $8,757.27 $8,234.65 $43,937.37 $711.36 $27,656.81 $31,623.19 $ 53.35 20 JOB_4586 $66,780.00 1/06/2020 2/06/2020 $30,354.55 $6,602.11 $5,878.55 $42,835.21 $801.36 $31,155.91 $35,624.09 $ 53.35 21 JOB_4587 $47,200.00 24/07/2020 23/07/2020 1 $21,454.55 $7,080.00 $7,153.83 $35,688.38 $566.40 $22,020.95 $25,179.05 $ 53.35 22 23 Total $636,110.00 21 $289,140.91 $77,681.05 $75,210.21 $442,032.17 $7,633.32 $296,774.23 $339,335.77 24 25 26 27

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ronald W Hilton

7th Edition

0073022853, 978-0073022857

Students also viewed these Accounting questions