I have completed A-G. I need H, J, K, and L completed. I have completed some of H and some of J. Please use format provided on solution tabs. Thank you.

DIRECTIONS
            On the tab labeled SOLUTION 1, use all available data (Assumptions Row 4-Row 52, Balance Sheet for 2016, results from other SOLUTION tabs) to:
        A    Create a SALES BUDGET for the year ended December 31, 2017.
        B    Create a SCHEDULE OF EXPECTED CASH COLLECTIONS for the year ended December 31, 2017.
            On the tab labeled SOLUTION 2, use all available data (Assumptions Row 4-Row 52, Balance Sheet for 2016, results from other SOLUTION tabs) to:
        C    Create a PRODUCTION BUDGET for the year ended December 31, 2017.
            On the tab labeled SOLUTION 3, use all available data (Assumptions Row 4-Row 52, Balance Sheet for 2016, results from other SOLUTION tabs) to:
        D    Create a DIRECT MATERIALS BUDGET for the year ended December 31, 2017.
        E    Create a SCHEDULE OF EXPECTED CASH DISBURSEMENTS FOR PURCHASES OF MATERIALS for the year ended December 31, 2017.
            On the tab labeled SOLUTION 4 , use all available data (Assumptions Row 4-Row 52, Balance Sheet for 2016, results from other SOLUTION tabs) to:
        F    Create a DIRECT LABOR BUDGET for the year ended December 31, 2017.
            On the tab labeled SOLUTION 5 , use all available data (Assumptions Row 4-Row 52, Balance Sheet for 2016, results from other SOLUTION tabs) to:
        G    Create a MANUFACTURING OVERHEAD BUDGET for the year ended December 31, 2017.
            On the tab labeled SOLUTION 6 , use all available data (Assumptions Row 4-Row 52, Balance Sheet for 2016, results from other SOLUTION tabs) to:
        H    Create a ENDING FINISHED GOODS INVENTORY BUDGET (absorption costing basis) for the year ended December 31, 2017.
            On the tab labeled SOLUTION 7 , use all available data (Assumptions Row 4-Row 52, Balance Sheet for 2016, results from other SOLUTION tabs) to:
        I    Create a SELLING AND ADMINISTRATIVE EXPENSE BUDGET for the year ended December 31, 2017.
            On the tab labeled SOLUTION 8 , use all available data (Assumptions Row 4-Row 52, Balance Sheet for 2016, results from other SOLUTION tabs) to:
        J    Create a CASH BUDGET for the year ended December 31, 2017.
            On the tab labeled SOLUTION 9 , use all available data (Assumptions Row 4-Row 52, Balance Sheet for 2016, results from other SOLUTION tabs) to:
        K    Create a BUDGETED INCOME STATEMENT (absorption costing basis) for the year ended December 31, 2017.
            On the tab labeled SOLUTION 10 , use all available data (Assumptions Row 4-Row 52, Balance Sheet for 2016, results from other SOLUTION tabs) to:
        L    Create a BUDGETED BALANCE SHEET as of December 31, 2017.
Assumptions Row 4 -- Row 52
        Assumptions
        
Endless Mountain Company manufactures a single product that is popular with outdore recreation enthusiasts. The company sells its product to retailers throughout the northeastern quadrant of the United States. It is in the process of creating a master budget for 2017. The company's CFO in consultation with various managers across the company is providing the latest Balance Sheet and a set of assumptions to help create the 2017 budgets.
        Budgeted Unit sales:
        Q1 2017    12,000
        Q2 2017    37,000
        Q3 2017    15,000
        Q4 2017    25,000
        Q1 2018    13,000
        Budgeted Selling Price per unit    $ 32
        All sales are credit sales
        Ignore Uncollectible Accounts. They are minimal.
        Percentage of Sales collected in the quarter of the sale    75%
        Percentage of Sales collected in the subsequent quarter    25%
        Quarter ending finished goods inventory as a percent of next quarter's unit sales    15%
        Yards of raw material required for each unit    3.5
        Cost per yard of raw material    $ 3.00
        Quarter ending raw materials inventory as a percent of next quarter's production needs    10%
        Estimated ending raw materials inventory on December 31, 2017 (in yards)    5,000
        Percent of purchases paid for in the quarter of the purchase    70%
        Percent of purchases paid for in the quarter following the purchase    30%
        Direct labor hourly rate    $ 18.00
        Direct labor hours required to finish each unit of finished goods    0.25
        Direct labor hours are paid in the quarter incu
ed
        Budgeted variable manufacturing overhead per direct labor-hour    $ 3.00
        Quarterly fixed manufacturing overhead (including depreciation expense on equipment)    $ 150,000
        Quarterly depreciation on equipment    $ 20,000
        The number of direct labor hours is used as the allocation base for the budgeted plantwide...