Question

1 Approved Answer

Posted on Jun 10, 2024

6800 68000 52000 16000 60000 54000 68000 69000 68000 Units 48000 0.94 0.95 0.96 0.97 0.98 0.59 1.01 1.02 1.08 Unit Costs 1 24 1.88

6800 68000 52000 16000 60000 54000 68000 69000 68000 Units 48000 0.94 0.95 0.96 0.97 0.98 0.59 1.01 1.02 1.08 Unit Costs 1 24 1.88 192 1.95 1.99 2.08 2.07 2.12 Selling Price 177 1.81 2010 2011 2012 2013 2014 2015 2016 2017 2018 New Froject 2009 Exhibits Exhibits Revenue 94,960 00 $ 94 120.00 $ 108,040.00 $ 112 800.00 $ 122,890.00 $ 132,600.00 $ 135,320.00 $ 138,040.00 $ 140,760.00 $ 144,160.00 Cost to Expand 37 817.0 Production Expenses 45,120.00 $ 49.400.00 $ 53,760.00 $ 58.200.00 $ 62,720.00 $ 67 320.00 $ 68,000.00 $ 68,680.00 $ 69,360.00 $ 70,040.00 Interest Exp 7.7536 136 Raw Material: 4,360.37 5 3,600.00 5 3.708.00 $ 3,819 24 5 3.933.82 $ 4.173.39 4,298.59 5 4,427.35 $ 4,697.18 8003 Manufacturing Overhead 4,051 83 $ 2,387 03 $ 2.458.64 $ 2,582 39 5 2.608.37 $ 2,686.62 5 2,767.22 $ 2830.23 5 2,935.74 336 Maintenance Expense 2 317.50 $ Depreciation 4,000 2,250 00 5 28,174.90 $ 30/989.50 31,969.60 $ 83,088.30 S 34,246.60 $ 35,445.20 Tax Rate 40% Exhibit S Labor Expense 18,640.00 $ 20.233.30 $ 22,942 40 $ 23.254.60 $ 7.80% Selling General and Admin 6,626 89 5 7.341.30 $ 9,037.12 5 8.798.40 $ 9,504.64 $ 10.342.80 5 10,534.90 10,707.12 5 10.979.28 $ 11,244.49 98 645.43 $ 107,06367 $ 145,333.08 $ 117,309.77 $ 119,730.38 $ 121,995.49 $ 124,362.60 INFV Discount 7.75% Total Operating Expense 76,23609 $ 83,000.16 $ 90,845.79 $ 8,703 12 $ 41 119.84 5 12,19422 $ 1415435 $ 15,816 33 $ 17 266.93 5 17,840.23 $ 18,309.62 5 18,763.52 $ 19,797.40 EBITDA 4,000.00 5 4,000.00 $ 4,000.00 $ 4,000.00 Flat Depreciation 4,000.00 5 4,000.00 $ 4,000.00 5 4.000.00 $ 4,000.00 5 4,000.00 $ 13 256.93 $ 13,810.23 $ 14,309.62 5 14,763.52 $ 15,797.40 EBT 4,723 12 5 7.119.84 $ 9,194 21 10.154.59 5 11,816.33 $ 4,490.82 $ 4,48082 5 4.490.82 $ 4,420.92 5 4,480.82 $ 4,480.92 5 4,480.82 Interest Expense 4,480 82 5 4.490.82 $ 4,480.82 5 3.828.80 5 10,282.70 $ 11,316.52 EBT 242 30 $ 2.639.02 $ 3,713 39 $ 5.673.73 $ 7,385 51 $ 8.786.15 $ 9,529.41 $ 4,526.63 Calc Taxes 96.92 $ 1,095.61 $ 1,485 36 $ 2.269.49 $ 2,93421 $ 3.514.45 $ 3,731.77 5 3,931.32 $ 4,113.08 $ 6.789.95 Net Frofit 145.39 5 1,593.41 $ 2,228 04 $ 3.404.24 4,401 31 $ 5.271.68 $ 5,597.65 5 5.897.28 $ 6,169.62 5 4,000.00 $ 4,000.00 Flat Add Depreciation 4,000.00 5 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 5 4,000.00 $ Total Cash FI 6,228 04 3 9.897.28 10,789.93 4,145 38 5 9.583.41 $ 9.597.65 5 10,169.62 $ -37 817.0 $ 7.404.24 $ 8,401 31 5 9.271.60 $ NF QB: The sales team has been able to add a new product for an existing client to the mic. This contract w al 10% of unit production on the line immediately. what impact does this have on the : in unit production will not have an impact on labor. According to the case, how much project? It is expected that revenue per unit and costs per unit will be the sam excess capacity will you have left after adding 10it in production