Quantitative Analysis
Order Description
For this task, review the attached “Task 3 Excel Spreadsheet” and, using the instructions given in parts A–C, write a brief response.

Note: When the files opens, enter your name and student ID in the respective boxes so the task questions and problems will populate the worksheet. If the attached template does not open or is missing information, please contact Ecare for assistance with opening the file.
Task:

A. Determine the order size for Company A in the given scenario that would minimize total annual cost by using the economic order quantity model, showing all of your work.
1. Describe the process used to obtain the answer for part A for an audience not familiar with the formula.

B. Determine the lot size for Company B in the given scenario that would minimize total annual cost by using the economic production lot size model, showing all of your work.
1. Describe the process used to obtain the answer for part B for an audience not familiar with the formula.

C. When you choose to use sources, include all in-text citations and references in APA format.

Note: To reduce unnecessary matches select ignore “small matches <20 words” and “bibliography.”

Note: For definitions of terms commonly used in the rubric, see the attached Rubric Terms.

Note: When using sources to support ideas and elements in a paper or project, the submission MUST include APA formatted in-text citations with a corresponding reference list for any direct quotes or paraphrasing. It is not necessary to list sources that were consulted if they have not been quoted or paraphrased in the text of the paper or project.

Note: No more than a combined total of 30% of a submission can be directly quoted or closely paraphrased from sources, even if cited correctly. For tips on using APA style, please refer to the APA Handout web link included in the General Instructions section.