question is below ending finished good Inventory budget.

help.me with this problem 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 29. - Direct Labour costs $19.7 per direct labour hour. 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 Fine Office Company 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: - Selling and Administration expenses for the budgeted year are as follows: Variable Cost: minimum cash balance of $10,000 in the bank for each quarter. - Budgeted sales volumes year 2024 Q1: - Selling and Administration expenses for the budgeted year are as follows: Variable Cost: \begin{tabular}{|l|r|} \hline Fixed Costs per quarter: & \multicolumn{1}{|c|}{$} \\ \hline Accounting \& professional services & 1600 \\ \hline Administrative \& Sales Salaries & 40000 \\ \hline Advertising & 8000 \\ \hline Computer costs & 3000 \\ \hline Depreciation & 25000 \\ \hline Office Supplies & 2000 \\ Printing & 2500 \\ Insurance & 1500 \\ \hline Property taxes & 1000 \\ \hline Rent & 12000 \\ \hline Utilities & 3400 \\ \hline Total Fixed Costs & 100000 \\ \hline \end{tabular} - Fine Office Company will purchase a new machine on 1/1/2023 worth $500,000 and will make two equal payments. The first payment will be in Q1 and the second in Q4. Assume the machine was purchased at the beginning of the year. - Taxation is 55% on taxable income and paid at the end of Q 4 each year (Ignore negative taxes). - Balance sheet information as at 31st December 2022 is as follows; PPE Common Stock \begin{tabular}{|r|} \hline$100,000 \\ \hline$580,000 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline Accumulated Depreciation & $100,000 \\ \hline Retained Earnings & $145,000 \\ \hline \end{tabular} - For Cost of goods sold (COGS): Add total costs of production + Beginning Finished goods - Ending Finished goods Inventory. - Interest of 59,000 on loans is paid in total at the end of the year and is a fixed cost. \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{4}{|c|}{ Ending Finished Goods Inventory Budget P100 } \\ \hline 2 & \multicolumn{1}{|c|}{ Cost Element } & Quantity & Cost & Total \\ \hline 3 & Direct Materials & & & \\ \hline 4 & + Direct Labour & & & \\ 5 & + Manufacturing Overhead & & & \\ 6 & = Product Cost Per Unit & & & \\ \hline 7 & X Ending inventory in Units & & & \\ \hline 8 & Ending Finished Goods Inventory & & & \\ \hline & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline 10 & \multicolumn{3}{|c|}{ Ending Finished Goods Inventory Budget P200 } \\ \hline 11 & \multicolumn{1}{|c|}{ Cost Element } & Quantity & Cost & Total \\ \hline 12 & Direct Materials & & & \\ \hline 13 & + Direct Labour & & & \\ \hline 14 & + Manufacturing Overhead & & & \\ \hline 15 & - Product Cost Per Unit & & & \\ 16 & X Ending Inventory in Units & & & \\ \hline 17 & Ending Finished Goods Inventory & & & \\ \hline 18 & & & \end{tabular} \begin{tabular}{|r|l|} \hline Max. Points & Group Points \\ \hline 2 & \\ \hline 2 & \\ \hline 2 & \\ \hline 2 & \\ \hline 2 & \\ \hline 2 & \\ \hline 12 & \\ \hline \end{tabular}