Please do in excel and provide working calculations in how you achieved an answer. If you will not do as stated please leave for someone else. Thanks!

10.47 Sales, Materials, Production, and Labour Budgets, Flexible Budgets, Motivation Mike's Bikes makes and sells high-quality replacement gears for mountain bikes. Mike Speedway, controller, is responsible for preparing the master budget and has assembled the following data for 2016.

The direct labour rate includes wages and all employee-related benefits and the employer's share of Canada Pension Plan (CPP) and Employment Insurance (EI). Labour-saving machinery will be fully operational by February. Also, as of March 1, the company's union contract calls for an increase in direct labour wages that is included in the direct labour rate.

Mike's Bikes expects to have 100 gear units in inventory at December 31, 2015, and has a policy of carrying 5% of the following month's projected sales in inventory during the first quarter of the year.

		2016
	January	February	March	April
Estimated unit sales	800	1,000	2,000	2,400
Sales price per unit	$30	$30	$25	$25
Direct labour hours per unit	0.75	0.5	0.5	0.5
Direct labour hourly rate	$16	$16	$18	$18
Direct materials cost per unit	$5	$5	$5	$5
Direct materials per gear	0.30 kg	0.30 kg	0.30 kg	0.30 kg

Required

B) Calculate the total budgeted contribution margin for Mike's Bikes for the first quarter of 2016. Be sure to show supporting calculations. C) Assume that due to decreasing gas prices, more people are expected to drive (not bike) during the first quarter of 2016. The revised estimated sales for replacement gear units is 10% lower. Prepare new budgets based on this revised estimate. D) If the actual sales in January are 750 gears, which budget would you use to evaluate performance? Using a rolling budget approach, what adjustments would you make to the remaining budgets?