Use the data provided to make the Selling and Administrative Expense budget. The format is provided just use the data and plug in the numbers from the data.
Thermium, inc, is preporing its budget for the coming year, 2023, The first step is to plan for the first quarter of that coming vear, The compony has gathered information from its managers in preparation of the budgeting process. Thermium likes to keep 10% of the next month's unit sales in ending irwentory. All sales are on account. 80% of the Accounts Recelvable are collected in the month of sale, and 20% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31,2022 , totaled $180,000 Thermium likes to heep B\% of the materials needed for the next month in its ending inventory. Raw Materials on December 31.2022, totaled 34,050 pounds. Payment for materials is paid 75% in the month of parchase, and 25% is pald in the month after puirchase. Accounts Payable on December 31, 2022, totaled $25,000. Thermium thes to keep bx of the materials needed for the next month in is ending imventory. Raw Materialt on December 31, 2022, totaled 34,050 pounds. Payment for materials is paid 75% in the month of purchase, and 25% is paid in the month after purchase. Accounts Payable on Decernter 31,2002 , totaled $25,000. other information The Cash balance on December 31,2022, totaled $100,000, but the Bark requires Thermium to maintain an end of month cash balance of at least $700,000 beginning on January 31,2023. Dividends are paid each month at the rate of $3,00 per share for 5,000 shares outsanding. The company has an open line of credit with Calypas Bank. The terms of the agreement requires borrowing to be in 51,000 increments at 124 interest. Thermium borrows on the first day of the borrowing month and repays on the las: day of the repayment month. 6. For the first quarter of 2023, prepare a selling and administrative expense budget. Instruction: In this schedule we provide the Selling and Administrative budget. Some expenses are variable - which means they vary based on the sales. A good example of this is commission expense. The more cars a car dealer sells the more variable commissions are paid to sales representotives. Remember, Depreciation is a non-cash expense. Many of the expenses are fixed and can be derived from the data tab. Check Figure - Total Selling and Administrative Expenses =$897,900