Part $1$: Create a spreadsheet template that calculates the following from inputs of cutting speed, feed per tooth, number of teeth $(1$ if turning$),$ tool $($milling$)$ or part $($turning$)$ diameter, and radial and$/$or axial depth of cut $(50$ points$)$:

$-$ RPM

$-$ Feed rate

$-$ MRR $($include inputs for radial and axial DOC$)$

$-$ HP at tool

$-$ HP of spindle$/$motor $($assume $\backslash (90\backslash \%\backslash )$ efficiency$)$

$-$ Time to perform turning operations

Part $2$: Speeds, Feeds, Time, and Power $(50$ points$)$:

Background: Bottom bracket $($BB$)$ shells $($figures $1$ and $2)$ are a key component of bike frames and are relatively easy to make, depending on the base material$-$aluminum is very easy to machine, but other materials such as titanium $($strong and light$)$ or stainless steel $($durable$)$ are very hard to machine and take more time to produce.

Assignment: Determine differences in machining $($turning$)$ requirements$-$calculate RPM$,$ Feed Rate, Power Consumption, and Tuming Time for the component shown in figure $3(\backslash (\backslash$mathrm$\{$L$\}=98\backslash$mathrm$\{$~mm$\}\backslash ),\backslash (\backslash$mathrm$\{$ID$\}=47\backslash$mathrm$\{$~mm$\},\backslash$mathrm$\{$OD$\}=54\backslash$mathrm$\{$~mm$\}\backslash )).$ Assume $1$ mm max depth of cut and a finish pass of $\mathrm{.}25$ mm at $\backslash (75\backslash \%\backslash )$ of the roughing feed rate and starting stock of $2\mathrm{.}25$ in OD and $1\mathrm{.}75$ in ID$.$ Use the spreadsheet developed in part $1$:

Tabie $1.$ Spuds and Fuds Data