Please use excel to create a replica, otherwise it will be incorrect.

Requirement

1. Prepare a production budget for the year that shows the number of jars to be produced each quarter and for the year in total.

A) Enter all amounts as positive values. DO NOT use parentheses or a minus-sign for amounts to be subtracted.

IMPORTANT

*ALWAYS USE CELL REFERENCES AND FORMULAS WHERE APPLICABLE TO RECEIVE CREDIT. USE CELL REFERENCES FROM PRIOR CALCULATIONS, IF APPLICABLE.*

PLEASE USE CELL REFERENCES TO FIND THE ANSWERS TO FILL IN THE BLUE BOXES, PLEASE SHOW HOW CELL REFERENCES ARE USED AND WHERE.

THANK YOU

Project Description: ca_braunma3e.e9.21a Steps to Perform: Ringer Foods produces sprecially soup sold in jars. The projected sales in dollars and jars for each guarter of the upcoming year are as follows: Ringer anticipates selling the following in the first quarter of the pear following the yeat given in the 2 precediratisis: Ringer has a policy that the endiry, inventory of jars must be: 25% of the tollowing quarter's sales Use the blue shaded areas on the ENTLRANSWERS tab for inputs. 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 20 applicable. Ringer anticipates selling the following 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 Use the blue shaded areas on the ENTERANSWERS tab tor inputs. 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. Requirement 1. Prepare a production budget for the year that shows the number of jars to be produced each quarter and for the year in total. a. Enter all amounts as positive values. Do NOT use parentheses or a minus sign for amounts to be subtracted. (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.)