Can someone please help me with this. This is Acc 207 Final Project 2 Student Workbook.

8 F Instructions Milestone 1 10 1. 12 . 13 Sales Budget 14 Prepare Sales Budget 15Prepare Schedule of 16 17 18 19 2. 20 21 Prepare Merchandise Expected Cash Collection From Sales Purchasing Budget Purchases Budget Cash Disbursements for 23 Prepare Schedule of Expected 24 25 26 27 13. 28 29Prepare Selling and Admin 30 Merchandise Purchases Admin Budget Budnat Includinn Fynected Instructions Milestone One Instructions 8 ITEMS TO COMPLETE FOR THIS MILESTONE (Blue Tabe): 19 20 GENERAL 21 You are the accountant tasked with creating the master budget for SRS Educational Supply Company. You have made your budget 22 assumptions (see the red tab labeled Part I Assumptions) and are ready to prepare the following 23 24 SALES BUDGET 25 26 27 28 29 PURCHASING BUDGET 30 31 32 Prepare the sales budget by month and in total Prepare a schedule of excepted cash collections from sales by month and in total Prepare a merchandise purchases budget by month and in total Prepare a schedule of expected cash disbursements for merchandise purchases by month and in total 34 ADMIN BUDGET 35 36 37 Prepare a selling and admin budget by month and in total Add expected cash disbursements for selling and admin by month and in total 39 CASH BUDGET Instructions Milestone One Instructions Part Il Assumptions Part il Sales Budget O Type here to search Conditional Format as Formatting, Table- Styles. Clipboard Font Alignment Cells A1 Most likely sales atio 7PURCHASING MANAGER PRIVATE INFORMATION Desired ending inventory as a percentage of next month's cost of sales 10 Most likely cost of merchandise as a % of sales 9 45% 20% 12 OPERATION MANAGER PRIVATE INFORMATION 13 Most likely shipping expenses as a percent of sales 14 Most likely other expenses as a percent of sales 15 Salaries and wages (per month) 16 Most likely advertising costs (per month) 17 Most likely insurance costs (per month) Part 1 Information 5 0% 80% 85,000 50,000 3,000 25,000 Depreciation expense (per month) 19 20 FINANCE MANAGER PRIVATE INFORMA TION 22 Percent sales collected in month of sale 23 Percent sales collected in month after sale ion 30% 70% instructions Part II Part Ul Sales Budget O Type here to search H12 Percent sales collected in month of sale 30% 70% Percent sales collected in month after sale Percent of inventory purchases paid in month of purchase 6 Percent of inventory purchases paid in month after purchase 50% 50% 100% 0% 28 Percent of operating expenses paid in month of purchase 29 Percent of operating expenses paid in month after purchase 30 31 Desired minimum ending cash balance each month 32 Borrow in increments of 33 Monthly interest rate on borrowings (not compounded) 34 35 35,000 1,000 1% 36 Other planned outlays of cash September 37 Capital expenditures 38 Dividends 50,000 $ 39 40 42 SRS Educational Supply Company 43 Balance Sheet 44 Previous Year End 45 Assets Part II Assumptions P Instructions Milestone One Instructions Part II Sales Budget O Type here to search Arial Paste | B 1-IB-lo-A-| --Merge & Center. | $.% , Number Clipboard Font G15 Sales Budget August September Quarte 5 Sales Schedule of Cash Collections July August September Quarter 9 June sales (A/R From Beginning Balance Sheet) 10 July sales-Collected in Current Month 11 July sales-Collected in Following Month 2 Auqust sales-Collected in Current Month 13 August sales-Collected in Following Month 14 September sales-Collected in Current Month Total Expected Cash Collections 16 19 Total Sales for the Quarter 20 A/R at the end of the Quarter (September Sales Still not Collected Dart Il Assumptions Part Il Sales Budget nstructions Milestone One Instructions O Type here to search udgeted Cost of Merchandise Sold us Desired Ending Inventory otal Inventory Needs ess Beginning Inventory Required Purchases Schedule of Expected Cash Disbursements - Purchases July August September Quarter June Purchases (A/P From Balance Sheet) s July Purchases 26 August Purchases 27 September Purchases 28 Total Disbursements 30 32 Cost of Merchandise Sold for the Quarter 3 Ending Inventory at the end of the Quarter 34 Ending A/P at the end of the Quarter 36 38 Part il AssumptionsPart li Sales Budget Part II Purchasing Budget O Type here to search esc F4 16 Number Arial Font Alignment Number Clipboard D17 Cash Budget July 6 Cash Balance: Beginning 7 Add Cash Collections (From Sales Budget) 8 Total cash Available 9 Less Cash Disbursements 10 For Inventory (From Purchasing Budget) 11 For Operating Expenses (From Selling and Admin Budget) 2 For Equipment 3 For Cash Dividends 14 For Interest (From Previous Month's Borrowing) 15 Total Cash Disbursements 16 Excess (Deficiency) of Cash 7 Financing Borrowing 19 Repayment 20 Total Financing 21 Cash Balance Ending 25 Outstanding Loan Balance 26 Interest on Borrowing (Due the Following Quarter) Part il Purchasing Budget Part II Admin Budget Part II Cash Budget O Type here to search 8 F Instructions Milestone 1 10 1. 12 . 13 Sales Budget 14 Prepare Sales Budget 15Prepare Schedule of 16 17 18 19 2. 20 21 Prepare Merchandise Expected Cash Collection From Sales Purchasing Budget Purchases Budget Cash Disbursements for 23 Prepare Schedule of Expected 24 25 26 27 13. 28 29Prepare Selling and Admin 30 Merchandise Purchases Admin Budget Budnat Includinn Fynected Instructions Milestone One Instructions 8 ITEMS TO COMPLETE FOR THIS MILESTONE (Blue Tabe): 19 20 GENERAL 21 You are the accountant tasked with creating the master budget for SRS Educational Supply Company. You have made your budget 22 assumptions (see the red tab labeled Part I Assumptions) and are ready to prepare the following 23 24 SALES BUDGET 25 26 27 28 29 PURCHASING BUDGET 30 31 32 Prepare the sales budget by month and in total Prepare a schedule of excepted cash collections from sales by month and in total Prepare a merchandise purchases budget by month and in total Prepare a schedule of expected cash disbursements for merchandise purchases by month and in total 34 ADMIN BUDGET 35 36 37 Prepare a selling and admin budget by month and in total Add expected cash disbursements for selling and admin by month and in total 39 CASH BUDGET Instructions Milestone One Instructions Part Il Assumptions Part il Sales Budget O Type here to search Conditional Format as Formatting, Table- Styles. Clipboard Font Alignment Cells A1 Most likely sales atio 7PURCHASING MANAGER PRIVATE INFORMATION Desired ending inventory as a percentage of next month's cost of sales 10 Most likely cost of merchandise as a % of sales 9 45% 20% 12 OPERATION MANAGER PRIVATE INFORMATION 13 Most likely shipping expenses as a percent of sales 14 Most likely other expenses as a percent of sales 15 Salaries and wages (per month) 16 Most likely advertising costs (per month) 17 Most likely insurance costs (per month) Part 1 Information 5 0% 80% 85,000 50,000 3,000 25,000 Depreciation expense (per month) 19 20 FINANCE MANAGER PRIVATE INFORMA TION 22 Percent sales collected in month of sale 23 Percent sales collected in month after sale ion 30% 70% instructions Part II Part Ul Sales Budget O Type here to search H12 Percent sales collected in month of sale 30% 70% Percent sales collected in month after sale Percent of inventory purchases paid in month of purchase 6 Percent of inventory purchases paid in month after purchase 50% 50% 100% 0% 28 Percent of operating expenses paid in month of purchase 29 Percent of operating expenses paid in month after purchase 30 31 Desired minimum ending cash balance each month 32 Borrow in increments of 33 Monthly interest rate on borrowings (not compounded) 34 35 35,000 1,000 1% 36 Other planned outlays of cash September 37 Capital expenditures 38 Dividends 50,000 $ 39 40 42 SRS Educational Supply Company 43 Balance Sheet 44 Previous Year End 45 Assets Part II Assumptions P Instructions Milestone One Instructions Part II Sales Budget O Type here to search Arial Paste | B 1-IB-lo-A-| --Merge & Center. | $.% , Number Clipboard Font G15 Sales Budget August September Quarte 5 Sales Schedule of Cash Collections July August September Quarter 9 June sales (A/R From Beginning Balance Sheet) 10 July sales-Collected in Current Month 11 July sales-Collected in Following Month 2 Auqust sales-Collected in Current Month 13 August sales-Collected in Following Month 14 September sales-Collected in Current Month Total Expected Cash Collections 16 19 Total Sales for the Quarter 20 A/R at the end of the Quarter (September Sales Still not Collected Dart Il Assumptions Part Il Sales Budget nstructions Milestone One Instructions O Type here to search udgeted Cost of Merchandise Sold us Desired Ending Inventory otal Inventory Needs ess Beginning Inventory Required Purchases Schedule of Expected Cash Disbursements - Purchases July August September Quarter June Purchases (A/P From Balance Sheet) s July Purchases 26 August Purchases 27 September Purchases 28 Total Disbursements 30 32 Cost of Merchandise Sold for the Quarter 3 Ending Inventory at the end of the Quarter 34 Ending A/P at the end of the Quarter 36 38 Part il AssumptionsPart li Sales Budget Part II Purchasing Budget O Type here to search esc F4 16 Number Arial Font Alignment Number Clipboard D17 Cash Budget July 6 Cash Balance: Beginning 7 Add Cash Collections (From Sales Budget) 8 Total cash Available 9 Less Cash Disbursements 10 For Inventory (From Purchasing Budget) 11 For Operating Expenses (From Selling and Admin Budget) 2 For Equipment 3 For Cash Dividends 14 For Interest (From Previous Month's Borrowing) 15 Total Cash Disbursements 16 Excess (Deficiency) of Cash 7 Financing Borrowing 19 Repayment 20 Total Financing 21 Cash Balance Ending 25 Outstanding Loan Balance 26 Interest on Borrowing (Due the Following Quarter) Part il Purchasing Budget Part II Admin Budget Part II Cash Budget O Type here to search