Please provide excel formulas and functions only ach applied problem, use E 1 Tw

Question

Please provide excel formulas and functions only

ach applied problem, use E 1 Two salepersons sell two models of new cars: luxury and compact. The August and September gross dollar sales for each month are recorded in the matrices below: August CompactLuxury September Compact Luxury Salesperson 1 $ 54,000.00 88,000.00 Salesperson 2 126,000.00 $ Salesperson 1 228,000.00 $ 368,000.00 Salesperson 2 304,000.00 322,000.00 What were the combined gross dollar sales in August and September for each salesperson and model type? What was the increase in dollar sales from August to September for each salesperson and model type? If both salespersons receive a 5% commission on gross dollar sales, compute the September commission For each salesperson.

Explanation / Answer

1. Excel Function : SUM; formula :   =SUM(Cell1,Cell2) , where Cell1 : cell containing sales volume of a particular model for salesperson 1 in August and Cell2 : cell containing sales volume of the same model for salesperson 1 in September.

2. Excel Function : SUM ; Formula:    =SUM(Cell2, - Cell1) , where Cell1 : cell containing sales volume of a particular model for salesperson 1 in August and Cell2 : cell containing sales volume of the same model for salesperson 1 in September. Please note the minus sign which makes this formula different from part 1.

3. Excel Function : SUM ; Formula :   =SUM(Cell1,Cell2) * 0.05 , where Cell1 : cell containing sales volume of a compact model for salesperson 1 in September and Cell2 : cell containing sales volume of the luxury model for salesperson 1 in September

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.