A company must meet the following payment for suppliers’ invoices for cash at the beginning of each of the next six months: Month XXXXXXXXXXPayment $200 $100 $50 $80 $160 $140 At the beginning of...

1 answer below »

A company must meet the following payment for suppliers’ invoices for cash at the beginning of each of the next six months:
























Month



1



2



3



4



5



6



Payment



$200



$100



$50



$80



$160



$140



At the beginning of month 1, the company has $150 in cash and $200 worth of bond 1, $100 worth of bond 2 and $400 worth of bond 3. All these bonds will not mature in 5 months. However, to meet the payment due dates, the company will have to sell some bonds. A penalty will be charged for any bonds sold before the end of month 6. The penalties for selling $1 worth of each bond are shown in the table below.





























































Penalty for selling $1 worth bond in each month












1




2




3




4




5




6




Available




Bond 1




0.07




0.06




0.06




0.04




0.03




0.03




$200




Bond 2




0.17




0.17




0.17




0.11




0




0




$100




Bond 3




0.33




0.33




0.33




0.33




0.33




0




$400



Question: (Use one workbook for each question below)



  1. Assuming that all bills must be paid on time, formulate a network problem that can be used to minimize the cost of meeting the cash demands for the next six months.

  2. Assume that payment of bills can be made after they are due, but a penalty of $0.02 per month is assessed for each dollar of cash demands that is postponed for one month. Assume all bills must be paid by the end of month 6, modify the model developed in part a) in a separate workbook to minimize the cost of paying the next six months' bills.




SkillMatch Skill Match Required skill sets for jobs Job 1Job 2Job 3Job 4Job 5Job 6 ProgrammingRequiredRequired StatisticsRequiredRequired Modeling RequiredRequiredRequired ExcelRequiredRequired TypingRequiredRequiredRequired Skill sets acquired by workers Worker 1Worker 2Worker 3Worker 4Worker 5Worker 6 ProgrammingYesYesYes StatisticsYesYesYesYesYes Modeling YesYes ExcelYesYesYes TypingYesYesYesYesYes Answers to the questions: [You should summarize your answers to the question here] a) Describe the problem using network representation. You should completely specify how the nodes and arcs are constructed, which nodes are connected to the source and the sink, and how the arc capacities are specified. b) Work on the spreadsheet provided and to find the optimal matching.
Answered 2 days AfterJun 01, 2022

Answer To: A company must meet the following payment for suppliers’ invoices for cash at the beginning of each...

Rajeswari answered on Jun 03 2022
88 Votes
Here we can find total bills amount due in 6 months = 730
Total bonds available = 700
Cash available = 150
Total =
850
Since surplus amount is available there will not be any problem in paying the amounts due in correct time.
The only qestion is which bond is to be closed which month so that total penalty is kept to the minimum
We find in I month 200 is bill amount whereas cash available is only 150. Hence we have to sell atleast one bond to meet this expense.
I month we find penalty is 0.07, 0.17 and 0.11 for bond 1,2,3 respectively
In order to minimize cost we select the least penalty i.e. 0.07 for bond I
Penalty = 200*0.07 = 14 $. Redeemed amount = 200-14 = 186 $
With this 186+150 cash, we can meet first month bill 200 easily. Balance cash = 136 dollars
Second month only 100 dollars is bill amount and this can be paid from cash 136 $
Third month only 50 dollars is bill amount and cannot be adjusted with remaining 36 dollars cash.
Though 3rd month penalty is less for 100 dollars we find 4th, 5th 6th months are decreasing for 100 dollars whereas it is constant of 0.33 for 400 dollars
So it is wise to sell 400 dollars bond now.
Hence 400 dollars can be sold with penalty 400*0.33 = 132 and with this available cash would be
400-132+36 = 304 dollars
With this amount 4th, 5th months bills can be paid easily with balance cash 304-(80+160) = 64 dollars
Now 100 dollars no penalty so can be sold with cash balance =64+100 = 164
Now 6th month 140 can be paid with available cash now 24 dollars
Thus total...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here