Gable Foods produces specialty soup sold in jars. The projected sales in dollars Gable anticipates selling 222,000 jars with total sales revenue of $268,000 and jars for each quarter of the upcoming year are as follows: in the first quarter of the year following the year given in the table to the left. Number of jars Gable has a policy that the ending inventory of jars must be 30% of the Total sales revenue sold following quarter's sales. ist quarter . . . . $180,000 150,000 Prepare a production budget for the year that shows the number of jars to 2nd quarter . . . . $212,000 185,000 be produced each quarter and for the year in total. 3rd quarter . . . . $252,000 210,500 4th quarter . . . . $193,000 165,000 Prepare the production budget by first calculating the total units needed, then calculate the units to produce. Gable 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