Rough-cut capacity planning

Christmas is approaching and demand for teddy bears is booming. Santas elves must make some kind of rough-cut capacity plan in order to meet the demand. They are now producing three types of bears; little bears (A), medium-sized bears (B) and big bears (C). The master production schedule for teddy bears is the following:

Below in is the resource bill (in hours) for teddy bears, e.g. producing teddy bears requires above mentioned amount of work per bear.

Calculate the number of hours required in department (2) over the next 6 weeks. The number of hours for department (2) over the next 6 weeks is found by multiplying the labor hour requirement in department (2) for each product by the quantity of that product to be produced in each week and summing the hours required for all products in each week. Fill in to below table.

Week	1	2	3	4	5	6
Product A
Product B
Product C
Total hours

Return the excel file along with other assignments of this section, the total hours per week, e.g. hours required to produce A + B + C for.