FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Related questions
Question
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 $53,965.
- All sales are on account. Sales in September were $990,000 and in October were $1,330,000.
- November sales are expected to be $2,160,000.
- 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.
- Khloe purchases all merchandise on account. Purchases in September were $715,000 and in October were $950,000. November purchases are expected to be $2,020,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 $41,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,700 paid monthly in cash.
- Utilities average $6,200 per month and are paid in cash.
- In November, Khloe expects to pay employment taxes of $6,625.
- 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,000.
Required:
Prepare a cash budget for Khloe Company for the month of November.
Khloe CompanyCash BudgetFor the Month of November
| Beginning balance, cash account | $fill in the blank 1 |
| Received on account from sales in: | |
| October | fill in the blank 2 |
| November | fill in the blank 3 |
| Total cash available | $fill in the blank 4 |
| Disbursements: | |
| Payments for purchases made in: | |
| October | fill in the blank 5 |
| November | fill in the blank 6 |
| Salaries paid for work in: | |
| October | fill in the blank 7 |
| November | fill in the blank 8 |
| Rent | fill in the blank 9 |
| Utilities | fill in the blank 10 |
| Employment taxes | fill in the blank 11 |
| Customs duty and shipping | fill in the blank 12 |
| Other cash expenses | fill in the blank 13 |
| Total disbursements | $fill in the blank 14 |
| Ending cash balance | $fill in the blank 15 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps
Knowledge Booster
Similar questions
- Budgeting Cash Collections Lowell Consulting, which sells on terms 2/10, n/30, had credit sales for March and April of $90,000 and $75,000, respectively. Analysis of Lowell's operations indicates that the pattern of customers' payments on account is as follows (percentages are of total monthly credit sales) In month of sale in month of following sale Uncollectible accounts, returns, and allowances Receiving Discount Beyond Discount Period Totals 20% 60% 20% 35% 5% 100% 40% 15% Determine the estimated cash collected on customers' accounts in April.arrow_forwardssume a merchandising company provides the following information from its master budget for the month of May: Sales $ 126,000 Cost of goods sold $ 91,000 Selling and administrative expenses $ 25,000 Accounts receivable, May 1st $ 17,000 Accounts receivable, May 31st $ 36,500 If all of the company’s sales are on account, what is the amount of cash collections from customers included in the cash budget for May?arrow_forwardThe BRS Corporation makes collections on sales according to the following schedule: 45% in month of sale 53% in month following sale 2% in second month following sale The following sales have been budgeted: Sales April $220, 000 $150,000 May June $140, 000 Budgeted cash collections in June would be: Multiple Cholce $140,000 $142,500 $146,900 $140,440arrow_forward
- Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month Sales Revenue Month Sales Revenue $300,000 March 245,000 April $200,000 155,000 January February All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of sale. Operating expenses total $40,000 per month and are paid during the month incurred. The cash balance on February 1 is estimated to be $30,000. Prepare monthly cash budgets for February, March, and April. Use negative signs only with beginning and ending cash balances, when appropriate. Do not use negative signs with disbursement answers. Wilson's Retail Company Cash Budgets February, March, and April February March Cash balance, beginning $ Total Cash receipts Cash available Total disbursements Cash balance, ending…arrow_forwardCash Budget The controller of Stanley Yelnats Inc. asks you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: January February March Sales Manufacturing costs 42,000 $101,000 $121,000 $171,000 52,000 62,000 Selling and administrative expenses Capital expenditures 29,000 33,000 38,000 41,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 65% are expected to be collected in full in the month following the sale and the remainder in the following month. Depreciation, Insurance, and property tax expense represent $8,000 of the estimated monthly manufacturing costs. The annual Insurance premium is paid in June, and the annual property taxes are paid in October. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. All selling and administrative expenses are paid in the month incurred.…arrow_forwardsubject - accountingarrow_forward
- Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $ 80,000 $ 71,000 $ 83,000 Credit sales 80,000 85,200 91,300 Total $ 160,000 $ 156,200 $ 174,300 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month following the month of sale. Customers are granted a 1.5% discount for payment within 10 days of billing. Approximately 75% of collectible credit sales take advantage of the cash discount. Inventory purchases each month are 100% of the cost of the following month’s projected sales. (The gross profit rate for Timpco is approximately 30%.) All merchandise purchases are made on credit, with 20% paid in the month of purchase and the remainder paid in the following month. No cash discounts…arrow_forwardanswer in text form please (without imagearrow_forwardsarrow_forward
- Budgeting for a Merchandising Firm Goldberg Company is a retail sporting goods store thatuses an accrual accounting system. Facts regarding its operations follow:∙ Sales are budgeted at $250,000 for December and $225,000 for January, terms 1/eom, n/60.∙ Collections are expected to be 50% in the month of sale and 48% in the month following the sale.Two percent of sales are expected to be uncollectible and recorded in an allowance account at theend of the month of sale. Bad debts expense is included as part of operating expenses.∙ Gross margin is 30% of gross sales.∙ All accounts receivable are from credit sales. Bad debts are written off against the allowanceaccount at the end of the month following the month of sale.∙ Goldberg desires to have 80% of the merchandise for the following month’s sales on hand at the endof each month. Payment for merchandise is made in the month following the month of purchase.∙ Other monthly operating expenses to be paid in cash total $25,000.∙ Annual…arrow_forwardCash Budget LeeAnn Ortiz owns a retail store that sells new and used sporting equipment. LeeAnn has requested a cash budget for October. After examining the records of the company, you find the following: Cash balance on October 1 is $1,130. Actual sales for August and September are as follows: August September Cash sales $6,000 $4,500 Credit sales 58,000 62,000 Total sales $64,000 $66,500 Credit sales are collected over a three-month period: 40 percent in the month of sale, 36 percent in the next month, and 22 percent in the second month after the sale. The remaining sales are uncollectible. Inventory purchases average 70 percent of a month's total sales. Of those purchases, 45 percent are paid for in the month of purchase. The remaining 55 percent are paid for in the following month. Salaries and wages total $3,850 per month. Rent is $3,150 per month. Taxes to be paid in October are $1,635. LeeAnn usually withdraws $3,500 each month as…arrow_forwardmn.2arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education