1) Start with the May Blending Dept Cost Report. Fill in the information about units and percentages of completion in the May blue box. The blue box is the only place on the worksheet where you are allowed to type in numbers. FORMAT percentages as %, not as decimals. Use the % formatting icon on the Excel Ribbon (top bar of the screen)

2) Fill in the cost information in the May blue box. (Hint on finding information: Gather information from April's cost report and from the General Ledger). Format in DOLLARS and CENTS using the $ formatting icon on the ribbon. If you get a ######### it simply means your column is not wide enough (if so, drag and drop the cell line so that the cell is wider, or double click on the cell line next to the column letter to auto-size the column width.)

3) Use cell references and formulas to populate the production cost report. For example, in cell E4 you should type in the following reference: = B3. In cell E6 you should type in the following formula: = E4+E5. NOTE: DO NOT TYPE IN ANY NUMBERS. ALL CELLS SHOULD CONTAIN FORMULAS OR REFERENCES TO CELLS IN THE BLUE BOX.