Leave all cells with numbers to be entered with no fill but make all cells with

Question

Leave all cells with numbers to be entered with no fill but make all cells with calculations light grey. 1 Assignment 8 ENGR 3315 Fall 2017 Submitted by: Lee Hinkle (key) Cost Component Capacitor Resistor Units $ 0.10 each $ 0.01 each Numbers in white are to be entered Numbers in grey are calculated 6 Printed Circuit Board 0.30 /sq inch $0.25 each 2.75 each Transistor Integrated Circuit LED 0.15 each 10 Bill of Materials Capacitor Resistor |Printed Circuit Board Transistor Quantity Unit Cost Total 6 0.10 0.60 16 0.01 $ 0.16 15 0.30 $ 4.50 2 0.25 0.50 1 2.75 2.75 4 S 0.15 $ 0.60 Total Material: 9.11 12 13 14, 15 16 Integrated Circuit 17 18 19 LED 20 Manufacturing Cost 0.12 per part 21 Total Parts 22 Manufactuing Cost 5.28 23 Packaging & Shipping 3.00 24 Total Landed Cost s 17.39

Explanation / Answer

Following are the formulas used in the excel sheet

In the second table with the labels " Bill of Material", to have values in the column "Unit Cost" write the formula given below in the cell D12

=C4

Drag the same formula in the cell D13, D14, D15, D16 and D17

Then to have values in the column "Total", write the below formula in the cell E12

=C12*D12

Drag the same formula in the rest of the required cells.

To have value of "total Material", use the below formula

=SUM(E12:E17)

To get the value of "total parts" write the below formula

=SUM(C12:C17)

To get the value of "manufacturing Cost as $5.28" write the below formula

=C21*C20

To get the value of "Total Landed Cost as $17.39" write the below formula

=SUM(E18,C22,C23)

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.