Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1. 12.00 points Exercise 15-3 Using a flexible budget to accommodate market unce

ID: 2587197 • Letter: 1

Question

1. 12.00 points Exercise 15-3 Using a flexible budget to accommodate market uncertainty LO 15-2 According to its original plan, Bailey Consulting Services Company plans to charge its customers for service at $131 per hour in 2014 The company president expects consulting services provided to customers to reach 48,000 hours at that rate. The marketing manager, however, argues that actual results may range from 42,000 hours to 54,000 hours because of market uncertainty. Baley's standard variable cost is $44 per hour, and its standard fixed cost is $1,370,000 Required Prepare flexible budgets based on the assumptions of service levels at 42000 hours, 48,000 hours, and 54,000 hours Flexible Budget 54,000 Hours Flexible Budget Flexible Budget 48,000 Hours chamomile-4014..gcha images (3ig images (2)jp9 O Type here to search

Explanation / Answer

Flexible Budget

42,000 Hours

Flexible Budget

48,000 Hours

Flexible Budget

54,000 Hours

Note : In case of flexible budget Fixed Costs are remain constant for all level of activities

Flexible Budget

42,000 Hours

Flexible Budget

48,000 Hours

Flexible Budget

54,000 Hours

Sales 42,000*131 = 5,502,000 48,000*131 = 6,288,000 54,000*131 = 7,074,000 Variable Costs 42,000*44 = (1,848,000) 48,000*44 = (2,112,000) 54,000*44 = (2,376,000) Contribution Margin 3,654,000 4,176,000 4,698,000 Fixed Costs (1,370,000) (1,370,000) (1,370,000) Net Income $2,284,000 $2,806,000 $3,328,000