Page 137 - Finance for Non-Financial Managers
P. 137
Siciliano07.qxd 3/20/2003 11:23 AM Page 118
10/25/02 11/01/02 11,384 99,228 1,024 6,594 949,763 956,455 945,168 712,581 2.333,101 2,367,713 — 64,616 (11,384) (99,228) 2,321,717 2,333,101 16% 10% 14% 15% 425,000 425,000 49,216 45,941 13,382 11,892 — 50,000 (55,459) (58,617) 7,139 49,216
10/18/02 42,012 13,362 1,056,700 2,823,921 1,641,768 767,957 (42,012) 2,367,713 8% 18% 375,000 60,727 3,720 70,000 (88,506) 45,941
10/11/02 71,078 44,985 1,081,075 3,464,634 1,689,532 23,314 (71,078) 1,641,768 17% 21% 305,000 204,225 374,557 (400,000) (118,055) 60,727
10/4/02 57,606 57,326 1,104,272 2,201,621 1,737,229 9,909 (57,606) 1,689,532 17% 22% 705,000 58,118 207,790 — (61,683) 204,225
9/27/02 24,645 17,377 1,088,123 3,283,517 1,718,797 43,077 (24,645) 1,737,229 18% 19% 705,000 1,944 17,066 65,000 (25,892) 58,118
9/20/02 131,752 9,983 1,084,906 864,870 1,828,440 22,109 (131,752) 1,718,797 23% 21% 640,000 79,443 32,199 80,000 (189,698) 1,944
9/13/02 9/6/02 38,393 27,748 741 27,748 1,120,594 1,135,331 3,802,839 2,130,817 1,724,176 1,743,528 142,657 8,396 (38,393) (27,748) 1,828,440 1,724,176 14% 16% 18% 19% 560,000 484,445 53,791 130,629 60,060 22,542 75,555 (50,000) (109,964) (49,380) 79,443
Actual Results for the Week Ending: 8/30/02 8/23/02 8/16/02 59,002 189,577 12,430 3,402 19,040 800 1,128,172 1,181,612 1,345,920 921,760 524,583 1,709,010 1,783,311 1,926,479 1,900,000 19,219 46,409 38,909 (59,002) (189,577) (12,430) 1,743,528 1,783,311 1,926,479
Metric Orders shipped (Net Orders shipped on time Past due orders in house Sales and Marketing New quotes issued + New orders booked – Shipments to customers Percent of A/R beyond 90 Percent of A/P beyond 45 Notes Payable—Bank Beginning cash balance Ending cash balance
Operations Sales) Beginning backlog (Net Sales) Ending backlog Finances and Administration days past due days past due Loan Balance + Receipts ± Bank Credit Line advances – Disbursements
118
