Step 1: Use the V look-up function and the part number given, complete costs per unit for the respective types of computers. For reference on how to write Vlookup function, please see link at Vlookup Function from MS Excel (Hint: you may also want to use an absolute reference to lock the range referenced in the vlook up function).
Step 2: Calculate the overhead cost per direct labor hour based on the overhead cost shown in the Inventory Master File. The estimated direct labor hours for the year will be provided. Use that information and the direct labor rate per hour to finish calculating the total cost each of the products. Feel free to add column as needed (for example, you should add a column called Total cost)
Step 3: Calculate the total material cost and total cost per a computer unit.
Best Computer Company Premium Desktop Gaming Compter Product Cost Unit of Units Total Product Cost Cost per Component 152 Measure ea Required 1.00 1.00 1.00 ea 272 ea Part Number 00100 00600 00800 00300 00500 00400 00700 00900 ea 1.00 424 152 157 ea 1.00 Description Coursair Obsidian 7500 CC ATX Full Tower Computer Case ASUS AMD AM4 ROG Strix Gaming ATX Motherboard AMD Ryzen 9 3900X 12 Core 3.8 GHz Processor Corsair Hydro Series H150i PRO 240mm Water/liquid CPU Cooler G.SKILL TridentZ RGB Series 32GB SDRAM DDR4 3600 Nvidia GeForce RTC 2080 Ti Graph Card 11GB Corsair RMx Series RM850x 850 Watt Power Source Crucial MX500 2TB SATA III Internal Solid State Drive Total Materials Direct Labor Overhead Total Cost per Unit ea 1000 1.00 1.00 ea 120 408 ea 1.00 hr 10100 10200 00200 3.00 3.00 20 11 hr Best Computer Company Premium Descktop Computer- Power Users Unit of Measure Units Required 1.00 Cost per Component 152 ea ea Part Number 00100 00610 00820 00510 00410 00700 00910 1.00 1.00 180 408 ea ea 80 1.00 1.00 ea 400 Description Coursair Obsidian 7500 CC ATX Full Tower Computer Case ASUS AM4 TUF Gaming X57--Plus ATX Motherboard with PCle 4.0 AMD Ryzen 7 3800X 8-Core 3.9 GHZ Processor w/Corsair Hydro water cooler G.SKILL TridentZ RGB Series 16GB SDRAM DDR4 3200 Nvidia GeForce GTX 970 Graphic Card 4 GB Corsair RMx Series RM850x 850 Watt Power Source Crucial MX500 2TB SATA III Solid State Drive Total Materials Direct Labor Overhead Total Cost per Unit ea 120 2.00 1.00 ea 192 hr 2.00 20 10100 10200 00210 hr 2.00 11 Best Computer Company Premium Desktop Gaming Compter Product Cost Unit of Units Total Product Cost Cost per Component 152 Measure ea Required 1.00 1.00 1.00 ea 272 ea Part Number 00100 00600 00800 00300 00500 00400 00700 00900 ea 1.00 424 152 157 ea 1.00 Description Coursair Obsidian 7500 CC ATX Full Tower Computer Case ASUS AMD AM4 ROG Strix Gaming ATX Motherboard AMD Ryzen 9 3900X 12 Core 3.8 GHz Processor Corsair Hydro Series H150i PRO 240mm Water/liquid CPU Cooler G.SKILL TridentZ RGB Series 32GB SDRAM DDR4 3600 Nvidia GeForce RTC 2080 Ti Graph Card 11GB Corsair RMx Series RM850x 850 Watt Power Source Crucial MX500 2TB SATA III Internal Solid State Drive Total Materials Direct Labor Overhead Total Cost per Unit ea 1000 1.00 1.00 ea 120 408 ea 1.00 hr 10100 10200 00200 3.00 3.00 20 11 hr Best Computer Company Premium Descktop Computer- Power Users Unit of Measure Units Required 1.00 Cost per Component 152 ea ea Part Number 00100 00610 00820 00510 00410 00700 00910 1.00 1.00 180 408 ea ea 80 1.00 1.00 ea 400 Description Coursair Obsidian 7500 CC ATX Full Tower Computer Case ASUS AM4 TUF Gaming X57--Plus ATX Motherboard with PCle 4.0 AMD Ryzen 7 3800X 8-Core 3.9 GHZ Processor w/Corsair Hydro water cooler G.SKILL TridentZ RGB Series 16GB SDRAM DDR4 3200 Nvidia GeForce GTX 970 Graphic Card 4 GB Corsair RMx Series RM850x 850 Watt Power Source Crucial MX500 2TB SATA III Solid State Drive Total Materials Direct Labor Overhead Total Cost per Unit ea 120 2.00 1.00 ea 192 hr 2.00 20 10100 10200 00210 hr 2.00 11
