Kevin's Restaurant Supply is preparing its cash budgets for the first two months of the upcoming year. Here is the information about the company's upcoming cash receipts and cash disbursements: Click the icon to view the information.) Requirements 1. Prepare schedules of (a) budgeted cash collections, (b) budgeted cash payments for purchases, and (c) budgeted cash payments for operating expenses. Show totals for each month and totals for January and February combined. 2. Prepare a combined cash budget. If no financing activity takes place, what is the budgeted cash balance on February 28? Requirement 1a. Prepare a schedule of budgeted cash collections for January and February. Show totals for each month and totals for January and February combined. Kevin's Restaurant Supply Cash Collections Budget For the Months Ended January 31 and February 28 January February Total Cash sales Collection on credit sales Total cash collections b. Prepare a schedule of budgeted cash payments for purchases for January and February. Show totals for each month and totals for January and February combined. Kevin's Restaurant Supply Cash Payments for Material Purchases Budget For the Months Ended January 31 and February 28 1,7,8,9 Enter any number in the edit fields and then continue to the next question. merits o MacBook Pro esc F2 SO F3 F4 2 3 4 5 6 dis for cash payments operaung ex and totals for January and February combine Prepare a combined cash budget. If no financing activity takes place, what is the budgeted cash balance on Febr 282 Kevin's Restaurant Supply Cash Payments for Material Purchases Budget For the Months Ended January 31 and February 28 January February Total 40% of current month DM purchases 60% of last month's DM purchases Total cash payments c. Prepare a schedule of budgeted cash payments for operating expenses for January and February. Show totals for each month and totals for January and February combined. (If a box is not used in the table leave the box empty, do not enter a zero. Round all amounts to the nearest dollar) Kevin Restaurant Supply Cash Payments for Operating Expenses Budget For the Months Ended January 31 and February 28 January February Total Variable cash operating expenses Enter any number in the edit fields and then continue to the next question MacBook Pro esc F1 F2 20 F3 Fa F5 @ # $ 1 2 3 % 5 4 6 W E R . ab Total Kevin Restaurant Supply Cash Payments for Operating Expenses Budget For the Months Ended January 31 and February 28 January February Variable cash operating expenses: Sales commissions: December Sales commissions: January Sales commissions: February Total variable cash operating expenses Fixed cash operating expenses: Sales salaries: December Sales salaries: January Sales salaries: February Rent expense Tay away a Enter any number in the edit fields and then continue to the next question. M esc FI BO F3 F2 OOD F4 F5 % 2 3 4 5 Q W D 2. Prepare a combined cash budget. If no financing activity takes place, what is the budgeted cash balance on February 28? Sales salanes: February Rent expense Tax expense Total fixed cash operating expenses Total cash payments for operating expenses Requirement 2. Prepare a combined cash budget for January and February. If no financing activity takes place, what is the budgeted cash balance on February 28? Kevin's Restaurant Supply Combined Cash Budget For the Months Ended January 31 and February 28 January February 2 months Beginning cash balance Plus: Cash collections from customers Total cash available Less cash payments: Enter any number in the edit fields and then continue to the next question mer MacBook Pro esc FI F2 F3 Do Fa FS @ # $ % 1 2 3 4 5 co Q W E R T T . S D F G udgeted cash balance on February 28? Kevin's Restaurant Supply Combined Cash Budget For the Months Ended January 31 and February 28 January February 2 months Beginning cash balance Plus: Cash collections from customers Total cash available Less cash payments: Direct materials purchases Operating expenses Total cash payments Ending cash balance Enter any number in the edit fields and then continue to the next question. MacBook esc F F2 OOO DOO F4 F3 ES # $ % 1 2 3 4 5 co Q W E R . . S D F G Kevin's Restaurant Supply is preparing its cash budgets for the first two months of the upcoming year. Here is the information about the company's upcoming cash receipts and cash disbursements: Click the icon to view the information.) Requirements 1. Prepare schedules of (a) budgeted cash collections, (b) budgeted cash payments for purchases, and (c) budgeted cash payments for operating expenses. Show totals for each month and totals for January and February combined. 2. Prepare a combined cash budget. If no financing activity takes place, what is the budgeted cash balance on February 28? Requirement 1a. Prepare a schedule of budgeted cash collections for January and February. Show totals for each month and totals for January and February combined. Kevin's Restaurant Supply Cash Collections Budget For the Months Ended January 31 and February 28 January February Total Cash sales Collection on credit sales Total cash collections b. Prepare a schedule of budgeted cash payments for purchases for January and February. Show totals for each month and totals for January and February combined. Kevin's Restaurant Supply Cash Payments for Material Purchases Budget For the Months Ended January 31 and February 28 1,7,8,9 Enter any number in the edit fields and then continue to the next question. merits o MacBook Pro esc F2 SO F3 F4 2 3 4 5 6 dis for cash payments operaung ex and totals for January and February combine Prepare a combined cash budget. If no financing activity takes place, what is the budgeted cash balance on Febr 282 Kevin's Restaurant Supply Cash Payments for Material Purchases Budget For the Months Ended January 31 and February 28 January February Total 40% of current month DM purchases 60% of last month's DM purchases Total cash payments c. Prepare a schedule of budgeted cash payments for operating expenses for January and February. Show totals for each month and totals for January and February combined. (If a box is not used in the table leave the box empty, do not enter a zero. Round all amounts to the nearest dollar) Kevin Restaurant Supply Cash Payments for Operating Expenses Budget For the Months Ended January 31 and February 28 January February Total Variable cash operating expenses Enter any number in the edit fields and then continue to the next question MacBook Pro esc F1 F2 20 F3 Fa F5 @ # $ 1 2 3 % 5 4 6 W E R . ab Total Kevin Restaurant Supply Cash Payments for Operating Expenses Budget For the Months Ended January 31 and February 28 January February Variable cash operating expenses: Sales commissions: December Sales commissions: January Sales commissions: February Total variable cash operating expenses Fixed cash operating expenses: Sales salaries: December Sales salaries: January Sales salaries: February Rent expense Tay away a Enter any number in the edit fields and then continue to the next question. M esc FI BO F3 F2 OOD F4 F5 % 2 3 4 5 Q W D 2. Prepare a combined cash budget. If no financing activity takes place, what is the budgeted cash balance on February 28? Sales salanes: February Rent expense Tax expense Total fixed cash operating expenses Total cash payments for operating expenses Requirement 2. Prepare a combined cash budget for January and February. If no financing activity takes place, what is the budgeted cash balance on February 28? Kevin's Restaurant Supply Combined Cash Budget For the Months Ended January 31 and February 28 January February 2 months Beginning cash balance Plus: Cash collections from customers Total cash available Less cash payments: Enter any number in the edit fields and then continue to the next question mer MacBook Pro esc FI F2 F3 Do Fa FS @ # $ % 1 2 3 4 5 co Q W E R T T . S D F G udgeted cash balance on February 28? Kevin's Restaurant Supply Combined Cash Budget For the Months Ended January 31 and February 28 January February 2 months Beginning cash balance Plus: Cash collections from customers Total cash available Less cash payments: Direct materials purchases Operating expenses Total cash payments Ending cash balance Enter any number in the edit fields and then continue to the next question. MacBook esc F F2 OOO DOO F4 F3 ES # $ % 1 2 3 4 5 co Q W E R . . S D F G