Prepare the production budget by first calculating the total units needed, then calculate the units to produce

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 222,000 jars with total sales revenue of $268,000 in the first quarter of the year following the year given in the preceding table. Johnson has a policy that the ending inventory of jars must be 30% of the following quarters 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. 1st quarter.. $ 2nd quarter 3rd quarter . 4th quarter ... $ Total sales revenue 189,000 217,000 250,000 195,000 Number of jars sold 150,000 183,500 214,500 163,000 Prepare the production budget by first calculating the total units needed, then calculate the units to produce. Johnson Foods Production Budget For the Quarters in the Upcoming Year Quarter 1 Quarter 2 Quarter 3 Unit sales Plus: Desired ending inventory Total needed Less: Beginning inventory Units to produce Quarter 4 Year