Calculate payments to suppliers assuming that the company places orders during each quarter equal to 30 percent of projected sales for the next quarter. Assume that the company pays immediately. Calculate payments to suppliers assuming a 90-day payables period (Round your answers to 2 decimal places, e.g., 32.16.) Calculate payments to suppliers assuming a 60-day payables period (Round your answers to 2 decimal places, e.g., 32.16.)

46 0

Get full Expert solution in seconds

$2.99 ONLY

Unlock Answer

EXPERT ANSWER

Answer a) If payment is made immediatiely
Q1Q2Q3Q4
Payment of Accounts273.00261.00291.00298.80
Working
WorkingQ1Q2Q3Q4
Projected sale for Next Quarter[a]910870970996
Percentage of Purchase[b]30%30%30%30%
Purchase[c = a*b]273.00261.00291.00298.80
Payment of Accounts[d = c]273.00261.00291.00298.80
Answer b) If payment is made in 90 Days
Q1Q2Q3Q4
Payment of Accounts249.00273.00261.00291.00
Working
WorkingPrevious Q4Q1Q2Q3Q4
Projected sale for Next Quarter[a]830910870970996
Percentage of Purchase[b]30%30%30%30%30%
Purchase[c = a*b]249.00273.00261.00291.00298.80
Payment of Accounts[d = Previous Quarter Purchase]249.00273.00261.00291.00
Answer c) If payment is made in 60 Days
Q1Q2Q3Q4
Payment of Accounts257.00269.00271.00293.60
Working
WorkingPrevious Q4Q1Q2Q3Q4
Projected sale for Next Quarter[a]830910870970996
Percentage of Purchase[b]30%30%30%30%30%
Purchase[c = a*b]249.00273.00261.00291.00298.80
Payment of Accounts[d = Previous Quarter Purchase * 60/90 + Current Quarter purchase *30/90]257.00269.00271.00293.60