Capital Budgeting Using SOLVER in Excel - A Capital Rationing Problem (Integer Programming)

แชร์
ฝัง
  • เผยแพร่เมื่อ 10 พ.ย. 2024

ความคิดเห็น • 3

  • @jaxon_leadbitter6496
    @jaxon_leadbitter6496 3 ปีที่แล้ว

    Hi
    Would you please explain how to use the solver including the ability to c/f unused capital?

  • @ntcuong01ct1
    @ntcuong01ct1 4 ปีที่แล้ว +1

    Dear Friends,
    I have a case of capital budgeting:
    Example: I want to build new factory, I know the build cost is CAPEX budget and cash outflow.
    When the factory begin run, I need purchase raw materials, purchase labor, purchase overhead (water, electric,etc) to manufacture finished goods.
    I know this costs depreciation cost from this factory is OPEX cost.
    Question: With the capital budgeting, I will collect the CAPEX and OPEX inside a plan or separate plans?.
    Capital budgeting need to OPEX cost to run and examine efficiency of this factory, right?.
    Could you help?. Thank you.

    • @FabianMoa
      @FabianMoa  4 ปีที่แล้ว +1

      I would collect CAPEX and OPEX in one plan, easier to see the whole picture.