Exp22_Excel_Ch07_CumulativeAssessment_Variation_Shipping

profileSolutions Aplus
afrhuj_Exp22_Excel_Ch07_CumulativeAssessment_Variation_Shipping.xlsx
Home>Computer Science homework help>Exp22_Excel_Ch07_CumulativeAssessment_Variation_Shipping

Week

Input Area Cities Shipping
Order Total Threshold $ 1,000 Austin $ 24
Total Days Delivery Goal 10 Dallas-Forth Worth $ 20
Shipping Refund Rate 50% Houston $ 30
Date Ordered Date Shipped Date Arrived Total Days Arrival Weekday Airport Code Shipped From Order Total Shipping Cost Shipping Refund
8/5/24 8/6/24 8/14/24 AUS $ 975
8/5/24 8/7/24 8/15/24 AUS $ 1,055
8/5/24 8/7/24 8/16/24 IAH $ 1,075
8/5/24 8/7/24 8/12/24 DFW $ 1,000
8/5/24 8/9/24 8/16/24 IAH $ 2,535
8/5/24 8/5/24 8/12/24 DFW $ 1,890
8/5/24 8/8/24 8/16/24 AUS $ 950
8/6/24 8/8/24 8/15/24 DFW $ 1,485
8/6/24 8/6/24 8/9/24 DFW $ 550
8/6/24 8/8/24 8/19/24 AUS $ 1,250
8/6/24 8/8/24 8/14/24 IAH $ 1,600
8/6/24 8/9/24 8/19/24 DFW $ 2,500
8/7/24 8/12/24 8/16/24 IAH $ 1,425
8/7/24 8/9/24 8/16/24 AUS $ 800
8/7/24 8/9/24 8/14/24 DFW $ 1,000
8/7/24 8/24/24 8/30/24 DFW $ 1,125
8/7/24 8/12/24 8/16/24 IAH $ 1,625
8/8/24 8/9/24 8/18/24 IAH $ 1,345
8/8/24 8/9/24 8/16/24 DFW $ 2,100
8/8/24 8/8/24 8/12/24 DFW $ 1,475
8/8/24 8/9/24 8/13/24 IAH $ 1,825
8/8/24 8/12/24 8/16/24 AUS $ 2,055
8/8/24 8/13/24 8/19/24 IAH $ 1,625
8/8/24 8/12/24 8/19/24 DFW $ 1,000
8/9/24 8/12/24 8/19/24 AUS $ 1,005
8/9/24 8/12/24 8/16/24 IAH $ 1,745
8/9/24 8/12/24 8/16/24 DFW $ 2,100
8/9/24 8/9/24 8/20/24 AUS $ 1,005
8/9/24 8/9/24 8/24/24 IAH $ 960

Stats

Statistics AUS DFW IAH
# of Shipments
Total Order Value
Average # of Days
Houston (IAH) Orders Over $1,000
Number of Orders Shipped
Total of Orders Shipped
Highest Order Value
Date Ordered Total Days Airport Code Order Total
8/5/24 0 AUS $ 975
8/5/24 10 AUS $ 1,055
8/5/24 11 IAH $ 1,075
8/5/24 7 DFW $ 1,000
8/5/24 11 IAH $ 2,535
8/5/24 7 DFW $ 1,890
8/5/24 11 AUS $ 950
8/6/24 9 DFW $ 1,485
8/6/24 3 DFW $ 550
8/6/24 13 AUS $ 1,250
8/6/24 8 IAH $ 1,600
8/6/24 13 DFW $ 2,500
8/7/24 9 IAH $ 1,425
8/7/24 9 AUS $ 800
8/7/24 7 DFW $ 1,000
8/7/24 23 DFW $ 1,125
8/7/24 9 IAH $ 1,625
8/8/24 6 IAH $ 1,345
8/8/24 8 DFW $ 2,100
8/8/24 4 DFW $ 1,475
8/8/24 5 IAH $ 1,825
8/8/24 8 AUS $ 2,055
8/8/24 11 IAH $ 1,625
8/8/24 11 DFW $ 1,000
8/9/24 10 AUS $ 1,005
8/9/24 7 IAH $ 1,745
8/9/24 7 DFW $ 2,100
8/9/24 11 AUS $ 1,005
8/9/24 0 IAH $ 960

Map

State Revenue
California $ 55,945
Colorado $ 30,650
Texas $ 41,080

Loan

Loan Information Payment # Beg Balance Interest Principal End Balance
Loan (PV) $ 80,000.00 1 $ 75,000.00
APR 5.00% 2 $ - 0
Monthly Rate 0.42% 3 $ - 0
Years for Loan 6 4 $ - 0
NPER 72 5 $ - 0
Monthly Payment $1,207.87 6 $ - 0
7 $ - 0
Cumulative Totals after Year 2 8 $ - 0
Interest 9 $ - 0
Principal Paid 10 $ - 0
11 $ - 0
What if the goal is $1,150 monthly payment? 12 $ - 0
Monthly Payment $ 1,150.00 13 $ - 0
Monthly Rate Needed 14 $ - 0
APR Needed 15 $ - 0
16 $ - 0
17 $ - 0
18 $ - 0
19 $ - 0
20 $ - 0
21 $ - 0
22 $ - 0
23 $ - 0
24 $ - 0