SALES PROJECTIONS Wilson Sports basketball sales in August were 150,000 units. Sales are expected to grow by 2% in September October sales are expected to be 1,000 units less than in September. November sales will be 3% more than October. The selling price of the basketballs will remain the same $30 per unit. December sales projection is 157,000 units. INVENTORY POLICIES FINISHED GOODS MAINTAIN AND ENDING INVENTORY EQUAL TO 25% OF NEXT MONTH SALES ACTUAL BEGINNING INVENTORY 38,500 UNITS DIRECT MATERIALS MAINTAIN AND ENDING INVENTORY EQUAL TO 30% OF NEXT MONTH PRODUCTION ACTUAL BEGINNING INVENTORY 9,000 POUNDS The cost of materials purchased in August were $210,000 REQUIREMENTS Each basketball requires 25 pounds of materials at a cost of $7 per pound. December production are projected to be 156,000 units. Each basketball requires 15 minutes of labor at a rate of $12.00 per hour Fixed Overhead is $400,000 monthly and variable overhead is assigned as 130% of direct labor SELLING AND ADMINISTRATIVE EXPENSES Commissions are 10% of Sales and Sales salaries are $90,000 monthly General & Administrative Expenses are $150,000 OTHER EXPENSES AND CASH FLOWS A new machine at a total cost of $2,500,000 will be purchase in September Cash dividends of $2 million will be paid in October Last quarter taxes of $2,200,000 will be paid in October, because taxes are paid in next quarter at tax rate of 35% CASH POLICY The firm requires an ending cash balance of $350,000. Actual cash balance is $350,000 The firm has a short credit arrangement (credit line) with The National Bank. If the cash balance is lower than the required ending balance, the firm borrows from the bank. If the cash balance is higher than the required ending balance, the firm will pay the loan to the bank. The outstanding loan balance is $1,000,000 and the bank charges a 1% monthly interest rate. 80% of sales are cash sales and the remaining 20% collected one month later. 90% of direct materials purchased are paid in cash and the remaining 10% are paid in the next month. CALCULATE LOAN BALANCE AT THE END OF OCTOBER SALES PROJECTIONS Wilson Sports basketball sales in August were 150,000 units. Sales are expected to grow by 2% in September October sales are expected to be 1,000 units less than in September. November sales will be 3% more than October. The selling price of the basketballs will remain the same $30 per unit. December sales projection is 157,000 units. INVENTORY POLICIES FINISHED GOODS MAINTAIN AND ENDING INVENTORY EQUAL TO 25% OF NEXT MONTH SALES ACTUAL BEGINNING INVENTORY 38,500 UNITS DIRECT MATERIALS MAINTAIN AND ENDING INVENTORY EQUAL TO 30% OF NEXT MONTH PRODUCTION ACTUAL BEGINNING INVENTORY 9,000 POUNDS The cost of materials purchased in August were $210,000 REQUIREMENTS Each basketball requires 25 pounds of materials at a cost of $7 per pound. December production are projected to be 156,000 units. Each basketball requires 15 minutes of labor at a rate of $12.00 per hour Fixed Overhead is $400,000 monthly and variable overhead is assigned as 130% of direct labor SELLING AND ADMINISTRATIVE EXPENSES Commissions are 10% of Sales and Sales salaries are $90,000 monthly General & Administrative Expenses are $150,000 OTHER EXPENSES AND CASH FLOWS A new machine at a total cost of $2,500,000 will be purchase in September Cash dividends of $2 million will be paid in October Last quarter taxes of $2,200,000 will be paid in October, because taxes are paid in next quarter at tax rate of 35% CASH POLICY The firm requires an ending cash balance of $350,000. Actual cash balance is $350,000 The firm has a short credit arrangement (credit line) with The National Bank. If the cash balance is lower than the required ending balance, the firm borrows from the bank. If the cash balance is higher than the required ending balance, the firm will pay the loan to the bank. The outstanding loan balance is $1,000,000 and the bank charges a 1% monthly interest rate. 80% of sales are cash sales and the remaining 20% collected one month later. 90% of direct materials purchased are paid in cash and the remaining 10% are paid in the next month. CALCULATE LOAN BALANCE AT THE END OF OCTOBER