High School

We appreciate your visit to Top executive officers of Munoz Company a merchandising firm are preparing next year s budget The controller has provided everyone with the current year s. This page offers clear insights and highlights the essential aspects of the topic. Our goal is to provide a helpful and engaging learning experience. Explore the content and find the answers you need!

Top executive officers of Munoz Company, a merchandising firm, are preparing next year's budget. The controller has provided everyone with the current year's projected income statement.

**Current Year**

- Sales revenue: $1,800,000
- Cost of goods sold: $1,260,000
- Gross profit: $540,000
- Selling & administrative expenses: $215,000
- Net income: $325,000

Cost of goods sold is usually 70 percent of sales revenue, and selling and administrative expenses are usually 10 percent of sales plus a fixed cost of $35,000. The president has announced that the company’s goal is to increase net income by 15 percent.

**Required**

The following items are independent of each other:

1. **Prepare a pro forma income statement.**
What percentage increase in sales would enable the company to reach its goal?

2. **Market Stagnation Scenario:**
The market may become stagnant next year, and the company does not expect an increase in sales revenue. The production manager believes that an improved production procedure can cut cost of goods sold by 2 percent.
- Prepare a pro forma income statement assuming the President's goal to increase net income by 15 percent.
- Calculate the required reduction in selling & administrative expenses to achieve the budgeted net income.

3. **Increased Advertising Scenario:**
The company decides to escalate its advertising campaign to boost consumer recognition, which will increase selling and administrative expenses to $341,000. With the increased advertising, the company expects sales revenue to increase by 15 percent. Assume that cost of goods sold remains a constant proportion of sales.
- Prepare a pro forma income statement.
- Will the company reach its goal?

**Pro Forma Income Statement Format**

- Sales revenue
- Cost of goods sold
- Gross profit
- Selling & administrative expenses
- Net income

For each scenario, calculate:

- Percentage increase needed for sales
- Required reduction in selling & administrative expenses

Will the company reach its goal?

Answer :

The company needs to increase its sales revenue by 15 percent to achieve its goal.

Sales revenue = $1,800,000

Cost of goods sold = 0.7*$1,800,000 = $1,260,000

Gross profit = $1,800,000 - $1,260,000 = $540,000

Selling & administrative expenses = 0.10*$1,800,000 + $35,000 = $215,000

Net income = $325,000

To increase net income by 15 percent, the company needs to generate a net income of $325,000*1.15 = $373,750.

New Sales revenue = Old Sales revenue * (1 + Increase percentage)

New Net income = Old Net income * (1 + Desired net income percentage)

$373,750 = $325,000 * (1 + Increase percentage)

Increase percentage = ($373,750/$325,000) - 1 = 0.15 or 15 percent.

Therefore, the company needs to increase its sales revenue by 15 percent to achieve its goal.

Pro Forma Income Statement with 2% cost of goods sold reduction:

Sales revenue = $1,800,000

Cost of goods sold = 0.7*$1,800,000*(1 - 0.02) = $1,235,200

Gross profit = $1,800,000 - $1,235,200 = $564,800

To achieve a net income of $373,750, selling & administrative expenses need to be:

Net income = Sales revenue*(1- Cost of goods sold percentage) - Selling & administrative expenses

$373,750 = $1,800,000*(1-0.6877778) - Selling & administrative expenses

Selling & administrative expenses = $115,523

Pro Forma Income Statement with increased advertising:

Sales revenue = $1,800,000*(1+0.15) = $2,070,000

Cost of goods sold = 0.7*$2,070,000 = $1,449,000

Gross profit = $2,070,000 - $1,449,000 = $621,000

Selling & administrative expenses = $341,000

Net income = $621,000 - $341,000 = $280,000

The company will not reach its goal of a 15 percent increase in net income with the increased advertising, as the net income decreased from $325,000 to $280,000.

Pro Forma Income Statement with required sales increase:

New net income = Old net income*(1+ Desired net income percentage)

$373,750 = $325,000*(1 + Increase percentage)

Increase percentage = ($373,750/$325,000) - 1 = 0.15 or 15 percent.

New Sales revenue = Old Sales revenue * (1 + Increase percentage)

New Sales revenue = $1,800,000 * (1 + 0.15) = $2,070,000

Revenue refers to the income generated by a company through the sale of goods or services to its customers. It is the total amount of money a business earns from its core operations during a specific period of time, such as a month, quarter, or year. Revenue is a crucial metric for any business because it reflects the company's ability to generate income and sustain its operations.

Revenue is calculated by multiplying the price of a product or service by the number of units sold. For example, if a company sells 1,000 units of a product for $10 each, the total revenue generated would be $10,000. Revenue can also be generated through other sources such as interest income, rental income, and investments. Revenue is an essential factor in determining a company's financial health and growth potential. By tracking revenue, businesses can evaluate their sales performance and make informed decisions about future investments and business strategies.

To learn more about Revenue visit here:

brainly.com/question/31683012

#SPJ4

Thanks for taking the time to read Top executive officers of Munoz Company a merchandising firm are preparing next year s budget The controller has provided everyone with the current year s. We hope the insights shared have been valuable and enhanced your understanding of the topic. Don�t hesitate to browse our website for more informative and engaging content!

Rewritten by : Barada