this is a management accounting question, i do not know how to do it.

Beaver Baseball Company In-Class Project At Beaver Baseball Company, we make the world's best baseballs. We use world-class leather, cork and string to create unmatched quality and durability. To support our world-class baseballs, we create a master operational budget each year to plan and coordinate our efforts and to allow us to evaluate our performance. To help us complete this year's master operating budget, you will need the following information. Sales Budget We sell our baseballs for $14 per baseball. During the first quarter we plan on selling 40,000 balls in January, 145,000 balls in February, and 130,000 balls in March. After selling our baseballs, we plan on collecting 40% of those sales in the month of sale and 60% in the month following the sale. The beginning balance in accounts receivable will be $75,000. Production Budget We always start each year with 10,000 finished baseballs in inventory on January 1st. Each month during the year we want 25% of the following month's unit sales in ending inventory. We expect 225,000 units to be sold in April. Direct Material Budget - Leather Only We have already prepared the direct material budget for string and cork so you need to help with the direct material budget for the leather. We use 9 square inches of leather to make one baseball. Each month we want 35% of the following month's production requirements of leather in ending inventory. We buy premium leather for $0.25 per square inch. The beginning balance in accounts payable balance this year will be $85,000 and we plan to pay for 55% of the purchases in the month of purchase and 45% in the month following the purchase. We expect total production needed in April to be 1,650,000 square inches. Direct Labor Budget Our employees spend 0.05 of an hour making each baseball and we pay our employees $18 per hour. Manufacturing Overhead Budget Our variable manufacturing overhead rate is $3.00 per budgeted direct labor hour. Each month our fixed manufacturing overhead is $12,500. Each month we record $6,500 of depreciation for the factory and production equipment. SG&A Budget Our variable SG&A expenses are $1.10 per baseball. Our fixed SG&A expenses are as follows: Advertising Salaries Rent Insurance Property Taxes Depreciation $ 7,500 $22,500 $18,000 $ 2,500 $ 4,000 $ 8,000 Cash Budget We start each year with $25,000 in our bank account and require at least $25,000 in the bank at the end of every month. We have a $1,000,000 revolving line of credit at our bank and we are not restricted to any specific increment when borrowing or repaying funds, but when we borrow we must borrow at the beginning of a month and must repay at the end of a month. The bank charges us a 12% annual interest rate and interest is only paid when a principle payment is made. We purchase $80,000 of equipment in January and another $65,000 of equipment in March. The owners are paid $750,000 of dividends in February. Beaver Baseball Company Sales Budget Jan Feb Mar Qtr Jan Feb Mar Qtr Feb Mar Qtr Budgeted Unit Sales Sales Price/Unit Budgeted Revenue Schedule of Collections A/R Beginning Jan Sales Feb Sales Mar Sales Budgeted Cash Collection Collection - month of sale 40% Collection - month following sale 60% Production Budget Jan Budgeted Unit Sales Ending Inventory Required -- FG Total Units Needed Beginning Inventory -- FG Required unit production FG Ending Inventory Requirements 25% following month's budgeted unit sales Beaver Baseball Company Direct Material Budget Jan Feb Mar Qtr Required unit production Required material per unit - square inches Total Production Need Ending Inventory Required -- RM Total raw materials needed Beginning Inventory -- RM Raw material to be purchased Cost of raw material per square inch Budgeted Cost of Material to be Purchased RM Ending Inventory Requirements 35% Schedule of Cash Payments Jan following month's production requirements Feb Mar Qtr Feb Mar Qtr A/P Beginning Jan Purchases Feb Purchases Mar Purchases Budgeted Cash Payments Payment - month of purchase 55% Payment - month following purchase 45% Direct Labor Budget Required unit production Direct labor hours per unit Total direct labor hours Direct labor cost per hour Total direct labor cost Jan Beaver Baseball Company Manufacturing Overhead Budget Jan Feb Mar Qtr Jan Feb Mar Qtr Budgeted direct labor hours VOH Rate VOH FOH Total MFG-OH Depreciation Cash Paid for MFG-OH Total MFG-OH Budgeted DLH POR SG&A Budget Budgeted unit sales Variable SG&A per unit Variable SG&A Fixed SG&A: Advertising Salaries Rent Insurance Property Taxes Depreciation Total Fixed SG&A Total SG&A Depreciation Cash Paid for SG&A - - - - Beaver Baseball Company Cash Budget Jan Feb Beginning Balance Budgeted Cash Collection Budgeted Cash Available Budgeted Cash Payments: Materials Labor MFG-OH SG&A Dividends Equipment Total Budgeted Cash Payments Cash Over/(Short) Financing: Borrowing Repayment Interest Paid Total Financing Ending Balance Minimum Ending Balance Interest Rate $25,000.00 12% Borrowing: At beginning of the month Repayment: At end of the month Mar Qtr