Cash BudgetKhloe Company imports gift items from overseas and sells them togift shops and...Cash...

Free

60.1K

Verified Solution

Question

Accounting

Cash Budget
Khloe Company imports gift items from overseas and sells them togift shops and department stores throughout the United States.Khloe Company provided the following information:
The October 31 balance in the cash account is $54,215.
All sales are on account. Sales in September were $1,000,000and in October were $1,330,000.
November sales are expected to be $2,170,000.
In Khloe’s experience, 70 percent of sales are collected in themonth of sale and 27 percent are collected in the month followingsale. The remaining credit sales are uncollectible.
Khloe purchases all merchandise on account. Purchases inSeptember were $715,000 and in October were $950,000. Novemberpurchases are expected to be $2,030,000 as Khloe prepares for theChristmas buying season. Fifteen percent of purchases are paid inthe month of purchase, while the remainder is paid in the monthfollowing the purchase month.
Khloe Company has nine employees who are paid a total of$41,000 per month. Due to timing issues, about 90 percent of totalwages are paid in the month earned and the remaining 10 percent arepaid in the following month.
Rent for office and warehouse space is $12,200 paid monthly incash.
Utilities average $6,400 per month and are paid in cash.
In November, Khloe expects to pay employment taxes of$6,650.
Since Khloe imports product from overseas, customs duty andshipping to the central location of 20 percent of current monthlypurchase cost must be paid in the month of purchase.
Other cash expenses for November are expected to be$41,000.
Required:
Prepare a cash budget for Khloe Company for the month ofNovember.
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 $

Answer & Explanation Solved by verified expert

3.8 Ratings (327 Votes)

Khloe Company
Cash Budget
For the Month of November
Beginning balance, cash account	$ 54,215
Received on account from sales in:
October	$ 3,59,100	=1330000*27%
November	$ 15,19,000	=2170000*70%
Total cash available	$ 19,32,315
Disbursements:
Payments for purchases made in:
October	$ 8,07,500	=950000*85%
November	$ 3,04,500	=2030000*15%
Salaries paid for work in:
October	$ 4,100	=41000*10%
November	$ 36,900	=41000*90%
Rent	$ 12,200
Utilities	$ 6,400
Employment taxes	$ 6,650
Customs duty and shipping	$ 4,06,000	=2030000*20%
Other cash expenses	$ 41,000
Total disbursements	$ 16,25,250
Ending cash balance	$ 3,07,065

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

In: AccountingCash BudgetKhloe Company imports gift items from overseas and sells them togift shops and...Cash BudgetKhloe Company imports gift items from overseas and sells them togift shops and department stores throughout the United States.Khloe Company provided the following information:The October 31 balance in the cash account is $54,215.All sales are on account. Sales in September were $1,000,000and in October were $1,330,000.November sales are expected to be $2,170,000.In Khloe’s experience, 70 percent of sales are collected in themonth of sale and 27 percent are collected in the month followingsale. The remaining credit sales are uncollectible.Khloe purchases all merchandise on account. Purchases inSeptember were $715,000 and in October were $950,000. Novemberpurchases are expected to be $2,030,000 as Khloe prepares for theChristmas buying season. Fifteen percent of purchases are paid inthe month of purchase, while the remainder is paid in the monthfollowing the purchase month.Khloe Company has nine employees who are paid a total of$41,000 per month. Due to timing issues, about 90 percent of totalwages are paid in the month earned and the remaining 10 percent arepaid in the following month.Rent for office and warehouse space is $12,200 paid monthly incash.Utilities average $6,400 per month and are paid in cash.In November, Khloe expects to pay employment taxes of$6,650.Since Khloe imports product from overseas, customs duty andshipping to the central location of 20 percent of current monthlypurchase cost must be paid in the month of purchase.Other cash expenses for November are expected to be$41,000.Required:Prepare a cash budget for Khloe Company for the month ofNovember.Khloe CompanyCash BudgetFor the Month of NovemberBeginning balance, cash account$Received on account from sales in:OctoberNovemberTotal cash available$Disbursements:Payments for purchases made in:OctoberNovemberSalaries paid for work in:OctoberNovemberRentUtilitiesEmployment taxesCustoms duty and shippingOther cash expensesTotal disbursements$Ending cash balance$