1
2
3
4
5
6
7
8
9
10
11
12
25
26
27
28
29
30
31
32
33
34
B C D E F G H I J
Input Area:
Beginning cash balance 154,000$
Outlay in fourth Q 325,000$
Target cash balance 80,000$
Q1 Q2 Q3 Q4
Gross sales 863,500$ 918,500$ 996,000$ 924,000$
Sales (1st quarter of next year) 908,000$
Output Area:
Sales 863,500.00$ 918,500.00$ 996,000.00$ 924,000.00$
Sales discount (5,181.00) (5,511.00) (5,976.00) (5,544.00)
Payables paid
From previous quarter orders (119,930.56) (127,569.44) (138,333.33) (128,333.33)
From current quarter orders (331,680.56) (359,666.67) (333,666.67) (327,888.89)
Piepkorn Manufacturing Working Capital Management
Chapters 16 & 17
42
43
44
45
46
47
48
49
62
63
64
65
66
67
68
69
70
71
84
B C D E F G H I J
Q1 Q2 Q3 Q4
Beginning cash balance 154,000.00$ 195,690.11$ 240,637.72$ 354,301.72$
Net cash inflow 41,690.11 44,947.61 113,664.00 (245,841.78)
Ending cash balance 195,690.11$ 240,637.72$ 354,301.72$ 108,459.94$
Minimum cash balance 80,000.00 80,000.00 80,000.00 80,000.00
Cumulative surplus (deficit) 115,690.11$ 160,637.72$ 274,301.72$ 28,459.94$
Beginning short-term investments 74,000.00$ 116,430.11$ 162,542.02$ 277,831.44$
Ending short-term investments 116,430.11 162,542.02 277,831.44 34,767.98
Beginning short-term debt – – – –
Ending short-term debt – – – –
Q1: Excess funds at start of quarter of $74,000.00 earns $740.00 in income.
Q2: Excess funds at start of quarter of $116,430.11 earns $1,164.30 in income.
Q3: Excess funds at start of quarter of $162,542.02 earns $1,625.42 in income.
Q4: Excess funds at start of quarter of $277,831.44 earns $2,778.31 in income.
Cash Balance
Short-term Financial Plan