Excelsior Company has three salespersons. Average sales price per unit sold, average variable manufacturing costs...
70.2K
Verified Solution
Link Copied!
Question
Accounting
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
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!