Download exel assignment to learn PMT and more Assignments Business Statistics in PDF only on Docsity!
CAPILANO UNIVERSITY
AERO LOGISTICS LTD.
Cargo Information ITEM Quantity Weight Per Unit (kg) Total Weight Weight Per Unit (lbs) Total Weight (lbs) Cartons 28 58 1624 127.89 3580. Crates 14 136 1904 299.88 4198. Model 48 Diesel Engines 3 2200 6600 4851 14553 Total ( Before Tax And Fees ) 45 2394 10128 5278.77 22332. Total After Tax : Insurance Table State Tax : 9.75% $12,520.17 Value State Transportation Fee Appli 2.47 55160.6328 $ 4, $196,092.80 $ 6, $ 10, Shipping From : 3151 Aylmer Rd, Richmond, BC V7B 1L5 $ 15, Shipping To : 157 Craft Dr, Alamosa, CO 81101, United States $ 25, $ 35, Fuel Surcharge Per Mile Total Miles Total Fuel Charges $ 50, $0.96 1485 $1,425.60 $ 65, $ 85, Total Miles Miles/Hour Total Hours Maximum Hours In A Day $ 100, 1485 45 33.00 7.5 $ 150, $ 175, Driver Service Charges $ 195, Charge per day (7.5 hours): Total Hours: Total Days (7.5 Hours): Total Charges: $ 285.00 33 4.40 $ 1,254. BONUS FOR DRIVER Threshold (in Miles ) Total Miles Travelled Bonus Per Extra Mile Total Bonus ( In $ ) Total Charge On Driver With Bonus, Wage And Petrol 940 1485 $0.25 136.25 $2,815.
CAPILANO UNIVERSITY
For Conversion To Lbs Unit Price Total Price 1 KG $975 $27,300 2. $3,258 $45, $18,500 $55, $22,733 $128,412 Weight (In Lbs) State Transportation Fees ( Per Pound) Insurance Table 1500 $1. Charge Cost Of Goods Delivered $128,412 2000 $1. $ 14.00 Insurance Charge $88.00 2800 $1. $ 16.00 3500 $1. $ 20.00 4900 $1. $ 25.00 5700 $1. $ 30.00 7400 $1. $ 39.00 9800 $1. $ 41.00 10,500 $1. $ 54.00 11,900 $2. $ 62.00 13,500 $2. $ 88.00 15,000 $2. $ 98. $ 125. $ 175. What were your experiences and opinions with the project? Really made me use my brain a lot just to understand the assignment at first, but overall intersting. How did any other outside sources/data affect your decision making? The Distance to the city given to me, changed a lot of calculations for the drivers part If you were to redo this assignment, what would you different? If i redo this assignment, i will try to maintain a proper space for overything for the layout. What was your analysis and explanation to your overall decisions making process? What was your main decision and why? Overall decsion making was very cautious to be honest, as it took me precise details to calulate everything, if just i choose one value wrong somewhere it could break my whole assignment. What was your understanding, lessons learnt and key takeaways from this assignment? – Discuss briefly. I learned on how to use the PMT , IF and vlookup functions also got a real time data to caluclate this time when finding the distance between cities. What were your three strategies? Explain how you arrive at your project solution. ie: Excel communication decision procedure, layout and presentation of your work I solved everything step by step I wrote down all the forumlas i am gonna use seprately I also, wrote down the details of address, and distance between the things on a seprate paper to easily fill details when needed.
CAPILANO UNIVERSITY
Aero Logistics Ltd.
3151 Aylmer Rd P: 234236234 Email : Aerologisticsltd@gmail. Richmond, BC V7B 1L5 F: 432464354 Website : Aerologistics.com Bill To: Mr. Donald. J. Nelson VP International Sales Phone: 456423245 Invoice #: 324123 Address: Market Systems Manufacturing Fax: 543523643 Invoice Date: 18th Oct 2022 20450 Champlain Road Email: Langley, BC V6Y 2L
Invoice For
Item # Description Qty Unit Price Discount Price 1 Total Driver Charge $2,816 $ 2,816. 2 State Transportation Fees $55,160.63 $55,160. 3 State Tax $12,520 $12, 4 Total Cargo Charges 45 $128,412 $ 128,412. 5 Insurance Charge $88 $ 88. marketsystems@gmail.com
CAPILANO UNIVERSITY
Invoice Subtotal $ 198,996. TOTAL $ 198,996. Make all checks payable to Aero Logistics Ltd..
