Please use excel formulas. And please show how you got the answers (-:

The Master Budget Production Budget Hoffman 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 revenue Number of jars sold $181,000 1st quarter 2nd quarter 152,500 $219,000 181,500 3rd quarter 4th quarter $255,000 213,000 $199,000 160,500 Hoffman anticipates selling the following in the first quarter of the year following the year given in the preceding table: Sales in units (jars) 223,000 Sales revenue $260,000 Hoffman has a policy that the ending inventory of jars must be: 30% of the following quarter's sales (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong. Use cell references from prior calculations, if applicable.) Hoffman Foods Production Budget For the Upcoming Year Quarter 2 Quarter 3 Quarter 1 Quarter 4 Year Unit sales BPlus: Desired ending inventory Total needed -0 Less: Beginning inventory 1 Number of units to produce 2 3 4 6