I need to complete the Sales Budget, Purchasing Budget, Admin Budget & Cash Budget using the first 3 pics which are the Assumption and Balance Sheet.
Formatting Table Styles A1 October 00,000 S 910,000S 475,000 S 385,000 7 PURCHASING MANAGER PRIVATE INFORMATION Most likely cost of merchandise as a % of sales 9 Desired ending inventory as a percentage of next month's cost of sales 20% 12 OPERATION MANAGER PRIVATE INFORMATION 3 Most likely shipping expenses as a percent of sales 14 Most likely other expenses as a percent of sales 5.0% 8.0% 85,000 50,000 3,000 25,000 16 Most likely advertising costs (per month) 17 Most likely insurance costs (per 18 Depreciation e 21 FINANCE MANAGER PRIVATE INFORMATION 22 Percent sales collected in month of sale 23 Percent sales collected in month after sale 70% O Type here to search Font , | | X ,G || MOST LIKELY NUMBERS AND ASSUMPTIONS 21 FINANCE MANAGER PRIVATE INFORMATION 22 Percent sales collected in month of sale 23 Percent sales collected in month after sale Part 1 Information 70% 25 Percent of inventory purchases paid in month of purchase 26 Percent of inventory purchases paid in month after purchase 50% 27 28 Percent of operating expenses paid in month of purchase 100% 0% 29 Percent of operating expenses paid in month after purchase 31 Desired minimum ending cash balance each month 32 Borrow in increments of 33 Monthly interest rate on borrowings (not compounded) 35,000 1,000 36 Other planned outlays of cash 37 Capital expenditures 38 Dividends 40 September 00,000 90,000S 50,000 S 42 SRS Educational Supply Company 43 Balance Sheet O Type here to search A1 x '/ MOST LIKELY NUMBERS AND ASSUMPTIONS 42 SRS Educational Supply Company 43 Balance Sheet 44 Previous Year End 46 Current assets 47 Cash 48 Accounts receivable 49 Invent 50 Prepaid insurance 51 Total current assets 52 Buildings and equipment (net) 53 TOTAL ASSETS 40,000 340,000 50,000 18,000 S 448,000 Liabilities and Equity 56 Liabilites 57 Accounts payable 58 Notes payable 59 Total liabilities 60 Stockholder's equity 61 Capital stock 62 Retained earnings 63 Total equity 64 TOTAL LIABILITIES AND EQUIT 130,000 s 130,000 420,000 S 1178,000 S 1,308,000 O Type here to search iune sales (AV/R From Beginning Balance Sheet) A9 July August September Quarter 5 Sales Schedule of Cash Collections July August September Quarter 9 1 June sales (AR From Beginning Balance Shee 10 July sales-Collected in Current Month 11 July sales-Collected in Following Month 12 August sales-Collected in Current Month 13 August sales-Collected in Following Month 14 September sales -Collected in Current Month 15 Total Expected Cash Collections Milestone One instructionsPart il Assumptions Part II Sales Budget In ns Type here to search Purchase Budget July August September October 5 Sales Cost of Merchandise as % of Sales 7 Budgeted Cost of Merchandise Sold 9 Following Month's COGS 10 | Desired Ending Inventory % 11 Desired Ending Inventory Dollars 13 Budgeted Cost of Merchandise Sold 14 Plus Desired Ending Inventory 15 Total Inventory Needs 16 Less Beginning Inventory 17 Required Purchases Part Il AssumptionsPart Part Sales udgetPart lI Purchasing Budget Budget Part Il Admin Burt O Type here to search 12 Shipping 13 Other Fixed Expenses 22 Less Noncash tems (Depreciation and Prepaid ins) Part II Admin Budget D17 July August September Quarter 7 Add Cash Collections (From Sales Budget) 8 Total cash Available 9 Less Cash Disbursements 10 For Inventory (From Purchasing Budget) 12 For Equipment 13 For Cash Dividends 15 Total Cash Disbursements 16 Excess (Deficiency) of Cash 18 Borrowing 20 Total Financing 25 Outstanding Loan Balance 26 nterest on Borrowing (Due the Folowing Quarter) Part II Cash Budget Instructions Final . Type here to search
