Formulas Customer Invoice ProductPriceQuantitySub TotDiscount %Discount AmtTotal E-Tec USB 2 Drive$19.9945$899.555%44.98854.57 Lenolo Tab 2$196.9812$2,363.7610%236.382127.38 Reflux...

1 answer below ยป



Formulas Customer Invoice ProductPriceQuantitySub TotDiscount %Discount AmtTotal E-Tec USB 2 Drive$19.9945$899.555%44.98854.57 Lenolo Tab 2$196.9812$2,363.7610%236.382127.38 Reflux A4 paper White 500$24.9928$699.725%34.99664.73 Laser Jet Toner Cartridge Black$194.003$582.005%29.10552.90 Totals4199.59 Add+ Subtract- Multiply* Divide/ Exponent^ Functions Sales Ledger 2016 Name Q1Q2Q3Q4TotalAverageMaxMinCommissionCommission rate:4% Prentice23100131001680037422904222260637422131003616.88 Chirillo227002411048752395661351283378248752227005405.123.0000 Wong209002260020140221858582521456226002014034333.0000 Baker15900227001760012334685341713422700123342741.363.0000 Richards250003400021000384431184432961138443210004737.729 Hite241105481215200284641225863064754812152004903.44 de Moret256004875230300184431230953077448752184434923.8 McWilliams226005844516800204541182992957558445168004731.96 Howard227004864836855294301376333440848648227005505.32 Silvis233002460021380422041114842787142204213804459.36 Morris23800277001260017790818902047327700126003275.6 Lewis548265922424100236671618174045459224236676472.68 Jefferson312002310017700342101062102655334210177004248.4 Patrino502241730015200273301100542751450224152004402.16 Trowns-Hale15500190003030034482992822482134482155003971.28 Nguyen309002440016800298431019432548630900168004077.72 Johnsen14815131001158015590550851377115590115802203.4 OBrien245002560022000388431109432773638843220004437.72 Tantalo20900226002014029466931062327729466201403724.24 Parker15900227001760039003952032380139003159003808.12 TOTALS508475606491432847579169212698285079.28 Summary Data Summary Data 2016 Total Sales$2,126,982.00 Average Sales$26,587.50 Total Commission$85,079.28 Bonus Bonus5% Emp IDFirst NameSurnameSalesBonus 1JulieFennell$ 120,000$ 6,000 2SamViney$ 70,000$ 3,500 3AndreaBall$ 78,000$ 3,900 4AnnabelleLewis$ 45,000$ 2,250 5CindyThompson$ 89,000$ 4,450 6AndySmith$ 88,000$ 4,400 7FranCarpenter$ 80,000$ 4,000 Named Ranges Book Sales by Author Author IDContract DateYears EmployedBooks in PrintBooks SoldSell PriceIncome Earned 17551/15/126.6654789852.991432165.15Total Income Earned:208237340.76 19321/7/126.681227449112.993565638.09Total Books Sold:22769224 170411/24/116.808966849.99965873.16Average Sell Price:8.6814893617 132810/10/116.935669379.99668700.63Average No Books in Print:8.2553191489 10487/19/117.154439215.99263086.79First Contract Date:1/15/00 18185/5/117.3681926813.99768797.19 13875/2/117.36113047292.99911139.71 13253/9/117.5161020162.99305027.84 11583/3/117.53821444210.992356717.58 17473/2/117.535702833.99280429.17 10351/20/117.65118339910.99916555.01 114212/21/107.7312255032.99674253.97 126210/7/107.9341885652.99563809.35 12069/16/107.99121376623.995128246.34 12598/23/108.06249185312.996389170.47 16766/22/108.2362229549.992227310.46 14875/12/108.3465898912.99766267.11 10065/5/108.36153162373.991261785.63 12384/15/108.41121595933.99636776.07 11621/17/108.66129551412.993838726.86 177312/27/098.71124940657.993947579.35 193912/27/098.7182834149.992831305.86 16209/23/098.9743847197.993073904.81 13725/28/099.29133266495.991956627.51 14145/6/099.358697503.99278302.5 19284/27/099.3812306785.991381761.22 13273/16/099.4912373589.992371206.42 192912/3/089.78994832.9928354.17 122210/22/089.8943077415.991843368.59 187110/1/089.95845406410.994990163.36 10249/21/089.9822556507.992042643.5 14286/29/0810.219162742.9948659.26 16643/23/0810.4784394485.992632293.52 19503/2/0810.5351339935.99802618.07 16222/25/0810.5510691053.99275728.95 11792/14/0810.58114306223.991033057.38 128912/13/0710.75836662823.998795405.72 151410/24/0710.89143416942.991021665.06 18639/22/0710.981412844712.991668526.53 14828/7/0711.10945911523.9911014168.85 19147/26/0711.1314359872.99107601.13 19114/29/0711.37111441212.99187211.88 16801/8/0711.6815689352.99206115.65 124612/24/0611.7212692783.991074419.22 162212/15/0611.7454697329.994692622.68 151310/4/0611.941517081712.992218912.83 14519/29/0611.961313065610.991435909.44 15349/28/0611.96152050110.99225305.99 15108/9/0612.091048184010.995295421.6 18037/1/0612.20131132175.99678169.83 19252/8/0612.6014742567.99593305.44 181712/22/0512.7374946722.991479069.28 133911/8/0512.8585618810.99617506.12 10456/24/0513.22728358810.993116632.12 186211/21/0413.811240444312.995253714.57 137610/24/0413.896551939.99551378.07 17559/29/0413.96143302915.996924133.71 10218/6/0414.10143449445.992066214.56 17736/13/0414.2571569402.99469250.6 13266/11/0414.26121423629.991422196.38 14956/10/0414.26132514189.992511665.82 139011/27/0314.7912028632.99606560.37 19159/16/0314.993530612.99158652.39 16476/22/0315.23935769212.994646419.08 12306/16/0315.2453806407.993041313.6 19586/8/0315.26124909103.991958730.9 18435/3/0315.36118619315.991378226.07 18043/30/0315.45145300310.99582502.97 106612/19/0215.73132318233.99924973.77 19519/26/0215.96132924519.992921585.49 17998/4/0216.1110896367.99716191.64 12106/1/0216.28123656149.993652483.86 181611/29/0116.79123460242.991034611.76 190210/18/0116.9094244932.991269234.07 13627/1/0117.20318928210.992080209.18 17016/23/0117.221220799215.993325792.08 13295/17/0117.3213255107.992600824.9 10424/2/0117.4515168922.9950507.08 16123/4/0117.531327750715.994437336.93 141612/27/0017.71114937595.992957616.41 187211/24/0017.8072349032.99702359.97 111111/8/0017.85111404622.99419981.38 161910/20/0017.90745919415.997342512.06 11989/28/0017.96149629323.9911906069.07 12989/28/0017.96141150112.99343882.89 16998/1/0018.1213295067.992632752.94 15947/17/0018.161438786012.995038301.4 15466/14/0018.25733999812.994416574.02 16936/7/0018.273791165.99473904.84 11854/29/0018.37319752210.992170766.78 15353/19/0018.4862828437.992259915.57 19522/13/0018.5881941457.991551218.55 15121/15/0018.6684461842.991334090.16 22226/30/180.2055555553.992216664.45 Create Named Ranges using Name Box and Create from Selection SUMIFS First NameSurnameGenderDepartmentSalary JulieFennellFIT$120,000.00 SamVineyMMarketing$70,000.00 AndreaBallFFinance$78,000.00 AnnabelleLewisFIT$45,000.00 CindyThompsonFFinance$89,000.00 AndySmithMFinance$88,000.00 FranCarpenterFMarketing$80,000.00 Number of Staff in Finance3 Number of Staff who earn over 80K3 Total Salaries inFinance$ 255,000 Total Salaries inIT$ 165,000 Total Salaries inMarketing$ 150,000 Challenge: Change the SUMIFS to get total salaries for FEMALES in each department FinanceITMarketing255000165000150000 IF First NameSurnameAttendanceResultsGrade60- 100Pass JulieFennell10084Pass0- 59Fail SamViney6557Fail AndreaBall8068Pass AnnabelleLewis8071Pass CindyThompson6563Pass AndySmith10075Pass FredCarpenter10052Fail Logical Functions =IF =OR =AND IF KPI LastFirstKPISalesKPI Met Y/NBonusBonus Rates DECKERErica100000857362572.08KPI Met10% BARRYAngela120000135647Y13564.7KPI Not Met3% COLEDaniel120000610851832.55 CHAFFEEAdam100000137491Y13749.1 DONNELLSusan8000091386Y9138.6 FERNElizabeth120000136424Y13642.4 ELLISJanet120000154849Y15484.9 CHUNGBob120000143610Y14361 FLANDERSSabrina100000119338Y11933.8 CLARKJohn100000176077Y17607.7 BOLLERMary120000120440Y12044 CAROLElizabeth1500001198873596.61 CLARKAnna100000916842750.52 CLARKEJoe120000136519Y13651.9 COMUNTZISMark120000147034Y14703.4 IF Invoice Data Invoice #Invoice AmtInvoice DateDue DatePaid DateDays AfterExtensionEarly DiscountAdjusted Amt 30245$1,460.0012/7/1712/21/1712/8/17-13146$1,314.00 30246$7,338.0012/15/1712/29/1712/17/17-12733.8$6,604.20 30247$3,910.0012/16/1712/30/171/5/1860$3,910.00 30248$7,045.0012/24/171/7/181/5/18-2704.5$6,340.50 30249$4,733.0012/24/171/7/181/25/18180$4,833.00 30250$8,756.001/6/181/20/181/14/18-6875.6$7,880.40 30251$8,282.001/13/181/27/182/21/1825Y0$8,382.00 30252$4,455.001/13/181/27/182/21/18250$4,555.00 30253$816.001/17/181/31/182/6/1860$816.00 30254$2,987.001/26/182/9/183/5/18240$3,087.00 30255$8,717.001/26/182/9/182/18/1890$8,717.00 30256$6,537.001/27/182/10/182/24/18140$6,537.00 30257$4,758.001/30/182/13/183/5/1820Y0$4,858.00 30258$558.001/31/182/14/182/21/1870$558.00 30259$1,649.002/2/182/16/182/27/18110$1,649.00 Clients who pay before the due Date are elligible for a 10% discount Clients who pay more than 14 days after the Due Date pay a $100 late penalty Clients who have arranged for an extension are exempt from the penalty Tables Book Sales by AuthorCommission Rate:3% Author IDContract DateYears EmployedBooks in PrintBooks SoldSell PriceIncome EarnedCommission 10065/5/101/8/0015316237$ 3.901233324.336999.729 10218/6/041/14/0014344944$ 5.992066214.5661986.4368 10249/21/081/9/002255650$ 7.992042643.561279.305 10351/20/111/7/001183399$ 10.99916555.0127496.6503 10424/2/011/17/001516892$ 2.9950507.081515.2124 10456/24/051/13/007283588$ 10.993116632.1293498.9636 10487/19/111/7/00443921$ 5.99263086.797892.6037 106612/19/021/15/0013231823$ 3.99924973.7727749.2131 111111/8/001/17/0011140462$ 2.99419981.3812599.4414 114212/21/101/7/001225503$ 2.99674253.9720227.6191 11583/3/111/7/008214442$ 10.992356717.5870701.5274 11621/17/101/8/001295514$ 12.993838726.86115161.8058 11792/14/081/10/001143062$ 23.991033057.3830991.7214 11854/29/001/18/003197522$ 10.992170766.7865123.0034 11989/28/001/17/001496293$ 23.9911906069.07357182.0721 12069/16/101/7/001213766$ 23.995128246.34153847.3902 12106/1/021/16/0012365614$ 9.993652483.86109574.5158 122210/22/081/9/004307741$ 5.991843368.5955301.0577 12306/16/031/15/005380640$ 7.993041313.691239.408 12384/15/101/8/0012159593$ 3.99636776.0719103.2821 124612/24/061/11/001269278$ 3.991074419.2232232.5766 12598/23/101/8/002491853$ 12.996389170.47191675.1141 126210/7/101/7/004188565$ 2.99563809.3516914.2805 128912/13/071/10/008366628$ 23.998795405.72263862.1716 12989/28/001/17/0014115011$ 2.99343882.8910316.4867 13253/9/111/7/006102016$ 2.99305027.849150.8352 13266/11/041/14/0012142362$ 9.991422196.3842665.8914 13273/16/091/9/001237358$ 9.992371206.4271136.1926 132810/10/111/6/00566937$ 9.99668700.6320061.0189 13295/17/011/17/001325510$ 7.992600824.978024.747 133911/8/051/12/00856188$ 10.99617506.1218525.1836 13627/1/011/17/003189282$ 10.992080209.1862406.2754 13725/28/091/9/0013326649$ 5.991956627.5158698.8253 137610/24/041/13/00655193$ 9.99551378.0716541.3421 13875/2/111/7/0011304729$ 2.99911139.7127334.1913 139011/27/031/14/001202863$ 2.99606560.3718196.8111 14145/6/091/9/00869750$ 3.99278302.58349.075 141612/27/001/17/0011493759$ 5.992957616.4188728.4923 14286/29/081/10/00916274$ 2.9948659.261459.7778 14519/29/061/11/0013130656$ 10.991435909.4443077.2832 14828/7/071/11/009459115$ 23.9911014168.85330425.0655 14875/12/101/8/00658989$ 12.99766267.1122988.0133 14956/10/041/14/0013251418$ 9.992511665.8275349.9746 15108/9/061/12/0010481840$ 10.995295421.6158862.648 15121/15/001/18/008446184$ 2.991334090.1640022.7048 151310/4/061/11/0015170817$ 12.992218912.8366567.3849 151410/24/071/10/0014341694$ 2.991021665.0630649.9518 15349/28/061/11/001520501$ 10.99225305.996759.1797 15353/19/001/18/006282843$ 7.992259915.5767797.4671 15466/14/001/18/007339998$ 12.994416574.02132497.2206 15947/17/001/18/0014387860$ 12.995038301.4151149.042 16123/4/011/17/0013277507$ 15.994437336.93133120.1079 161910/20/001/17/007459194$ 15.997342512.06220275.3618 16209/23/091/8/004384719$ 7.993073904.8192217.1443 16222/25/081/10/001069105$ 3.99275728.958271.8685 162212/15/061/11/005469732$ 9.994692622.68140778.6804 16476/22/031/15/009357692$ 12.994646419.08139392.5724 16643/23/081/10/008439448$ 5.992632293.5278968.8056 16766/22/101/8/006222954$ 9.992227310.4666819.3138 16801/8/071/11/001568935$ 2.99206115.656183.4695 16936/7/001/18/00379116$ 5.99473904.8414217.1452 16998/1/001/18/001329506$ 7.992632752.9478982.5882 17016/23/011/17/0012207992$ 15.993325792.0899773.7624 170411/24/111/6/00896684$ 9.99965873.1628976.1948 17473/2/111/7/00570283$ 3.99280429.178412.8751 17551/15/121/6/005478985$ 2.991432165.1542964.9545 17559/29/041/13/001433029$ 15.996924133.71207724.0113 17736/13/041/14/007156940$ 2.99469250.614077.518 177312/27/091/8/0012494065$ 7.993947579.35118427.3805 17998/4/021/16/001089636$ 7.99716191.6421485.7492 18037/1/061/12/0013113217$ 5.99678169.8320345.0949 18043/30/031/15/001453003$ 10.99582502.9717475.0891 181611/29/011/16/0012346024$ 2.991034611.7631038.3528 181712/22/051/12/007494672$ 2.991479069.2844372.0784 18185/5/111/7/008192681$ 3.99768797.1923063.9157 18435/3/031/15/001186193$ 15.991378226.0741346.7821 186211/21/041/13/0012404443$ 12.995253714.57157611.4371 18639/22/071/10/0014128447$ 12.991668526.5350055.7959 187110/1/081/9/008454064$ 10.994990163.36149704.9008 187211/24/001/17/007234903$ 2.99702359.9721070.7991 190210/18/011/16/009424493$ 2.991269234.0738077.0221 19114/29/071/11/001114412$ 12.99187211.885616.3564 19147/26/071/11/001435987$ 2.99107601.133228.0339 19159/16/031/14/00353061$ 2.99158652.394759.5717 19252/8/061/12/001474256$ 7.99593305.4417799.1632 19284/27/091/9/001230678$ 5.991381761.2241452.8366 192912/3/081/9/0099483$ 2.9928354.17850.6251 19321/7/121/6/0012274491$ 12.993565638.09106969.1427 193912/27/091/8/008283414$ 9.992831305.8684939.1758 19503/2/081/10/005133993$ 5.99802618.0724078.5421 19519/26/021/15/0013292451$ 9.992921585.4987647.5647 19522/13/001/18/008194145$ 7.991551218.5546536.5565 19586/8/031/15/0012490910$ 3.991958730.958761.927 prepared by Nicky6/30/18 VLOOKUP Grade Grades Emp IDFirst NameSurnameResultsGrade 1JulieFennell84A 2SamViney57D0Fail 3AndreaBall68C40E 4AnnabelleLewis71B50D 5CindyThompson63C60C 6AndySmith75B70B 7FranCarpenter43E80A =VLOOKUP(Value,Data,Column,Range?) VLOOKUP Product Sales Record DatePart NumberProductVendorUnit PriceUnitsTotal 6/20/131243KeyboardDiamond$29.003$87.00 6/20/131245MonitorPile$129.001$129.00 6/20/131249System UnitTreetop$199.002$398.00 6/20/131271Memory BoardPile$59.0010$590.00 TOTAL:$1,204.00 Product List Part NumberProductVendorUnits On-HandUnit Price 1251MouseAce160$19.00 1257KeyboardCircular48$29.00 1269Memory BoardCircular45$59.00 1248Hard DriveCircular60$99.00 1260Hard DriveCircular17$99.00 1243KeyboardDiamond100$29.00 1252MonitorDiamond40$129.00 1264MonitorDiamond110$129.00 1250System UnitDiamond100$199.00 1256System UnitDiamond148$199.00 1261MouseLetter C32$19.00 1270KeyboardLetter C10$29.00 1247CD ROM DriveLetter C20$39.00 1254Hard DriveLetter C40$99.00 1265Memory BoardNickel89$59.00 1272System UnitNickel13$199.00 1268MousePile20$19.00 1246Memory BoardPile300$59.00 1253Memory BoardPile112$59.00 1271Memory BoardPile2$59.00 1273Memory BoardPile85$59.00 1245MonitorPile400$129.00 1262MonitorPile56$129.00 1267MonitorPile64$129.00 1266MouseQuick Parts35$19.00 1258KeyboardQuick Parts36$29.00 1263CD ROM DriveQuick Parts18$39.00 1255MonitorQuick Parts43$129.00 1244MouseTreetop218$19.00 1259CD ROM DriveTreetop5$39.00 1249System UnitTreetop60$199.00 Charts Sales Summary YearBook SalesMusic SalesTotal 20005508567755124840 20016853493206163741 200281890113827197719 200385825113289201117 200490422120261212687 200599282129067230354 2006101943139662243611 2007106210135949244166 2008110054161779273841 2009110943145335258287 2010111484150503263997 2011118299145508265818 2012118443145685266140 2013122586166717291316 2014123095155100280209 2015137633198192337840 2016135128189179326323 2017161817233016396850 Sales Summary Book Sales200020012002200320042005200620072008200920102011201220132014201520162017550856853481890858259042299282101943106210110054110943111484118299118443122586123095137633135128161817Music Sales2000200120022003200420052006200720082009201020112012201320142015201620176775593206113827113289120261129067139662135949161779145335150503145508145685166717155100198192189179233016
unifolks_636741731174507279_122268_1.xlsm unifolks_636741731174507279_122268_2.xlsx
Answered Same DayOct 03, 2020ACCG200Macquaire University

