Teppler Service anticipates the following sales revenue over a five-month period: Teppler Service's collection history indicates that credit sales are collected as follows: (Click the icon to view the sales data.) i (Click the icon to view the collections data.) . . . Teppler Service's sales are 30% cash and 70% credit. How much cash will be collected in January? In February? In March? X Sales Data Complete the cash budget to determine how much cash will be collected in January, February, an Teppler Service Cash Collections Budget November December January February March For the Months of January through March Sales revenue . . . . $ 16,700 $ 10,000 $ 15,500 $ 12,400 $ 14,400 January February March Cash sales $ 4,650 $ 3,720 4,320 Collection of credit sales: Print Done 30% Month of sale 3,255 2,604 3,024 60% Month after 6% Two months after Total cash collectionsSurity Corporation is preparing its cash payments budget for next month. The following information pertains to the cash payments: (Click the icon to view the data.) How much cash will be paid out next month? X Surity Corporation Data table Cash Payments Budget Cash payments for direct materials: a. Surity Corporation pays for 50% of its direct materials purchases in the month of purchase and the Current month's purchases remainder the following month. The current month's direct material purchases were $73,000, while Surity Corporation anticipates $81,000 of direct material purchases next month Next month's purchases b. Direct labour for the upcoming month is budgeted to be $40,000 and will be paid at the end of the upcoming Cash payments for direct labour month. Cash payments for manufacturing overhead c. Manufacturing overhead is estimated to be 150% of direct labour cost each month and is paid in the month in which it is incurred. This monthly estimate includes $13,000 of depreciation on the plant and equipment. Cash payments for operating expenses d. Monthly operating expenses for next month are expected to be $45,000, which includes $2,500 of depreciation on office equipment and $1,900 of bad debt expense. These monthly operating expenses are Cash payment for taxes paid during the month in which they are incurred. Total cash payments e. Surity Corporation will make an estimated tax payment of $7,800 next month. Print DoneCosta Manufacturing has $11,000 cash on hand on December 1. The company requires a minimum cash balance of 58,400 December cash collections are $552000. Total cash payments for December are $585,000. Prepare a cash budget for December. How much cash: if any' will Costa need to borrow by the end of December? Complete the cash budget below (Use parentheses or a minus sign for negative ending cash balances or deciencies.) Cosh Manufacturing Cash Budget For the Month Ended December 31 Beginning cash balance Cash collections from customers Cash available before nancing Total cash payments Ending cash balance before financing Minimum cash balance desired Cash excess (deficiency) Donaldson Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each Donaldson anticipates selling 229,000 jars with total sales revenue of $263,000 in the first quarter of the upcoming year are as follows: quarter of the year following the year given in the table to the left. Donaldson has a policy that Number of jars the ending inventory of jars must be 25% of the following quarter's sales. Total sales revenue sold . . . Prepare a production budget for the year that shows the number of jars to be produced each 1st quarter . . . . $ 182,000 155,000 quarter and for the year in total. 2nd quarter . . . . $219,000 181,500 3rd quarter . . . . $255,000 212,000 4th quarter . . . . $ 190,000 161,500 Prepare the production budget by first calculating the total units needed, then calculate the units to produce. Donaldson Foods Production Budget For the Upcoming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Unit sales Desired ending inventory Total needed Less: Beginning inventory Units to produce