Master Budget project

Find Cash receipt budget and Cash Budget

NSA Airlines For the Year Ended 12/31/2020 Financial Data and Assumptions SALES DATA Q1 Q2 Q3 Quarter Projected Sales for 2019 (Units) Projected Sales for 2020 (Units) Projected Sales for 2021 (Units) Q4 32000 30000 27000 25000 28000 26000 23000 Estimated Sales Price Per Unit (2019) Estimated Sales Price Per Unit (2020) Estimated Sales Price Per Unit (2021) 25.00 26.00 26.50 FINANCIAL DATA Cash Receipts Data Percentage of total sales that are cash sales Percentage of total sales are credit sales Percentage of credit sales paid in quarter of sale Percentage of credit sales paid in following quarter 30% 70% 60% 40% Cash Budget Data Minimum required cash balance Money is borrowed for the exact amount needed 25000 Interest is charged at 3% per quarter until the loan is paid off PURCHASING DATA - Quarter Projected Cash Payments for 2020 Q1 7 00,000 Q2 550,000 03 650,000 04 675,000 PRODUCTION DATA Finished Goods Data Finished Goods ending inventory estimated to be 20% of next quarter sales Beginning Inventory Prior to Q1 0.00 Direct Material Data DM cost per unit 10.00 DM ending inventory estimated to be 15% of next quarters production need Direct Labor Data DL hours per unit DL rate per hour Overtime is paid out at time and y 1.50 Manufacturing Overhead Data Variable OH cost per unit Fixed OH costs Depreciation Utiliites, insurance, property taxes OH is allocated based on DL hours per units 10000 25000 0.00 Cost of Goods Sold Data PY total manufacturing cost Beginning inventory Current Year Unit Cost Information Direct Materials Direct Labor Labor hours required per unit Predetermined OH allocation rate 8.00 18.00 1.50 25.00 NSA Airlines Cash Receipts Budget For the Year Ended 12/31/2020 04 01 Total budgeted sales Cash receipts Q1 Cash sales Credit sales - collected in current quarter Credit sales - collected in following quarter Total cash receipts 02 Q2 03 Q3 04 Q4 Total Cash Receipts Year End Accounts Receivable Balance NSA Airlines Cash Budget For the Year Ended 12/31/2020 qi 02 25,000 25,000 Q3 25,000 Q4 25,000 Total 25,000 25,000 25,000 25,000 25,000 25,000 Beginning cash balance Cash receipts Cash available Cash payments Interest expense Ending cash balance before financing Required Minimum Balance Projected cash excess (shortage) Financing Borrowing Repayments Effects of financing Ending cash balance 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000