Top executive officers of Rundle Company, a merchandising firm, are preparing the next year's budget. The controller has provid everyone with the current year's projected income statement. Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Current Year $ 1,900,000 1,425,000 475,000 266,000 $ 289,000 Cost of goods sold is usually 75 percent of sales revenue, and selling and administrative expenses are usually 10 percent of sales a fixed cost of $76,000. The president has announced that the company's goal is to increase net income by 10 percent. Required The following items are independent of each other: a. Prepare a pro forma income statement. What percentage increase in sales would enable the company to reach its goal? b. 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 1 percent. Prepare a pro forma income statement still assuming the President's goal to increase net income by 10 percent. Calculate the required reduction in selling & administrative expenses to achieve the budgeted net income. c. The company decides to escalate its advertising campaign to boost consumer recognition, which will increase selling and administrative expenses to $306,000. With the increased advertising, the company expects sales revenue to increase by 10 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? Complete this question by entering your answers in the tabs below. Required A Required B Required C Prepare a pro forma income statement. What percentage increase in sales would enable the company to reach its goal? Note: Round "Percentage increase" to 2 decimal places. (i.e., .2345 should be entered as 23.45). Sales revenue RUNDLE COMPANY Pro Forma Income Statement Cost of goods sold Gross profit Selling & administrative expenses Net income Percentage increase 0 $ 0 %6 Required B >
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Step by step
Solved in 5 steps