Your team's second task is to analyze discrepancies between what was planned and what actually happened. As it turns out, it appears that the previous management team chose to ignore their own analysis, which indicates that they are likely to have a cash shortfall during the quarter. In the end, the previous management team got lucky. They did not experience the anticipated cash flow problems. Try to analyze what "saved" them from having to take out an emergency loan. Provide a brief summary of your ideas on a separate page submitted along with the completed Cash Flow Worksheet.

CASH FLOW ANALYSIS

SALES, FORECASTED: $$,$$$760,595\mathrm{.}57$

Tons $3,776\mathrm{.}73$

SALES, ACTUAL: $

Tons

CASH IN:

PLANNED

ACTUAL

Cash on Hand at Start of Quarter $$9544\mathrm{.}00$ $$9544$

Cash Sales Forecast & Actual$($Total Sales Adjusted for Credit Policy$)\_$ $$532,416\mathrm{.}90$

Accounts Receivable Collected $\_$ $$141\mathrm{.}358\mathrm{.}20\_$

Interest Earned on Investment $("$Investment Income"$)$ $$225\mathrm{.}00$

Cash USES:

Inventory Purchases:

B$.$ Total Cash Outlay$\_\_$ $$686,355$

c$.$ Cash Flow from Operations $(A_{-}B),-$$$2,810\mathrm{.}90$

D$.$ Target & Actual Cash Balance $($your choice$)$ $$5,000$

E$.$ Net Cash Flow $($C$-$v$)$:

If Positive $-$ Cash Available

If Negative $-$ Cash Required

$-$$$7,810\mathrm{.}9$

Financing Decisions:

F$.$ Investment Called

G$.$ Borrow Money

H$.$ Repay Loan

I. Make Investment

$\frac{\text{\$}0}{\text{\$}0}$

$-$$$6,875$

$$0$

Balance $(E+F+G-H-I)-$ $$14,685\mathrm{.}90$ "SHOWING MY WORK"