Find NSA Direct material budget and Direct labor 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 G H I NSA Airlines Direct Materials Budget For the Year Ended 12/31/2020 Q1 Q2 Q3 Q4 Total Q1 32,600 10 326,000 Budgeted units to produce DM cost per unit DM needed for production Ending DM inventory Total DM needed Beginning DM inventory Budgeted purchases of DM NSA Airlines Direct Labor Budget For the Year Ended 12/31/2020 Q1 Q2 Q3 Q4 Total Budgeted units to produce DL hours per unit DL needed for production DL cost per hour Budgeted DL cost