B C D E F G H 1 A 1 The Master Budget 2 Production Budget 4 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: CO OU AWN Total sales revenue Number of jars sold 1st quarter $180,000 150,000 2nd quarter $216,000 180,000 9 3rd quarter $252,000 210,000 10 4th quarter $ 192,000 160,000 11 12 Ringer anticipates selling the following in the first quarter of the year following the year given in the preceding table: 13 Sales in units (jars) 220,000 14 $264.000 Sales revenue 15 16 Ringer has a policy that the ending inventory of jars must be: 17 25% of the following quarter's sales 18 19 Use the blue shaded areas for inputs 20 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 21 22 23 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. 5 points 24 (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked 25 26