can i get the workings for these as well please

PART I. COMPANY'S INFORMATION (a) Balance Sheet, December 31, Year 0 ASSETS Current Assets \begin{tabular}{|l|c|c|} \hline Cash & $7,000 & \\ \hline Accounts Receivable & $10,000 & \\ \hline Finished Goods Inventory & $10,500 fo & 1,500 units \\ \hline Raw Materials Inventory & $10,350 fo & 6,900 lbs \\ \hline Prepaid Insurance & $2,400 & \\ \hline \end{tabular} Property, Plant and Equipment Total Assets $105,250 LIABILITIES \& STOCKHOLDERS' EQUITY Liabilities Accounts Payable $8,000 $20,000 \begin{tabular}{l|r|l|l|} \hline Direct material requirement & 2 & lbs per unit of product cost per lbs & $1.50 \\ \hline Direct labor requirement & 0.5 hrs per unit of product cost per DLH & $6.00 \\ \hline Variable Overhead's POR & $1.40 & per direct labor hour & \\ \hline \end{tabular} Fixed Overhead per Month \begin{tabular}{|r|r|} \hline Salaries & $680 \\ \hline Utilities & $350 \\ \hline Insurance & $200 \\ \hline Depreciation & $700 \\ \hline Total & $1,930 \\ \hline \end{tabular} (d) Desired Ending Inventories Finished goods 50% of Unit sales in next month Raw material 60% of Quantity (pounds) to be used in production next month (e) Estimated S \& A (selling and administrative) Expenses \begin{tabular}{|l|r|l|} \hline Sales Commissions (Variable) & $0.80 & per Unit sold \\ \hline Salaries (Fixed) & $2,000 & per Month \\ \hline Advertising (Fixed) & $600 & per Month \\ \hline Miscellaneous (Fixed) & $2,345 & Jan only \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} \hline Miscellaneous (Fixed) & $2,345 & Jan only \\ \hline Miscellaneous (Fixed) & $1,540 & Feb only \\ \hline Miscellaneous (Fixed) & $481 & Mar only \\ \hline \end{tabular} (f) Estimated Cash Collections, Cash Payments, Financing and Other Information Cash Collections from Sales 70% Same month of sale 30% Next month Cash payments 60% Same month of purchase for Material Purchases 40% Next month Cash Payment for Dividends $500 End of March \begin{tabular}{|l} New Equipment Purchase \\ \hline Cash Payments for Other Items \end{tabular} $3,000 End of March Minimum Cash Level $6,000 (Has to be maintained at the end of each month) (Minimum cash level should be maintained before making interest payment, but after borrowing or repayment.) but after borrowing or repayment.) Bank Loan Borrowing time (If borrowing is needed for a given month, it should occur at the beginning of the month.) Just enough to satisfy the minimum cash level requirement Repayment time (If repayment is ever made for a given month, it should occur at the beginning of the month) Repayment amount Maximum possible amount after satisfying the minimum cash level requirement 1% per month on outstanding loan balance as of the end of the month To be paid at the end of each month Insurance cost will be charged to (deducted from) Prepaid Insurance. No cash will be paid. Long-term Note is a liability that does not bear interest. PART II. ALL BUDGETS/SCHEDULES FOR THE FIRST QUARTER OF Year 1 (1) Sales Budget Expected sales - units Selling price per unit Total sales (2) Schedule of Expected Cash Collections (Cash Receipts Budget) Jan Feb Mar Qtr From sales before January From January sales From February sales From March sales Total cash collections (3) Production Budget Expected sales units Desired ending inventory Total needs Less: Beginning inventory Less: Beginning inventory Units to be produced (4) Direct Materials Purchases Budget Units to be produced Material needed per unit (lbs) Production needs (lbs) Desired ending quantity (lbs) Total needs (lbs) Less: Beginning quantity (lbs) Material to be purchased (lbs) Cost of material purchase (\$) (5) Schedule of Expected Cash Disbursements (Cash Disbursements Budget) for Direct Materials For Purchases before January For January purchases For February purchases For March purchases Qtr Total cash disbursements (6) Direct Labor Budget \begin{tabular}{|l|l|l|} \hline Jan & Feb & Mar \\ \hline \end{tabular} Units to be produced DL time required per unit Total hours of DL time needed Direct labor cost per hour Cash Disbursements for MOH (8) Selling and Administrative Expense Budget Qtr Budgeted sales in units Variable S\&A expense per unit Budgeted variable expense Budgeted Fixed S\&A expenses Salaries Advertising Miscellaneous Total \begin{tabular}{|} \\ \\ \\ \hline \end{tabular} Total budgeted S\&A expenses (9) Cash Budget Cash balance, beginning Add cash receipts: Collections from sales Total cash available Disbursements: \begin{tabular}{|l|} \hline Payments for Material purchases \\ \hline Payments for Direct labor costs \\ \hline Payments for Manufacturing overhead \\ \hline Payments for Selling and administrative \\ \hline Payments for Equipment purchase \\ \hline Payments for Dividends \\ \hline Total Disbursements \\ \hline \end{tabular} Excess (Deficiency) * negative amount in ( ) Financing: Bank loan Borrowing (repayment) * negative amount in ( ) Cash before interest payment Interest payment Cash balance, ending (10) Budgeted Income Statement, for 1st Quarter of Year 1 Qtr Sales Less: Cost of goods sold Gross margin Less: Selling and admin. expenses Met oneratinn incoms LIABILITIES \& STOCKHOLDERS' EQUITY Liabilities Accounts Payable Long-term Note Bank Loan \begin{tabular}{|} \hline+2 \\ \hline \end{tabular} Stockholders' Equity Common Stock Retained Earnings Total Liabilities and Equity Net operating income Less: Interest expenses Net income (11) Balance Sheet, as of March 31, Year 1 ASSETS Current Assets Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Prepaid Insurance Property, Plant and Equipment Plant and Equipment Less: Accumulated Depreciation Total Assets PART I. COMPANY'S INFORMATION (a) Balance Sheet, December 31, Year 0 ASSETS Current Assets \begin{tabular}{|l|c|c|} \hline Cash & $7,000 & \\ \hline Accounts Receivable & $10,000 & \\ \hline Finished Goods Inventory & $10,500 fo & 1,500 units \\ \hline Raw Materials Inventory & $10,350 fo & 6,900 lbs \\ \hline Prepaid Insurance & $2,400 & \\ \hline \end{tabular} Property, Plant and Equipment Total Assets $105,250 LIABILITIES \& STOCKHOLDERS' EQUITY Liabilities Accounts Payable $8,000 $20,000 \begin{tabular}{l|r|l|l|} \hline Direct material requirement & 2 & lbs per unit of product cost per lbs & $1.50 \\ \hline Direct labor requirement & 0.5 hrs per unit of product cost per DLH & $6.00 \\ \hline Variable Overhead's POR & $1.40 & per direct labor hour & \\ \hline \end{tabular} Fixed Overhead per Month \begin{tabular}{|r|r|} \hline Salaries & $680 \\ \hline Utilities & $350 \\ \hline Insurance & $200 \\ \hline Depreciation & $700 \\ \hline Total & $1,930 \\ \hline \end{tabular} (d) Desired Ending Inventories Finished goods 50% of Unit sales in next month Raw material 60% of Quantity (pounds) to be used in production next month (e) Estimated S \& A (selling and administrative) Expenses \begin{tabular}{|l|r|l|} \hline Sales Commissions (Variable) & $0.80 & per Unit sold \\ \hline Salaries (Fixed) & $2,000 & per Month \\ \hline Advertising (Fixed) & $600 & per Month \\ \hline Miscellaneous (Fixed) & $2,345 & Jan only \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} \hline Miscellaneous (Fixed) & $2,345 & Jan only \\ \hline Miscellaneous (Fixed) & $1,540 & Feb only \\ \hline Miscellaneous (Fixed) & $481 & Mar only \\ \hline \end{tabular} (f) Estimated Cash Collections, Cash Payments, Financing and Other Information Cash Collections from Sales 70% Same month of sale 30% Next month Cash payments 60% Same month of purchase for Material Purchases 40% Next month Cash Payment for Dividends $500 End of March \begin{tabular}{|l} New Equipment Purchase \\ \hline Cash Payments for Other Items \end{tabular} $3,000 End of March Minimum Cash Level $6,000 (Has to be maintained at the end of each month) (Minimum cash level should be maintained before making interest payment, but after borrowing or repayment.) but after borrowing or repayment.) Bank Loan Borrowing time (If borrowing is needed for a given month, it should occur at the beginning of the month.) Just enough to satisfy the minimum cash level requirement Repayment time (If repayment is ever made for a given month, it should occur at the beginning of the month) Repayment amount Maximum possible amount after satisfying the minimum cash level requirement 1% per month on outstanding loan balance as of the end of the month To be paid at the end of each month Insurance cost will be charged to (deducted from) Prepaid Insurance. No cash will be paid. Long-term Note is a liability that does not bear interest. PART II. ALL BUDGETS/SCHEDULES FOR THE FIRST QUARTER OF Year 1 (1) Sales Budget Expected sales - units Selling price per unit Total sales (2) Schedule of Expected Cash Collections (Cash Receipts Budget) Jan Feb Mar Qtr From sales before January From January sales From February sales From March sales Total cash collections (3) Production Budget Expected sales units Desired ending inventory Total needs Less: Beginning inventory Less: Beginning inventory Units to be produced (4) Direct Materials Purchases Budget Units to be produced Material needed per unit (lbs) Production needs (lbs) Desired ending quantity (lbs) Total needs (lbs) Less: Beginning quantity (lbs) Material to be purchased (lbs) Cost of material purchase (\$) (5) Schedule of Expected Cash Disbursements (Cash Disbursements Budget) for Direct Materials For Purchases before January For January purchases For February purchases For March purchases Qtr Total cash disbursements (6) Direct Labor Budget \begin{tabular}{|l|l|l|} \hline Jan & Feb & Mar \\ \hline \end{tabular} Units to be produced DL time required per unit Total hours of DL time needed Direct labor cost per hour Cash Disbursements for MOH (8) Selling and Administrative Expense Budget Qtr Budgeted sales in units Variable S\&A expense per unit Budgeted variable expense Budgeted Fixed S\&A expenses Salaries Advertising Miscellaneous Total \begin{tabular}{|} \\ \\ \\ \hline \end{tabular} Total budgeted S\&A expenses (9) Cash Budget Cash balance, beginning Add cash receipts: Collections from sales Total cash available Disbursements: \begin{tabular}{|l|} \hline Payments for Material purchases \\ \hline Payments for Direct labor costs \\ \hline Payments for Manufacturing overhead \\ \hline Payments for Selling and administrative \\ \hline Payments for Equipment purchase \\ \hline Payments for Dividends \\ \hline Total Disbursements \\ \hline \end{tabular} Excess (Deficiency) * negative amount in ( ) Financing: Bank loan Borrowing (repayment) * negative amount in ( ) Cash before interest payment Interest payment Cash balance, ending (10) Budgeted Income Statement, for 1st Quarter of Year 1 Qtr Sales Less: Cost of goods sold Gross margin Less: Selling and admin. expenses Met oneratinn incoms LIABILITIES \& STOCKHOLDERS' EQUITY Liabilities Accounts Payable Long-term Note Bank Loan \begin{tabular}{|} \hline+2 \\ \hline \end{tabular} Stockholders' Equity Common Stock Retained Earnings Total Liabilities and Equity Net operating income Less: Interest expenses Net income (11) Balance Sheet, as of March 31, Year 1 ASSETS Current Assets Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Prepaid Insurance Property, Plant and Equipment Plant and Equipment Less: Accumulated Depreciation Total Assets