Preston anticipates selling 223,000 jars with total sales revenue of $267,000 in the first quarter of the year following the year given in the preceding table. Preston has a policy that the ending inventory of jars must be 20% of the following quarter's sales. Preston 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....$ 186,000 153.000 2nd quarter ... $ 210.000 181,500 3rd quarter ... $ 252,000 211,000 4th quarter ... $ 192,000 160,000 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 Year For the Quarters in the Upcoming Year Quarter 1 Quarter 2 Quarter 3 153,000 181,500 211,000 36,300 42,200 32,000 Quarter 4 160.000 Unit sales 705,500 44,600 44,600 Plus: Desired ending inventory Total needed 189,300 204,600 750,100 223,700 36,300 243,000 42,200 Less: Beginning inventory 32,000 187,400 Units to produce 200,800 172,600