Chapter 7, Problem 20PSB

a)

To determine

Determine the percentage increase in sales and prepare the pro forma income statement.

Explanation of Solution

The formula to calculate the percentage of increase in sales:

$\%\text{of}\text{increase in sales}=\frac{\text{COGS}}{\text{Current sales}}\times 100$

Compute net income:

Excel workings:

Table (1)

Excel spread sheet:

Table (2)

Compute the percentage of COGS for next year:

$\begin{array}{c}\%\text{of budgeted COGS}=\frac{\text{COGS}}{\text{Sales}}\times 100\\ =\frac{\$560,000}{\$800,000}\times 100\\ =70\%\end{array}$

Hence, the percentage of COGS for next year is 70%.

Compute the sales value:

Consider sales as X:

$\begin{array}{c}\text{Net income}=\text{Sales}-\text{COGS}-\text{S\&A expenses}\\ \$132,000=\text{X}-0.70\text{X}-\$78,000-0.10\text{X}\\ \$132,000+\$78,000=\text{X}-0.70\text{X}-0.10\text{X}\\ \$210,000=0.2\text{X}\\ \text{X}=\$1,050,000\end{array}$

Hence, sales are $1,050,000.

Compute selling and administration expenses:

$\begin{array}{c}\text{Selling and administration expenses}=\text{10\% of sales revenue}+\text{Fixed cost}\\ =\$1,050,000\times 0.10+\$78,000\\ =\$183,000\end{array}$

Hence, the selling and administration expenses are $183,000.

Compute the percentage of increase in sales:

$\begin{array}{c}\%\text{of}\text{increase in sales}=\frac{\text{Projected sales}-\text{Current sales}}{\text{Current sales}}\times 100\\ =\frac{\$1,050,000-\$800,000}{\$800,000}\times 100\\ =31.25\%\end{array}$

Hence, the percentage of increase in sales is 31.25%.

Prepare a pro forma income statement:

Table (3)

Table (4)

Hence, the net income is $132,000.

b)

To determine

Prepare the pro forma income statement and the other ideas to reach the Person H’s goal.

Given information:

Discount rate of 3% on COGS

Explanation of Solution

Compute the COGS:

Excel spread sheet:

Table (5)

Excel workings:

Table (6)

Hence, the COGS are $543,200.

Compute the selling and administration expenses:

Consider selling and administration expenses as X:

$\begin{array}{c}\text{Gross profit}-\text{S\&A expenses}=\text{Net income}\\ \$256,800-\text{X}=\$132,000\\ \$256,800-\$132,000=\text{X}\\ \text{X}=\$124,800\end{array}$

Hence, selling and administration expenses are $124,800.

Prepare a pro forma income statement:

Excel spreadsheet:

Table (7)

The management cuts the selling and administrative expenses by the amount of $5,200 to reach the goals of Person H.

c)

To determine

Whether the company can reach the goal of Person H

Explanation of Solution

Compute projected sales:

$\begin{array}{c}\text{Projected sales}=\text{Current sales}\times 1\text{25\%}\\ =\$800,000\times \frac{\left(100+25\right)}{100}\\ =\$1,000,000\end{array}$

Hence, the projected sales are $1,000,000.

Compute the projected cost of goods sold:

$\begin{array}{c}\text{Projected cost of goods sold}=\text{Projected sales}\times \text{70\% }\\ =\text{\$1,000,000}\times 70\text{\% }\\ =\text{\$700,000}\end{array}$

Hence, the projected cost of goods sold is $700,000.

Prepare a pro forma income statement:

Excel workings:

Table (8)

Excel spreadsheet:

Table (9)

Hence, the net income is $130,000.

The company cannot reach the goal as the desired profit more than the actual that is $130,000 is more than the $132,000.