Optimizing Production

Task 2 Optimizing Production

QUANTITATIVE ANALYSIS

Competency 309.3.1: Decision-Making Models – The graduate uses optimizing models and other models as aids for making more informed decisions.

Introduction:

Graphical models enable a manager to visualize the objective function (profit line), constraints, and possible solutions to a given problem, and to make more informed decisions based on that information. In this task you will be using your knowledge of graphical models, the given scenario, and the attached “QAT1 Task 2 Spreadsheet” to complete the assessment.

Scenario:

Company A produces and sells a popular pet food product packaged under two brand names, with formulas that contain different proportions of the same ingredients. Company A made this decision so that their national branded product would be differentiated from the private label product. Some product is sold under the company’s nationally advertised brand (Brand Y), while the re-proportioned formula is packaged under a private label (Brand X) and is sold to chain stores. Because of volume discounts and other stipulations in the sales agreements, the contribution to profit from the Brand Y product sold to distributors under the company’s national brand is only $12.50 per case compared to $100 per case for private label product Brand X. There are four ingredients involved in the two products. The recipes specifying the use of each ingredient in the two product brands are given in the “QAT1 Task 2 Spreadsheet”. Also note that an ingredient may either be in limited supply or may have government regulations requiring a minimum or maximum amount.

Task:

Note: Save file linked under “File Attachments” to your computer, then open the file. When the file opens, enter your name and student ID as they appear in Taskstream into the respective boxes so the task questions and problems will populate the worksheet.

A. Identify the objective function.

1. Determine the total profit to be made if the company produces a combination of cases of Brand X and Brand Y that lies on the black-dashed objective function line (profit line), as shown on the graph in the attached “QAT1 Task 2 Spreadsheet.”

B. Write the four constraints that are described in the scenario given in the attached “QAT1 Task 2 Spreadsheet.”

1. Describe why each of the four written constraints from part B is a minimum or a maximum constraint.

C. Analyze the optimum production yielding the greatest amount of profit by doing the following:

1. Determine the number of cases of Brand X that should be produced, showing all of your work.

2. Determine the number of cases of Brand Y that should be produced, showing all of your work.

3. Discuss how the feasible region was used to arrive at your calculations for parts C1 and C2.

4. Determine the total profit that would be generated by the production levels determined in parts C1 and C2, showing all of your work.

Note: Partial cases are allowed as part of the solution.

D. When you 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: When using sources to support ideas and elements in an assessment, 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 assessment.

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

Answers

Related Questions

Writing : 16499509 1...

Running head: IMAGE ADVERTISEMENT CASE STUDYImage Advertisement Case StudyStudents NameInstitutional Affiliation1IMAGE ADVERTISEMENT CASE STUDYImage A...

Management : Ups Co. Logistics.edited...

1Running head: UPS LOGISTICSUnited Parcel ServiceStudents NameInstitutionDate2UPS LOGISTICSUnited Parcel Service1. Company NameUnited Parcel Service2....

Health & Medical : Disaster Management Response...

Running head: DISASTER MANAGEMENT1Disaster Management ResponseStudents NameProfessors NameCourse TitleDateDISASTER MANAGEMENT2Disaster Management Resp...

Management : Memorandum....

MemorandumTo:MGT 490C Students; Andersons Sections 1, 2, & 3From: Joe S. Anderson, Ph.D. JSADate: 1/25/2020Re:Burned N Turned Mini-Case Memo due Wedne...

English : Character Analysis...

1Running Head: Character AnalysisCharacter Analysis: Dolly LeviStudent name:Institutional affiliation:2Character AnalysisCharacter Analysis: Dolly Lev...

Accounting : Strategy Analysis...

Running head: ACC453 - ADUITING COURSEACC453 - Aduiting courseName of the studentName of the professorCourseDate1ACC453 - ADUITING COURSE2Strategy ana...

Health & Medical : Dq9 Nurse Role And Scope...

Running head: DISCUSSION1DiscussionStudents NameInstitutional AffiliationDISCUSSION2DiscussionRole and Scope of NursesQuestion 1In the healthcare sett...

Nursing : Nursing Research Discussion Q.edited...

1Running head: HOSPITAL READMISSIONHospital ReadmissionStudents NameProfessors NameCourse TitleDateHOSPITAL READMISSION2Patient healthcare is usually...

Accounting : Answer...

Running head: FINANCIAL ETHICSFinancial EthicsStudents NameInstitutional AffiliationFINANCIAL ETHICSFinancial EthicsUnethical financial reporting prol...

Management : Type Of Employee...

Running Head: EMPLOYEES BENEFITS1Type of Employees BenefitsStudents NameInstitution AffiliationDateEMPLOYEES BENEFITS2IntroductionMy organization is s...

Management : Compulsory Internship As A Graduation...

Running head: COMPULSORY INTERNSHIP AS A GRADUATION REQUIREMENTCompulsory internship as a graduation requirementName of StudentName of Institution1COM...

Writing : Streaming Analysis 3 A Pro Streamer...

Running head: STREAMING ANALYSIS 3: FUTUREMANGAMINGStreaming Analysis 3: FuturemanGamingNameInstitution1STREAMING ANALYSIS 3: FUTUREMANGAMING2Streamin...

Psychology : Ec Articles Summary...

Running Head: ARTICLES SUMMARY1EC Articles SummaryNameCourseProfessorDateARTICLES SUMMARY2EC Articles SummaryArticle 1The research aimed to use clinic...

Computer Science : Reflection Paper.edited...

Running head: REFLECTION PAPER1Reflection PaperStudents NameInstitutional AffiliationDateREFLECTION PAPER2Reflection PaperStudies indicate that variou...

Article Writing : Case Studies...

Running head: ENTERPRISE RISK MANAGEMENTEnterprise Risk ManagementStudents NameCourseInstructors NameDate Submitted1ENTERPRISE RISK MANAGEMENT2Enterpr...

Law : Rehabilitation 1...

1Running Head: REHABILITATIONRehabilitationInstitutional AffiliationNameDate2REHABILITATIONRehabilitationRestoring an individual to the prior state us...

Economics : Human Resource And Accounting...

Running head: ECONOMICS1EconomicsStudent NameInstitution AffiliationECONOMICS2What would be an ineffective human response by Ken? What would be an eff...

Nursing : Response 2...

1Running header: RESPONSERESPONSEStudents NameTutors NameCourse TitleDateLike it has been well explained in the article, I agree that the health of a...

Business : 17179562...

Running head: WORKPLACE ETHICS1Workplace EthicsNameInstitutionWORKPLACE ETHICS2Ideals, Effects, and ConsequencesIn this case, there are different idea...

History : Cold War...

Running Head: U.S HISTORY1Cold War between U.S and Soviet UnionStudents name:Course:Course number:Instructor:Date:U.S HISTORY2Cold War between U.S and...

Writing : Target Organization List...

Target Organization ListOrganizationSanctuary Social workersJoin togetherLion heartNational Active criminaljusticeOncology Social WorkAmerican School...

Computer Science : Software Defined Network 2...

Running head: SDN1Software-Defined NetworkStudents NameInstitutionInstructorDateSDN2Software-Defined Network (SDN) refers to a set of principles of ne...

Business : E Commerce Case Study...

Running head: E-COMMERCE1E-Commerce Case StudyNameInstitutionE-COMMERCE2E-Commerce Case StudyPandora, an online radio system, had a different model of...

History : Help With History Assignment Equality Mo...

Running head: EQUALITY MOVEMENTS1Equality MovementsNameInstitutionEQUALITY MOVEMENTS2Equality MovementsThe main goal of the African American Civil Rig...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it