a)
| Schedule of Budgeted Cash Receipts | |
| March | |
| Cash sales (20% x $70000) | 14000 |
| Collection of credit sales for: | |
| March (80% x $70000 x 60%) | 33600 |
| February (80% x $50000 x 30%) | 12000 |
| January (80% x $40000 x 8%) | 2560 |
| Total budgeted cash receipts $ | 62160 |
b)
| Cash Budget | |
| For the Month of March | |
| Beginning cash balance $ | 6000 |
| Add receipts: | |
| Collections from customers | 62160 |
| Total cash available | 68160 |
| Less cash disbursements: | |
| Inventory purchases | 28000 |
| Operating expenses | 40000 |
| Dividends | 4000 |
| Total cash disbursements | 72000 |
| Excess (deficiency) of cash available over disbursements | -3840 |
| Financing: | |
| Borrowings | 8840 |
| Repayments | 0 |
| Interest | 0 |
| Total financing | 8840 |
| Ending cash balance $ | 5000 |
Duiy cUpaily lls plathed the tollowing sales for the next three months: January Budgeted Sales $40,000...
Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales January Budgeted D.M. Purchases $35,000 49,400 38,500 $266,000 286,100 251,900 February March Nieto's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...
Getty Company expects sales for the first three months of next year to be $190,000, $235,000 and $315,000, respectively. Getty expects 40 percent of its sales to be cash and the remainder to be credit sales. The credit sales will be collected as follows: 10 percent in the month of the sale and 90 percent in the following month. Compute a schedule of Getty's cash receipts for the months of February and March February March Budgeted Cash Receipts References eBook...
Exercise 22-17 Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales January February March $237,000 227,300 284,800 Budgeted D.M. Purchases $36,500 43,100 42,900 Nieto's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month...
Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $257,000 $32,700 February 277,200 37,500 March 297,900 51,500 Nieto's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale: 4% are uncollectible. Nieto's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...
Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $251,000 $35,100 February 282,800 40,100 March 342,600 46,700 Nieto's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...
Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted D.M. Purchases Budgeted Sales $251,000 $32,200 January February 238,100 45,300 March 299,600 38,300 Nieto's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto's purchases are 50% cash and 50% on account Purchases on account are paid 40% in the month of purchase,...
Sarasota Company's budgeted sales and direct materials purchases are as follows. January February March Budgeted Sales $261,300 250,800 344,000 Budgeted D.M. Purchases $39,300 43,300 44,000 Sarasota's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Sarasota's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...
Hagen Company's budgeted sales and direct materials purchases
are as follows.
Budgeted Sales
Budgeted D.M. Purchases
January
$300,000
$60,000
February
330,000
70,000
March
350,000
80,000
Hagen's sales are 40% cash and 60% credit. Credit sales are
collected 10% in the month of sale, 50% in the month following
sale, and 36% in the second month following sale; 4% are
uncollectible. Hagen's purchases are 50% cash and 50% on account.
Purchases on account are paid 40% in the month of purchase,...
Please show full calculations for each. Thanks! 1) ABC Company's budgeted sales are as follows: July = 3,000 units; August = 2,500 units. June ending inventory = 1,200 units. Budgeted ending inventory must equal 40% of next month's budgeted sales. Production budgeted for July would equal units = ? units ------ 2) ABC Company's budgeted production is as follows: January = 5,000 units; February = 8,000 units. Each unit produced requires 3 pounds of raw material. January beginning inventory...
Martin Company projects the following sales for the first three months of the year: $14,300 in January: $11,300 in February; and $15,800 in March. The company expects 80% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Read the requirements Requirement 1. Prepare a...