Question
Lee Company provides the following data for the months of July through October: Month
Lee Company provides the following data for the months of July through October:
Month Sales Purchases
July $180,000 $105,000
August 165,000 120,000
September 150,000 90,000
October 195,000 135,000
Collections from customers are normally 70% in the month of sale and 30% in the following month. All purchases are on credit and paid in cash in the following month.
November sales are budgeted to be $165,000, and November purchases are forecast to be $150,000. Cash disbursements for expenses in November are budgeted to be $35,000. Beginning cash balance on November 1 is $50,000.
Required: Prepare a cash budget in good form for November.
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
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...
The LaPann Company has obtained the following sales forecast data: July August September October Cash Sales...
The LaPann Company has obtained the
following sales forecast data:
July
August
September
October
Cash Sales
$80,000
$70,000
$50,000
$60,000
Credit Sales
$240,000
$220,000
$180,000
$200,000
The regular pattern of collection of credit sales is 30% in the
month of sale and 70% in the month following the month of
sale. There are no bad debts.
The budgeted accounts
receivable balance on September
30th is:
$126,000
$154,000
$161,000
$186,000
Bluebear Corporation budgeted sales for the last four months of 2018: Month Sales September $360,000 October...
Bluebear Corporation budgeted sales for the last four months of
2018:
Month Sales September $360,000 October 400,000 November 350,000
December 410,000
Historically, the cash collection of sales have been as
follows:
65 percent in month of sale 25 percent in month following sale 8
percent in second month following sale 2 percent
uncollectible
The company allows a 2 percent cash discount for payments made by
customers during the month of the sale. July and August sales were
$405,000 and $275,000,...
Redding Company has budgeted sales revenues as follows:
Redding Company has budgeted sales revenues as follows:
June July August
Credit
sales $135,000 $145,000 $ 90,000
Cash
sales 90,000 255,000 195,000
Total
sales $225,000 $400,000 $285,000
Past experience indicates that 60% of the credit sales will be
collected in the month of sale and the remaining 40% will be
collected in the following month. Purchases of inventory are all on
credit and 50% is paid in the month of purchase and 50% in the
month following purchase. Budgeted inventory purchases are:
June $300,000
July 250,000
August 105,000
Other cash disbursements budgeted: (a) selling and
administrative...
E22-28 Purchases and Cash Budgets On July 1, MTC Wholesalers had a cash balance of $175,000...
E22-28 Purchases and Cash Budgets
On July 1, MTC Wholesalers had a cash balance of $175,000 and
accounts payable of $99,000. Actual sales for May and June, and
budgeted sales for July, August, September, and October are:
Month
Actual Sales.
Month
Budgeted Sales
May
$150,000
July
$90,000
June
160,000
August
80,000
September
100,000
October
120,000
All sales are on credit with 75 percent collected during the
month of sales, 20 percent collected during the next month, and 5
percent collected...
C. The Sun Pacific Company budgeted the following sales: July200,000 August210,000 September190,000 Sales in May were...
C.
The Sun Pacific Company budgeted the following sales:
July200,000
August210,000
September190,000
Sales in May were 190,000 and in June 180,000. 60% of sales are
cash, 30% of sales are to be collected the next month, and the
remaining 10% in 2 months.
Budgeted purchases of the required materials for production
are:
July100,000
August105,000
September95,000
Purchases in June were 90,000. 70% of purchases are cash and 30%
should be paid the next month.
Direct Labor is 35% of purchases
Selling...
Cruises, Inc. has budgeted sales revenues as follows: June July August Credit Sales $135,000 $135,000 $90,000...
Cruises, Inc. has
budgeted sales revenues as follows:
June
July
August
Credit Sales
$135,000
$135,000
$90,000
Cash Sales
90,000
225,000
195,000
Total Sales
$225,00
$380,000
$285,000
Past experience
indicates that 60% of the credit sales will be collected in the
month of sale and the remaining 40% will be collected in the
following month.
Cash disbursements were $421,000 for July and $250,500 for
August.
The company wishes to maintain a minimum cash balance of $50,000 at
the end of each...
Application/theory (excel problem) Problem - Cash Budget The following information pertains to Amigo Corporation: Month Sales...
Application/theory (excel
problem)
Problem - Cash Budget
The following information
pertains to Amigo Corporation:
Month
Sales
Purchases
July
$60,000
$20,000
August
68,000
24,000
September
76,000
28,000
October
84,000
32,000
November
96,000
36,000
December
120,000
40,000
•
Cash is collected from customers
in the following manner:
Month of sale
40%
Month following sale
50%
Two months following sale
10%
•
50% of purchases are paid for in
cash in the month of purchase, and the balance is paid the
following month....
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...
ThinkPad Corporation in the beginning states in the preparation of the cash budget. The company estimates...
ThinkPad Corporation in the beginning states in the preparation
of the cash budget. The company estimates cost of goods sold are
60% of sales. The merchandise purchases are required to
be acquired during the month preceding the month of the
sales. ThinkPad Corporation pays 60% in the month of the
purchase and the remaining the following month. The
Controller estimates wages are 20% of sales and are paid in the
month of the sale. The company incurs other operating expenses
approximating 10% of...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 11 minutes ago
asked 11 minutes ago
asked 13 minutes ago
asked 38 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago
asked 2 hours ago
asked 2 hours ago
asked 2 hours ago