Johnson Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each quarter of the upcoming year are as follows: Johnson anticipates selling 226,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. Johnson has a policy that the ending inventory of jars must be 20% of the following quarter's sales. Total sales revenue Number of jars sold Prepare a production budget for the year that shows the number of jars to be produced each quarter and for the year in total. $184,000 153,500 1st quarter 2nd quarter 3rd quarter 4th quarter $217,000 $251,000 181,000 211,500 160,500 $ 194,000 Prepare the production budget by first calculating the total units needed, then calculate the units to produce. Johnson Foods Production Budget For the Upcoming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Unit sales Desired ending inventory Total needed