Question
Sunland Connectivity Company manufactures various electrical connectors. The companys sales budget for the first six months of the coming year is as follows. All sales
Sunland Connectivity Company manufactures various electrical connectors. The companys sales budget for the first six months of the coming year is as follows. All sales are made on credit.
January | February | March | April | May | June | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Budgeted sales | $520,000 | $475,000 | $585,000 | $650,000 | $560,000 | $270,000 |
Sunland is planning to change its credit policies in the coming year. For the first time in its history, the company is offering a 2% discount to customers who pay within 15 days of the invoice date. Based on industry trends, Sunland estimates that this change will result in 50% of credit sales being paid within the discount period; another 15% of sales, within the month of sale (but outside the discount period); and another 32% of sales, during the month after the sale. An estimated 3% of sales will be uncollectible. (a) Prepare Sunlands cash receipts budget for the second quarter of the coming year. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)
April | May | June | Bad Debts | ||||
---|---|---|---|---|---|---|---|
March sales | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | ||||
April sales | |||||||
Within discount period | enter a dollar amount | enter a dollar amount | enter a dollar amount | ||||
Outside discount period | enter a dollar amount | enter a dollar amount | enter a dollar amount | $enter a dollar amount | |||
May sales | |||||||
Within discount period | enter a dollar amount | enter a dollar amount | enter a dollar amount | ||||
Outside discount period | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | |||
June sales | |||||||
Within discount period | enter a dollar amount | enter a dollar amount | enter a dollar amount | ||||
Outside discount period | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | |||
Totals | $enter a total amount | $enter a total amount | $enter a total amount | $enter a total amount |
Assume that there are no outstanding accounts receivable and allowance for doubtful accounts balances at the beginning of the budgeted year. | |
Net Accounts Receivable at the end of second quarter of the coming year | $enter the net accounts receivable amount in dollars |
(b) | How much cash will Sunland sacrifice in the second quarter by offering the new discount? | |
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started