Additional information:

1. Sales and variable costs of sales are expected to increase by seven percent in the next quarter.
2. All sales are on credit with 50 percent collected in the quarter of sale and 50 percent collected in the following quarter.
3. Variable cost of sales consists of 40 percent materials, 40 percent direct labor, and 20 percent variable overhead. Materials are purchased on credit. Sixty percent are paid for in the quarter of purchase, and the remaining amount is paid for in the quarter after purchase. There is no inventory. Also, direct labor and variable overhead costs are paid in the quarter the expenses are incurred.
4. Fixed production costs (other than $5,000 of depreciation expense) are expected to increase by 1.5 percent. Fixed production costs requiring payment are paid in the quarter they are incurred.
5. Fixed selling and administrative costs (other than $3,000 of depreciation expense) are expected to increase by three percent. Fixed selling and administrative costs requiring payment are paid in the quarter they are incurred.
6. The tax rate is expected to be 20 percent. All taxes are paid in the quarter they are incurred.
7. No purchases of fixtures or equipment are expected in the first quarter of 2021

8. Using Excel, prepare budget schedules according to the directions in 10-2 a. for Abruzzi Oil Company. Respond to questions 10-2 b. and c. in written report format with citations (APA style) included from the textbook and at least two other sources of your choosing.

   Sales Budgets with Consolidated Business (20 pts)

   Sales Budgets without Consolidated Business (20 pts)

   Production Budgets based on Sales Budgets (without extra sales to consolidated) (20 pts)

   Production Budgets based on Sales Budgets (with extra sales to consolidated) (20 pts)

   part b. (10 pts)

   part c. (10 pts)

Problem 10.2 (L02) Master Budget The results of operations for the Garret Bug Spray Manufacturing Company for the fourth quarter of 2020 were as follows in thousands): Sales of bug spray $500,000 Less variable cost of goods sold 280,000 Contribution margin 220,000 Less fixed production costs $90,000 Less fixed selling and administrative expenses 50,000 140,000 Income before taxes 80,000 Less taxes on income 32,000 Net income $ 48,000 Note: Garret uses the variable costing method. Thus, only variable costs are included in the cost of goods sold. Fixed costs are charged to expense in the period incurred. The company's balance sheet as of the end of the fourth quarter of 2020 was as follows (in thousands): Assets: Cash $ 30,000 Accounts receivable 250,000 Total current assets 280,000 Fixtures and equipment $130,000 Less accumulated depreciation 80,000 50,000 Total assets $330,000 Liabilities and owners' equity: Accounts payable $ 44,800 Retained earnings 175,000 Common stock 110,200 Total liabilities and owners' equity $330,000