Answer To: Formulas Customer Invoice ProductPriceQuantitySub TotDiscount %Discount AmtTotal E-Tec USB 2...

Aarti J answered on Oct 05 2020
127 Votes
Information
        ACCG200 Excel Assignment 2018 Semester 2
        Student Name:
        Student Number:    44093322
        TO PROCEED YOU MUST ENABLE MACROS AND ENTER YOUR STUDENT NUMBER WHEN PROMPTED
        ASSIGNMENT OVERVIEW
        BikePro Ltd want you to perform a Cost Volume Profit Analysis for their High End Racing Bike product, the X-800. You will need to calculate the labour costs, material costs, fixed costs and variable costs and then work out the break even volume. You have also been asked to show a forecast for different unit volumes and produce a break even analysis line chart.
Download the full instructions and a mark breakdown from iLearn.
        PLEASE NOTE:
        Do not use rounding functions unless specifically instructed
        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 grey cells should be changed and these should ALL contain some form of calculation i.e. begin with =
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            M@QU@R1E2017
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            M@cquar1e
Labour Costs
    Labour Costs for the year
                    % Super    9.5%
    Employee Number    Annual    Bonus Rate    Bonus Amount    Super     Total Package
    10026    $ 32,244.00    2%    $ 844.88    $ 3,063.18    $ 36,152.06
    10027    $ 41,597.00    0%    $ 200.00    $ 3,951.72    $ 45,748.72
    10030    $ 51,499.00    0%    $ 200.00    $ 4,892.41    $ 56,591.41
    10032    $ 50,757.00    0%    $ 200.00    $ 4,821.92    $ 55,778.92
    10033    $ 41,084.00    2%    $ 1,021.68    $ 3,902.98    $ 46,008.66
    10034    $ 55,396.00    2%    $ 1,307.92    $ 5,262.62    $ 61,966.54
    10035    $ 53,126.00    0%    $ 200.00    $ 5,046.97    $ 58,372.97
    10036    $ 36,769.00    0%    $ 200.00    $ 3,493.06    $ 40,462.06
    10037    $ 32,710.00    0%    $ 200.00    $ 3,107.45    $ 36,017.45
    10038    $ 32,130.00    0%    $ 200.00    $ 3,052.35    $ 35,382.35
    10039    $ 51,715.00    3%    $ 1,751.45    $ 4,912.93    $ 58,379.38
                    Total     $ 530,860.50
                    Average    $ 48,260.05
                    Highest     $ 61,966.54
