Hi please help me write the answers for part II inventory management! Please refer to the attachments, I have the answer for the excel, just i need helpthe answer to the following questions.

Please I need help with only the questions:

II. Inventory Management Inventory management serves to minimize the cost to maintain inventory and maximize returns. In this section, the company?s financial data will be reviewed in order to determine the optimal inventory management system. A. Determine an optimal cost allocation method based on the relevant costs. B. Describe how this method should be used by decision makers to fulfill their responsibilities. Support your response with examples. C. What are the pros and cons of implementing the just-in-time (JIT) inventory system? Do the pros outweigh the cons for this company? D. Explain how the just-in-time (JIT) inventory system can benefit this organization. Defend your response. E. Identify the inventory management method you recommend, and explain why this method will benefit the company.

Thank you.

ACC 550 Milestone Two Guidelines and Rubric Overview: The final project for this course is the creation of a quantitative analysis that includes an Excel spreadsheet accompanied by a memo to management. Accountants provide management with the logistics of the business that are crucial for daily operations and a company's overall success. In any business, it is of the utmost importance to be aware of all finances and internal processes. Cost accountants focus solely on the internal processes of a business and are tasked with eliminating any unnecessary costs in order to maximize profits. For the final project, you have been tasked with conducting a quantitative analysis that looks into the internal processes of a company. Based on your analysis, you will formulate recommendations to management that aim to improve internal processes and increase profits for the company. Prompt: For this milestone, submit a draft of the inventory management and benchmarking sections of the final project (Sections II and III, respectively), including all the critical elements listed below. Refer to the Hampshire Company Case Study document, as this provides details on how to complete this milestone. All calculations for your quantitative analysis should be completed in the Hampshire Company Spreadsheet. You will provide a rough draft of your qualitative analysis in a Word document. Specifically, the following critical elements must be addressed: II. Inventory Management Inventory management serves to minimize the cost to maintain inventory and maximize returns. In this section, the company's financial data will be reviewed in order to determine the optimal inventory management system. A. Determine an optimal cost allocation method based on the relevant costs. B. Describe how this method should be used by decision makers to fulfill their responsibilities. Support your response with examples. C. What are the pros and cons of implementing the just-in-time (JIT) inventory system? Do the pros outweigh the cons for this company? D. Explain how the just-in-time (JIT) inventory system can benefit this organization. Defend your response. E. Identify the inventory management method you recommend, and explain why this method will benefit the company. III. Benchmarking In this section, benchmarking will be reviewed. Benchmarking can be implemented in various ways depending on a company's circumstances. Your company has decided to implement benchmarking and would like you to research and recommend the most effective approach. A. What is the advantage to benchmarking in terms of improving companies' performance? Support your response. B. Identify possible approaches to benchmarking. Describe each. C. Which benchmarking method should management adopt and why? If you would like a refresher course on using various features of Excel, sign in to Atomic Learning and type \"Excel\" in the search box. This will provide you with options to select the specific level of training that you need (intro, intermediate, or advanced) and the specific version of Excel that you have (e.g., 2011 or 2013). The trainings are broken down into small, meaningful chunks. Therefore, you should be able to find specific topics at each level that will meet your needs. Guidelines for Submission: The written portion of this submission must be a three- to four-page Word document with 12-point Times New Roman font, double spacing, and one-inch margins. Sources should be cited according to APA style. Use the Hampshire Company Spreadsheet to submit your calculations as an Excel file. Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information, review these instructions. Critical Elements Inventory Management: Relevant Costs Inventory Management: Method Inventory Management: Pros and Cons Inventory Management: Inventory System Inventory Management: Inventory Benchmarking: Advantage Benchmarking: Approaches Benchmarking: Benchmarking Method Articulation of Response Proficient (100%) Determines an optimal cost allocation method based on the relevant costs Recommends how the method should be used by decision makers to fulfill their responsibilities and supports response with examples Identifies the pros and cons of implementing JIT and describes whether the pros outweigh the cons for this company Explains how the JIT inventory system can benefit the organization and defends response Identifies the inventory management method recommended and explains why this method will benefit the company Identifies an advantage of benchmarking and supports response Identifies different approaches to benchmarking and describes each Determines which benchmarking method management should adopt and justifies response Submission has no major errors related to citations, grammar, spelling, syntax, or organization Needs Improvement (75%) Determines an optimal cost allocation method, but determination is not based on the relevant costs Recommends how the method should be used by decision makers to fulfill their responsibilities but does not support response with examples Identifies the pros and cons of implementing JIT but does not describe whether the pros outweigh the cons for this company Explains how the JIT inventory system can benefit the organization but does not defend response Not Evident (0%) Does not determine an optimal cost allocation method Value 11 Does not recommend how the method should be used by decision makers 11 Does not identify the pros and cons of implementing JIT 11 Does not explain how the JIT inventory system can benefit the organization 11 Identifies the inventory management method recommended but does not explain why this method will benefit the company Identifies an advantage of benchmarking but does not support response Identifies different approaches to benchmarking but does not describe each Determines which benchmarking method management should adopt but does not justify response Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas Does not identify the inventory management method that is recommended 11 Does not identify an advantage of benchmarking Does not identify different approaches to benchmarking Does not determine which benchmarking method management should adopt 11 Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas Earned Total 12 11 11 100% Requirement 1 Hampshire Company Variable Costing Income Statement Units Sales Variable Cost of Goods Sold: Beginning Inventory Direct Materials Direct Labor Manufacturing Overhead Total Variable Costs 60,000 $ $12.50 $750,000.00 $0 80,000 80,000 80,000 20,000 Cost of Good Available for Sale Deduct Ending Inventory Variable Costs of Goods Sold Variable Selling Costs Contribution Margin Fixed Costs: Fixed Manufacturing Costs Fixed Administrative Costs Operating Income $3.00 $1.50 $0.40 $4.90 60,000 $1.10 $240,000.00 $120,000.00 $32,000.00 $392,000.00 $392,000.00 $98,000.00 $66,000.00 $294,000.00 $66,000.00 $390,000.00 $216,000 $79,525 $94,475.00 Requirement 2 Hampshire Company Absorption Costing Income Statement Sales Variable Cost of Goods Sold: Beginning Inventory Direct Materials Direct Labor Manufacturing Overhead Total Variable Costs Allocated Fixed Manufacturing Costs Cost of Good Available for Sale Deduct Ending Inventory Costs of Goods Sold Gross Margin Fixed Costs: Variable Selling Costs Fixed Administrative Costs Operating Income Units 60,000 $ $12.50 $750,000.00 $0 80,000 80,000 80,000 $3.00 $1.50 $0.40 80,000 $2.70 20,000 $7.60 $240,000.00 $120,000.00 $32,000.00 $392,000.00 $216,000.00 $608,000.00 $152,000.00 $456,000.00 $294,000.00 60,000 $1.10 $66,000 $79,525 $148,475.00 Requirement 1 Price Variances: (Actual Price - Standard Price) X Actual Quantity Cloth Actual $1.25 Standard Actual Quantity Variance Favorable or Unfavorable $1.15 128,000 $12,800 Unfavorable Handle Assembly $0.99 $1.05 80,808 -$4,848 Favorable Labor Price Variance $7.62 $7.50 15,748 $1,890 Unfavorable Requirement 2 Efficiency Variances: (Actual Quantity of Input Used - Standard Quantity of Input Allowed for Actual Output) X Budgeted Price of Input Cloth (1.5 Yards per Unit) Handle Assembly (1 per Unit) Labor (.20 per Unit) Actual 128,000 Standard 120,000 Standard Price Variance Favorable or Unfavorable $1.15 $9,200 Unfavorable 80,808 80,000 $1.05 15,748 16,000 $7.50 848 Unfavorable -$1,890 Favorable