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 Sales Budget For the Year Ended 12 Q1 Q2 03 04 Total Budgeted units sold Sales price per unit Total sales NSA Airlines Production Budget For the Year Ended 12/31/2020 Q1 Q2 Year 2 Q3 04 Total 23,000 Budgeted units to sell Ending inventory Total needed Beginning inventory Budgeted units to produce Q1 28,000 4,600 32,600 32,600