Please help me fill out this excel worksheet. The instructions are provided in the word document, but the processing page needs to be filled out via spreadsheet.

Jackson's Vacuum company makes two types of vacuums: Basic and Advanced. The factory is set up into 3 working departments. Both vacuums utilize process \#1 to assemble the basic components. Those units destined as basic will transition to department \#2 to be finalized. The advanced vacuums will skip department #2 and go directly to the advanced processing department \#3. There are 4 types of raw material. \#1-3 are all direct materials and #4 is an indirect material Requested materials - Dept: \#1 $106,675 in raw material #1 was requested, $40,000 for #2,$195,000 for #3 Dept. \#2 $20,000 in raw material \#1 was requested, $15,484 for #2,$46,000 for \#3 Dept. \#3 * $74,000 in raw material \#1 was requested, $13,000 for #2,$172,238 for \#3 Indirect materials (#4) used this year amounted to $56,222 There are 3 type of factory workers. Assembly line, area supervisor, and repairman/maintenance. 1. Assembly line workers: a. 12 workers - each work 1,900 hours per year. b. 6 workers work in process 1 and earn $12/ hour. c. The other 6 workers work equally in departments 2&3 and make $16/ hour. 2. In total, there are 2 supervisors each paid $72,786 each and 2 repairman/maintenance each paid $40,000 Other factory overhead consists of the following: 1. Property taxes paid for the year $35,000 2. Utilities paid for the year- $148,897 3. Six large machines. Each with a value of $100,000 depreciated over 10 years. Two machines are used in each department. Factory overhead is allocated using the ABC method and based on machine setups and machine hours Factory Overhead. using machine hours = Fact. Dep. \& Indirect materials total Factory overhead using machine set ups = Property taxes, utilities and indirect labor total Department \#1 had 3,500 units in beginning WIP that were 50% complete as to conversion costs (totaling $12,000 ) and 100% complete for materials (totaling 42,000 ). 57,003 units were started into production. Transferred out 56,000 units which included 37,000 basic to WIP #2 and 19,000 advanced to WIP \#3. The remaining ending inventory was 100% complete for materials and 40% for conversion costs. Department #2 had 2,000 units in beginning WiP that were 50% complete as to conversion costs (totaling $3,000 ) and 100% complete for materials (totaling 10,000). 37,000 units were started into production. Transferred out 35,000 units. The remaining ending inventory was 100% complete for materials and 64% for conversion costs. Department \#3 had 1,000 units in beginning WIP that were 50% complete as to conversion costs (totaling $4,000 ) and 100\% complete for materials (totaling 13,000). 19,000 units were started into production. Transferred out 19,200 units. The remaining ending inventory was 100% complete for materials and 70% for conversion costs. Beginning finished goods for basic vacuums totaled 6,500 units at a total cost of $142,384 Beginning finished goods for advanced vacuums totaled 2,300 units at a total costs of $98,555 Total sales for the basic vacuum were 38,033 units @ \$55 each Total sales for the advanced vacuum were 19,800 units 9$87 each Instructions A. Prepare the following journal entries 1. Raw material purchases 2. Distribution of raw materials to each WIP or Factory.Overhead 3. Accumulation of wages owed 4. Distribution of wages to each WIP or Factory Overhead 5. Accumulation of factory overhead 6. Allocation of Factory overhead using ABC per WIP 7. Transition of WIP 1 goods to either WIP 2 or 3 8. Transition of WIP 2 goods to Finished Goods 9. Transition of WIP 3 goods to Finished Goods 10. Sale of Basic vacuums 11. Sale of Advanced vacuums B. What is the Gross Profit of each separately and combined? Hulne h11 Further breakdown of the Raw Material and Factory Labor T-Accounts GENERAL JOURNAL p. 1 * seip lines between transaction dates Date Transaction Sample Debit account credit account A1 "skip a ine between transactions" ABC Breakdown of Factory Overhead Total machine hours Total machine setugs WIP \pm 1 ABC Machine Hours FOH cost 55 for Machine hour items Percent used by WiP x cost ABC Machine Setups FOH cost $5 for Machine setup items Percent used by WIP x cost TOTAL Costs Machine hours Mestine setupes WIP in WIP \#1 WIP \pm 1 WIP n1 WIP 3 WIP \#2 WIP #2 WiP az WIP \#3 W 3 WiP A3 Total Total