Chapter IE, Problem 13IE

INTEGRATION EXERCISE 13 Master Budgeting, Statement ofCash Flows, Ratio Analysis, Cost-Volume-Profit Relationships, Variable Costing LO5-5. LO6-2, LO8-5, LO8-6, LO8-8, LO8-9, LO8-10. LO14-2, LO15-3 Refer to the information pertaining to Endless Mountain Company that is provided in Integration Exercise 9 as well as the schedules that you prepared in answering Integration Exercises 9 through 12.

Required:

1. Assume that the company expects to collect all of its credit sales in the quarter of sale rather than the original assumption that it will collect 75% of credit sales in the quarter of sale and the remaining25% in the subsequent quarter. Without changing any of the underlying assumptions in your budgeting assumptions tab,calculate the following revised figures related to the 2017 budget:
1. Net income (absorption basis)
2. Accounts receivable turnover
3. Net cash provided by operating activities
2. Go to the Budgeting Assumptions tab in your Microsoft Excel worksheet. Change the percentage of sales that are collected in the quarter of sale to 100% and the percentage of sales that are collected in the quarter after sale to 0%. Do your answers to la through lc match the numbers that appear in your Excel worksheet? If not, why?
3. Refer to the original budgeting assumptions from Integration Exercise 9. Assume that the company expects to pay its direct laborers $19 per hour instead of the original estimate of
$18 per hour. Without changing any of the underlying assumptions in your budgeting assumptions tab, calculate the following revised figures related to the 2017 budget:

1. Ending finished goods inventory at December 31. 2017.
2. The break-even point in unit sales.
3. Variable costing net operating income

Go to the Budgeting Assumptions tab in your Microsoft Excel worksheet. Change the direct labor cost per hour from S18 to S19. Do your answers to 3a through 3c march the numbers that appear in your Excel worksheet? If not, why?