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:
Required
Answer
Particulars | Amount ($) |
Beginning balance, cash account | $ 53,965 |
Received on account from sales in: | |
October (1,350,000*27%) | $ 364,500 |
November (2,180,000*70%) | $ 1,526,000 |
Total cash available (A) | $ 1,944,465 |
Disbursements: | |
Payments for purchases made in: | |
October (950,000*85%) | $ 807,500 |
November (2,020,000*15%) | $ 303,000 |
Salaries paid for work in: | |
October (42,000*10%) | $ 4,200 |
November (42,000*90%) | $ 37,800 |
Rent | $ 12,300 |
Utilities | $ 5,500 |
Employment taxes | $ 6,725 |
Customs duty and shipping (2,020,000*15%) | $ 303,000 |
Other cash expenses | $ 40,500 |
Total disbursements (B) | $ 1,520,525 |
Ending cash balance (A-B) | $ 423,940 |
In case of any doubt, please comment.
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: a. The October 31 balance in the cash account is $53,890. b. All sales are on account. Sales in September were $980,000 and in October were $1,260,000. c. November sales are expected to be $2,145,000. d. In Khloe's experience, 70 percent of sales are collected in the month of sale and 26...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 will be $39,000. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 65,000 397,000 November $ 65,000 522,000 December $ 82,600 598,000 Sales on account are collected over a three-month period in the...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $53,200. b. Actual sales for October and November and expected sales for December are shown below. Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected in...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $56,600. b. Actual sales for October and November and expected sales for December are shown below. Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected in...
value 10.00 points You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $40,000 b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 65,000 $ 70,000 $ 83,000 400,000 525,000 600,000 Sales on account are collected over a three-month period...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $43,200. b. Actual sales for October and November and expected sales for December are shown below. Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected in...
Vonn Company, a furniture store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the quarter: As of the end of the prior quarter, September 30, the company’s general ledger showed the following account balances: Cash $62,000 (debit) Accounts receivable $480,000 (debit) Inventory $78,000 (debit) Buildings and equipment, net $570,000 (debit) Accounts payable $193,000 (credit) Capital stock $300,000 (credit) Retained earnings $619,000 (credit) Actual sales for September...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $41,000. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 68,400 $ 87,400 $ 95, 800 $ 415,000 $ 614,000 $ 692,000 Sales on account are collected over a three-month...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $58,600. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 73,200 $ 485,000 November December $ 78,000 $ 92,000 $ 568,000 $ 663,000 Sales on account are collected over a three-month period...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: points a. The cash balance on December 1 is $56,600. b. Actual sales for October and November and expected sales for December are as follows: eBook Cash sales Sales on account October November December $ 71,200 $ 73,400 $ 86,200 $ 440,000 $ 576,000 $ 639,000 Print Sales on account are collected over...