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....S 180,000 152,500 2nd quarter... $ 210,000 182,500 3rd quarter...$ 255,000 212,000 4th quarter...$ 190,000 162,500 Preston anticipates selling 226,000 jars with total sales revenue of $269,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 25% 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 Prepare the production budget by first calculating the total units needed, then calculate the units to produce Preston Foods Production Budget For the Quarters in the Upcoming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Unit sales Plus: Desired ending inventory 152.500 45.025 182,500 212,000 162,500 709,500 53,000 40.625 50,500 50.500 Total needed 196.125 235,500 252,625 219,000 766,000 Less: Beginning inventory Units to produce Question Viewer