can you answer this in excel with work shown please

A laptop manufacturer produces and sells two models: Model 1000 and Model 3000. The total standard labor hours required to produce one unit of Model 1000 is 7 hours and of Model 3000 is 11 hours. The assembly is done in 3 stages: picking, assembly, and testing. Average percentages of the labor hours for these three stages are 25%, 45% and 30% of the total. Note that these are the CPOF. Given the following production schedule for the next 6 weeks, calculate the weekly labor hours needed in each of the three work centers. Week 1 2 3 4 5 6 Model 1000 150 150 300 250 300 400 Model 3000 100 50 250 200 150 100