Complete Case Study — “Low Nail Company” from our text (see p. 148 in the original textbook). Provide a brief discussion of your results for each question.
– Provide your answers in a well-formatted EXCEL file, using this template — Low Nail Company.xlsx
– Limit the width of the workbook to 1 page using Portrait layout (to allow for printing and grading in Blackboard). Multiple pages “tall” are OK.
– Label each question with titles and all answers with proper units (e.g. $, cases per order, $ per year, etc.).
– Effective spreadsheet design must be used. For example, all input data must be shown in separate cells and all answers must be formulas that reference the input cells. In this way, any input can be quickly changed for immediate recalculation of your answers! This happens all the time on-the-job.