Please help solve and show cell reference as well.

19 20 Direct Labor: 21 DL Hrs per Unit 1.60 per unit 22 DL Avg Cost per DLH $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $22.00 $22.00 $22.00 $22.00 $22.00 $22.00 23 24 Overhead: Fixed (monthly) Var (per DLH) 25 Supplies SO $1.0 26 Power so $0.20 27 Maintenance $12,500 $1.10 28 Supervision $14,000 $0.00 29 Depreciation $45,000 $0.00 30 Taxes $4,300 $0.00 31 Other $86,000 $1.60 32 33 Selling & Admin: Fixed (monthly) Var (perunit) 34 Salaries $88,500 $0.00 35 Commissions $1.40 36 Depreciation $25,000 $0.00 37 Shipping $0 $3.60 38 Other $137,000 $1.60 39 40 Planned Capital Expenditures SO $68,000 SO SO $500,000 $0 $2,000,000 SO SO SO SO 41 42 Cash: 43 Beg Balance 01/01/16 $62,900 44 Minimum Monthly Balance $25,000 Minimum Cash Borrow $1,000 46 Annual Interest Rate 12.00% (use below rate for monthly interest calculations) 47 Montly Interest Rate 1.00% (use this for monthly rate) 48 49 Actuals (use in Variances): 50 Annual Sales (in $) $24,000,000 51 Annual Sales Units 198,000 52 Annual Production Units 200,000 53 54 Actual FMOH $1,950,000 Annual 55 Actual VMOH $1,224,500 Annual 56 Actual DL Hours 340,000 Annual 57 Total DL Cost $7,276,000 Annual 58 59 Part #K298 purchase units 405,000 Annual 60 Part #K298 total cost $1,579,500 Total 61 62P A B C D F F G H K M N O 2016 Budget Information 2017 IN January February March April May June July August September October November December Total January February W Projected Sales Units 10,000 10,500 13,000 16,000 18,500 20,000 20,000 20,000 18,000 17,000 16,000 15,000 194,000 14,000 13,000 Projected Selling Price $110.00 $110.00 $110.00 $112.00 $115.00 $115.00 $120.00 $120.00 $120.00 $125.00 $125.00 $125.00 $125.00 $125.00 Beg Inventory Units 01/01/16 900 Desired Ending Inventory % 20.00% of next month's sales units Co Direct Materials 9 Part #K298: 10 Part #K298 Per-Unit Usage 2.00 per unit 11 Part #K298 cost $4.75 per unit of #K298 12 Beg Inventory Qty 01/01/16 6,720 units of #K298 13 Desired Ending Inventory % 18.00% of next month's production needs Part #C30: 15 Part #C30 Per-Unit Usage 3.00 per unit 16 Part #C30 cost $8.40 per unit of #C30 17 Beg Inventory Qty 01/01/16 10,080 units of #C30 18 Desired Ending Inventory % 30.00% of next month's production needs\fSchedule 2: Production Budget Needed for DM Purchases Budget January February March April May June July August September October November December Total January February Unit Sales (sched 1) Desired Ending Inventory Total Units Needed Less: Beginning Inventory Units to ProduceSchedule 3: DM Purchases Budget 2017 Part K298 January February March April May June July August September October November December Total January Units Produced (sched 2) x DM per Unit Production Needs Desired El Total Needed Less: Beginning Inventory DM to Purchase x Cost per Unit Total K298 Purchase Cost SO Part C30 January Units Produced (sched 2) x DM per Unit Production Needs Desired El Total Needed Less: Beginning Inventory DM to Purchase x Cost per Unit Total C30 Purchase Cost SOSchedule 4: DL Budget January February March April May June July August September October November December Total Units Produced (sched 2) x DL per Unit Total Hours Needed x Wage Rate per Hour Total DL Cost so