Question: please help!! (BLUE NUMBERS ARE INCORRECT) Having a really hard time- need to include FORMULAS PLEASE 6 Data Section: 8 Actual and Budgeted Unit Sales:
please help!! (BLUE NUMBERS ARE INCORRECT) Having a really hard time- need to include FORMULAS PLEASE



6 Data Section: 8 Actual and Budgeted Unit Sales: 910111213141516AprilMayJuneJulyAugustSeptemberBalanceSheet,May31,19x5 17181920CashAccountsreceivableMerchandiseinventoryFixedassets(net) $8,000 107,800 52,800 130,000 $$298,600 $74,800 223,800 $298,600 30 Average selling price 31 Average purchase cost per unit $55 32 Desired ending inventory 33 (\% of next month's unit sales) 60% 34 Collections from customers: 35 Collected in month of sale 20% 36 Collected in month after sale 20% 38 Collected two months after sale 20% 38 Projected cash payments: 39 Variable expenses 40 Fixed expenses (per month) $10,000 41 Depreciation per month $1,000 \begin{tabular}{lll} 16 & 43 & \\ \hline & 44 & Answer Section: \\ 8 & 45 & Sales Budget \\ 46 & \end{tabular} Unit Purchases Budget 794 Financing 6 Data Section: 8 Actual and Budgeted Unit Sales: 910111213141516AprilMayJuneJulyAugustSeptemberBalanceSheet,May31,19x5 17181920CashAccountsreceivableMerchandiseinventoryFixedassets(net) $8,000 107,800 52,800 130,000 $$298,600 $74,800 223,800 $298,600 30 Average selling price 31 Average purchase cost per unit $55 32 Desired ending inventory 33 (\% of next month's unit sales) 60% 34 Collections from customers: 35 Collected in month of sale 20% 36 Collected in month after sale 20% 38 Collected two months after sale 20% 38 Projected cash payments: 39 Variable expenses 40 Fixed expenses (per month) $10,000 41 Depreciation per month $1,000 \begin{tabular}{lll} 16 & 43 & \\ \hline & 44 & Answer Section: \\ 8 & 45 & Sales Budget \\ 46 & \end{tabular} Unit Purchases Budget 794 Financing
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
