On December 31, 20X2, the accounting records of XYZ Corporation show the following unit sales for 20X2.
1st quarter 2nd quarter 41,200 units 43,000 units 3rd quarter 4th quarter 45,800 units 70,000 units
The following are additional actual amounts for the 4th quarter of 20X2.
Sales (70,000 units @$5.20) Purchases ( 58,800 units @ $2.80) Ending inventory $364,000$164,64024,700 units
Management has established a unit sales goal of 240,000 units for 20X3 and 50,000 units for the first quarter of 20X4. The sales manager, after reviewing price trends and checking with the company's merchandise suppliers, projects that the unit cost of merchandise will stay at the 20X2 price, $2.80 per unit, through 20X3. Because of stable costs, the company will be able to keep its unit sales price at$5.20 through 20X3.
After considering the time required to reorder merchandise, the sales manager requests that 50.0% of each quarter's unit sales be available in the prior quarter's ending inventory.
Expenses are projected as shown below. Except where noted, percentages are based on quarterly projected net sales. For these items, calculate each quarter's amount by multiplying the percentage times that quarter's net sales. Calculate the annual total by adding the four quarterly amounts. When a dollar amount is given, the total amount should be divided equally among the four quarters.
Interest expense for each quarter is projected to be $900.00.
Federal income taxes are calculated using the tax rate table shown in this chapter. Equal quarterly income tax payments are based on the projected annual federal income tax expense.
Additional information is as follows:
a. The balance of cash on hand on January 1, 20X3, is$45,080.00.
b. In each quarter, cash sales are 20.0% and collections of accounts receivable are 25.0% of the projected net sales for the current quarter. Collections from the preceding quarter's net sales are 54.5% of that quarter. Uncollectible accounts expense is 0.5% of net sales.
Selling Expenses Advertising Expense Delivery Expense Depreciation Expense-Delivery Equipment Depreciation Expense-Store Equipment Miscellaneous Expense-Sales Salary Expense-Sales Supplies Expense-Sales 1.2%0.7%$8,400$3,6000.2%5.4%0.8%
Administrative Expenses Depreciation Expense-Office Equipment Insurance Expense Miscellaneous Expense–Administrative Payroll Taxes Expense Rent Expense Salary Expense-Administrative Supplies Expense-Administrative Uncollectible Accounts Expense Utilities Expense $2,880$7,280$4,80012.0% of salaries $13,280$52,000$3,6000.5%1.5%
c. In each quarter, cash payments for cash purchases are 10.0% and for accounts payable 50.0% of the purchases for the current quarter. Cash payments for purchases of the preceding quarter are 40.0% of that quarter.
d. In the first quarter, $24,000 will be borrowed on a promissory note and equipment costing$35,000 will be purchased for cash. In each quarter, dividends of $30,000 will be paid in cash. In the fourth quarter, the promissory note plus interest will be paid in cash,$25,920.
Instructions:
Prepare the following budget schedules for the year ended December 31, 20X3. Round percentage amounts to the nearest 0.1%, unit amounts to the nearest 100 units, and dollar amounts to the nearest $10.
Prepare a selling expenses budget schedule (Schedule 3).