this is what i have so far , i am stuck on the raw materials budget , but i need help on all of it

i did some more work on it but i still dont know if my answers are correct , the ones with stars by it are the ones i am unsure of and i need help with the rest .

The management of Catlet Manufacturing, Inc- prepartd the following estimated balabce shect for June M022. To prepare a master budget for July, Abgust, and Scpiember of 2022 , management gathers the followitg infornation. 3. Sales were 18.000 units in June. Ferecasied sales in units are as follows: July. 20.000. Angast. 15.000. September. 30.000. and October 24,000 . The preducr's selling price is $17 per unit and its total peoduct cost is $14,35 per unit. b. Company policy calls for a given momh's ending finished goods inventory to equal 7of of the next month's expected anit sales The June 30 finished goods inventory is 16,500 units, which does not comply with the policy. The June 30 raw materials imvestory is 4,350 units ( which also fails to meet the policy). The bodneted september 30 raw manerials is 1,780 units. Raw materials cost $8 per wit. Fach finished unit requires 0,50 units of raw materials d. Each finished unit requires 0.50 bours of direct labor at a rate of $16 per hour: 6. OWerhead is allocated based on direct labor hoers. The predetermined variable overhead rate is 52.70 per dirset laber hoert. Depreciatice of $20,000 per month ts treahed as fixed factory overhead. f. Monthly gencral and administrative expenses include $10,000 administrative salaries and 0.9 s. monthly interest ce the loeg term aote payable. g. Soles representatives' commissions are 10% of sales and are puid in the month of the sales. The sales manager's moently salury is 53,500 . h. The eampany expects 30% of sales bo be for eash and the remaining 70% oo credin. Roceivables are collekted in fall in the morilh follorsing the sale (noec are collected in the moeth of the sale). i. All raw materials purchases are on credit, and no payables arise from any other trancactions. One msceth's raw muatcrials parchases are fully paid in the next month. j. Devidends of 525,000 are to be dectared and paid in Aisgast. J. Income taxes payable at June 30 will be paid in July. Income tax expense will be asensed at 35% in the quarter and paid in Octeber. k. Equipment purchases of $100,000 are budgeted for the last day of September: m. The minimum ending cash balance for all months is $30,000. If nccessary, the company bornows cnough cah using a short-kim note to rech the minimum. Short-term noecs require an inkerest paytnent of 1% ah each macmith-cnd (before any twpaytment). If the ending eash balance execeds the minimam, the excess will be applied to repaying the shori-term noten payable balance. Required Propare the following budgets and other financial information as roaired. All bodects and other financial informatiot aloell be propurod for the third calendar quarter, except as othcrwise noted below. Round calculations to the nearest whole dollar: 1. Sales badget. 7. Gencral and admintstrative expense bedget. 2. Production budget. 8. Cash budget. 3. Raw materials badget. 9. Bodgeted income statement for the entire quarter inot for each 4. Dircet labor budget mbenh separately). 5. Factory overhead bodget. 6. Selling expense budget. Sales Budget Catiett Manufacturing, Inc. 3rd Quarter 2021 \begin{tabular}{|l|l|r|r|r|r|} \hline 4 & & & & \\ \hline 5 & & Month & (Units) & (Per Unit) & (Dollars) \\ \hline 6 & & Sales & Selling Price & Budgeted Sales \\ \hline 7 & July & Mugust & 20,000 & $17.00 & 340,000 \\ \hline 8 & Auge & 15,000 & $17.00 & 255,000 \\ \hline 9 & September & 20,000 & $17.00 & 340,000 \\ \hline 10 & & 55,000 & & $935,000 \\ \hline 11 & & & \\ \hline \hline \end{tabular} 12 13 14 Production Budget 15 Catlett Manufacturing, Inc. 16 3rd Quarter 2021 17 \begin{tabular}{|l|l|} \hline 18 & \\ \hline 19 & Next Month's Sales \\ \hline 20 & X Ending Inventory % \\ \hline 21 & Ending Inventory Units \\ \hline 22 & Current Months Sales \\ \hline 23 & Current Month Needs \\ \hline 24 & Less: Beginning Inventory \\ \hline 25 & Budgeted Monthly Production (Units) \\ \hline \end{tabular} Raw Materials Budget Catlett Manufacturing, Inc. 3rd Quarter 2021 Budgeted Monthly Production (Units) X Raw Materials Needed per Unit Raw Materials Needed for Current Month \begin{tabular}{|rrr|} \hline \multicolumn{1}{|c|}{ July } & \multicolumn{1}{c|}{ August } & September \\ \hline 14,200 & 18,500 & 22,800 \\ \hline 0.50 & 0.50 & 0.50 \\ \hline 7,100 & 9,250 & 11,400 \\ \hline \end{tabular} 80 Selling Expense Budget 81 Catlett Manufacturing. Inc. 82. 3rd Quarter 2021 General \& Administrative Expense Budget Catlett Manufactariag. Inc. 3rd Quarter 2021 Administrative Salaries 100 Interest on N/P(0.9%65300,000) 101 Total General \&.Administrative Expenses 102 \begin{tabular}{|lll|} \hline 50 & $0 & 50 \\ \hline \end{tabular} 103 104 105 Schedule of Cash Receipts 106 Catlett Manufacturing. Inc. 107 3rd Quarter 2021 108 1109 Monthly Sales (Dollars) 111 X Cash W 112 Monthly Cash Sales (Dollars) 114 Monthly Sales (Dollars) 115 X Credit \% 116 Monthly Crodit Sales (Dollars) - A/R 117 118 Monthly Cash Receipts: \begin{tabular}{|r|r|r|} \hline$102,000 & $76,500 & $102,000 \\ \hline 0 & 238,000 & 178,500 \\ \hline$102,000 & $314,500 & $280,500 \\ \hline \end{tabular} Schedule of Cash Disbursements for Purchases 126 Catlett Manufacturing, Inc. 127 3rd Quarter 2021 \begin{tabular}{|r|r|r|} \hline July & August & \multicolumn{1}{c|}{ September } \\ \hline$0 & $71,600 & $77,440 \\ \hline \hline \end{tabular} Cash Budget Catiett Manufacturing, Inc. 3rd Quarter 2021 \begin{tabular}{|l|l} 137 & \\ \hline 138 & \\ \hline 139 & Beginning Cash \\ \hline \end{tabular} 140 Cash Receipts for Sales (Schedule of Cash Rec) 141 Total Cash Available 142 143 Cash Disbursements: 152 Interest on Short Term Note Payable (LOC)-1\% 157 Borrow 158 Repay 159 Ending Cash Balance \begin{tabular}{|lll} \hline($64,770)($20,345)($64,465) \\ \hline \end{tabular} Short-Term Note Analysis 164 165 166 167 168 169 170 Badgeted Inceme Statement Catictt Manufacturing. Inc. 3rd Quarter 2021 174 Raw Materials Budget Catlett Manufacturing. Inc. 3rd Quarter 2021 Budgeted Monthly Production (Units) X Raw Materials Needed per Unit Raw Materials Needed for Current Month Next Month Production Needs (Above) X Ending Inventory \% Ending Inventory Needs (Units) \begin{tabular}{rrr|} \hline 9,250 & 11.400 & 8900 \\ \hline 0.20 & 0.20 & 0.2 \\ \hline 1.850 & 2.280 & 1.780 \\ \hline \end{tabular} Raw Material Needs: Ending Inventory Production Needs Total Needs (Units) Less: Beginning Inventory Total Units to be Purchased X Cost per Unit Total Cost of Units to be Purchased \begin{tabular}{|rrr|} \hline 1.850 & 2,280 & 1,780 \\ \hline 7,100 & 9,250 & 11,400 \\ \hline 8,950 & 11,530 & 13,180 \\ (4.350) & (1.850) & (2,280) \\ \hline 4,600 & 9,680 & 10,900 \\ \hline 8.00 & 8.00 & 8.00 \\ \hline$36.800 & $77,440 & $87,200 \\ \hline \hline \end{tabular} Direct Laber Budget Catlett Manufacturing. Inc. 3rd Quarter 2021 Budgeted Monthly Production (Units) X Direct Labor Hours per Unit Total Direet Labor Hours Needed X Direct Labor Rate per Hour Total Cest of Direct Laber Needed Factory Overhead Budget Catlett Manufacturing. Inc. 3rd Quarter 2021 Variable Factory Overbead: Total Factery Overhead Selling Expense Budget Catlett Manufacturing. Ine. 3rd Quarter 2021 Variable Selling Expense: Total Budgeted Sales (Dollars) X Commission Rate Tota Variable Selling Expense Fixed Selling Expense - Sale's Mgr Salary Total Selling Expense \begin{tabular}{|r|r|r|} \hline \multicolumn{1}{|c|}{ July } & Augast & Sentember \\ \hline$340,000 & & \\ \hline 0.10 & $255,000 & $340,000 \\ \hline$34,000 & $25,500 & $34,000 \\ \hline 3,500 & 3,500 & 3.500 \\ \hline$32.500 & $29.0$90 & $37.500 \\ \hline \hline \end{tabular} General \& Administrative Expense Budget Catlett Manufacturing. Ine. 3rd Quarter 2021 Administrative Salaries Interest on N/P (0.9%$300,000) Total General \& Administrative Expenses \begin{tabular}{|rrr|} \hline Iuly & Ausust & Sistember \\ \hline$10,000 & $10,(000 & $10,000 \\ \hline 1 & 1 & 1 \\ \hline$10,001 & $10,001 & $10,001 \\ \hline \hline \end{tabular} The management of Catlet Manufacturing, Inc- prepartd the following estimated balabce shect for June M022. To prepare a master budget for July, Abgust, and Scpiember of 2022 , management gathers the followitg infornation. 3. Sales were 18.000 units in June. Ferecasied sales in units are as follows: July. 20.000. Angast. 15.000. September. 30.000. and October 24,000 . The preducr's selling price is $17 per unit and its total peoduct cost is $14,35 per unit. b. Company policy calls for a given momh's ending finished goods inventory to equal 7of of the next month's expected anit sales The June 30 finished goods inventory is 16,500 units, which does not comply with the policy. The June 30 raw materials imvestory is 4,350 units ( which also fails to meet the policy). The bodneted september 30 raw manerials is 1,780 units. Raw materials cost $8 per wit. Fach finished unit requires 0,50 units of raw materials d. Each finished unit requires 0.50 bours of direct labor at a rate of $16 per hour: 6. OWerhead is allocated based on direct labor hoers. The predetermined variable overhead rate is 52.70 per dirset laber hoert. Depreciatice of $20,000 per month ts treahed as fixed factory overhead. f. Monthly gencral and administrative expenses include $10,000 administrative salaries and 0.9 s. monthly interest ce the loeg term aote payable. g. Soles representatives' commissions are 10% of sales and are puid in the month of the sales. The sales manager's moently salury is 53,500 . h. The eampany expects 30% of sales bo be for eash and the remaining 70% oo credin. Roceivables are collekted in fall in the morilh follorsing the sale (noec are collected in the moeth of the sale). i. All raw materials purchases are on credit, and no payables arise from any other trancactions. One msceth's raw muatcrials parchases are fully paid in the next month. j. Devidends of 525,000 are to be dectared and paid in Aisgast. J. Income taxes payable at June 30 will be paid in July. Income tax expense will be asensed at 35% in the quarter and paid in Octeber. k. Equipment purchases of $100,000 are budgeted for the last day of September: m. The minimum ending cash balance for all months is $30,000. If nccessary, the company bornows cnough cah using a short-kim note to rech the minimum. Short-term noecs require an inkerest paytnent of 1% ah each macmith-cnd (before any twpaytment). If the ending eash balance execeds the minimam, the excess will be applied to repaying the shori-term noten payable balance. Required Propare the following budgets and other financial information as roaired. All bodects and other financial informatiot aloell be propurod for the third calendar quarter, except as othcrwise noted below. Round calculations to the nearest whole dollar: 1. Sales badget. 7. Gencral and admintstrative expense bedget. 2. Production budget. 8. Cash budget. 3. Raw materials badget. 9. Bodgeted income statement for the entire quarter inot for each 4. Dircet labor budget mbenh separately). 5. Factory overhead bodget. 6. Selling expense budget. Sales Budget Catiett Manufacturing, Inc. 3rd Quarter 2021 \begin{tabular}{|l|l|r|r|r|r|} \hline 4 & & & & \\ \hline 5 & & Month & (Units) & (Per Unit) & (Dollars) \\ \hline 6 & & Sales & Selling Price & Budgeted Sales \\ \hline 7 & July & Mugust & 20,000 & $17.00 & 340,000 \\ \hline 8 & Auge & 15,000 & $17.00 & 255,000 \\ \hline 9 & September & 20,000 & $17.00 & 340,000 \\ \hline 10 & & 55,000 & & $935,000 \\ \hline 11 & & & \\ \hline \hline \end{tabular} 12 13 14 Production Budget 15 Catlett Manufacturing, Inc. 16 3rd Quarter 2021 17 \begin{tabular}{|l|l|} \hline 18 & \\ \hline 19 & Next Month's Sales \\ \hline 20 & X Ending Inventory % \\ \hline 21 & Ending Inventory Units \\ \hline 22 & Current Months Sales \\ \hline 23 & Current Month Needs \\ \hline 24 & Less: Beginning Inventory \\ \hline 25 & Budgeted Monthly Production (Units) \\ \hline \end{tabular} Raw Materials Budget Catlett Manufacturing, Inc. 3rd Quarter 2021 Budgeted Monthly Production (Units) X Raw Materials Needed per Unit Raw Materials Needed for Current Month \begin{tabular}{|rrr|} \hline \multicolumn{1}{|c|}{ July } & \multicolumn{1}{c|}{ August } & September \\ \hline 14,200 & 18,500 & 22,800 \\ \hline 0.50 & 0.50 & 0.50 \\ \hline 7,100 & 9,250 & 11,400 \\ \hline \end{tabular} 80 Selling Expense Budget 81 Catlett Manufacturing. Inc. 82. 3rd Quarter 2021 General \& Administrative Expense Budget Catlett Manufactariag. Inc. 3rd Quarter 2021 Administrative Salaries 100 Interest on N/P(0.9%65300,000) 101 Total General \&.Administrative Expenses 102 \begin{tabular}{|lll|} \hline 50 & $0 & 50 \\ \hline \end{tabular} 103 104 105 Schedule of Cash Receipts 106 Catlett Manufacturing. Inc. 107 3rd Quarter 2021 108 1109 Monthly Sales (Dollars) 111 X Cash W 112 Monthly Cash Sales (Dollars) 114 Monthly Sales (Dollars) 115 X Credit \% 116 Monthly Crodit Sales (Dollars) - A/R 117 118 Monthly Cash Receipts: \begin{tabular}{|r|r|r|} \hline$102,000 & $76,500 & $102,000 \\ \hline 0 & 238,000 & 178,500 \\ \hline$102,000 & $314,500 & $280,500 \\ \hline \end{tabular} Schedule of Cash Disbursements for Purchases 126 Catlett Manufacturing, Inc. 127 3rd Quarter 2021 \begin{tabular}{|r|r|r|} \hline July & August & \multicolumn{1}{c|}{ September } \\ \hline$0 & $71,600 & $77,440 \\ \hline \hline \end{tabular} Cash Budget Catiett Manufacturing, Inc. 3rd Quarter 2021 \begin{tabular}{|l|l} 137 & \\ \hline 138 & \\ \hline 139 & Beginning Cash \\ \hline \end{tabular} 140 Cash Receipts for Sales (Schedule of Cash Rec) 141 Total Cash Available 142 143 Cash Disbursements: 152 Interest on Short Term Note Payable (LOC)-1\% 157 Borrow 158 Repay 159 Ending Cash Balance \begin{tabular}{|lll} \hline($64,770)($20,345)($64,465) \\ \hline \end{tabular} Short-Term Note Analysis 164 165 166 167 168 169 170 Badgeted Inceme Statement Catictt Manufacturing. Inc. 3rd Quarter 2021 174 Raw Materials Budget Catlett Manufacturing. Inc. 3rd Quarter 2021 Budgeted Monthly Production (Units) X Raw Materials Needed per Unit Raw Materials Needed for Current Month Next Month Production Needs (Above) X Ending Inventory \% Ending Inventory Needs (Units) \begin{tabular}{rrr|} \hline 9,250 & 11.400 & 8900 \\ \hline 0.20 & 0.20 & 0.2 \\ \hline 1.850 & 2.280 & 1.780 \\ \hline \end{tabular} Raw Material Needs: Ending Inventory Production Needs Total Needs (Units) Less: Beginning Inventory Total Units to be Purchased X Cost per Unit Total Cost of Units to be Purchased \begin{tabular}{|rrr|} \hline 1.850 & 2,280 & 1,780 \\ \hline 7,100 & 9,250 & 11,400 \\ \hline 8,950 & 11,530 & 13,180 \\ (4.350) & (1.850) & (2,280) \\ \hline 4,600 & 9,680 & 10,900 \\ \hline 8.00 & 8.00 & 8.00 \\ \hline$36.800 & $77,440 & $87,200 \\ \hline \hline \end{tabular} Direct Laber Budget Catlett Manufacturing. Inc. 3rd Quarter 2021 Budgeted Monthly Production (Units) X Direct Labor Hours per Unit Total Direet Labor Hours Needed X Direct Labor Rate per Hour Total Cest of Direct Laber Needed Factory Overhead Budget Catlett Manufacturing. Inc. 3rd Quarter 2021 Variable Factory Overbead: Total Factery Overhead Selling Expense Budget Catlett Manufacturing. Ine. 3rd Quarter 2021 Variable Selling Expense: Total Budgeted Sales (Dollars) X Commission Rate Tota Variable Selling Expense Fixed Selling Expense - Sale's Mgr Salary Total Selling Expense \begin{tabular}{|r|r|r|} \hline \multicolumn{1}{|c|}{ July } & Augast & Sentember \\ \hline$340,000 & & \\ \hline 0.10 & $255,000 & $340,000 \\ \hline$34,000 & $25,500 & $34,000 \\ \hline 3,500 & 3,500 & 3.500 \\ \hline$32.500 & $29.0$90 & $37.500 \\ \hline \hline \end{tabular} General \& Administrative Expense Budget Catlett Manufacturing. Ine. 3rd Quarter 2021 Administrative Salaries Interest on N/P (0.9%$300,000) Total General \& Administrative Expenses \begin{tabular}{|rrr|} \hline Iuly & Ausust & Sistember \\ \hline$10,000 & $10,(000 & $10,000 \\ \hline 1 & 1 & 1 \\ \hline$10,001 & $10,001 & $10,001 \\ \hline \hline \end{tabular}