Please show the formulas to get the answer.

(4 pesos per link)

full warranty

Simplistic Scents Candle Co. Projected Budgeting Data Simplistic Scents Candle Co. Balance Sheet As of September 30, 2023 Schedule of Expected Cash Collections \begin{tabular}{|l|c|c|c|c|} \hline & \multicolumn{4}{|c|}{2023} \\ \hline & October & November & December & TOTA \\ \hline Cash from Current Month & & & & \\ \hline Cash from Prior Month & & & & \\ \hline TOTAL CASH COLLECTIONS & & & & \\ \hline \end{tabular} Production Budget Raw Materials Purchases Budget \begin{tabular}{|l|c|c|c|c|} \hline & \multicolumn{3}{|c|}{2023} \\ \hline & October & November & December & TOTA \\ \hline Units Produced & & & & \\ \hline Ounces of RM Required Per Unit of FG & & & & \\ \hline Total Ounces Used in Production & & & & \\ \hline Plus: Desired Ounces in Ending Inventory & & & & \\ \hline Total Ounces Required & & & & \\ \hline Less: Ounces in Beginning Inventory & & & & \\ \hline RAW MATERIALS PURCHASES (OUNCES) & & & & \\ \hline Cost per Ounce & & & & \\ \hline RAW MATERALS PURCHASES (COST) & & & & \\ \hline \end{tabular} Direct Labor Budget \begin{tabular}{|l|c|c|c|c|} \hline & \multicolumn{4}{|c|}{2023} \\ \hline & October & November & December & T \\ \hline Units Produced & & & & \\ \hline Labor Hours per Unit & & & & \\ \hline TOTAL LABOR HOURS REQUIRED & & & & \\ \hline Rate per Labor Hour & & & & \\ \hline TOTAL DIRECT LABOR COST & & & & \\ \hline \end{tabular} Manufacturing Overhead Budget \begin{tabular}{|l|c|c|c|c|} \hline & \multicolumn{3}{|c|}{2023} \\ \hline & October & November & December & \\ \hline Units Produced & & & & \\ \hline Variable Overhead Rate per Unit & & & & \\ \hline Total Variable Overhead Cost & & & & \\ \hline Fixed Overhead & & & & \\ \hline TOTAL OVERHEAD COST & & & & \\ \hline Noncash Overhead Expenses & & & & \\ \hline TOTAL OVERHEAD DISBURSEMENTS & & & & \\ \hline \end{tabular} Selling \& Administrative Expense Budget \begin{tabular}{|l|c|c|c|r|} \hline & \multicolumn{4}{|c|}{2023} \\ \hline Unit Sales & October & November & December & TOT \\ \hline Variable S\&A per Unit & & & & \\ \hline Total Variable S\&A & & & & \\ \hline Fixed S\&A & & & & \\ \hline TOTAL S\&A EXPENSE & & & & \\ \hline Noncash S\&A Expenses & & & & \\ \hline TOTAL S\&A DISBURSEMENTS & & & & \\ \hline \end{tabular} Cash Budget Simplistic Scents Candle Co. Budgeted Income Statement For the Quarter Ending DECEMBER 31, 2023 Sales Variable Expenses: Variable Manufacturing Expense Variable S\&A Expense Contribution Margin Fixed Expenses: Fixed Manufacturing Expense Fixed S\&A Expense Net Operating Income Simplistic Scents Candle Co. Budgeted Balance Sheet As of DECEMBER 31, 2023 ASSETS LIABILITIES \& EQUITIES Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory PP\&E, net TOTAL ASSETS Accounts Payable Note Payable Interest Payable TOTAL LIABILITIES Retained Earnings TOTAL EQUITIES TOTAL LIABILITIES \& EQUITIES Simplistic Scents Candle Co. Projected Budgeting Data Simplistic Scents Candle Co. Balance Sheet As of September 30, 2023 Schedule of Expected Cash Collections \begin{tabular}{|l|c|c|c|c|} \hline & \multicolumn{4}{|c|}{2023} \\ \hline & October & November & December & TOTA \\ \hline Cash from Current Month & & & & \\ \hline Cash from Prior Month & & & & \\ \hline TOTAL CASH COLLECTIONS & & & & \\ \hline \end{tabular} Production Budget Raw Materials Purchases Budget \begin{tabular}{|l|c|c|c|c|} \hline & \multicolumn{3}{|c|}{2023} \\ \hline & October & November & December & TOTA \\ \hline Units Produced & & & & \\ \hline Ounces of RM Required Per Unit of FG & & & & \\ \hline Total Ounces Used in Production & & & & \\ \hline Plus: Desired Ounces in Ending Inventory & & & & \\ \hline Total Ounces Required & & & & \\ \hline Less: Ounces in Beginning Inventory & & & & \\ \hline RAW MATERIALS PURCHASES (OUNCES) & & & & \\ \hline Cost per Ounce & & & & \\ \hline RAW MATERALS PURCHASES (COST) & & & & \\ \hline \end{tabular} Direct Labor Budget \begin{tabular}{|l|c|c|c|c|} \hline & \multicolumn{4}{|c|}{2023} \\ \hline & October & November & December & T \\ \hline Units Produced & & & & \\ \hline Labor Hours per Unit & & & & \\ \hline TOTAL LABOR HOURS REQUIRED & & & & \\ \hline Rate per Labor Hour & & & & \\ \hline TOTAL DIRECT LABOR COST & & & & \\ \hline \end{tabular} Manufacturing Overhead Budget \begin{tabular}{|l|c|c|c|c|} \hline & \multicolumn{3}{|c|}{2023} \\ \hline & October & November & December & \\ \hline Units Produced & & & & \\ \hline Variable Overhead Rate per Unit & & & & \\ \hline Total Variable Overhead Cost & & & & \\ \hline Fixed Overhead & & & & \\ \hline TOTAL OVERHEAD COST & & & & \\ \hline Noncash Overhead Expenses & & & & \\ \hline TOTAL OVERHEAD DISBURSEMENTS & & & & \\ \hline \end{tabular} Selling \& Administrative Expense Budget \begin{tabular}{|l|c|c|c|r|} \hline & \multicolumn{4}{|c|}{2023} \\ \hline Unit Sales & October & November & December & TOT \\ \hline Variable S\&A per Unit & & & & \\ \hline Total Variable S\&A & & & & \\ \hline Fixed S\&A & & & & \\ \hline TOTAL S\&A EXPENSE & & & & \\ \hline Noncash S\&A Expenses & & & & \\ \hline TOTAL S\&A DISBURSEMENTS & & & & \\ \hline \end{tabular} Cash Budget Simplistic Scents Candle Co. Budgeted Income Statement For the Quarter Ending DECEMBER 31, 2023 Sales Variable Expenses: Variable Manufacturing Expense Variable S\&A Expense Contribution Margin Fixed Expenses: Fixed Manufacturing Expense Fixed S\&A Expense Net Operating Income Simplistic Scents Candle Co. Budgeted Balance Sheet As of DECEMBER 31, 2023 ASSETS LIABILITIES \& EQUITIES Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory PP\&E, net TOTAL ASSETS Accounts Payable Note Payable Interest Payable TOTAL LIABILITIES Retained Earnings TOTAL EQUITIES TOTAL LIABILITIES \& EQUITIES