4. Below in Appendix A is a highly simplified bill of materials for a hypothetical robotic assembly, & each has been assigned an estimated lead time, BOM quantity for this pretend robot, and a unit cost (assume 1 ea per unit cost for simplicity purposes). Demand for this product (finished good) is as follows:

2024
Jan	Feb	Mar	April	May	Jun	July	Aug	Sept	Oct	Nov	Dec
2	7	5	5	5	5	6	6	7	11	8	4

Pleaseorganizeintoasupplyplanasyouseefit(Excelisfine),andprovideresponsestothefollowing:

1. Whatsafetystockwouldyourecommendforeachcomponent iftotalproductiontimetakes 7 business days, and taking into account parts cost?Hint: you're free to propose your own reasonable monthly inventory budget for this example.
2. Whatwouldthebusiness's2023inventorycostbeinthishypotheticalexample?
3. Whatwouldthebusiness's2024inventorycostbe,broken-downbymonth?
4. Please compile a "supply plan of record" for a hypothetical business update in which your audience wants to see demand volumes, production volumes, and inventory (assume finished goods sales were 1 unit less than the demand forecast for each month from January- June,and1moreunitthandemandeachmonthforJuly-Dec).Thisshouldbeagraphthat gives a visual for a senior leadership audience.

AppendixA:

Controlsystem:

Microcontroller:ArduinoMega2560(3months,$48.40/ea,BOM:6) Motor drivers: L298N H-bridge (6 weeks, $15.83/ea, BOM: 6)

Powersupply:

12V10Aswitchingpowersupply(1week,$22.65/ea,BOM:2)

Mechanicalstructure:

6061-T6extrudedAlum.,500mmlength(1weekrawmaterial,1weekmachiningtime,$1,573/ea,BOM:1) Complex 440C machined component (2 weeks raw material, 3 weeks machining time, $3,650/ea, BOM: 2) 360 degree rotary joints with bearings (15 days, $12.49/ea, BOM: 12)

Screws:

M3x10mmsocketheadcapscrews,blackoxidefinish(3days,$8.60/ea,BOM:36) Bolts: M4x20mm hex head bolts, black oxide finish (3 days, $7.21/ea, BOM 38)

Electricmotors:

NEMA17steppermotors,1.8degreestepangle,2.8A/phase(1week,$291.84/ea,BOM:6) Gearboxes: planetary gearboxes, 20:1 reduction ratio (1 week, $41.91/ea, BOM: 6)

Encoders:

quadratureencoders,1024CPR(2weeks,$42.67/ea,BOM:6)

Limitswitches:micro-limitswitches,SPST-NO(7weeks,$36.47/ea,BOM:2) load cell, 50kg capacity (4 weeks, $53.38/ea, BOM: 4)

Gripper:

Pneumaticcylinder:double-actingcylinder,25mmbore,50mmstroke(1week,$92.00/ea,BOM:2) Vacuum pump:

12VDCvacuumpump,10L/minflowrate(1week,$18.95/ea,BOM:1) Wiring:

Electricalcables:22AWGstrandedwire,variouslengths(2days,$2.89/ea,BOM:15) Connectors:

JSTconnectors,crimpstyle(2days,$0.89/ea,BOM: 36)