Northeastern University Production and Selling Simulation Research Report 4. You are given the attached process (Excel file) and asked to:a. Figure out how

Northeastern University Production and Selling Simulation Research Report 4. You are given the attached process (Excel file) and asked to:a. Figure out how much to sell the product for (using your company’s 40% minimum profit margin on sales rate). Show all your work (you may do this in Excel if it’s easier for you).b. Suggest some possible process improvements which could increase the profit to 50% or higher…..can you suggest some ideas to achieve this? You can increase up to 4 yields by 10%. Show all your work (you may do this in Excel if it’s easier for you). 20191205061348get1100_exam_1_problem_4_f19
LABOR
OPERATION
Assembly Step 1
Assembly Step 2
Assembly Step 3
Inspection
Assembly Step 4
Inspection
Test
Ship
OPERATOR
Assembler
Assembler
Assembler
QA
Assembler
QA
Test Technician
Shipping Clerk
UNITS TO SHIP
TOTAL YIELD
MATERIAL
YIELD
# OF UNITS
85.0%
80.0%
80.0%
75.0%
70.0%
95.0%
90.0%
100.0%
Components
Required
LOT SIZE
60
60
60
60
60
60
60
60
LOTS
HOURS
PER LOT
TOTAL
HOURS
$
$
$
$
OVERHEAD
340%
TOTAL COST
RAW
COST
OVERHEAD
6%
TOTAL COST
6.00
5.00
4.00
1.00
8.00
1.00
3.00
0.50
Component
Cost
Material 1
Material 2
Material 3
Material 4
RAW
COST
1.60
2.35
1.05
1.90
Totals
LABOR
LABOR OH
340%
MATERIAL
MATERIAL OH
6%
TOTAL LABOR, MATERIAL, AND OVERHEAD
GENERAL & ADMINISTRATIVE
30%
RATES
$
Assembler
16.00
TOTAL COST
QA
$ –
Test
Technician
$
18.00
Shipping
Clerk
$ 15.00
PROFIT (ON SELL PRICE)
40%
TOTALREVENUE
UNIT PRICE

Purchase answer to see full
attachment