ACC 311 Final Project II Student Workbook nvg

xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

311

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

21

Uploaded by EarlSteel5127

Report
Southern New Hampshire University Final Project II ACC 311 - Cost Accounting - STUDENT WORKBOOK 1. 1. Prepare Sales Budget Prepare Budgeted Income Prepare Schedule of Statement Expected Cash Collection Prepare Budgeted Balance From Sales Sheet 2. 2. Reporting Prepare Merchandise Purchases Budget In a separate Word document Prepare Schedule of Expected Analyze Data Cash Disbursements for 1. Briefly summarize each department's Merchandise Purchases budget - its purpose, what the numbers represent, how they 3. can be used. Also, discuss the month to month variances, what Prepare Selling and Admin they mean, and why they are Budget, Including Expected important Cash Disbursements 2. Explain two variances that might 4. cause concern or prompt further analysis. Prepare Cash Budget In a separate Word document or PowerPoint Presentation Executive Brief Presentation 1. Create an executive briefing presentation in which you briefly summarize all budgets. Include all supporting documentation as addendums to the brief. MILESTONE ONE (Due in Module Five) FINAL PROJECT (Due in Module Seven) *Refer to Final Project II Assignment Guidelines and Rubric document Sales Budget Sales Budget Admin Budget Admin Budget Purchasing Budget Purchasing Budget Financial Statements Financial Statements Instructions Milestone 1 Instructions Milestone 1 Instructions Final Project Instructions Final Project Cash Budget Cash Budget
Southern New Hampshire University College of Continuing Education (COCE) ACC 311 - Cost Accounting - STUDENT WORKBOOK IMPORTANT NOTES: Use the data from this milestone and begin work on your final presentation, which is due in Module Se GENERAL SALES BUDGET Prepare the sales budget by month and in total. Prepare a schedule of excepted cash collections from sales by month and in total. PURCHASING BUDGET Prepare a merchandise purchases budget by month and in total. Prepare a schedule of expected cash disbursements for merchandise purchases by month and ADMIN BUDGET Prepare a selling and admin budget by month and in total. Add expected cash disbursements for selling and admin by month and in total. CASH BUDGET Prepare a cash budget by month and in total. FINANCIAL INFORMATION FOR BUDGETS - SEE PART II ASSUMPTIONS (RED TAB) INSTRUCTIONS FOR MILESTONE 1 (Due Week 5) Make sure to completely review the Milestone One Final Project II Rubric. ITEMS TO COMPLETE FOR THIS MILESTONE (Blue Tabs) : You are the accountant tasked with creating the master budget for SRS Educational Supply Company. You h budget assumptions (see the red tab labeled Part II Assumptions) and are ready to prepare the following:
even. in total. have made your HOME HOME
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
MOST LIKELY NUMBERS AND ASSUMPTIONS SALES MANAGER PRIVATE INFORMATION Most likely sales PURCHASING MANAGER PRIVATE INFORMATION Most likely cost of merchandise as a % of sales Desired ending inventory as a percentage of next month's cost of sales OPERATION MANAGER PRIVATE INFORMATION Most likely shipping expenses as a percent of sales Most likely other expenses as a percent of sales Salaries and wages (per month) Most likely advertising costs (per month) Most likely insurance costs (per month) Depreciation expense (per month) FINANCE MANAGER PRIVATE INFORMATION Percent sales collected in month of sale Percent sales collected in month after sale Percent of inventory purchases paid in month of purchase Percent of inventory purchases paid in month after purchase Percent of operating expenses paid in month of purchase Percent of operating expenses paid in month after purchase Desired minimum ending cash balance each month Borrow in increments of Monthly interest rate on borrowings (not compounded) Other planned outlays of cash Capital expenditures Dividends SRS Educational Supply Company Balance Sheet Previous Year End Assets Current assets: Cash Accounts receivable Inventory Prepaid insurance Total current assets Buildings and equipment (net) TOTAL ASSETS
Liabilities and Equity Liabilites Accounts payable Notes payable Total liabilities Stockholder's equity Capital stock Retained earnings Total equity TOTAL LIABILITIES AND EQUITY
July August September October $ 600,000 $ 910,000 $ 475,000 $ 385,000 Part 1 Information 45% 20% Part 1 Information 5.0% 8.0% $ 85,000 $ 50,000 $ 3,000 $ 25,000 Part 1 Information 30% 70% 50% 50% 100% 0% $ 35,000 $ 1,000 1% July August September $ 200,000 $ 90,000 $ - $ 50,000 $ - $ - $ 40,000 $ 340,000 $ 50,000 $ 18,000 $ 448,000 $ 860,000 $ 1,308,000 Home Home
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$ 130,000 $ - $ 130,000 $ 420,000 $ 758,000 $ 1,178,000 $ 1,308,000
Sales Budget July August September Sales $ 600,000 $ 910,000 $ 475,000 Schedule of Cash Collection July August September June sales (A/R From Beginning Balance Sheet) 340,000 July sales - Collected in Current Month 180,000 July sales - Collected in Following Month 420,000 August sales - Collected in Current Month 273,000 August sales - Collected in Following Month 637,000 September sales - Collected in Current Month 142,500 Total Expected Cash Collections $ 520,000 $ 693,000 $ 779,500 Total Sales for the Quarter A/R at the end of the Quarter (September Sales Still not Collected)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Quarter $ 1,985,000 ns Quarter 340,000 180,000 420,000 273,000 637,000 142,500 $ 1,992,500 $ 1,985,000 $ 332,500 View Assumptions View Assumptions HOME HOME
Inventory Purchase Budget July August September October Sales $ 600,000 $ 910,000 $ 475,000 $ 385,000 Cost of Merchandise as % of Sales 45% 45% 45% 45% Budgeted Cost of Merchandise Sold $ 270,000 $ 409,500 $ 213,750 $ 173,250 Following Month's COGS $ 409,500 $ 213,750 $ 173,250 Desired Ending Inventory % 20% 20% 20% Desired Ending Inventory Dollars 81,900 42,750 34,650 Budgeted Cost of Merchandise Sold 270,000 409,500 213,750 893,250 Plus Desired Ending Inventory 81,900 42,750 34,650 Total Inventory Needs 351,900 452,250 248,400 Less Beginning Inventory (50,000) (81,900) (42,750) Required Purchases $ 301,990 $ 370,350 $ 205,650 Schedule of Expected Cash Disbursements - Purchases July August September Quarter June Purchases (A/P From Balance Sheet) $ 130,000 $ 130,000 July Purchases $ 150,950 $ 150,950 $ 301,900 August Purchases $ 185,175 $ 185,175 $ 370,350 September Purchases $ 102,825 $ 102,825 Total Disbursements $ 280,950 $ 336,125 $ 288,000 $ 905,075 Cost of Merchandise Sold for the Quarter $ 893,250 Ending Inventory at the end of the Quarter $ 34,850 Ending A/P at the end of the Quarter $ 102,825 View Assumption View Assumption
ns ns HOME HOME
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Selling and Administrative Budget July August September Quarter Sales $ 600,000 $ 910,000 $ 475,000 $ 1,985,000 Shipping as a Percentage of Sales 5% 5% 5% 5% Other Expenses as a Percentage of Sales 8% 8% 8% 8% Variable Expenses: Shipping 30,000 45,500 23,750 99,250 Other Expenses 48,000 72,800 38,000 158,800 Total Variable Expenses 78,000 118,300 61,750 258,050 Fixed Expenses: Salaries and Wages 85,000 85,000 85,000 255,000 Advertising 50,000 50,000 50,000 150,000 Prepaid Insurance 3,000 3,000 3,000 9,000 Depreciation 25,000 25,000 25,000 75,000 Total Fixed Expesnes 163,000 163,000 163,000 489,000 Total Selling and Admin Expenses 241,000 281,300 224,750 747,050 Less Noncash Items (Depreciation and Prepaid Ins) (28,000) (28,000) (28,000) (84,000) Total Cash Disbursements 213,000 253,300 196,750 663,050 Prepaid Insurance That Is Expensed During the Quarter $ 9,000 Depreciation Expense Recognized During the Quarter $ 75,000
View Assumptions View Assumptions HOME HOME
Cash Budget July August September Quarter Cash Balance: Beginning 40,000 35,050 35,435 40,000 Add Cash Collections (From Sales Budget) 520,000 693,000 779,500 1,992,500 Total cash Available 560,000 728,050 814,935 2,032,500 Less Cash Disbursements For Inventory (From Purchasing Budget) 280,950 336,125 288,000 905,075 For Operating Expenses (From Selling and Admin Budget) 213,000 253,300 196,750 663,050 For Equipment 200,000 90,000 0 290,000 For Cash Dividends 50,000 0 0 50,000 For Interest (From Previous Month's Borrowing) 0 $ 2,190 $ 2,080 4,270 Total Cash Disbursements 743,950 681,615 486,830 1,912,395 Excess (Deficiency) of Cash (183,950) 46,435 328,105 120,105 Financing Borrowing 219,000 0 0 219,000 Repayment (11,000) (208,000) (219,000) Total Financing 219,000 (11,000) (208,000) 0 Cash Balance: Ending 35,050 35,435 120,105 120,105 Outstanding Loan Balance Interest on Borrowing (Due the Following Quarter) $ 4,270
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
HOME HOME View Assumptions View Assumptions
Southern New Hampshire University Final Project II ACC 311 - Cost Accounting - STUDENT WORKBOOK IMPORTANT NOTES: Use the data from Milestone One and begin work on your final presentation, which is due in Module Se GENERAL Use data from Milestone One and the Part II Assumptions tab (the red tab) for your statement pr BUDGETED FINANCIAL STATEMENTS Prepare a budgeted income statement. Prepare a budgeted balance sheet. In a separate Word document *Refer to Final Project II Assignment Guidelines and Rubric document ANALYZE DATA 1. Briefly summarize each department's budget - its purpose, what the numbers represent, how they can be used. Also, discuss the month to month variances, what they mean, and why they are important. 2. Explain two variances that might cause concern or prompt further analysis. In a separate Word document or PowerPoint Presentation EXECUTIVE BRIEF PRESENTATION 1. Create an executive briefing presentation in which you briefly summarize all budgets. Include all supporting documentation (the budgets/statements) as addendums to the brief. INSTRUCTIONS FOR FINAL PROJECT II (Due Module Seven Make sure to completely review the Final Project II Rubric. ITEMS TO COMPLETE FOR FINAL PROJECT II (Purple Tabs) :
even. reparation. n) HOME HOME
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
SRS Educational Supplies Company Budgeted Income Statement For the Quarter Ended September 30th Sales Cost of Goods Sold 1,985,000 Gross Margin 89,250 Selling and Administrative Expenses 1,091,750 Shipping 99,250 Other 158,800 Salaries and Wages 255,000 Advertising 15,000 Prepaid Insurance 9,000 Depreciation 75,000 747,050 Net Operating Incomes 344,700 Less Interest Expense 4,270 Net Income 340,430 SRS Educational Supply Company Balance Sheet September 30th Assets Current Assets: Cash $ 120,015 Accounts receivable 332,250 Inventory 34,650 View Assumptions View Assumptions Home Home
Prepaid Insurance 9,000 Total Current Assets 495,915 Buildings and Equipment (Net) 1,075,000 Total Assets $1,570,915 Liabilities and Equity Accounts Payable 102,825 Notes Payable 0 102,825 Stockholder's Equity Capital Stock 420,000 Retained Earnings 1,048,430 Total Liability and Equity 1,571,255
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help