Question

Khloe Company imports gift items from overseas and sells them to gift shops and department stores...

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:

  1. The October 31 balance in the cash account is $53,965.
  2. All sales are on account. Sales in September were $1,000,000 and in October were $1,290,000.
  3. November sales are expected to be $2,155,000.
  4. In Khloe’s experience, 70 percent of sales are collected in the month of sale and 27 percent are collected in the month following sale. The remaining credit sales are uncollectible.
  5. Khloe purchases all merchandise on account. Purchases in September were $740,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.
  6. Khloe Company has nine employees who are paid a total of $46,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.
  7. Rent for office and warehouse space is $11,600 paid monthly in cash.
  8. Utilities average $5,700 per month and are paid in cash.
  9. In November, Khloe expects to pay employment taxes of $6,900.
  10. Since Khloe imports product from overseas, customs duty and shipping to the central location of 10 percent of current monthly purchase cost must be paid in the month of purchase.
  11. Other cash expenses for November are expected to be $40,000.

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 $

Homework Answers

Answer #1

SOLUTION

Cash budget-

Particulars Amount ($)
Beginning balance, cash account 53,965
Received on account from sales in:
October (1,290,000*27%) 348,300
November (2,155,000*70%) 1,508,500
Total cash available (A) 1,910,765
Disbursements:
Payments for purchases made in:
October (950,000*85%) 807,500
November (2,000,000*15%) 300,000
Salaries paid for work in:
October (46,000*10%) 4,600
November (46,000*90%) 41,400
Rent 11,600
Utilities 5,700
Employment taxes 6,900
Customs duty and shipping (2,000,000*30%) 600,000
Other cash expenses 40,000
Total disbursements (B) 1,817,700
Ending cash balance (A-B) 93,065
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Cash Budget Khloe Company imports gift items from overseas and sells them to gift shops and...
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,115. All sales are on account. Sales in September were $960,000 and in October were $1,340,000. November sales are expected to be $2,180,000. In Khloe’s experience, 70 percent of sales are collected in the month of sale and 26 percent are collected in...
The following information is from Barkley’s Auto Alarm Company financial records. Collections from customers are normally...
The following information is from Barkley’s Auto Alarm Company financial records. Collections from customers are normally 70 percent in the month of sale, 20 percent in the month following the sale, and 9 percent in the second month following the sale. The balance is expected to be uncollectible. All purchases are on account. Management takes full advantage of the 3 percent discount allowed on purchases paid for by the tenth of the following month. Purchases for December are budgeted at...
The following information is from White Mountain Furniture Showroom’s financial records. Month Sales Purchases July $...
The following information is from White Mountain Furniture Showroom’s financial records. Month Sales Purchases July $ 80,000 $ 42,000 August 68,000 47,000 September 67,000 35,000 October 86,000 53,000 Collections from customers are normally 67 percent in the month of sale, 20 percent in the month following the sale, and 11 percent in the second month following the sale. The balance is expected to be uncollectible. All purchases are on account. Management takes full advantage of the 3 percent discount allowed...
Admire is a retail company that sells specialized gardening products. The company is considering opening a...
Admire is a retail company that sells specialized gardening products. The company is considering opening a new store on October 1, Year1. As budget coordinator, you have been asked to prepare a master budget for the first 3 months of the company’s operation. You have gathered the following information: October sales are estimated to be $300000 of which 45 percent will be cash and the remainder will be on credit. The company expects all sales to increase at the rate...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $164,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $110,000. La Famiglia pays 25% in the month of...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $156,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $116,000. La Famiglia pays 25% in the month of...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $167,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $102,000. La Famiglia pays 25% in the month of...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $167,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $100,000. La Famiglia pays 25% in the month of...
Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown...
Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below: Wheeling Company Balance Sheet September 30 Assets Cash $ 78,600 Accounts receivable 102,000 Inventory 40,500 Buildings and equipment, net of depreciation 279,000 Total assets $ 500,100 Liabilities and Stockholders’ Equity Accounts payable $ 129,600 Common stock 216,000 Retained earnings 154,500 Total liabilities and stockholders’ equity $ 500,100 The company is in the process of preparing a budget for October and has assembled the...
Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown...
Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below: Wheeling Company Balance Sheet September 30 Assets Cash $ 77,800 Accounts receivable 134,000 Inventory 62,100 Buildings and equipment, net of depreciation 284,000 Total assets $ 557,900 Liabilities and Stockholders’ Equity Accounts payable $ 225,900 Common stock 216,000 Retained earnings 116,000 Total liabilities and stockholders’ equity $ 557,900 The company is in the process of preparing a budget for October and has assembled the...