Please provides steps to solve this question in EXCEL. Thank you.

E9-21A PREPARE A PRODUCTION BUDGET (Learning Objective 2) Ringer Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each quarter of the upcoming year are as follows: Check sum: Yearly units to produce is 717,500. Total sales revenue Number of jars sold 1st quarter. $180,000 150,000 2nd quarter. $216,000 180,000 3rd quarter. $252,000 210,000 $192,000 160,000 4th quarter.. Ringer anticipates selling 220,000 jars, with total sales revenue of $264,000, in the first quarter of the year following the year given in the preceding table. Ringer has a policy that the ending inventory of jars must be 25% of the following quarter's sales. Prepare a production budget for the year that shows the number of jars to be produced each quarter and for the year in total