BoM
    Bill of Materials
    Product    Part Code    Quantity    Category    Product Decsription    Supplier    Unit Price    Total Price        Cost Brakdown for:    X-800
    ZF300    GR1751    2    Groupset    CNC brakes 200g Brakes    Cycle Warehouse    $98.60    $197.20        Groupset    792.24
    X-800    AC1914    2    Accessories and tuning    Nashbar Alpe d Huez Pedals    Nashbar    $13.58    $27.16        Accessories and tuning    72.99
    ZF300    CO2357    1    Contact Points    RockBros CrMo Saddle    Cycle Warehouse    $23.69    $23.69        Contact Points    264.47
    X-800    FR1235    1    Frameset    J&L Fork    Bikes Plus    $231.00    $231.00        Frameset    681.52
    X-800    CO1469    180    Contact Points    Generic Foam Tape Tape    Cycle Warehouse    $0.20    $36.00        Wheels    644.08
    ZF300    GR2009    1    Groupset    Ultegra Cranks    Nashbar    $149.46    $149.46        Total Cost per Unit    2455.3
    X-800    WH1100    2    Wheels    XR-270/Bitex Wheel    Cycle Warehouse    $121.13    $242.26
    X-800    CO1099    1    Contact Points    Nashbar Carbon Bar    Nashbar    $83.52    $83.52
    ZF300    CO1469    180    Contact Points    Generic Foam Tape Tape    Cycle Warehouse    $0.20    $36.00
    ZF300    FR2360    1    Frameset    J&L Plug    Bikes Plus    $11.96    $11.96
    X-800    GR1770    1    Groupset    Nashbar RD    Nashbar    $62.70    $62.70
    X-800    WH2942    2    Wheels    Titanium QR Skewers    Cycle Warehouse    $5.40    $10.80
    ZF300    FR1934    1    Frameset    Headset    Bikes Plus    $0.00    $0.00
    ZF300    GR1322    1    Groupset    Ultegra RD    Backcountry    $58.50    $58.50
    ZF300    FR1235    1    Frameset    J&L Fork    Bikes Plus    $231.00    $231.00
    ZF300    GR1172    1    Groupset    Ultegra FD    Nashbar    $24.65    $24.65
    ZF300    CO2904    2    Contact Points    Custom Bar Plugs    Cycle Warehouse    $1.01    $2.02
    ZF300    FR1080    1    Frameset    J&L Top Cap & Screw    Cycle Warehouse    $4.00    $4.00
    ZF300    GR1215    1    Groupset    Dura Ace Chain    Nashbar    $36.80    $36.80
    X-800    WH2373    2    Wheels    Veloplugs Rim tape    LBS    $5.94    $11.88
    X-800    CO2904    2    Contact Points    Custom Bar Plugs    Cycle Warehouse    $1.01    $2.02
    X-800    WH1260    2    Wheels    CNC V18 Ultra Wheels    Cycle Warehouse    $158.40    $316.80
    X-800    WH1573    2    Wheels    Forte Light Tubes    Performance    $4.62    $9.24
    ZF300    CO1099    1    Contact Points    Nashbar Carbon Bar    Nashbar    $83.52    $83.52
    X-800    FR1934    1    Frameset    Headset    Bikes Plus    $0.00    $0.00
    ZF300    FR1323    1    Frameset    Nashbar Carbon Frame    Nashbar    $417.60    $417.60
    X-800    CO2143    5    Contact Points    Spacers    Bikes Plus    $0.00    $0.00
    X-800    AC2716    220    Accessories and...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?