ShahExp22ExcelCh02CumulativeFurnitureSales

.xlsx
Garten Furniture Weekly Date Prepared: Sunday, October 22, 2023 Client Name SKU Item Name Delivery Price McGowan #NAME? #NAME? #NAME? #NAME? Client Name SKU Item Name Delivery Price McGowan 294211 Leather sectional Yes ₹ 1,399.00 Grossman 327064 Media cabinet Yes ₹ 379.99 Chamberlain 446741 End table set No ₹ 467.99 Vong 643081 Dining table No ₹ 599.99 Williams 294211 Leather sectional No ₹ 1,399.00 Hicks 446741 End table set No ₹ 467.99 Singh 306862 Entertainment center Yes ₹ 809.99 Zach 643081 Dining table No ₹ 599.99 Li 446741 End table set Yes ₹ 467.99 Totals SKU Description Price 294211 Leather sectional $1,399.00 306862 Entertainment center $809.99 327064 Media cabinet $379.99 446229 Suede recliner $1,099.99 446741 End table set $467.99 643081 Dining table $599.99
y Sales Total Due Years Monthly Payment #NAME? #NAME? #NAME? Total Due Years Monthly Payment Inputs ₹ 1,474.00 3 ₹ 43.03 Delivery Fee $75.00 ₹ 454.99 5 ₹ 8.23 Interest Rate 3.25% ₹ 467.99 3 ₹ 13.66 Months Per Year 12 ₹ 599.99 5 ₹ 10.85 ₹ 1,399.00 3 ₹ 40.84 ₹ 467.99 3 ₹ 13.66 ₹ 884.99 4 ₹ 19.69 ₹ 599.99 4 ₹ 13.35 ₹ 542.99 5 ₹ 9.82 ₹ 173.11 Statistics Number of Orders 9 Lowest Monthly Payment ₹ 8.23 Average Monthly Payment $19.23 Maximum Monthly Payment ₹ 43.03 Median Monthly Payment 13.66
Page1of 2
Uploaded by Kenilshah8550 on coursehero.com