Break-even and other CVP analysis

Please provide the answers in the format of the screen shot excel spreadsheet. I have to be able to place answers in this format.

This link will take you to a teachers instruction with different numbers used. http://ashford.mediaspace.kaltura.com/media/ACC206A+Chapter+5+Problem+4/0_6q4jspa1

Quebec Inc. manufactures and sells a single product. The information that follows relates to the year just ended, when 230,000 units were sold:

Sales price per unit	$	10
Variable cost per unit		4.50
Fixed costs		930,000

Instructions

Determine the number of units that Quebec sold in excess of its break-even point.

If current revenue and cost patterns continue, compute the dollar sales needed next year to produce a target income of $492,000.

Assume that a different compensation plan was in effect during the current year. Rather than pay six salespeople an average salary of $36,000 each, management has proposed that the salespeople receive a $10,000 base salary and a 8% commission based on gross sales.

1) Would the company have been better off financially if the new plan had been adopted for the year just ended? By how much?

2) What effect might paying a commission have on gross sales? Briefly explain.

In addition to the compensation plan described in part (c), Quebec is studying the impact of other operating changes as well. State whether you agree or disagree with the following findings of a newly hired staff accountant: 1) A rise in property taxes will increase the break-even point. 2) A decrease in raw material cost will increase the contribution margin and decrease total fixed costs.

ACC206 Guidance Report Week Three Read-only Excel File Home Insert page Layout Formula Data Review view Q lell me what you want to do D95 15 YOUR ANSWERS BASED UPON COURSE START DATE a. Number of units that Quebec sold in excess of its break even point b. Compute the dollar sales needed 148 next year to produce a target income of $492,000. This amount is multiplied by the unit sales price, c. Change to costs if salary changed to $60,000 151 plus 6% commission based on gross sales. 1) By how much would the company have been better off financially if the new plan had been 154 adopted for the year just ended? By how much? 2) What effect might paying a commission have 55 56 on gross sales? Briefly explain. d. In addition to the compensation plan 158 described in part (c), Quebec is studying the impact of other operating changes as well. 60 State whether you agree or disagree with the following findings of a newly hired 162 staff accountant: 1) A rise in property taxes will increase the break-even point, 2) A decrease in raw material cost will increase the contribution margin and decrease total fixed costs. 68 Student Guidance Report Ready a ype here to search rhonda paul X Share 2:42 PM 5/2/2017