question is cash budget

help me with this question guys. thanks

Additional details: - Fine Office Company produces two products P100 and P200 - Sales price per P100 is - Sales price per P200 is - The value of P100 finished goods inventory at the end of 2022 is - At the end of each quarter, Fine Office Company requires ending inventory to be equal to The value of P200 finished goods inventory at the end of 2022 is $300,000 - Each P100 unit uses Each P200 unit uses \begin{tabular}{|r|l|l|} \hline 114 & sq. ft. of steel during the manufacturing process. The cost of steel for 2023 is estimated to be \\ \hline 152 & sq. ft. of steel during the manufacturing process. \end{tabular} - Fine Office Company currently has $8 per sq. ft. - Fine Office Company allocates manufacturing overhead costs based on the estimated machine hours. Estimated manufacturing overhead cost for 2023 are $143,640 and are all variable. - For each quarter, it is estimated that will be credit sales. Of the credit sales, 80% pay in the quarter of the sale and 20% pay in the following quarter. Credit sales from Q4 2022 were - Direct labour costs and manufacturing overhead costs are paid for in cash in tt Yuarter they occurred. - Assume operating expenses occur evenly throughout the year and are all paid in cash. - For each quarter, \begin{tabular}{|r|r|} \hline 70% & of material purchases are paid for in cash in the quarter of \\ \hline 30% & are paid in the following quarter. Purchases of materials from \\ \hline$1,500,000 & \end{tabular} Fine Office Company Additional details continued: - Fine Office Company will pay $60,000 in dividends in Q4 Additional details continued: - Fine Office Company will pay $60,000 in dividends in Q4 - Currently, the cash balance in the bank is $15,000. Fine Office Company wants to maintain a minimum cash balance of $10,000 in the bank for each quarter. - Budgeted sales volumes year 2024Q1 : Variable Cost: \begin{tabular}{|r|r|} \hline$0.30 & per sales unit. \\ \hline 0.1 & % of sales value. \end{tabular} - Taxation is the beginning of the year. 25% on taxable income and paid at the end of Q 4 each year (Ignore negative taxes). - Balance sheet information as at 31 st December 2022 is as follows; \begin{tabular}{|l|l|l|l|} \hline PPE & $100,000 & Accumulated Depreciation & $100,000 \\ \hline Common Stock & $580,000 & Retained Earnings & $145,000 \\ \hline - For Cost of goods sold (COGS): & & & \end{tabular} - Interest of - Interest of $9,000 on loans is paid in total at the end of the year and is a fixed cost