We describe a student-centered approach for the required business school management science course. We articulate three principles for teaching management science to business students: real-world ...context, spreadsheet-native attitude, and student self-efficacy. We examine the implications of these principles and how they affect course content and delivery. We show how to establish relevance as perceived by business students. We highlight the business analysis lifecycle as a valuable “roadmap” for students and instructors alike. We explain costs, benefits, and techniques for spreadsheet-native modeling. Spreadsheet modeling should be treated as a computer programming process, based on the properties of the spreadsheet programming language. We explain how and why to separate the modeling process from the act of typing into a spreadsheet. Spreadsheets can function as valuable organizational assets. We candidly discuss the challenges faced transitioning from a tools-based teaching approach to a student-centered approach.
Logistics optimization has significantly grown in popularity over the last few decades. Improvements in computing power, modeling software, and the willingness of companies to invest time in the ...modeling effort have allowed models that were once too unwieldy to solve to optimality to be solved quickly. This has led to a more wide‐spread recognition by logistics managers of the potential advantages of using optimization. The scope of logistics optimization in companies and organizations has expanded to address strategic, tactical, operational, and collaborative decision making. Spreadsheets, an analytical tool familiar to managers, have played a crucial role in the expanded modeling efforts of companies. Although optimization’s role in logistics has grown tremendously, there still are areas that remain to be explored that will allow it to achieve an even larger and more successful role in the management of companies. Additionally, there are some models that are still too large or too complex to currently solve to optimality, despite the advances in computing power and modeling/solving software.
Many mutations that contribute to the pathogenesis of acute myeloid leukemia (AML) are undefined. The relationships between patterns of mutations and epigenetic phenotypes are not yet clear.
We ...analyzed the genomes of 200 clinically annotated adult cases of de novo AML, using either whole-genome sequencing (50 cases) or whole-exome sequencing (150 cases), along with RNA and microRNA sequencing and DNA-methylation analysis.
AML genomes have fewer mutations than most other adult cancers, with an average of only 13 mutations found in genes. Of these, an average of 5 are in genes that are recurrently mutated in AML. A total of 23 genes were significantly mutated, and another 237 were mutated in two or more samples. Nearly all samples had at least 1 nonsynonymous mutation in one of nine categories of genes that are almost certainly relevant for pathogenesis, including transcription-factor fusions (18% of cases), the gene encoding nucleophosmin (NPM1) (27%), tumor-suppressor genes (16%), DNA-methylation-related genes (44%), signaling genes (59%), chromatin-modifying genes (30%), myeloid transcription-factor genes (22%), cohesin-complex genes (13%), and spliceosome-complex genes (14%). Patterns of cooperation and mutual exclusivity suggested strong biologic relationships among several of the genes and categories.
We identified at least one potential driver mutation in nearly all AML samples and found that a complex interplay of genetic events contributes to AML pathogenesis in individual patients. The databases from this study are widely available to serve as a foundation for further investigations of AML pathogenesis, classification, and risk stratification. (Funded by the National Institutes of Health.).
The COVID-19 pandemic has forced the rapid adoption of remote teaching modalities including “hyflex” where students attend some class sessions in person and some online. Managing the hyflex course ...requires faculty to quickly generate several reports and to update these reports rapidly when the authorities adjust the rules, students add/drop, or the number of course sessions is changed. The creation of these reports is tedious and error-prone, so they need to be automated. However, the nature of the task precludes traditional Excel programming approaches. We use Excel’s new “dynamic array” capabilities (which are available only in Excel 365) to automate the creation and updating of the reports needed to manage the hyflex course. We show how to program the reports, and we discuss the importance of taking an iterative approach to creating effective, error-free cell formulas. To help the reader acquire genuine access to the dynamic array functions, we provide a practical tutorial on the principles and new concepts of dynamic arrays, explain how they relate to legacy array functions, and present selected dynamic array functions including SEQUENCE, FILTER, and XLOOKUP.
•Eliminates the challenge of scaling spreadsheet linear programming models.•Spreadsheet LPs can now be re-used and re-optimized as easily as algebraic models.•Enables fully reusable code for ...spreadsheet models.•Operates in native Excel without use of macros or VBA.•Works for any LP with up to 1 million non-zero constraint coefficients.
Linear programming models implemented in spreadsheets are understood to be difficult to reuse, whether with modified data that increases or decreases model scale (such as routine model maintenance), as well as with new data (such as deploying a model to a new business setting). The difficulty arises because spreadsheets commingle cell formulas with data, which requires editing cell formulas when the data changes. We provide a novel technique to implement a linear programming model in a spreadsheet that allows for full re-use of the spreadsheet code. It robustly accommodates modified or new data, and enables a spreadsheet LP easily to be reused or even deployed to a new setting with an entirely new dataset. This technique applies to any linear programming model up to approximately 1 million non-zero constraint coefficients, and operates in native Excel without use of macros or VBA. Spreadsheet LP models can now be re-used, re-deployed, and re-optimized as easily as with algebraic software.
Many service industries (e.g., walk-in clinics, vehicle inspection facilities, and data-processing centers) have customers who choose among congested facilities, and select the facility with the ...lowest combination of travel cost plus congestion cost at the facility. In general, customers over-utilize attractive facilities, causing higher costs than if customers were assigned to facilities to minimize total costs. Optimal facility prices induce customers to select facilities that minimize total cost. We find optimal facility prices and show they equal charging customers for the impact (net costs and benefits) they cause for others. We explore a rich flexibility that allows a range of optimal prices, useful when negotiating the implementation of facility fees. Facility prices can be positive or negative (price discounts), and can be adjusted to be all positive, or to provide net subsidy or net revenue. We contribute to unifying and generalizing several disparate streams of research.
Operations research practitioners often write spreadsheet software that is used, modified, and transferred to other people over time. They need techniques that enable them to quickly write error-free ...code whose accuracy can be easily verified and tested. Practitioner spreadsheet models often must be suitable for transfer to others and be robust in the sense that inadvertently introducing errors during reuse and updating is difficult. We examine some problem areas for spreadsheet design and programming and suggest techniques intended to increase productivity and reduce the risk of errors, especially in situations in which someone other than the original author is using or maintaining the spreadsheets.
Somatic variants, primarily fusion genes and single-nucleotide variants (SNVs) or insertions/deletions (indels), are prevalent among sarcomas. In many cases, accurate diagnosis of these tumors ...incorporates genetic findings that may also carry prognostic or therapeutic significance. Using the anchored multiplex PCR–based FusionPlex system, a custom RNA sequencing panel was developed that simultaneously detects fusion genes, SNVs, and indels in 112 genes found to be recurrently mutated in solid tumors. Using this assay, a retrospective analysis was conducted to identify somatic variants that may have assisted with classifying a cohort of 90 previously uncharacterized primarily pediatric sarcoma specimens. In total, somatic variants were identified in 45.5% (41/90) of the samples tested, including 22 cases with fusion genes and 19 cases with SNVs or indels. In addition, two of these findings represent novel alterations: a WHSC1L1/NCOA2 fusion and a novel in-frame deletion in the NRAS gene (NM_002524: c.174_176delAGC p.Ala59del). These sequencing results, taken in context with the available clinical data, indicate a potential change in the initial diagnosis, prognosis, or management in 27 of the 90 cases. This study presents a custom RNA sequencing assay that detects fusion genes and SNVs in tandem and has the ability to identify novel fusion partners. These features highlight the advantages associated with utilizing anchored multiplex PCR technology for the rapid and highly sensitive detection of somatic variants.
Consider an organization whose capability to produce an item and whose customer demand are both stochastic. In such a context “take-or-pay” contracts can be attractive. Under such a contract the ...organization agrees to purchase from a supplier a fixed quantity per period over a specified number of periods. Simulation is too slow an analysis approach for the typical dynamic negotiation situation. We use a Markovian approach to create a tool that negotiators can use to evaluate the expected cost of a proposed contract, considering the stochastic demand and all relevant cost components. The approach is fast enough to use in real time, and yields accurate (sometimes exact) results.