Can someone help me with this please

OPTIMA, INC. Additional information: Ending finished goods inventory (percentage of the next quarter's sales) Ending raw materials inventory (percentage of the next quarter's production Exnected number of frames sold in following quarters: Regarding Inventory: Work-in-process has a zero beginning and ending balance. Direct Materials Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Purchased - Used = Ending) Finished Goods Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Produced Sold = Ending) Optima Company Balance Sheet 12/31/2019 Amount expected to be paid for a piece of equipment (purchased in 4th Quarter of Minimum cash balance required Borrowing increments Quarterly dividend payments $750,000 $40,000 $1 $250,000 Regarding Inventory: Work-in-process has a zero beginning and ending balance. Direct Materials Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Purchased - Used = Ending) Finished Goods Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Produced - Sold = Ending) Optima Company Balance Sheet 12/31/2019 Optima Company Sales Budget for the year ending December 31, 2020 Budgeted Sales (Units) 8 Unit Price Total Sales Optima Company Production Budget Optima Company Direct Materials Purchases Budget for the year ending December 31, 2020 Budgeted Production (Units) Materials per unit Production needs Desired ending Inventory \begin{tabular}{|rrrrr|} \hline Qtr. 1 & Qtr. 2 & Qtr. 3 & Qtr. 4 & Total \\ \hline 67,000 & 72,000 & 81,000 & 90,000 & 84,000 \\ 3 & 3 & 3 & 3 & 3 \\ \hline 201,000 & 216,000 & 243,000 & 270,000 & 252,000 \\ 64,800 & 72,900 & 81,000 & 75,600 & \\ \hline.. & & & & \end{tabular} Optima Company Direct Materials Purchases Budget for the year ending December 31, 2020 Optima Company Direct Labor Budget for the year ending December 31, 2020 Budgeted Production (Units) Hours per unit Hours needed Cost per hour Total Cost \begin{tabular}{|r|rrrr|} \hline Qtr. 1 & Qtr. 2 & \multicolumn{1}{|c|}{ Qtr. 3 } & Qtr. 4 & \multicolumn{1}{l|}{ Total } \\ \hline 67,000 & 72,000 & 81,000 & 90,000 & 310,000 \\ 0.50 & 0.50 & 0.50 & 0.50 & \\ \hline 33,500.00 & 36,000.00 & 40,500.00 & 45,000.00 & 155,000.00 \\ 15.00 & 15.00 & & 15.00 & 15.00 \\ \hline$502,500.00 & $540,000.00 & $607,500.00 & $675,000.00 & $2,325,000.00 \\ \hline \end{tabular} Optima Company Overhead Budget for the year ending December 31,2020 Optima Company Direct Labor Budgot Optima Company Overhead Budget for the year ending December 31, 2020 Budgeted hours Variable Rate Budgeted VOH Budgeted FOH Total OH \begin{tabular}{rrrrrr} \hline Qtr. 1 & Qtr. 2 & Qtr. 3 & Qtr. 4 & Total \\ \hline 33,500 & 36,000 & 40,500 & 45,000 & 155,000 \\ 88.00 & 8.00 & 8.00 & 8.00 & \\ \hline 268,000.00 & 288,000.00 & 324,000.00 & 360,000.00 & 1,240,000.00 \\ 275,000.00 & 275,000,00 & 275,000.00 & 275,000.00 & 1,100,000.00 \\ \hline$543,000.00 & $563,000.00 & $599,000.00 & $635,000.00 & $2,340,000.00 \\ \hline \end{tabular} Optima Company Selling and Administrative Expenses Budget for the year ending December 31, 2020 Budgeted Sales (Units) \begin{tabular}{ccrrr} Qtr. 1 & Qtr. 2 & Qtr. 3 & Qtr. 4 & Total \\ \hline 65,000 & 70,000 & 75,000 & 90,000 & 300,000 \end{tabular} Optima Company Selling and Administrative Expenses Budget for the year ending December 31, 2020 Optima Company Budgeted Cost Per Unit for the year ending December 31, 2020 Budgeted Manufacturing Costs: Unit Cost Direct Materials Direct Labor Overhead: Variable Fixed Total Unit Costs Optima Company Cost of Goods Sold Budget for the year ending December 31, 2020 Optima Company Income Statement for the year ending December 31, 2020 Sales Less: COGS Optima Company Income Statement for the year ending December 31,2020 Sales 2. Points Less: cOGS Gross margin Less: SRA Expenses income before taxes. Beginning Retained Earnings Optima Company Retained Earnings Statement for the year ending December 31, 2020 Add: Net income(Loss) Deduct Dividends Ending Retained Eamings Optima Company Balance Sheet Decmeber 31, 2020 Gross margin Less: SSA Expenses Income before taxes Optima Company Retained Earnings Statement for the year ending December 31, 2020 Beginning Retained Earnings 2 Points Add: Net Income(Loss) Deduct Dividends Ending Retained Eamings Optima Company Balance Sheet Decmeber 31, 2020 Liabilites and Stockholders Equity 4 Points Cash 40,000.00 Accounts Payable Accounts Receivable Line of Credit Payable Finished Goods imventory Capital Stock Direct Materials inventory Retained Earnings Total Plant, Property, and Equipment Total Assets Total Labilities \& Stockholders' f OPTIMA, INC. Additional information: Ending finished goods inventory (percentage of the next quarter's sales) Ending raw materials inventory (percentage of the next quarter's production Exnected number of frames sold in following quarters: Regarding Inventory: Work-in-process has a zero beginning and ending balance. Direct Materials Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Purchased - Used = Ending) Finished Goods Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Produced Sold = Ending) Optima Company Balance Sheet 12/31/2019 Amount expected to be paid for a piece of equipment (purchased in 4th Quarter of Minimum cash balance required Borrowing increments Quarterly dividend payments $750,000 $40,000 $1 $250,000 Regarding Inventory: Work-in-process has a zero beginning and ending balance. Direct Materials Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Purchased - Used = Ending) Finished Goods Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Produced - Sold = Ending) Optima Company Balance Sheet 12/31/2019 Optima Company Sales Budget for the year ending December 31, 2020 Budgeted Sales (Units) 8 Unit Price Total Sales Optima Company Production Budget Optima Company Direct Materials Purchases Budget for the year ending December 31, 2020 Budgeted Production (Units) Materials per unit Production needs Desired ending Inventory \begin{tabular}{|rrrrr|} \hline Qtr. 1 & Qtr. 2 & Qtr. 3 & Qtr. 4 & Total \\ \hline 67,000 & 72,000 & 81,000 & 90,000 & 84,000 \\ 3 & 3 & 3 & 3 & 3 \\ \hline 201,000 & 216,000 & 243,000 & 270,000 & 252,000 \\ 64,800 & 72,900 & 81,000 & 75,600 & \\ \hline.. & & & & \end{tabular} Optima Company Direct Materials Purchases Budget for the year ending December 31, 2020 Optima Company Direct Labor Budget for the year ending December 31, 2020 Budgeted Production (Units) Hours per unit Hours needed Cost per hour Total Cost \begin{tabular}{|r|rrrr|} \hline Qtr. 1 & Qtr. 2 & \multicolumn{1}{|c|}{ Qtr. 3 } & Qtr. 4 & \multicolumn{1}{l|}{ Total } \\ \hline 67,000 & 72,000 & 81,000 & 90,000 & 310,000 \\ 0.50 & 0.50 & 0.50 & 0.50 & \\ \hline 33,500.00 & 36,000.00 & 40,500.00 & 45,000.00 & 155,000.00 \\ 15.00 & 15.00 & & 15.00 & 15.00 \\ \hline$502,500.00 & $540,000.00 & $607,500.00 & $675,000.00 & $2,325,000.00 \\ \hline \end{tabular} Optima Company Overhead Budget for the year ending December 31,2020 Optima Company Direct Labor Budgot Optima Company Overhead Budget for the year ending December 31, 2020 Budgeted hours Variable Rate Budgeted VOH Budgeted FOH Total OH \begin{tabular}{rrrrrr} \hline Qtr. 1 & Qtr. 2 & Qtr. 3 & Qtr. 4 & Total \\ \hline 33,500 & 36,000 & 40,500 & 45,000 & 155,000 \\ 88.00 & 8.00 & 8.00 & 8.00 & \\ \hline 268,000.00 & 288,000.00 & 324,000.00 & 360,000.00 & 1,240,000.00 \\ 275,000.00 & 275,000,00 & 275,000.00 & 275,000.00 & 1,100,000.00 \\ \hline$543,000.00 & $563,000.00 & $599,000.00 & $635,000.00 & $2,340,000.00 \\ \hline \end{tabular} Optima Company Selling and Administrative Expenses Budget for the year ending December 31, 2020 Budgeted Sales (Units) \begin{tabular}{ccrrr} Qtr. 1 & Qtr. 2 & Qtr. 3 & Qtr. 4 & Total \\ \hline 65,000 & 70,000 & 75,000 & 90,000 & 300,000 \end{tabular} Optima Company Selling and Administrative Expenses Budget for the year ending December 31, 2020 Optima Company Budgeted Cost Per Unit for the year ending December 31, 2020 Budgeted Manufacturing Costs: Unit Cost Direct Materials Direct Labor Overhead: Variable Fixed Total Unit Costs Optima Company Cost of Goods Sold Budget for the year ending December 31, 2020 Optima Company Income Statement for the year ending December 31, 2020 Sales Less: COGS Optima Company Income Statement for the year ending December 31,2020 Sales 2. Points Less: cOGS Gross margin Less: SRA Expenses income before taxes. Beginning Retained Earnings Optima Company Retained Earnings Statement for the year ending December 31, 2020 Add: Net income(Loss) Deduct Dividends Ending Retained Eamings Optima Company Balance Sheet Decmeber 31, 2020 Gross margin Less: SSA Expenses Income before taxes Optima Company Retained Earnings Statement for the year ending December 31, 2020 Beginning Retained Earnings 2 Points Add: Net Income(Loss) Deduct Dividends Ending Retained Eamings Optima Company Balance Sheet Decmeber 31, 2020 Liabilites and Stockholders Equity 4 Points Cash 40,000.00 Accounts Payable Accounts Receivable Line of Credit Payable Finished Goods imventory Capital Stock Direct Materials inventory Retained Earnings Total Plant, Property, and Equipment Total Assets Total Labilities \& Stockholders' f