Question: Please do in excel. Thanks PROBLEM 4-11. Multiproduct, Contribution Margin Ratio RealTimeService of- fers computer consulting, training, and repair services. For the most recent fiscal


Please do in excel. Thanks
PROBLEM 4-11. Multiproduct, Contribution Margin Ratio RealTimeService of- fers computer consulting, training, and repair services. For the most recent fiscal year, profit was $230,000 as follows: Consulting $500,000 Training $400,000 Repair $300,000 Total $1,200,000 250,000 20,000 1,000 229,000 160,000 30,000 2,000 208,000 180,000 60,000 4,000 56,000 590,000 110,000 7,000 493,000 Sales Less variable costs: Salaries Supplies/parts Other Contribution margin Less common fixed costs: Rent Owner's salary Utilities Other Profit 40,000 200,000 15,000 8,000 $ 230,000 Required a. Jon Cisco, the owner of RealTimeService, believes that in the coming year he can increase sales by 20 percent. Assuming the current mix of services, what will be the percentage increase in profit associated with a 20 percent increase in sales? Why will profit increase at a greater percent than sales? COST-VOLUME-PROFIT ANALYSIS b. If Jon were to focus on the contribution margin per unit (rather than the contribu- tion margin ratio), what would be a likely unit of service
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
