Use the same spreadsheet you have just used to answer the previous problem. In this problem your

Question:

Use the same spreadsheet you have just used to answer the previous problem. In this problem your boss asks you to change various assumptions, one at a time. In each case, your starting point is the spreadsheet you created for the previous problem. What will the budgeted net income for 2014 be if you make only the change listed in each of the following assumptions?

A. Uncollectible sales are 1.5% instead of 1.1%.

B. Cash operating expenses are 8% of gross sales.

C. Taxes decrease to 33%.

D. The cost of goods sold for 2013 contained $100,000 of fixed costs, not

$40,000. The variable costs increase at the same 6% rate as sales.

E. While sales increase by 6%, and fixed costs in cost of goods sold are

$40,000, efficiency savings in the variable cost of goods sold mean that these costs only increase by 3% in 2014.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: