I Need this ASAP.

 

ACC 550 Milestone One 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 cost-volume-profit analysis (Section I of the final project), including all of 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. Once you have

 

 

 

completed your analysis, submit your Word and Excel documents.

 

Specifically, the following critical elements must be addressed:

 

 

I. Cost-Volume-Profit Analysis

 

 

 

Cost-volume-profit (CVP) analysis is a useful tool for informing short-term economic planning within an organization. In this section, a CVP analysis will be

 

conducted and used to inform business decisions and recommendations.

 

 

A. Perform a CVP analysis based on cost classifications.

 

B. Explain how a CVP analysis can assist management with short-term economic planning. Support your response with examples from your CVP

 

 

 

analysis.

 

 

C. Accurately compute the break-even quantity and break-even revenue.

 

D. Determine whether the company is breaking even. What are the CVP analysis implications on planning?

 

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 one- to two-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.