Question: using the numbers provided, can you help me with the sales budget & cash collections with formulas 15 16 Budgeting Assumptions 17 Yang Corp. 18


15 16 Budgeting Assumptions 17 Yang Corp. 18 \begin{tabular}{|c|} \hline Budgeting Assumptions \\ \hline \end{tabular} 19 First Year of Operations - 2024 20 21 Quarterly Sales Budget 22 Budgeted Sales in Units 23 Unit Selling Price 24 Percentage of sales collected in the quarter of sale 25 Percentage of sales collected in the quarter after sale Each Quarter 26 27 Quarterly Merchandise Burchases Budget 28 Cost of each unit 29 Desired Ending Merchandise Inventory in units \begin{tabular}{|lr|} \hline 5 & 500 \\ \hline & 4 \\ \hline \end{tabular} Quarterly SGRA Expense Budgat Variable SG\&A expense per unit Fixed SG\&A Expenses per quarter: Advertising Owner/Operator Salary Insurance Headquarters Rent Deprociation Property Tax \begin{tabular}{|lr|} \hline 5 & 500 \\ \hline \end{tabular} Cepital Expenditures Budget Purchases of fixed assets \begin{tabular}{|lr|} \hline S & 20,000 \\ \hline S & 96,000 \\ \hline S & 3,000 \\ \hline S & 15,000 \\ \hline S & 10,000 \\ \hline S & 750 \\ \hline \end{tabular} \begin{tabular}{|ll|} \hline & 250 \\ \hlineS & 400 \\ \hline & 65% \\ \hline & 35% \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
