Question:

Simple Moving Average Forecast ABC Analysis SMA = Cash inflov - Cash disbursement = Sum of net cash reserves: Sum of net cash reserves / # of weeks A Items = 10-207 of of items and 50 - 70% of projected dollar volume, B items = 20% of the items and 20% of the projected dollar volume, C Items = 60-70% of the items and 10-30% of the projected dollar volume: compute annual sales x unit cost; sum total and divide by % for each product to place in to A, B, and C classes x coordinate projected pop.= sum X: y coordinate projected pop.= sum Y: sum X divided projected population - X coordinate: sum Y divided projected population - Y coordinate COGS / Inventory = Turns Days in period or 365 / turns = days inventory Yas held Net income I sales = %. generated of every Center of Gravity Computation Inventory Turns Computation Compute How Many Days Inventory was held before sale Income generated as a % of Sales Net income / total asset = % generated of every its asset Income generated as a % of Assets Given Data 3 Month Simple Moving Average Forecast Week Cash Inflow Cash Disbursement Net Cash Reserve ABC Analysis Unit Cost (5) 60.0 40.0 Product Soccer Shoes (55) Soccer Ball (SB) Soccer Small Goals (SSG) Soccer Jersey (SJ) Captain Arm Band (CAB) Annual Sales (unit) 6.000 $ 600 $ 1,600 $ 2,500 $ 360 $ 120.0 30.0 30 Balance Statement Assets Income Statement Sales (all on Credit) $ Cost of Goods Sold $ Gross Margin $ 150,000 70,000 80,000 $ 52,000 Current Assts Cash Accounts Receivable 9,000 30,000 13,000 Totall Operating Cost & Earnings Before Interest and Tax (EBIT) $ Interest $ Tax $ Net Income $ Inventory Assets 40,500 29,500 12,000 7,000 20,500 85,000 137,000 Total Assets $ 60,000 24,000 36,000 Liabilities Current Liabilities Accounts Payable Other Current Liabilities Non-Current Liabilities Total Liabilities Stockholders Equity Total Liabilities and Equity 35,000 95,000 42,000 $ 137,000 Center of Gravity Center A X-coordiante Y-coordinate -16 3 -6 Projected Population 2,400 1,700 400 6 On average, LSC compute Income generated as a % of Assets Formula