Enter the data first and utilize cell formulas to complete the worksheet along with the answers to the 10 questions below the worksheet. Must use cell formulas on the worksheet and for the answers to the 10 questions.

Obj. 2, 3, 4 White Diamond Flour Company manufactures flour by a series of three processes, beginning with wheat grain being introduced in the Milling Department. From the Milling Department, the materials pass through the Sifting and Packaging departments, emerging as packaged refined flour. EXCEL TEMPLATE The balance in the account Work in ProcessSifting Department was as follows on July 1: Work in ProcessSifting Department (900 units,/scompleted): Direct materials (900 x $2.05) $1,845 Conversion (900x/sx $0.40) 216 $2,061 The following costs were charged to Work in ProcessSifting Department during July: Direct materials transferred from Milling Department: 15,700 units at $2.15 a unit Direct labor Factory overhead $33,755 4,420 2,708 During July, 15,500 units of flour were completed. Work in ProcessSifting Department on July 31 was 1,100 units, 4/5 completed. EQUIVALENT UNITS COST OF PRODUCTION ($) ACTUAL UNITS % (FRACTION COMPLETED THIS MONTH) EQUIVALENT UNITS BEGINNING VALUE MATERIALS PROCESSING BEGINNING INVENTORY 0 STARTED & COMPLETED 0 ENDING INVENTORY 0 0 0 0 0 0 MATERIAL COST PER UNIT PROCESSING COST PER UNIT Labor: Overhead: Total 0 1) Material Cost per unit? 2) Processing Cost per unit? 3) Total? and per unit cost of units S&C in a prior period and completed this period? 4) Total? and per unit cost of units S&C this period? 5) Total cost of W.I.P. Inventory at the end of period? 6) Total cost to be accounted for? 7) Total cost transferred out to Finished Goods? 8) Total units to be accounted for? 9) Equivalent units for materials? 10) Equivalent units for processing