Acca Exam Question

ACCA 205 FINAL PRACTICE QUESTIONS 1. The expected sales for Uptown Clothing in the month of May are shown in the table below. Chelsea Rogers, the owner, gives credit to a select group of customers (20 percent of sales), but all others must pay cash. Of Chelsea's credit customers, 80 percent pay her the month after the sale and 20 percent pay the following month. Chelsea pays cash for 10 percent of her purchases. The other 90 percent she pays off by the end of the next month. Chelsea's operating expenses are paid the month after incurrence. Her operating expenses are about $7,000 each month, $500 of which is depreciation. Selling expenses have a fixed and a variable component. The fixed is $1,500 a month, and the variable is 10 percent of sales. Chelsea began May with $9,000 in cash. | Sales | Purchases | March | $130,000 | $120,000 | April | 140,000 | 125,000 | May | 150,000 | 130,000 | Prepare a cash budget to determine Uptown Clothing's ending cash balance for May.

ANS:

Uptown ClothingCash BudgetFor the Month of May | Cash receipts: | | | Sales from two months previous (0.2  0.2  $130,000) | $ 5,200 | | Sales from previous month (0.2  0.8  $140,000) | 22,400 | | Sales from current month (0.8  $150,000) | 120,000 | | Total cash receipts | | $147,600 | | | | Cash payments: | | | Purchases from two months previous ($125,000  0.9) | $112,500 | | Purchases from current month ($130,000  0.10) | 13,000 | | Operating expenses | 6,500 | | Selling expenses | 1,500 | | Sales commissions (0.10  $150,000) | 15,000 | | Total cash payments | | 148,500 | Cash increase (decrease) | | $ ( 900) | Beginning cash balance | | 9,000 | Ending cash balance | | $ 8,100 | | | |

2. Allan International is in the construction business. In 2010, it is expected that 30 percent of a