complete all parts using excel

TUNUwing month's sales, plus 40% UI Instructions Prepare a production budget and a direct labor budget for L quarter of the year. The direct labor budget should include direct labor no budget for Lowell Company by month and for the first (CMA-Canada adapted) its manufacturing overhead budget for 2022. Relevant E22.11 (LO 3), AP Atlanta Company is preparing its manufacturing ove data consist of the following. Units to be produced (by quarters): 10,000, 12,000, 14,000, 16,000. Direct labor: time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect mater maintenance $0.50. costs per direct labor hour: indirect materials $0.80; indirect labor $1.20; and Thead costs per quarter: supervisory salaries $35.000; depreciation $15,000; and mainte- nance $12,000