Group Graded Assignment 4 Instructions Complete The Assignme

Group Graded Assignment 4 Instructions complete The Assignment Name It

Complete the assignment, name it as GroupXX_Assign4.xlsx (where XX is your Group Number), and upload it to the instructor through GeorgiaVIEW, using the link named “Group Graded Assignment 4.” Do not enter anything in the black cells labeled “Grader.” You must complete this assignment without assistance from anyone outside your group. Use any resources you deem necessary, including Excel’s Help feature. Answer the questions by placing the appropriate graphs and/or answers in the designated cells of the spreadsheet.

Do not change the appearance or functionality of the spreadsheet unless instructed to do so.

Paper For Above instruction

The assignment involves optimizing production and resource allocation through Linear Programming (LP) models for Hickory Cabinet and Furniture Company and personal investment decision-making for a 401K plan. It requires formulating LP problems, inputting data into specific spreadsheet cells, and analyzing sensitivity outputs to derive insights.

Specifically, the first part centers on a production problem where Hickory produces sofas, tables, and chairs, constrained by resources such as wood, upholstery, labor, and warehouse capacity. Students are tasked with developing the LP model to maximize profit, inputting profit coefficients, constraint coefficients, resource usage, slack/surplus calculations, and inequalities into a pre-designed Excel template. The objective function formula involves the SUMPRODUCT function referencing decision variables, profits, and resource constraints.

The second part updates the parameters based on recent contractual and resource changes, analyzing the LP solution and sensitivity report for the modified model. Students input decision variable values, profit ranges, and resource-related data to interpret how changes impact the optimal solution, resource surplus, and marginal worth of additional resources.

The third section shifts focus to personal finance, modeling a portfolio allocation problem across four asset classes—Real Estate, CD, Mutual Funds, and Bonds—with constraints on investment ratios and minimum investment amounts. Students formulate the LP problem to maximize the return, inputting return coefficients, constraints, and slack/surplus indicators. The sensitivity analysis provides bounds within which asset returns can fluctuate without altering the optimal investment distribution.

Finally, in the last part, students interpret the sensitivity report for the investment problem, assessing the impact of return variations on the optimal solution and the marginal value of constraints. They interpret shadow prices, allowable increases/decreases, and slack/surplus indicators related to investment constraints.

This comprehensive assignment tests abilities in LP formulation, linear modeling, spreadsheet data entry, sensitivity analysis interpretation, and real-world decision-making scenarios across manufacturing and investment contexts.

References

  • Hiller, F. S., & Lieberman, G. J. (2015). Introduction to Operations Research. McGraw-Hill Education.
  • Winston, W. L. (2004). Operations Research: Applications and Algorithms. Thomson/Brooks/Cole.
  • Hillier, F. S., & Lieberman, G. J. (2010). Introduction to Operations Research. McGraw-Hill Education.
  • Gross, D., & Harris, C. M. (1998). Fundamentals of Queueing Theory. Wiley-Interscience.
  • Seppä, M. (2010). Introduction to Linear Optimization. Springer.
  • Shelby, M. (2012). Practical Spreadsheet Modeling. Wiley.
  • French, S. (2012). An Introduction to Operations Research. Cengage Learning.
  • Gass, S. I., & Assad, A. (2005). Campaigns and Cases in Management Science. Dover Publications.
  • Ragsdale, C. T. (2018). Spreadsheet Modeling & Decision Analysis. Cengage Learning.
  • Keown, C., & Pinkerton, R. (2017). Financial Management: Principles and Applications. Pearson.

Related Assignments