60.1K

Verified Solution

Link Copied!

Excel formula as response( box) using cells A4 to c7 from the given information

fx= A B C D E 2 Macy? \begin{tabular}{|l|l|r|r|} \hline 4 & Office equipment list price & $6,000 & \\ \hline 5 & Prepaid freight & $30 & \\ \hline 6 & Terms: & & \\ \hline 7 & Days 1 through 10, terms 3/10 & 3% & 10 \\ \hline 8 & Days 11 through 30, terms n/30 & n & 30 \\ \hline 9 & & \end{tabular} 10 Required: 11 Using the information given above, answer the following questions: 12 13 Note: Use cells A4 to C7 from the given information to complete this question. 14 15 1. What amount does LeeCo pay Macy within the discount period (check amount)? 17 18 Formula may only include cell references and the value 1. A publishing company pays its salespeople a weekly salary plus a 2% commission on all net sales over $5,000 (no commission on returned goods), answer the following questions: Required: Note: Use cells A2 to F6 from the given information to complete this question. fx= A B C D E 2 Macy? \begin{tabular}{|l|l|r|r|} \hline 4 & Office equipment list price & $6,000 & \\ \hline 5 & Prepaid freight & $30 & \\ \hline 6 & Terms: & & \\ \hline 7 & Days 1 through 10, terms 3/10 & 3% & 10 \\ \hline 8 & Days 11 through 30, terms n/30 & n & 30 \\ \hline 9 & & \end{tabular} 10 Required: 11 Using the information given above, answer the following questions: 12 13 Note: Use cells A4 to C7 from the given information to complete this question. 14 15 1. What amount does LeeCo pay Macy within the discount period (check amount)? 17 18 Formula may only include cell references and the value 1. A publishing company pays its salespeople a weekly salary plus a 2% commission on all net sales over $5,000 (no commission on returned goods), answer the following questions: Required: Note: Use cells A2 to F6 from the given information to complete this

Answer & Explanation Solved by verified expert

See Answer