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

please help!! (BLUE NUMBERS ARE INCORRECT) Having a really hard time- needto include FORMULAS PLEASE 6 Data Section: 8 Actual and Budgeted UnitSales: 910111213141516AprilMayJuneJulyAugustSeptemberBalanceSheet,May31,19x5 17181920CashAccountsreceivableMerchandiseinventoryFixedassets(net) $8,000 107,800 52,800 130,000 $$298,600 $74,800 223,800 $298,600 30

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!