
Schedule 6A: Budgeted Unit Costs of Ending Finished-Goods Inventory December 31, 2020 is as follows:

Schedule 6B: Ending Inventories Budget December 31, 2020 is as follows:
Total ending inventory: 5,246,000 dollars

Schedule 7: Cost of Goods Sold Budget for the Year Ending December 31, 2020 is as follows:
Cost of goods manufactured: 28,280,000 dollars
Cost of goods available for sale: 28,926,000 dollars

Schedule 8: Operating (Nonmanufacturing) Costs Budget for the Year Ending December 31, 2020 is as follows:

The spreadsheet consists of 4 columns and 8 rows.
Row 1
Column 1: Revenues
Column 2: Schedule 1
Column 4: dollar 38,000,000
Row 2:
Column 1: Cost of goods sold
Column 2: Schedule 7
Column 4: dollar 24,440,000
Row 3
Column 1: Gross margin
Column 4: dollar 13,560,000
Row 4: Operating costs
Row 5
Column 1: Operating costs
Column 2: Schedule 8
Column 3: dollar 1,024,000
Row 6
Column 1: Marketing costs
Column 2: Schedule 8
Column 3: dollar 3,800,000
Row 7
Column 1: Distribution costs
Column 2: Schedule 8
Column 3: dollar 3,876,000
Row 8
Column 1: Operating income
Column 4: dollar 4,860,000
Budgeting is a cross-functional activity. The strategies developed by top managers for achieving a company’s revenue and operating income goals affect the costs planned for the different business functions of the value chain. For example, the budgeted increase in sales at Stylistic is based on spending more for marketing and must be matched with higher production costs to ensure there is an adequate supply of tables and with higher distribution costs to ensure the timely delivery of tables to customers.
Rex Jordan, the CEO of Stylistic Furniture, is very pleased with the 2020 budget and the plans to increase operating income by 10% compared with 2019. The keys to achieving higher operating income are a significant increase in sales of Deluxe tables and process improvements and efficiency gains throughout the value chain. As Jordan studies the budget more carefully, he is struck by two comments appended to the budget: First, changes in the competitive environment may require Stylistic to reduce selling prices by 3% to $582 for Casual tables and to $776 for Deluxe tables to achieve the budgeted number of tables sold. Second, supply shortages of direct materials may result in prices of direct materials (red oak and granite) to be 5% higher than budgeted. In this second scenario, selling prices are anticipated to remain unchanged. He asks Tina Larsen, a management accountant, to use Stylistic’s financial planning model to evaluate how these events will affect budgeted operating income.