Cash Budget
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter8: Budgeting For Planning And Control
Section: Chapter Questions
Problem 24E: Del Spencer is the owner and founder of Del Spencers Mens Clothing Store. Del Spencers has its own...
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 step
Solved in 2 steps
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning