Requirement 1. Prepare a budgeted income statement with columns for 1,100 units, 1,200 units, and 1,800 units sold. Bolden Company Budgeted Income Statement For the Year Ended December 31, 2019 1,100 1,200 Unit sales 1,800 Sales Revenue Cost of Goods Sold Gross Profit Selling and Administrative Expenses Operating Income Requirement 2. How might managers use this type of budgeted income statement? The budgeted income statement prepared in Requirement 1 is a budget. It allows Bolden's managers to plan for sales level(s). Requirement 3. How might spreadsheet software such as Excel assist in this type of analysis? onduct and prepare a company's If managers have a better understanding of how changes in sales Technology, such as Excel spreadhseet software, makes it more volume and costs are likely to affect , they can if key assumptions turn out to be wrong. Bolden Company Budgeted Income Statement For the Year Ended December 31, 2019 Unit sales $ Sales Revenue ($450 per unit) Cost of Goods Sold (40% of sales) Gross Profit 1,200 540,000 216,000 324,000 189,000 Selling and Administrative Expenses (35% of sales) 135,000 Operating Income