Question

In: Finance

Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of $450,000...

Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of $450,000 in January, $375,000 in February, and $555,000 in March. If 20% of the sales are for cash, 45% are credit sales paid in the month after the sale, and another 35% are credit sales paid 2 months after the sale, what are the expected cash receipts for March? Enter your answer rounded to two decimal places. Do not enter $ or comma in the answer box. For example, if your answer is $12,300.456 then enter as 12300.46 in the answer box.

8 In problem 7, Big City Manufacturing (BCM) assumed that all credit sales were paid in full, which is not realistic. BCM studied its past credit sales and determined that 2.5% of its credit sales resulted in Bad Debts that were never collected. Using the data from the previous problem with the new assumption that 2.5% of credit sales were never collected, what is your revised estimate for the expected cash receipts for March? Enter your answer rounded to two decimal places. Do not enter $ or comma in the answer box. For example, if your answer is $12,300.456 then enter as 12300.46 in the answer box.

  9. 4 In problem 7, Big City Manufacturing (BCM) assumed that all credit sales were paid in full, with no bad debt expense. For this problem, please assume that bad debt expense is again 0% for BCM. Purchases for next month's sales are 55% of projected sales for the next month, and April sales are estimated to be $495,000; purchases for April are paid in cash in March. "Other payments," which include wages, rent, and taxes, are 25% of sales for the current month. Construct a cash budget for March using your expected cash receipts from problem 7 and calculate the average net cash flow during the month of March. Enter your answer rounded to two decimal places. Do not enter $ or comma in the answer box. For example, if your answer is $12,300.456 then enter as 12300.46 in the answer box.

all related to one question

Solutions

Expert Solution

7.

Cash receipts for March 437250.00

Calculations:

January February March
Sales    450,000.00    375,000.00    555,000.00
20% cash sales      90,000.00      75,000.00    111,000.00
45% collected for the previous month    202,500.00    168,750.00
35% collected for the sales of period 2 months prior    157,500.00
Total cash collection    437,250.00

8.

Cash receipts for March 429093.75

Calculations:

January February March
Sales    450,000.00    375,000.00    555,000.00
20% cash sales      90,000.00      75,000.00    111,000.00
45% collected for the previous month (net of 2.5%)    197,437.50    164,531.25
35% collected for the sales of period 2 months prior (net of 2.5%)    153,562.50
Total cash collection    429,093.75

9.

Net cash flow 26250.00

Calculations:

March
Total collections from sales (as computed in 7)    437,250.00
less: payments and expenses
Purchases (55% of next month's sales)    272,250.00
Other payments (25% of current month's sale)    138,750.00
Total payments    411,000.00
Net cash flow = collections - payments      26,250.00

Related Solutions

1.Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of $450,000...
1.Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of $450,000 in January, $375,000 in February, and $555,000 in March.  If 20% of the sales are for cash, 45% are credit sales paid in the month after the sale, and another 35% are credit sales paid 2 months after the sale, what are the expected cash receipts for March?  2.In problem 1, Big City Manufacturing (BCM) assumed that all credit sales were paid in full,...
Q1. Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of...
Q1. Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of $450,000 in January, $375,000 in February, and $555,000 in March.  If 20% of the sales are for cash, 45% are credit sales paid in the month after the sale, and another 35% are credit sales paid 2 months after the sale, what are the expected cash receipts for March? 1a. In problem 1, Big City Manufacturing (BCM) assumed that all credit sales were paid...
Question 1 Part A Big City Manufacturing (BCM) is preparing its cash budget and expects to...
Question 1 Part A Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of $450,000 in January, $375,000 in February, and $555,000 in March. If 20% of the sales are for cash, 45% are credit sales paid in the month after the sale, and another 35% are credit sales paid 2 months after the sale. a) What are the expected cash receipts for March? Part B Big City Manufacturing (BCM) assumed that all credit sales...
Singal Inc. is preparing its cash budget. It expects to have sales of $30,000 in January,...
Singal Inc. is preparing its cash budget. It expects to have sales of $30,000 in January, $35,000 in February, and $20,000 in March. If 20% of sales are for cash, 40% are credit sales paid in the month after the sale, and another 40% are credit sales paid 2 months after the sale, what are the expected cash receipts for March? a. $34,200 b. $28,200 c. $24,600 d. $30,000 e. $27,600
Roan’s manufacturing is preparing its cash budget for the first two months of the upcoming year....
Roan’s manufacturing is preparing its cash budget for the first two months of the upcoming year. The following information concerns the company’s upcoming cash receipts and disbursements. Sales are 65% cash and 35% credit. Credit sales are collected 30% in the month of sale and the remainder in the month after the sale. Actual sales in December were $51,000. January sales are budgeted to be $60,000; February sales are budgeted to be $69,000 Actual purchases of direct materials in December...
PART C Roan’s manufacturing is preparing its cash budget for the first two months of the...
PART C Roan’s manufacturing is preparing its cash budget for the first two months of the upcoming year. The following information concerns the company’s upcoming cash receipts and disbursements. Sales are 65% cash and 35% credit. Credit sales are collected 30% in the month of sale and the remainder in the month after the sale. Actual sales in December were $51,000. January sales are budgeted to be $60,000; February sales are budgeted to be $69,000 Actual purchases of direct materials...
Roan’s manufacturing is preparing its cash budget for the first two months of the upcoming year....
Roan’s manufacturing is preparing its cash budget for the first two months of the upcoming year. The following information concerns the company’s upcoming cash receipts and disbursements. Sales are 65% cash and 35% credit. Credit sales are collected 30% in the month of sale and the remainder in the month after the sale. Actual sales in December were $51,000. January sales are budgeted to be $60,000; February sales are budgeted to be $69,000 Actual purchases of direct materials in December...
Raelynn is preparing its master budget for the quarter ended September 30. Budgeted sales and cash...
Raelynn is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for merchandise for the next three months follow. Budgeted July August September Sales          69,250          85,400          54,750 Cash payments for merchandise          42,950          39,300          33,600 Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $45,000 in accounts receivable;...
Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash...
Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for product costs for the quarter follow. July August September Budgeted sales $ 55,000 $ 71,000 $ 57,000 Budgeted cash payments for Direct materials 15,360 12,640 12,960 Direct labor 3,240 2,560 2,640 Factory overhead 19,400 16,000 16,400 Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances...
Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash...
Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 64,000 $ 80,000 $ 48,000 Budgeted cash payments for Direct materials 16,160 13,440 13,760 Direct labor 4,040 3,360 3,440 Factory overhead 20,200 16,800 17,200 Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT