Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Content Area Excelsior Company has three salespersons. Average sales price per unit sold, average variable manufacturing costs per unit, and number of units sold for
Content Area Excelsior Company has three salespersons. Average sales price per unit sold, average variable manufacturing costs per unit, and number of units sold for each salesperson follow. Commissions are earned according to the following schedule: Total Sales Percentage $0 to 49,999 6% $50,000 to $52,999 7% Over $53,000 8% Salesperson Mary Q. John A. Susan B. Avg. selling price per unit $50.00 $65.00 $45.00 Avg. var. mfg. costs per unit $25.00 $30.00 $35.00 Number of units sold 1,000 750 1,200 Prepare a contribution margin by salesperson report. Excelsior Company Contribution Margin by Salesperson For the Month Ended XX/XX/XXXX Salesperson Mary Q. John A. Susan B. Total sales $Total sales $Total sales $Total sales Variable mfg. cost Variable mfg. cost Variable mfg. cost Variable mfg. cost Manufacturing margin $Manufacturing margin $Manufacturing margin $Manufacturing margin Commissions Commissions Commissions Commissions Contribution margin per salesperson $Contribution margin per salesperson $Contribution margin per salesperson $Contribution margin per salesperson
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started