with the following information create a cash budget for the sale of january. (3rd picture)

question:

prepare a cash budget for just the montg of January.

a cash balance on January 1 of $25,000

selling general and administration cash disbursements during january of $60,000

a minimum dash balance on january 31 of $20,000

McKee Bakery is preparing the first quarter budget for its most popular product, Little Debbie Honey Buns. The following information has been assembled. December sales (actual) $300,000 100,000 boxes January budgeted sales $279,000 93,000 boxes February budgeted sales $204,000 68,000 boxes March budgeted sales $180,000 60,000 boxes April budgeted sales $270,000 90,000 boxes May budgeted sales $300,000 100,000 boxes McKee Bakery sells directly to grocery stores, and all sales are on account. Past collections have been 30% in the month of sale and 70% in the month following the sale. McKee budgets ending finished good inventory at 20% of the following month's sales. Each box of Little Debbie Honey Buns requires 6 ounces of a secret ingredient. McKee budgets ending direct materials inventory at 10% of the following month's production needs. It costs $0.50 per ounce. All purchases are paid in cash the month of purchase. Prepare a schedule of expected cash collections for the first quarter. January February March Quarter 1 200 000 x .07 210000 2 10000 8370 145 560 239000 x .03 204400 8,03 9000 : 3 180000 1.03 279000 204000 61 200 142800 54000 D4000 256,500 293700 196800 Total 74 7000 93060 800 19000 Prepare a production budget for the first quarter. Assume the beginning inventory of honey buns in January is 20,000 boxes. January February March Quarter 1 Budgeted Sales, in units 68000 221 60 77600 Add: Desired Ending go 12800 1830 Inventory Socco 7800 264600 Total Needs 19 Co Izced 2006 Less: Beginning Inventory Shoes 66com Required Production, in units Prepare a direct materials budget for the first quarter. Assume the beginning inventory of secret ingredient in January is 59,000 ounces. fil 20000 66900 219000 9000 om 110 000 92000 March Quarter 1 January 860 00 February GG 4.0 G6000 249. Coo G 6 6 46 Required Production, in units Ounces of secret ingredient needed per box of finished product Ounces of secret ingredient needed to meet production (Production needs) 1314000 519600 | 398,400 396000 39 guo 55200 5520 34600 Add: Desired secret ingredient ending inventory, in ounces Ounces of secret ingredient needed 959 440 0 3006 451200 59000 34940 39600 59000 Less: Beginning Inventory, in ounces 500 y yo 396 160 411660 Ounces to be purchased Cost of secret ingredient to be purchased Prepare a cash budget for just the month of January A cash balance on January 1 of $25,000. Selling general and Administrative cash disbursements during January of $60,000. A minimum cash balance on January 31 of $20,000. If necessary, the company will borrow cash from a bank. Cash balance, beginning January Cash collections from customers Total cash available Direct Material Purchases Selling. General, & Administrative Expenses Total cash disbursements Excess