Help me with this question...

go through the below tables and provide me with answer guys thank you .

21 11. Budgeted Balance Sheet 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 \begin{tabular}{|r|} \hline$1,200 \\ \hline$1,400 \\ \hline$360,000 \\ \hline \end{tabular} - 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 11% of the following quarter's budgeted sales in units. Each P100 unit uses \begin{tabular}{|l|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} Each P200 unit uses - Fine Office Company currently has $8 per sq. ft. the end of each quarter, Fine Office Company wants to have 91,200 sq. ft. of ending inventory. - Each product requires \begin{tabular}{|r|l|l} \hline 2 & machine hours and & 7 direct labour hrs to produga \\ \cline { 4 } & per direct labour hour. \end{tabular} - Direct Labour costs \$ - 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 40% of sales will be cash and 60% 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 the quarter they occurred. - Assume operating expenses occur evenly throughout the year and are all paid in cash. - For each quarter, the purchase and Q4 2022 were \begin{tabular}{|r|} \hline 70% \\ \hline 30% \\ \hline$1,500,000 \\ \hline \end{tabular} of material purchases are paid for in cash in the quarter of 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 2024 Q1: \begin{tabular}{|r|r|r|} \hline P100 & Q1 & 9804 \\ \hline P200 & Q1 & 10488 \\ \hline \end{tabular} - Budgeted sales volumes are: - Selling and Administration expenses for the budgeted year are as follows: Variable Cost: Delivery costs are based on Commissions are based on \begin{tabular}{|r|l} \hline$0.30 & per sales unit. \\ \cline { 1 - 2 } 0.1 & % of sales value. \end{tabular} Predetermined Overhead Rate: Estimated Manufacturing Overhead Machine Hours = = \$ per machine hour