60.1K

Verified Solution

Link Copied!

Find the beginning cash balance for each month and the quarter. I've done all of the other budgets, and I just need help getting started with the overall cash budget for the quarter.

	April	May	June	July	August
Unit Sales	25,000	30,000	31,000	33,000	30,000
Sales Price	$10
Desired Ending Inventory for Finished Goods	20%	of next month's sales in units
Desired Ending Inventory for Material Units	10%	of next month's materials needed for production
Cost of one pound of materials	$0.25
Units of Direct Materials to make one unit	3
Minutes of Direct Labor to make one unit	12 (.20-hour)
Direct Labor Costs per Hour	$20
Overhead Costs percentage of Direct Labor	175%
Minimum cash balance	$ 20,000.00
Cash collections in month of sale	65%
Cash collections in first month after sale	25%
Cash collections in second month after sale	10%
Cash Payments in month of purchase	70%
Cash Payments in the first month after purch	30%
Selling Costs per month	$ 10,000.00
Administrative Costs per month	$ 15,000.00
Annual Interest Rate for Letter of Credit	12%
Annual Interest Rate Earned on Excess Cash	4%

Find the beginning cash balance for each month and the quarter. I've done all of the other budgets, and I just need help getting started with the overall cash budget for the quarter. April May June July August Unit Sales 25,000 30,000 31,000 33,000 30,000 Sales Price $10 Desired Ending Inventory for Finished Goods 20% of next month's sales in units Desired Ending Inventory for Material Units 10% of next month's materials needed for productionCost of one pound of materials $0.25 Units of Direct Materials to make one unit 3 Minutes of Direct Labor to make one unit 12 (.20-hour) Direct Labor Costs per Hour $20 Overhead Costs percentage of Direct Labor 175% Minimum cash balance $ 20,000.00 Cash collections in month of sale 65% Cash collections in first month after sale 25% Cash collections in second month after sale 10% Cash Payments in month of purchase 70% Cash Payments in the first month after purch 30% Selling Costs per month $ 10,000.00 Administrative Costs per month $ 15,000.00 Annual Interest Rate for Letter of Credit 12% Annual Interest Rate Earned on Excess Cash 4% Find the beginning cash balance for each month and the quarter. I've done all of the other budgets, and I just need help getting started with the overall cash budget for the quarter. April May June July August Unit Sales 25,000 30,000 31,000 33,000 30,000 Sales Price $10 Desired Ending Inventory for Finished Goods 20% of next month's sales in units Desired Ending Inventory for Material Units 10% of next month's materials needed for productionCost of one pound of materials $0.25 Units of Direct Materials to make one unit 3 Minutes of Direct Labor to make one unit 12 (.20-hour) Direct Labor Costs per Hour $20 Overhead Costs percentage of Direct Labor 175% Minimum cash balance $ 20,000.00 Cash collections in month of sale 65% Cash collections in first month after sale 25% Cash collections in second month after sale 10% Cash Payments in month of purchase 70% Cash Payments in the first month after purch 30% Selling Costs per month $ 10,000.00 Administrative Costs per month $ 15,000.00 Annual Interest Rate for Letter of Credit 12% Annual Interest Rate Earned on Excess Cash 4%

Answer & Explanation Solved by verified expert

See Answer