80.2K

Verified Solution

Link Copied!

BUSINESS ANALYTICS

Roedel Electronics produces tablet computer accessories, including integrated keyboard tablet stands that connect a keyboard to a tablet device and holds the device at a preferred angle for easy viewing and typing. Roedel produces two sizes of integrated keyboard tablet stands, small and large. Each size uses the same keyboard attachment, but the stand consists of two different pieces, a top flap and a vertical stand that differ by size. Thus, a completed integrated keyboard tablet stand consists of three subassemblies that are manufactured by Roedel: a keyboard, a top flap, and a vertical stand.

USING EXCEL please answer parts A and B

Poedel Electronics produces tablet computer accessories, induding integrated knyboord tablet stands that connect a keyboard to a tablet device asd holds the device at a preferred anglo for casy viewing and typing. Roedel produces two sizes of integroted koyboard tablet stands, smoll and large, Each size uses the same keyboard attactment, but the stand consists of two efrerent pleces, a stand. season. Betause only 500 hours of in-house manufacturing time are availatle, foedel is consibering purchasing some, or all, of the subassemblios from outside suppliers. If Roedel marufatures a subassembiy in-house, it incurs a foxed setup cost as weil as a variable manufacturing cost. The following tabie shows the setup cost, the manufacturing time per subassamely, the manufacturing cost per subassembly, and the cost to purchase each of the subastemplies fron an outude swpplier. \begin{tabular}{|c|c|c|c|c|} \hline Subassembly & \begin{tabular}{l} Setup \\ Cost (5) \end{tabular} & \begin{tabular}{l} Manufacturing \\ Time per Unit (min.) \end{tabular} & \begin{tabular}{l} Manufacturing \\ Cost per Unit (\$) \end{tabular} & \begin{tabular}{l} Purchase Cost \\ per Unit (s) \end{tabular} \\ \hline Keypoard & 1,060 & 0.9 & 0,40 & 0.65 \\ \hline Small too flap & 1,200 & 2.2 & 2.90 & 3.45 \\ \hline Large tos flap & 1,900 & 3.0 & 2.15 & 2.70 \\ \hline Small vertical stand & 1,500 & 0.8 & 0.30 & Q.50 \\ \hline Large vertical sand & 1,500 & 1.0 & ass & 0.70 \\ \hline \end{tabular} manutactured by Roedel, and let y, be the number sulbassenoles i purchased from sutside suppliers, foc i=1,5 ) (x1,x2,x2,x4x5y1,x2,y2,y4,y5)=(,x) What is the total manufacturing ard purchne cont (in doliars) assocanes wth vour recommendation? $52500 1=1,,3. .)

Answer & Explanation Solved by verified expert

See Answer