AutoSave OFF Home Insert Draw ACG2209-Delieverable-6-Assignment.xlsx - Read-Only Page Layout Formulas Data Review View Automate Tell me Comments Share Arial 10 Paste v BIU A A A Wrap Text General Insert Merge & Center $%9 Cell Conditional Format Formatting as Table Styles Delete Format v v Sort & Filter Find & Select Analyze Sensitivity Data B18 fx A D G H K L M N 0 P Q 1 Personal budget 2 At the beginning of the school year, Joe Student decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget Cash balance, September 1 (from a summer job) 8 Purchase season football tickets in September Additional entertainment for each month 9 Pay fall samaster tuition in September 10 Pay rent at the beginning of each month 11 Pay for food each month 12 13 Pay apartment deposit on September 2 to be retumed December 15) Part-time job camings each month (net of taxes) 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Prepare the cash budget for the quarter of the year. Module 6 Deliverable Ready Accessibility: Investigate DATA Estimated cash receipts from Joe Student Cash Budget $8,700 170 270 4,500 850 600 550 1.300 For the Four Months Ending December 31 October September Total cash receipts Less estimated cash payments for Total cash payments Cash increase (decrease) Beginning Cash balance Cash balance at end of month November December 100% AutoSave OFF Home Insert Draw Paste v ACG2209-Delieverable-6-Assignment.xlsx - Read-Only Page Layout Formulas Data Review View Automate Tell me Comments Share Arial 10 BIU fx A A A Wrap Text General Insert Merge & Center $%9 Cell Conditional Format Formatting as Table Styles Delete Format v v Sort & Filter Find & Select Analyze Sensitivity Data B18 38 39 A D G H 40 41 C Budget surplus/shortage at the end of December Provide a 150-300 word statement as to whether Joe will have enough money at the end of December to cover the spring semester's tuition. Include figures and shortage/overage amounts 42 43 44 45 46 2 Flexible budget for selling and administrative expenses for a service company 47 48 Tax Services Inc. (a fictitious company) uses flexible budgets that are based on the following data: 49 DATA 50 51 Sales commissions 52 Advertising expense 8% of sales 16% of sales 53 Miscellaneous administrative expense 54 Office salanes ns $8.500 per month plus $54,000 per month 4% of sales 55 Customer support expenses 56 Research and development expense $17,000 per month plus $73,000 per month 27% of seles 57 58 Select the corresponding accounts. Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the C. D. E, and F columns. Enter all amounts as positive numbers. 59 60 61 62 63 64 Total sales 65 Variable co 66 67 68 69 70 Total variable co 71 Fixed cost 72 73 74 75 76 Total fixed co 77 Total seling and administrative expense 78 Module 6 Deliverable Ready Accessibility: Investigate + Tax Services Inc. Flexible Selling and Administrative Expenses Budget For the Month Ending October 31 $500,000 $800,000 $1,100,000 K L M N 0 P Q 100%