Cash Budget Khloe Company imports gift items from overseas and sells them to gift shops and department stores throughout the United States Khloe Company provided the following information The October 31 balance in the cash account is $54,165 All sales are on account Sales in September were $1,020,000 and in October were $1,270,000 November sales are expected to be $2,170,000 In Khloes experience, 70 percent of sales are collected in the month of sale and 28 percent are collected in the month following sale The remaining credit sales are uncollectible Khloe purchases all merchandise on account Purchases in September were $750,000 and in October were $950,000 November purchases are expected to be $2,000,000 as Khloe prepares for the Christmas buying season Fifteen percent of purchases are paid in the month of purchase, while the remainder is paid in the month following the purchase month Khloe Company has nine employees who are paid a total of $50,000 per month Due to timing issues, about 90 percent of total wages are paid in the month earned and the remaining 10 percent are paid in the following month Rent for office and warehouse space is $11,600 paid monthly in cash Utilities average $6,300 per month and are paid in cash In November, Khloe expects to pay employment taxes of $6,675 Since Khloe imports product from overseas, customs duty and shipping to the central location of 15 percent of current monthly purchase cost must be paid in the month of purchase Other cash expenses for November are expected to be $38,500 Required Prepare a cash budget for Khloe Company for the month of November Khloe Company Cash Budget For the Month of November Beginning balance, cash account $ Received on account from sales in October November Total cash available $ Disbursements Payments for purchases made in October November Salaries paid for work in October November Rent Utilities Employment taxes Customs duty and shipping Other cash expenses Total disbursements $ Ending cash balance $

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 08, 2024

Cash Budget Khloe Company imports gift items from overseas and sells them to gift shops and department stores throughout the United States. Khloe Company provided

Cash Budget

Khloe Company imports gift items from overseas and sells them to gift shops and department stores throughout the United States. Khloe Company provided the following information:

The October 31 balance in the cash account is $54,165.
All sales are on account. Sales in September were $1,020,000 and in October were $1,270,000.
November sales are expected to be $2,170,000.
In Khloes experience, 70 percent of sales are collected in the month of sale and 28 percent are collected in the month following sale. The remaining credit sales are uncollectible.
Khloe purchases all merchandise on account. Purchases in September were $750,000 and in October were $950,000. November purchases are expected to be $2,000,000 as Khloe prepares for the Christmas buying season. Fifteen percent of purchases are paid in the month of purchase, while the remainder is paid in the month following the purchase month.
Khloe Company has nine employees who are paid a total of $50,000 per month. Due to timing issues, about 90 percent of total wages are paid in the month earned and the remaining 10 percent are paid in the following month.
Rent for office and warehouse space is $11,600 paid monthly in cash.
Utilities average $6,300 per month and are paid in cash.
In November, Khloe expects to pay employment taxes of $6,675.
Since Khloe imports product from overseas, customs duty and shipping to the central location of 15 percent of current monthly purchase cost must be paid in the month of purchase.
Other cash expenses for November are expected to be $38,500.

Required:

Prepare a cash budget for Khloe Company for the month of November.

Khloe Company
Cash Budget
For the Month of November
Beginning balance, cash account	$
Received on account from sales in:
October
November
Total cash available	$
Disbursements:
Payments for purchases made in:
October
November
Salaries paid for work in:
October
November
Rent
Utilities
Employment taxes
Customs duty and shipping
Other cash expenses
Total disbursements	$
Ending cash balance	$