17. If 60% of sales are for cash, 40% of credit sales are collected during the month following the sale, and the remaining credit sales are collected two months after the sale, what formula would you need to enter on cell D7 to find th alue 4 Cash of total collections? April Mav June 582,000 730,000 774,000 2 Sales 3Collections 5 First Month 6 Second Month 7 Total Collections a. 0.6 B2+0.24 C2+0.16 D2 b. =0.6* D2+0.24*C2+0.16* B2 c.-0.6"D2+0.4*(C2+82) d' =0.4* D2+0.6*(C2+82) e. =0.6*D2-0.4*(C2+82)