Mathematics of buying

xfnppbzna
timer Asked: Jul 5th, 2015

Question Description

Attached in an excel worksheet with 5 worksheets.  I need these questions answered in 3 hours.


Saccoman_Kortnee_Copy of Project_4-11.xls

Unformatted Attachment Preview

A B C D E F 2 3 4 6 9 10 11 12 13 14 I INVOICE J. B. Sherr Co. 5 8 H Project Sheet 4 Chapter 9 - Mathematics of Buying 1 7 G Showroom and Warehouse S o l d 1704 Rollins Road Oaks Hardware Burlingame, CA 94010 10136 Fair Oaks Blvd T o S h i p Telephone: (850) 697-3430 Fair Oaks, CA 95628 Page No. 1 of 1 To Order: 1-800-660-1422 Oaks Hardware INVOICE DATE INVOICE NO. 3/17/2005 0000238-IN 10136 Fair Oaks Blvd T o Fair Oaks, CA 95628 15 16 SALESMAN 17 T a Qty Ord. 18 g TERMS: ENTRY NUMBER Shipped Unit ENTRY DATE SHIPPING DATE SHIPPING VIA Stock Number Description Sugg. Retail CUSTOMER ORDER NO/DEPT Unit Price Amount 19 1 12 12 Ea 736-080 Impt Natural Sea Sponge 0.00 $ 2.400 $ 28.80 20 2 1 0 Ea 267-6682 Acrylic Butter Dish 6.39 $ 3.768 $ - 21 3 1 1 Ea 267-6683 Acrylic Cream & Sugar Se 6.39 $ 3.768 $ 3.77 22 4 1 1 Ea 267-6684 Acrylic Napkin Holder 5.29 $ 3.140 $ 3.14 23 5 6 6 Ea 694-322 Impt Wenol Metal Polish 7.79 $ 4.650 $ 27.90 24 6 6 6 Ea 694-353 Imptred Bear Polish 7.39 $ 4.370 $ 26.22 25 7 2 2 Ea 274-10012 Friendship Mixing Bowl 31.50 $ 18.750 $ 37.50 26 8 1 1 Ea 274-11014 Friendship Mixing Bowl 44.90 $ 26.500 $ 26.50 27 9 2 2 Ea 274-31008 Flexible Chopping Mats 3.93 $ 2.360 $ 4.72 28 10 1 1 Ea 589-22153 Corner Sink Shelf w/Suc 2.79 $ 1.600 $ 1.60 29 11 6 2 Ea 281-7950 Gemco Juicer w/Glass Jar 4.59 $ 2.730 $ 5.46 30 12 2 2 Ea 54-611 Arden Waffle Towel - Blue 3.19 $ 1.900 $ 3.80 31 13 2 2 Ea 54-612 Arden Waffle Towel - Gree 3.19 $ 1.900 $ 3.80 32 14 2 2 Ea 60-6 Ashland Tire Mat 18.5 X 18.75 $ 11.250 $ 22.50 33 15 2 2 Ea 998-713 3 Half/ Rd Dragon 18 X 30 0.00 $ 5.200 $ 10.40 34 16 2 2 Ea 998-143 3 Welcome Mat 18 X 30 0.00 $ 6.910 $ 13.82 35 17 3 3 Ea 998-303 3 MB Plain Mat 18 X 30 0.00 $ 8.640 $ 25.92 36 18 2 2 Ea 998-504 4 Half-Rd MB Plain 20 X 3 0.00 $ 10.550 $ 21.10 Sales Tax Freight 37 19 38 20 39 Non Tax Total Taxable Total Misc. INVOICE TOTAL 40 0 $ 266.95 $ 16.02 19.45 0 $ 302.41 41 ALL ITEMS NOT SHIPPED ARE CANCELLED PLEASE REORDER Please pay from this 42 invoice. 43 All orders subject to credit acceptance. Prices subject to change without notice. Shortages must be reported with 10 44 days. No returns accepted without authorization. Past due accounts subject to interest (1 1/2% per mo.) plus collection 45 Customer's Copy charges. 46 Be sure to save your work 20150705215322saccoman_kortnee_copy_of_project_4_11.xlsInvoice A 1 B C E F Project Sheet 4 Chapter 9 - Mathematics of Buying 2 3 4 Trade Discount Net Cost Equivalent Single Discount Equivalent 5 15/35 0.5525 44.75% 6 20/20/10 7 40/20/10 8 25/10/20/10 9 33 1/3/20 10 D List Price Trade Discount Net Cost $ 148.00 $ 81.77 $ 1,250.00 $ 2,300.00 $ 10,940.00 $ 30,000.00 Be sure to save your work 20150705215322saccoman_kortnee_copy_of_project_4_11.xlsSDE-TradeDiscount-NetCost A B C 2 3 Invoice Amount 10 E F G H I J Project Sheet 4 Chapter 9 - Mathematics of Buying 1 4 5 6 7 8 9 D $ $ $ $ $ 166.10 96.06 248.00 780.70 262.00 Invoice Date 8-Mar 30-Nov 19-Jul 5-May 15-Jan Receive Cash Cash Shipping & Goods Date Invoice Net Cost Terms Discount Discount Final Cost Insurance Returned Paid Decimal (Yes or Decimal No) 6/10, n/30 $ 5.39 $ 14-Mar Net 30 $ 5.22 $ 20-Dec 3/15, 1/25, n/60 $ 9.45 $ 16-Aug net 30 $ 3.80 $ 125.00 1-Jun 2/15, net 30 $ 18.18 $ 15.00 23-Jan Be sure to save your work 20150705215322saccoman_kortnee_copy_of_project_4_11.xlsCash Discounts-1 A B C 2 3 Invoice Amount 11 E F G H I Net Cost Decimal Net Cost Project Sheet 4 Chapter 9 - Mathematics of Buying 1 4 5 6 7 8 9 10 D $ $ $ $ $ $ 682.28 194.04 2,960.00 11,450.00 3,250.60 8,518.00 Invoice Date Terms 4-Jun 22-Aug 31-Oct 6-Apr 17-Oct 9-Jun 3/20 ROG 5/10-60 ex 2/10 EOM 2/15 prox 3/15-20x 3/20 EOM Date Good Received Date Invoice Paid 25-Jul 15-Sep 10-Aug 5-Nov 5-Dec 30-Apr 20-Oct 18-Jul 10-Apr Receive Cash Cash Discount Discount Decimal (Yes or No) Be sure to save your work 20150705215322saccoman_kortnee_copy_of_project_4_11.xlsCash Discounts-2 A B C 4 5 6 7 8 9 E F G H I J Project Sheet 4 Chapter 9 - Mathematics of Buying 1 2 3 D Points (1 pt per cell for input in Column F & G, 1 pt per cell in Columns H-J, 1pt per cell for formulas in Columns H-J) Receive Date Cash Invoice Invoice Partial Cash Net Cost Credit Balance Terms Invoice Discount Amount Date Payment Discount Decimal Given Due Paid Decimal (Yes or No) $ 3,150.00 9-Jan 2/10 EOM 8-Feb $ 1,862.00 $ 884.00 6-Jun 5/10-30x 10-Jul $ 209.00 $ 1,920.00 11-Jan 3/10, 2/15. n/30 23-Jan $ 450.80 $ 6,120.00 4-Sep 4/20 prox 15-Nov $ 2,016.00 Be sure to save your work 20150705215322saccoman_kortnee_copy_of_project_4_11.xlsPartial Payments A B C D E F 2 3 4 6 9 10 11 12 13 14 I INVOICE J. B. Sherr Co. 5 8 H Project Sheet 4 Chapter 9 - Mathematics of Buying 1 7 G Showroom and Warehouse S o l d 1704 Rollins Road Oaks Hardware Burlingame, CA 94010 10136 Fair Oaks Blvd T o S h i p Telephone: (850) 697-3430 Fair Oaks, CA 95628 Page No. 1 of 1 To Order: 1-800-660-1422 Oaks Hardware INVOICE DATE INVOICE NO. 3/17/2005 0000238-IN 10136 Fair Oaks Blvd T o Fair Oaks, CA 95628 15 16 SALESMAN 17 T a Qty Ord. 18 g TERMS: ENTRY NUMBER Shipped Unit ENTRY DATE SHIPPING DATE SHIPPING VIA Stock Number Description Sugg. Retail CUSTOMER ORDER NO/DEPT Unit Price Amount 19 1 12 12 Ea 736-080 Impt Natural Sea Sponge 0,00 $ 2,400 $ 28,80 20 2 1 0 Ea 267-6682 Acrylic Butter Dish 6,39 $ 3,768 $ - 21 3 1 1 Ea 267-6683 Acrylic Cream & Sugar Se 6,39 $ 3,768 $ 3,77 22 4 1 1 Ea 267-6684 Acrylic Napkin Holder 5,29 $ 3,140 $ 3,14 23 5 6 6 Ea 694-322 Impt Wenol Metal Polish 7,79 $ 4,650 $ 27,90 24 6 6 6 Ea 694-353 Imptred Bear Polish 7,39 $ 4,370 $ 26,22 25 7 2 2 Ea 274-10012 Friendship Mixing Bowl 31,50 $ 18,750 $ 37,50 26 8 1 1 Ea 274-11014 Friendship Mixing Bowl 44,90 $ 26,500 $ 26,50 27 9 2 2 Ea 274-31008 Flexible Chopping Mats 3,93 $ 2,360 $ 4,72 28 10 1 1 Ea 589-22153 Corner Sink Shelf w/Suc 2,79 $ 1,600 $ 1,60 29 11 6 2 Ea 281-7950 Gemco Juicer w/Glass Jar 4,59 $ 2,730 $ 5,46 30 12 2 2 Ea 54-611 Arden Waffle Towel - Blue 3,19 $ 1,900 $ 3,80 31 13 2 2 Ea 54-612 Arden Waffle Towel - Gree 3,19 $ 1,900 $ 3,80 32 14 2 2 Ea 60-6 Ashland Tire Mat 18.5 X 18,75 $ 11,250 $ 22,50 33 15 2 2 Ea 998-713 3 Half/ Rd Dragon 18 X 30 0,00 $ 5,200 $ 10,40 34 16 2 2 Ea 998-143 3 Welcome Mat 18 X 30 0,00 $ 6,910 $ 13,82 35 17 3 3 Ea 998-303 3 MB Plain Mat 18 X 30 0,00 $ 8,640 $ 25,92 36 18 2 2 Ea 998-504 4 Half-Rd MB Plain 20 X 3 0,00 $ 10,550 $ 21,10 Sales Tax Freight 37 19 38 20 39 Non Tax Total Taxable Total Misc. INVOICE TOTAL 40 0 $ 266,95 $ 16,02 19,45 0 $ 302,41 41 ALL ITEMS NOT SHIPPED ARE CANCELLED PLEASE REORDER Please pay from this 42 invoice. 43 All orders subject to credit acceptance. Prices subject to change without notice. Shortages must be reported with 10 44 days. No returns accepted without authorization. Past due accounts subject to interest (1 1/2% per mo.) plus collection 45 Customer's Copy charges. 46 Be sure to save your work 20150705215346saccoman_kortnee_copy_of_project_4_11.xlsInvoice A 1 B C E F Project Sheet 4 Chapter 9 - Mathematics of Buying 2 3 4 Trade Discount Net Cost Equivalent Single Discount Equivalent 5 15/35 0,5525 44,75% 6 20/20/10 7 40/20/10 8 25/10/20/10 9 33 1/3/20 10 D List Price Trade Discount Net Cost $ 148,00 $ 81,77 $ 1.250,00 $ 2.300,00 $ 10.940,00 $ 30.000,00 Be sure to save your work 20150705215346saccoman_kortnee_copy_of_project_4_11.xlsSDE-TradeDiscount-NetCost A B C 2 3 Invoice Amount 10 E F G H I J Project Sheet 4 Chapter 9 - Mathematics of Buying 1 4 5 6 7 8 9 D $ $ $ $ $ 166,10 96,06 248,00 780,70 262,00 Invoice Date 8-Mar 30-Nov 19-Jul 5-May 15-Jan Receive Cash Cash Shipping & Goods Date Invoice Net Cost Terms Discount Discount Final Cost Insurance Returned Paid Decimal (Yes or Decimal No) 6/10, n/30 $ 5,39 $ 14-Mar Net 30 $ 5,22 $ 20-Dec 3/15, 1/25, n/60 $ 9,45 $ 16-Aug net 30 $ 3,80 $ 125,00 1-Jun 2/15, net 30 $ 18,18 $ 15,00 23-Jan Be sure to save your work 20150705215346saccoman_kortnee_copy_of_project_4_11.xlsCash Discounts-1 A B C 2 3 Invoice Amount 11 E F G H I Net Cost Decimal Net Cost Project Sheet 4 Chapter 9 - Mathematics of Buying 1 4 5 6 7 8 9 10 D $ $ $ $ $ $ 682,28 194,04 2.960,00 11.450,00 3.250,60 8.518,00 Invoice Date Terms 4-Jun 22-Aug 31-Oct 6-Apr 17-Oct 9-Jun 3/20 ROG 5/10-60 ex 2/10 EOM 2/15 prox 3/15-20x 3/20 EOM Date Good Received Date Invoice Paid 25-Jul 15-Sep 10-Aug 5-Nov 5-Dec 30-Apr 20-Oct 18-Jul 10-Apr Receive Cash Cash Discount Discount Decimal (Yes or No) Be sure to save your work 20150705215346saccoman_kortnee_copy_of_project_4_11.xlsCash Discounts-2 A B C 4 5 6 7 8 9 E F G H I J Project Sheet 4 Chapter 9 - Mathematics of Buying 1 2 3 D Points (1 pt per cell for input in Column F & G, 1 pt per cell in Columns H-J, 1pt per cell for formulas in Columns H-J) Receive Date Cash Invoice Invoice Partial Cash Net Cost Credit Balance Terms Invoice Discount Amount Date Payment Discount Decimal Given Due Paid Decimal (Yes or No) $ 3.150,00 9-Jan 2/10 EOM 8-Feb $ 1.862,00 $ 884,00 6-Jun 5/10-30x 10-Jul $ 209,00 $ 1.920,00 11-Jan 3/10, 2/15. n/30 23-Jan $ 450,80 $ 6.120,00 4-Sep 4/20 prox 15-Nov $ 2.016,00 Be sure to save your work 20150705215346saccoman_kortnee_copy_of_project_4_11.xlsPartial Payments
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors