Please let me know if you help me with this assignment.Thank you

Module 6 HW prob 8
                                                                    © Jeffrey M. Keisler 2021
        Product            1    2                    Problem (1 point)
        Price            35    25                    Using the data from 6.3 (see below starting in K24), and also assuming that:
        Fixed cost (ignoring for now)                                        Kiddies has 5000 square feet of wood available
                                                Kiddies has 25000 nails available
        Resource 1 cost to acquire            5                            AND
        Resource 2 cost to acquire            0.25                            Each storage box uses 5 Square feet of wood, instead of 4
                            Total used     Total avail
        Resource 1 used per unit            5    3    3750    5000            A)    Run Solver to find the optimal solution
        Resource 2 used per unit            30    20    25000    25000                to maximize operating profit
        Total unit cost            32.5    20                        (Hint: the amount of resources available is different
                            Operating profit                     than in the previous problems)
        Marginal profit per unit            2.5    5    6250                    # of Storage boxes        0
        Quantity            0    1250                        # of Birdhouses        1250
                                                Operating profit        6250
        Total labor used            0    3750    3750
        Total material used            0    25000    25000                B)     When you run solver, before selecting OK, click on
        Total labor cost            0    18750    18750                    Sensitivity report in order to create a sensitivity report
        Total material cost            0    6250    6250                        (Your sensitivity report should appear as another worksheet
                                                    named Sensitivity Report 1. Just leave it there)
        Variable cost            0    25000    25000
        Total cost            0    25000    25000
        Revenue            0    31250    31250                Storage boxes sell for $35.
        Profit            0    6250    6250                A storage box requires 4 5 square feet of wood and 30 nails.
                                            Birdhouses sell for $25
                                            A birdhouse uses 3 square feet of wood and 20 nails
                                            Wood costs $5/square foot, and nails cost $0.25 each
Sensitivity Report 1
    Microsoft Excel 16.0 Sensitivity Report
    Worksheet: [module-6-hw-probs-part-2-akf33odc.xlsx]Module 6 HW prob 8
    Report Created: 09-05-2021 11:09:06
    Variable Cells
                Final    Reduced    Objective    Allowable    Allowable
        Cell    Name    Value    Cost    Coefficient    Increase    Decrease
        $E$15    Quantity    0    -5    2.5    5    1E+30
        $F$15    Quantity    1250    0    5    1E+30    3.3333333333
    Constraints
                Final    Shadow    Constraint    Allowable    Allowable
        Cell    Name    Value    Price    R.H. Side    Increase    Decrease
        $G$9    Resource 1 used per unit Total used     3750    0    5000    1E+30    1250
        $G$10    Resource 2 used per unit Total used     25000    0.25    25000    8333.3333333333    25000
Module 6 HW prob 9
                                                                    © Jeffrey M. Keisler 2021
        Product            1    2                    Problem (3 points)
        Price            35    25                    Using the data from the previous problem, try the following variations:
        Fixed cost (ignoring for now)
                                        0.25    Part A:
        Resource 1 cost to acquire            5                        Run solver with 5010 sf wood available instead of 5000 (still 25000 nails)
        Resource 2 cost to acquire            0.25                            How much does Product 1 incr or decr                0    (e.g., if it goes from 100 down to 97, enter -3. if it goes from 100 up to 105, enter 5)
                            Total used     Total avail                How much does Product 2 incr or decr                0    and use the same convention for other answers on this problem
        Resource 1 used per unit            5    3    3900    5000                How much does profit incr or decr                0
        Resource 2 used per unit            30    20    26000    26000
                                        0.25    Part B:
        Total unit cost            32.5    20                    Run solver with 10000 sf wood (instead of 5000, still 25000 nails)
                            Operating profit
        Marginal profit per unit            2.5    5    6500                    How much does Product 1 incr or decr                0
        Quantity            0    1300                        How much does Product 2 incr or decr                0
                                                How much does profit incr or decr                0
        Total labor used            0    3900    3900
        Total material used            0    26000    26000            0.25    Part C:
        Total labor cost            0    19500    19500                Run solver with 26000 nails instead of 25000 (still 5000 sf wood)
        Total material cost            0    6500    6500
                                                How much does Product 1 incr or decr                0
        Variable cost            0    26000    26000                    How much does Product 2 incr or decr                50
        Total cost            0    26000    26000                    How much does profit incr or...