Cleary Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each quarter of the upcoming year are as follows: Number of jars C Cleary anticipates selling 227,000 jars with total sales revenue of $265,000 in the first quarter of the year following the year given in the table to the left. Cleary has a policy that the ending inventory of jars must be 20% of the following quarter's sales. Total sales revenue sold 1st quarter $184,000 153,500 Prepare a production budget for the year that 2nd quarter $214,000 185,000 shows the number of jars to be produced each quarter and for the year in total. 3rd quarter $257,000 214,000 4th quarter $191,000 162,500 Prepare the production budget by first calculating the total units needed, then calculate the units to produce. Cleary Foods Production Budget For the Upcoming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Unit sales 227000 185,000 214,000 162,500 788500 45400 37000 42800 32500 Desired ending inventory Total needed 272400 222000 256800 195000 Less: Beginning inventory (30,700) 45400 37000 42800 241700 176600 219800 152200 790300 Units to produce