Gable Foods produces specialty soup sold in jars. The projected sales in dollars and jars Gable anticipates selling 221,000 jars with total sales revenue of $266,000 in the first for each quarter of the upcoming year are as follows: quarter of the year following the year given in the table to the left. Gable has a policy that the ending inventory of jars must be 25% of the following quarter's sales. Total sales revenue Number of jars sold 1st quarter $ 180,000 153,000 Prepare a production budget for the year that shows the number of jars to be produced each quarter and for the year in total. 2nd quarter . . ... $219,000 181,000 3rd quarter ..... $255,000 211,500 4th quarter $ 195,000 163,000 Gable Foods Production Budget For the Upcoming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Unit sales Desired ending inventory Total needed Enter any number in the edit fields and then click Check