Finance has asked for a preliminary report on how much capital will be needed to purchase the units needed to complete these orders. Using the MRP matrices and the notes provided, calculate the capital costs per period and total for the quarter associated with the schedule you have constructed. There are no capital costs for finished samplers. Inventory holding costs are approximately the same for each lower level item and run about $0.50 per unit per period. There are no inventory costs for the final samplers themselves. Jody also needs to estimate the costs incurred from holding inventory over the quarter.

Item Master File Item On Hand Lead Time Lot Size Scheduled Receipts Unit Manufacturing /Purchasing Cost $6.00 9 2 1 0 15 1 1 $6.00 0 250 1 10 $1.00 0 301 2 75 $1.00 0 Northwest Grunge Sampler Deep South Hooch Sampler Walla Walla Mud Mt. Hood Dredge Tacoma Terror Tuscaloosa Tornado Meridian Mothball Augusta Augsbarge Labels Boxes 350 40 $0.50 0 15 1 $0.50 0 250 2 20 $0.50 0 5 1 40 $0.50 0 257 611 2 2 100 91 $0.01 $0.10 0 0 Finance has asked for a preliminary report on how much capital will be needed to purchase the units needed to complete these orders. Using the MRP matrices and the notes provided, calculate the capital costs per period and total for the quarter associated with the schedule you have constructed. There are no capital costs for finished samplers. Inventory holding costs are approximately the same for each lower level item and run about $0.50 per unit per period. There are no inventory costs for the final samplers themselves. Jody also needs to estimate the costs incurred from holding inventory over the quarter. Period LLC: 0 LT: 1 PD 2 3 4 5 6 8 9 10 11 12 Item: Deep South Lot size: 1 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases 0 0 0 0 0 0 0 0 0 0 0 0 0 D 0 0 0 0 0 0 0 0 0 0 01 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Subcontract $0.00 Period LLC: 1 LT: 1 PD 2 4 6 9 3 0 5 0 7 01 8 0 10 0 11 0 12 0 0 D 0 0 0 0 0 Item: Agusta Aug Lot size: 40 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases Capital Costs Expediting Cost 0 0 0 0 0 0 0 0 0 D 0 01 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 D 0 0 0 $0.00 0 $0.00 0 0 $0.00 0 S0.00 $0.00 $0.00 $0.00 S0.00 $0.00 $0.00 Period LLC: 1 LT:2 PD 4 2 0 3 0 5 0 6 6 0 7 0 8 0 9 0 10 0 11 0 12 0 0 0 0 0 0 0 0 0 0 Item: Mer. Mb Lot size: 20 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases Capital Costs Expediting Cost 0 0 0 0 0 D 0 0 0 0 0 0 0 0 0 $0.00 01 0 0 0 01 0 0 0 0 $0.00 0 0 0 $0.00 0 0 0 0 0 $0.00 0 0 $0.00 0 0 0 $0.00 0 $0.00 0 $0.00 0 0 S0.00 0 S0.00 $0.00 $0.00 $0.00 Period LLC: LT: 1 PD 2 3 41 4 91 10 11 1 0 5 0 6 0 7 0 8 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Item: T Tornado Lot size: 1 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases Capital Costs Expediting Cost 0 0 0 0 0 0 0 0 D 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 S0.00 0 0 $0.00 0 0 $0.00 0 0 $0.00 0 0 S0.00 0 0 $0.00 0 0 S0.00 0 $0.00 0 0 $0.00 0 0 S0.00 0 0 $0.00 $0.00 Period PD 21 4 5 6 7 8 9 10 11 12 Item: Grunge LLC: 0 Lot size: 1 LT: 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases 0 0 D 0 0 0 0 0 D 0 0 0 0 0 D 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Subcontract $0.00 Period PD 1 6 7 81 9 2 0 3 0 4 0 5 0 10 0 11 0 12 0 0 0 0 0 0 0 D 0 0 0 3 Item: WW Mud LLC: 1 Lot size: 10 LT: 1 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases Capital Costs - Expediting Cost 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 $0.00 0 S0.00 $0.00 $0.00 S0.00 S0.00 S0.00 S0.00 S0.00 $0.00 Period PD 1 $ 9 12 2 D 3 3 D 4 0 6 0 7 ol 8 0 10 0 11 0 D D 0 0 0 0 0 0 0 0 0 0 0 0 0 Item: Mt Dredge LLC: 1 Lot size: 75 LT: 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order recipts Planned order releases Capital Costs Expediting Cost 0 0 0 0 0 0 0 0 01 0 U 0 0 0 0 0 0 D 0 0 0 0 0 D $0,00 0 0 D $0.00 0 D 0 0 0 S0.00 D $0.00 0 D 50,00 $0.00 S0.00 0.00 0.00 S0.00 ).00 50.00 $0.00 Period PI) 3 6 7 1 0 2 0 4 0 5 0 8 0 9 0 10 0 11 0 12 0 0 0 0 0 0 0 0 0 0 0 0 Item: T Terror LLC: 1 Lot size: 40 LT: 1 Gross requirements Scheduled receipts Projected on hand Nct requirements Planned order receipts Planned order releases Capital Costs Expediting Cost 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D D $0.00 0 0 0 D 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 S0.00 D $0.00 0 0 S0.00 0 S0.00 $0.00 S0.00 50.00 50.00 50.00 S0.00 $0.00 Item Master File Item On Hand Lead Time Lot Size Scheduled Receipts Unit Manufacturing /Purchasing Cost $6.00 9 2 1 0 15 1 1 $6.00 0 250 1 10 $1.00 0 301 2 75 $1.00 0 Northwest Grunge Sampler Deep South Hooch Sampler Walla Walla Mud Mt. Hood Dredge Tacoma Terror Tuscaloosa Tornado Meridian Mothball Augusta Augsbarge Labels Boxes 350 40 $0.50 0 15 1 $0.50 0 250 2 20 $0.50 0 5 1 40 $0.50 0 257 611 2 2 100 91 $0.01 $0.10 0 0 Finance has asked for a preliminary report on how much capital will be needed to purchase the units needed to complete these orders. Using the MRP matrices and the notes provided, calculate the capital costs per period and total for the quarter associated with the schedule you have constructed. There are no capital costs for finished samplers. Inventory holding costs are approximately the same for each lower level item and run about $0.50 per unit per period. There are no inventory costs for the final samplers themselves. Jody also needs to estimate the costs incurred from holding inventory over the quarter. Period LLC: 0 LT: 1 PD 2 3 4 5 6 8 9 10 11 12 Item: Deep South Lot size: 1 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases 0 0 0 0 0 0 0 0 0 0 0 0 0 D 0 0 0 0 0 0 0 0 0 0 01 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Subcontract $0.00 Period LLC: 1 LT: 1 PD 2 4 6 9 3 0 5 0 7 01 8 0 10 0 11 0 12 0 0 D 0 0 0 0 0 Item: Agusta Aug Lot size: 40 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases Capital Costs Expediting Cost 0 0 0 0 0 0 0 0 0 D 0 01 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 D 0 0 0 $0.00 0 $0.00 0 0 $0.00 0 S0.00 $0.00 $0.00 $0.00 S0.00 $0.00 $0.00 Period LLC: 1 LT:2 PD 4 2 0 3 0 5 0 6 6 0 7 0 8 0 9 0 10 0 11 0 12 0 0 0 0 0 0 0 0 0 0 Item: Mer. Mb Lot size: 20 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases Capital Costs Expediting Cost 0 0 0 0 0 D 0 0 0 0 0 0 0 0 0 $0.00 01 0 0 0 01 0 0 0 0 $0.00 0 0 0 $0.00 0 0 0 0 0 $0.00 0 0 $0.00 0 0 0 $0.00 0 $0.00 0 $0.00 0 0 S0.00 0 S0.00 $0.00 $0.00 $0.00 Period LLC: LT: 1 PD 2 3 41 4 91 10 11 1 0 5 0 6 0 7 0 8 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Item: T Tornado Lot size: 1 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases Capital Costs Expediting Cost 0 0 0 0 0 0 0 0 D 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 S0.00 0 0 $0.00 0 0 $0.00 0 0 $0.00 0 0 S0.00 0 0 $0.00 0 0 S0.00 0 $0.00 0 0 $0.00 0 0 S0.00 0 0 $0.00 $0.00 Period PD 21 4 5 6 7 8 9 10 11 12 Item: Grunge LLC: 0 Lot size: 1 LT: 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases 0 0 D 0 0 0 0 0 D 0 0 0 0 0 D 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Subcontract $0.00 Period PD 1 6 7 81 9 2 0 3 0 4 0 5 0 10 0 11 0 12 0 0 0 0 0 0 0 D 0 0 0 3 Item: WW Mud LLC: 1 Lot size: 10 LT: 1 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases Capital Costs - Expediting Cost 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 $0.00 0 S0.00 $0.00 $0.00 S0.00 S0.00 S0.00 S0.00 S0.00 $0.00 Period PD 1 $ 9 12 2 D 3 3 D 4 0 6 0 7 ol 8 0 10 0 11 0 D D 0 0 0 0 0 0 0 0 0 0 0 0 0 Item: Mt Dredge LLC: 1 Lot size: 75 LT: 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order recipts Planned order releases Capital Costs Expediting Cost 0 0 0 0 0 0 0 0 01 0 U 0 0 0 0 0 0 D 0 0 0 0 0 D $0,00 0 0 D $0.00 0 D 0 0 0 S0.00 D $0.00 0 D 50,00 $0.00 S0.00 0.00 0.00 S0.00 ).00 50.00 $0.00 Period PI) 3 6 7 1 0 2 0 4 0 5 0 8 0 9 0 10 0 11 0 12 0 0 0 0 0 0 0 0 0 0 0 0 Item: T Terror LLC: 1 Lot size: 40 LT: 1 Gross requirements Scheduled receipts Projected on hand Nct requirements Planned order receipts Planned order releases Capital Costs Expediting Cost 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D D $0.00 0 0 0 D 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 S0.00 D $0.00 0 0 S0.00 0 S0.00 $0.00 S0.00 50.00 50.00 50.00 S0.00 $0.00