I am struggling with the Direct Materials budget tab as a whole and...

I am struggling with the Direct Materials budget tab as a whole and I want to make sure that the orange column is correct on the production tab as well. I have included the images in order. The first screenshot is the budget data given to me and the remaining 3 slides are ones that I have completed on my own.

  

 

 

Transcribed Image Text:

Production Information: Raw Materials (per unit): Fabric (Yards) Zippers/Rivets (Sets) Embroidery Thread (Yards) BBJ EBJ JBJ RM Cost/Unit 3 3.25 3.5 $6.00 per yard 1 1 1 $1.25 per set 3 27 3 $0.03 per yard Embellishments (Sets) 0 0 1 $8.00 per set Payables Information: 40% of direct materials are paid in the quarter of sale 60% are paid in the following quarter Direct Labor (per unit): Time in Minutes BBJ EBJ JBJ DL Cost/Hour Cutting 11 12 14 $18.00 Embroidery 5 7 9 $22.00 Embellishing 0 0 19 $26.00 Assembly 6 8 8 $15.00 Overhead: Applied on the basis of Machine Hours Cutting time in minutes Assembly time in minutes Inventory to keep on hand: Finished goods: Raw Materials: BBJ EBJ JBJ 8 9 13 5 10 8 15% of next quarter's sales projection 25% of next quarter's production requirements Production Information: Raw Materials (per unit): Fabric (Yards) Zippers/Rivets (Sets) Embroidery Thread (Yards) BBJ EBJ JBJ RM Cost/Unit 3 3.25 3.5 $6.00 per yard 1 1 1 $1.25 per set 3 27 3 $0.03 per yard Embellishments (Sets) 0 0 1 $8.00 per set Payables Information: 40% of direct materials are paid in the quarter of sale 60% are paid in the following quarter Direct Labor (per unit): Time in Minutes BBJ EBJ JBJ DL Cost/Hour Cutting 11 12 14 $18.00 Embroidery 5 7 9 $22.00 Embellishing 0 0 19 $26.00 Assembly 6 8 8 $15.00 Overhead: Applied on the basis of Machine Hours Cutting time in minutes Assembly time in minutes Inventory to keep on hand: Finished goods: Raw Materials: BBJ EBJ JBJ 8 9 13 5 10 8 15% of next quarter's sales projection 25% of next quarter's production requirements