{"id":32243,"date":"2026-06-22T15:05:29","date_gmt":"2026-06-22T15:05:29","guid":{"rendered":"https:\/\/academicwritersbay.com\/solutions\/the-weinberger-electronics-company-manufactures-four-highly-technical-products-that-it-offers-to-aerospace-firms-that-preserve-nasa-contracts-every-of-the-products-must-pass-thru-the-following-depart\/"},"modified":"2026-06-22T15:05:29","modified_gmt":"2026-06-22T15:05:29","slug":"the-weinberger-electronics-company-manufactures-four-highly-technical-products-that-it-offers-to-aerospace-firms-that-preserve-nasa-contracts-every-of-the-products-must-pass-thru-the-following-depart","status":"publish","type":"post","link":"https:\/\/academicwritersbay.com\/solutions\/the-weinberger-electronics-company-manufactures-four-highly-technical-products-that-it-offers-to-aerospace-firms-that-preserve-nasa-contracts-every-of-the-products-must-pass-thru-the-following-depart\/","title":{"rendered":"The Weinberger Electronics Company manufactures four highly technical products that it offers to aerospace firms that preserve NASA contracts. Every of the products must pass thru the following departments sooner than being shipped: wiring"},"content":{"rendered":"<p><strong>MSDA 628 Provide Chain Business Analytics<\/strong><\/p>\n<p><strong>Module 1 Assignment<\/strong><\/p>\n<p><strong><u>Total requirement<\/u><\/strong><\/p>\n<ul>\n<li>Make certain that every train\/sub-train is by itself worksheet. <\/li>\n<li>Your Excel model must be executable. In case your excel model is ran, it can presumably also aloof generate the identical results you put up. That means the spreadsheet has trusty embedded formulae and Solver dialog packing containers rating the total inputs. If \u2018Clear up\u2019 is clicked and your spreadsheet does not fabricate the reported results, a nil salvage shall be assigned to that train.<\/li>\n<li>Title the Excel file as \u201cHomework 1_Last Title.xlsx\u201d.<\/li>\n<li>Please contact the trainer whereas you happen to could per chance presumably rating got any questions regarding the assignment.<\/li>\n<\/ul>\n<p><strong>Notify of affairs 1<\/strong><\/p>\n<p>The Weinberger Electronics Company manufactures four highly technical products that it offers to aerospace firms that preserve NASA contracts. Every of the products must pass thru the following departments sooner than being shipped: wiring, drilling, meeting, and inspection. The time requirement in hours for every unit produced and its corresponding profit tag are summarized in the following table:<\/p>\n<p> <!--kg-card-begin: html--> <\/p>\n<table style=\"border:none;border-collapse:collapse;\">\n<colgroup>\n<col width=\"131\">\n<col width=\"65\">\n<col width=\"65\">\n<col width=\"65\">\n<col width=\"65\"><\/colgroup>\n<tbody>\n<tr style=\"height:25.2pt\">\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\"> <\/span><\/p>\n<\/td>\n<td colspan=\"4\" style=\"border-bottom:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">PRODUCT<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:21.05pt\">\n<td style=\"border-right:solid #000000 0.5pt;border-bottom:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">DEPARTMENT<\/span><\/p>\n<\/td>\n<td style=\"border-left:solid #000000 0.5pt;border-bottom:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">XJ201<\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">XM897<\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">TR29<\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">BR788<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:16.1pt\">\n<td style=\"border-right:solid #000000 0.5pt;border-top:solid #000000 1pt;vertical-align:bottom;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Wiring<\/span><\/p>\n<\/td>\n<td style=\"border-left:solid #000000 0.5pt;border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">0.5<\/span><\/p>\n<\/td>\n<td style=\"border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">1.5<\/span><\/p>\n<\/td>\n<td style=\"border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">1.5<\/span><\/p>\n<\/td>\n<td style=\"border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">1.0<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:16.1pt\">\n<td style=\"border-right:solid #000000 0.5pt;vertical-align:bottom;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Drilling<\/span><\/p>\n<\/td>\n<td style=\"border-left:solid #000000 0.5pt;vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">0.3<\/span><\/p>\n<\/td>\n<td style=\"vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">1.0<\/span><\/p>\n<\/td>\n<td style=\"vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">2.0<\/span><\/p>\n<\/td>\n<td style=\"vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">3.0<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:14.95pt\">\n<td style=\"border-right:solid #000000 0.5pt;vertical-align:bottom;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Meeting<\/span><\/p>\n<\/td>\n<td style=\"border-left:solid #000000 0.5pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">0.2<\/span><\/p>\n<\/td>\n<td style=\"vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">4.0<\/span><\/p>\n<\/td>\n<td style=\"vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">1.0<\/span><\/p>\n<\/td>\n<td style=\"vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">2.0<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:14.95pt\">\n<td style=\"border-right:solid #000000 0.5pt;border-bottom:solid #000000 1pt;vertical-align:bottom;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Inspection<\/span><\/p>\n<\/td>\n<td style=\"border-left:solid #000000 0.5pt;border-bottom:solid #000000 1pt;vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">0.5<\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">1.0<\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">0.5<\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">0.5<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:22.75pt\">\n<td style=\"border-right:solid #000000 0.5pt;border-bottom:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:bottom;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Unit Revenue ($)<\/span><\/p>\n<\/td>\n<td style=\"border-left:solid #000000 0.5pt;border-bottom:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:bottom;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">9.0<\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:bottom;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">12.0<\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:bottom;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">10.0<\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:bottom;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">8.0<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p> <!--kg-card-end: html--> <\/p>\n<p>The production available in every department every month and the minimal monthly production requirement to fulfill contracts are as follows:<\/p>\n<p> <!--kg-card-begin: html--> <\/p>\n<table style=\"border:none;border-collapse:collapse;\">\n<colgroup>\n<col width=\"128\">\n<col width=\"99\">\n<col width=\"94\">\n<col width=\"124\"><\/colgroup>\n<tbody>\n<tr style=\"height:43.2pt\">\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">DEPARTMENT<\/span><\/p>\n<\/td>\n<td style=\"border-right:solid #000000 0.5pt;border-bottom:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">CAPACITY (HOURS)<\/span><\/p>\n<\/td>\n<td style=\"border-left:solid #000000 0.5pt;border-bottom:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">PRODUCT<\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">MINIMUM PRODUCTION LEVEL<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:17.75pt\">\n<td style=\"border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Wiring<\/span><\/p>\n<\/td>\n<td style=\"border-right:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">15,000<\/span><\/p>\n<\/td>\n<td style=\"border-left:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">XJ201<\/span><\/p>\n<\/td>\n<td style=\"border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">150<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:17.75pt\">\n<td style=\"vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Drilling<\/span><\/p>\n<\/td>\n<td style=\"border-right:solid #000000 1pt;vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">17,000<\/span><\/p>\n<\/td>\n<td style=\"border-left:solid #000000 1pt;vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">XM897<\/span><\/p>\n<\/td>\n<td style=\"vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">100<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:17.75pt\">\n<td style=\"vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Meeting<\/span><\/p>\n<\/td>\n<td style=\"border-right:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">26,000<\/span><\/p>\n<\/td>\n<td style=\"border-left:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">TR29<\/span><\/p>\n<\/td>\n<td style=\"vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">300<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:17.75pt\">\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Inspection<\/span><\/p>\n<\/td>\n<td style=\"border-right:solid #000000 1pt;border-bottom:solid #000000 1pt;vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">12,000<\/span><\/p>\n<\/td>\n<td style=\"border-left:solid #000000 1pt;border-bottom:solid #000000 1pt;vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">BR788<\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">400<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p> <!--kg-card-end: html--> <\/p>\n<p>The production manager has the accountability of specifying production ranges for every product for the approaching month. Use Excel spreadsheet to solve Weinberger\u2019s profit-maximization train the usage of LP.<\/p>\n<p><strong>Notify of affairs 2<\/strong><\/p>\n<p>A unexpected amplify in the build a matter to for smoke detectors has left Hanson Alarms with insufficient ability to meet build a matter to. The firm has viewed its monthly build a matter to for electronic and battery-powered smoke detectors rise to 27,500 and 14,450, respectively. Tommy Hanson, the CEO of Hanson Alarms, has told his COO Julia Hanson that the firm must constantly meet build a matter to for its products. Hanson\u2019s production course of entails three departments: fabrication, meeting, and shipping. The knowledge for production and costs is summarized below.  <\/p>\n<p> <!--kg-card-begin: html--> <\/p>\n<table style=\"border:none;border-collapse:collapse;\">\n<colgroup>\n<col width=\"150\">\n<col width=\"150\">\n<col width=\"156\">\n<col width=\"144\"><\/colgroup>\n<tbody>\n<tr style=\"height:40.45pt\">\n<td style=\"border-bottom:solid #000000 1pt;border-top:solid #000000 0.5pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:Calibri,sans-serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\"> <\/span><\/p>\n<\/td>\n<td colspan=\"2\" style=\"border-bottom:solid #000000 1pt;border-top:solid #000000 0.5pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Hours required to present 1 unit<\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;border-top:solid #000000 0.5pt;vertical-align:bottom;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:11pt;font-family:'Aptos Narrow';color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\"> <\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:33.65pt\">\n<td style=\"border-bottom:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">DEPARTMENT<\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Electronic powered<\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Battery powered <\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;border-top:solid #000000 1pt;vertical-align:middle;background-color:#a8d08d;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Month-to-month Hours On hand <\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:17.75pt\">\n<td style=\"border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Fabrication <\/span><\/p>\n<\/td>\n<td style=\"border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">0.20 <\/span><\/p>\n<\/td>\n<td style=\"border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">0.13 <\/span><\/p>\n<\/td>\n<td style=\"border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">2,500 <\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:17.75pt\">\n<td style=\"vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Meeting <\/span><\/p>\n<\/td>\n<td style=\"vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">0.25 <\/span><\/p>\n<\/td>\n<td style=\"vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">0.22 <\/span><\/p>\n<\/td>\n<td style=\"vertical-align:middle;background-color:#daf2d0;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">4,470 <\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:17.75pt\">\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Shipping <\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">0.15 <\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">0.18 <\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">3,200 <\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height:17.75pt\">\n<td style=\"border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Variable price\/unit <\/span><\/p>\n<\/td>\n<td style=\"border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">$18.80 <\/span><\/p>\n<\/td>\n<td style=\"border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">$16.00 <\/span><\/p>\n<\/td>\n<td style=\"border-top:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\"><\/td>\n<\/tr>\n<tr style=\"height:17.75pt\">\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Retail tag <\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">$32.50 <\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">$31.60 <\/span><\/p>\n<\/td>\n<td style=\"border-bottom:solid #000000 1pt;vertical-align:middle;padding:0pt 5.75pt 0pt 5.75pt;overflow:hidden;overflow-wrap:break-word;\">\n<p dir=\"ltr\" style=\"line-height:1.2;text-align: center;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:'Times New Roman',serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\"> <\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p> <!--kg-card-end: html--> <\/p>\n<p>The firm additionally has the probability to carry out extra items from a subcontractor, The ChrisJones Company, who has equipped to present up to 25,000 items per month in any aggregate of electronic and battery-powered items, at a price of $22.75 per unit. For this tag, ChrisJones will meeting, test, and ship its items straight to the distributors with out the usage of Hanson\u2019s production course of. Use Excel spreadsheet to uncover the optimum portions to originate and\/or buy that can maximize profit. <\/p>\n<p>(<strong>Hint<\/strong>: For making or shopping for a product, Unit profit = Unit retail tag \u2013 Unit Mark)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MSDA 628 Provide Chain Business Analytics Module 1 Assignment Total requirement Make certain that every train\/sub-train is by itself worksheet. Your Excel model must be executable. In case your excel model is ran, it can presumably also aloof generate the identical results you put up. That means the spreadsheet has trusty embedded formulae and Solver [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-32243","post","type-post","status-publish","format-standard","hentry","category-solutions"],"_links":{"self":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/32243","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/comments?post=32243"}],"version-history":[{"count":0,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/32243\/revisions"}],"wp:attachment":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/media?parent=32243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/categories?post=32243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/tags?post=32243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}