Sales territory and salesperson profitability analysis Instructions Amount Descr

Question

Sales territory and salesperson profitability analysis Instructions Amount Descriptions Contribution Margin by Salesperson Contribution Margin by Territory Instructions Reyes Industries Inc. manufactures and sells a variety of commercial vehicles in the Northeast and Southwest regions. There are two salespersons assigned to each territory. Higher commission rates go to the most experienced salespersons. The following sales statistics are available for each salesperson Northeast Southwest Cassy G Todd Tim Jeff Average per unit: Sales price Variable cost of goods sold Commission rate Units sold Manufacturing margin ratio $96,000 57,600 12% 28 40% $84,000 33,600 16% 24 60% $108,000 64,800 16% 24 40% $78,000 31,200 12% 38 60% Required: A. Prepare a contribution margin by salesperson report. Calculate the contribution margin ratio for each salesperson." B. Prepare a contribution margin by territory report. Calculate the contribution margin for each territory as a percent, rounded to one decimal place,* Refer to the Amount Descriptions list provided for the exact wording of the answer choices for text entries.

Explanation / Answer

a) Contribution Margin by Salesperson :-

b) Contribution Margin by Territory :-

Particulars Cassy G. Todd Tim Jeff Sales (Selling Price * No. of Unit Sold) 2688000 2016000 2592000 2964000 Less : Variable Cost of Goods Sold (Variable Cost * No. of Unit Sold) (1612800) (806400) (1555200) (1185600) Manufacturing Margin 1075200 1209600 1036800 1778400 Less : Commission (Rate * Sales) (322560) (322560) (414720) (355680) Contribution Margin 752640 887040 622080 1422720 Contribution Margin Ratio ((Contribution Margin / Sales)*100) 28% 44% 24% 48%

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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