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 Q3 Q4 Total NSA Airlines Manufacturing Overhead Budget For the Year Ended 12/31/2020 Q1 Q2 Budgeted Variable OH Budgeted units to produce Variable OH cost per unit Budgeted Variable OH Budgeted Fixed OH Depreciation Utilities, insurance, property taxes Budgeted Fixed OH Budgeted Total OH Total budgeted DL hours needed Predetermined OH allocation rate per labor hour #DIV/0! NSA Airlines Manufacturing Cost per Unit For the Year Ended 12/31/2020 DM cost per unit DL cost per unit Predetermined OH allocation rate per unit Total Manufacturing Cost per unit Cost of Goods Sold (COGS) Budget For the Year Ended 12/31/2020 Q1 Q2 Q3 Q4 Total - Total units to sell Beginning inventory units Units produced and sold Beginning inventory Inventory produced and sold Budgeted COGS COGS to Income Statement