Rouse Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each quarter of the upcoming year are as follows: Total sales Number of jars revenue sold Rouse anticipates selling 225,000 jars with total sales revenue of $264,000 in the first quarter of the year following the year given in the preceding table. Rouse has a policy that the ending inventory of jars must be 25% of the following quarter's sales. 189,000 154,500 1st quarter $ 2nd quarter ... $ 3rd quarter $ 4th quarter $ Requirement Prepare a production budget for the year that shows the number of jars to be produced each quarter and for the year in total. 210,000 252,000 182,000 211,500 194,000 162,000 -..-- Prepare the production budget by first calculating the total units needed, then calculate the units to produce. Rouse Foods Production Budget For the Quarters in the Upcoming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Unit sales 154,500 182,000 211,500 162,000 56,250 710,000 56,250 Plus: Desired ending inventory 45,500 52,875 40,500 Total needed 200,000 234,875 252,000 218,250 766,250 Less: Beginning inventory Units to produce Rogers Services, Inc., has $8,600 cash on hand on July 1. The company requires a minimum cash balance of $7,600. July cash collections are $548,480. Total cash payments for July are $566,500. Prepare a cash budget for July. How much cash, if any, will Rogers need to borrow by the end of July? Complete the cash budget below. (Use parentheses or a minus sign for negative ending cash balances or deficiencies.) Rogers Services, Inc. Combined Cash Budget For the Month Ended July 31 Beginning cash balance $ 8,600 Plus: Cash collections 548,480 Total cash available 557,080 566,500 Less: Cash payments Ending cash balance before financing (9,420) 17020 Minimum cash balance desired 7600 Cash excess (deficiency)