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 RatioRealTimeService of- fers computer consulting, training, and repair services. For the most

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!