McKnight 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 1st quarter.... $ 181,000 154,500 2nd quarter... 217,000 182,000 3rd quarter $ 259,000 215,000 4th quarter $ 191,000 160,000 Prepare the production budget by first calculating the total units needed, then calculate the units to produce. McKnight Foods Production Budget For the Quarters in the Upcoming Year Quarter 1 Quarter 2 Quarter 3 Unit sales 154,500 182,000 215,000 Plus: Desired ending inventory 54,600 64,500 48,000 Total needed 209.100 246,500 263,000 Year Quarter 4 160,000 66,000 711,500 66,000 226,000 777,500 Less: Beginning inventory Units to produce Mcknight anticipates selling 220,000 jars with total sales revenue of $269,000 in the first quarter of the year following the year given in the preceding table. McKnight has a policy that the ending inventory of jars must be 30% of the following quarter's sales. 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