can you please tell me how to solve this or can help me solve this out

Recrealed from information providect. KLMN Purchases paid in cash in the same quarter % Purchases paid in the following quarter % Fine Office Company Fine Office Company makes office furniture for offices. They are in the process of preparing a Master Budget including the Operating budget, Cash Statement, Income Statement and Balance Shelet for 2023. The yearly budget is broken into quarters. The year end is 31st December 2023. Your group has been requested to compile a master budget for the fiscal year 2023. Package is to include the following budgets; 1. Sales budget for each quarter and for the year 2. Production budget for each quarter and for the year 3. Purchasing Budget for each quarter and for the year 4. Direct labour budget for each quarter and for the year 5. Manufacturing overhead budget for each quarter and for the year 6. Selling and Administration budget 7. Work sheets for Collections and Disbursements 8. Budgeted Income Statement 9. CVP Income Statement 10. Budgeted Cash Statement 11. Budgeted Balance Sheet Additional details: - Fine Office Company produces two products P100 and P200 - At the end of each quarter, Fine Office Company requires ending inventory to be equal to Marking Rubric \begin{tabular}{|l|r|r|} \hline Tab & Max. Points & Group Points \\ \hline Sales & 7 & 0 \\ \hline Production & 10 & 0 \\ \hline Dir. Materials & 13 & 0 \\ \hline Dir. Labour & 5 & 0 \\ \hline Manufacturing & 18 & 0 \\ \hline Cost of Ending F & 12 & 0 \\ \hline COGS & 14 & 0 \\ \hline Selling \& Admin & 17 & 0 \\ \hline 1/S & 18 & 0 \\ \hline CVP I/S & 1 & 0 \\ \hline Cash & 32 & 0 \\ \hline Cash Worksheet & 14 & 0 \\ \hline B/S & 24 & 0 \\ \hline Total & 185 & 0 \\ \hline \end{tabular} - Each P100 unit uses 313.5 sq. ft. of steel during the manufacturing process. The cost of steel for 2023 is estimated to be $8 persq. ft