6. The expected sales for Uptown Clothing in the month of May are shown in the t

Question

6. The expected sales for Uptown Clothing in the month of May are shown in the table below. Chelsea Rogers, tho owner, gives credit to a select group of customers (20 percent of sales), but all others must pay cash. Of Chelsca's credit customers, 80 percent pay her the month after the sale and 20 percent pay the following month. Chelsca 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 $7,000 each month, $500 of which is depreciation. Selling expens The fixed is $1,500 a month, and the variable is 10 percent of sales. Chelsea began May with the month after incurrence. Her operating expenses are about ses have a fixed and a variable component. $9,000 in cash. March April May Sales $130,000 140,000 150,000 Purchases $120,000 125,000 130,000 Prepare a cash budget to determine Uptown Clothing's ending cash balance for May. Use attached accounting paper.

Explanation / Answer

Uptown Clothing Cash Budget For the Month of May Details Amount ($) Amount ($) Cash Receipts : From sales made in March ( $130,000 * 20 % * 20 %) 5,200 From sales made in April ($140,000 * 20 % * 80 %) 22,400 From sales made in May ($150,000 * 80 %) 120,000 Total cash receipt for the month (A) 147,600 Cash Payments: For purchase made in April ($125,000 * 90 %) 112,500 For purchase made in May ($130,000 * 10 %) 13,000 For operating exense ( excluding depreciation) 6,500 For selling exense (fixed) 1,500 For selling exense (variable) [$150,000 * 10 %] 15,000 Total cash payments (B) 148,500 Decrease in cash (A- B) (900) Add : Beginning cash balance 9,000 Ending cash balance for the month $8,100

Related Questions

Navigate

• Browse (All)
• Browse 6
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.