Category: Accounting

Hello, I have added a screen shot of the assignment details. Thank you for your help!

Overview For this project, you will focus on analyzing a payroll onboarding process. By using your knowledge of general accounting principles, you will determine what information you will need to perform the analysis. Consider how you review the onboarding documentation to verify it for payroll and determine what information must be input into the accounting information system (AIS) related to the payroll onboarding process. Scenario You have recently been hired as a business analyst for the chief financial officer (CFO) of a small direct-to-consumer organization. The company is growing and is looking for ways to gain efficiency by automating some processes. The CFO has asked you to perform an analysis of the current payroll onboarding function within the organization. Through this analysis of the current onboarding functions, you will determine the benefits and drawbacks of how employee information flows through an AIS and how using an AIS will improve the payroll onboarding process. Using what you have learned from your Milestone One assignment (flowchart) and with your knowledge of inputting data into an AIS, you will analyze the current new-hire procedures to identify areas for improvement and present this to the CFO. Directions After reviewing the Scenario and Supporting Materials sections, complete your analysis. Begin by reviewing the current new-hire procedures manual specific to the payroll onboarding process. Using Microsoft PowerPoint, create a presentation including speaker notes, and incorporate the illustration completed in Milestone One (flowchart). This is your opportunity to incorporate feedback you received from your instructor into your flowchart before adding it to your PowerPoint presentation. Remember, the goal of the PowerPoint presentation is to present any findings to the CFO. You will need to include a dialog of your findings (script) within the Speaker Notes section in your presentation. You will then need to download the Speaker Notes in the form of a PDF file to upload for your submission with the completed PowerPoint presentation. You will have two submissions for Project One: your presentation and your script. Review the PowerPoint Speaker Notes Tutorial in the Supporting Materials section for assistance. Specifically, you must address the following rubric criteria: Provide a high-level overview of the payroll onboarding process. Illustrate the payroll onboarding process in the form of a flowchart. Include the following details in your response: Post your flowchart within the presentation after incorporating feedback from your instructor on Milestone One. Describe which job function is responsible for performing each task. Explain how the payroll onboarding processes function within accounting information systems. Identify inputs and outputs of the payroll onboarding processes within an accounting information system. Identify how key transaction cycles are automated. Include the following details in your response: Identify steps in the payroll process from paper approval (timesheet) to automated employee paychecks. Identify at least two benefits of automating the payroll onboarding system. Explain your rationale why the identified benefits support automating the payroll onboarding system. Identify at least two drawbacks of automating the payroll onboarding system. Explain your rationale why the identified drawbacks do not support automating the payroll onboarding process. Summarize your findings of the payroll onboarding process. Include the following details in your response: Tasks within a payroll onboarding process Inputs and outputs in the payroll onboarding process Appropriate personnel performing tasks (role) Employee onboarding process documents Approval protocol Benefits and drawbacks of the payroll onboarding process Security protocol Appropriate computerized output with corresponding due dates What to Submit To complete this project, you must submit the following: Payroll Onboarding Presentation Submit your completed 1214 slide presentation using the Project One Template and Microsoft PowerPoint. Sources should be cited in APA style. Speaker Notes Include speaker notes with your presentation in the form of a PDF file. Sources should be cited in APA style.

Now that your cookie business is well underway, you are going to use the knowledge that you have gained in this course to evaluate the financial information for the company. You will be creating a series of reports and analyzing the results using the templates provided to guide you through the project. In this final project, you will do the following:

1. Apply accounting concepts and standards to the creation of accounting information and reports.
2. Analyze accounting information used to make strategic business decisions.
3. Apply ethical behavior to accounting-related situations.
4. Make business decisions based on analyzing accounting data.

Length: Using the (see attached), prepare an eight-to-twelve-page written report (including spreadsheets).

References: At least three peer-reviewed sources are required, any additional resources used are required to be scholarly/academic in nature. APA Style is required for citations and references.

Details: First, start the paper with an abstract and introduction section, per the assignment template provided.

Part 1: Based on the data presented in the Unit VII Spreadsheet Template in Excel (CM Breakeven tab):

• Calculate the contribution margin (CM) for each of the three products sold at the cookie business.
• Calculate the weighted average CM.
• Calculate the breakeven point.

Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss the results based on your calculations as far as which type of cookie you think is the most profitable, which has the highest CM, and such.

Part 2: Based on the data presented in the Unit VII Spreadsheet Template in Excel (Full Variable tab), complete the calculations listed below.

• Calculate the value of ending inventory under full or absorption costing.
• Calculate the value of ending inventory under variable costing.

Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss the results, and comment on which method you think is more helpful to managers and why.

Part 3: Based on the data presented in the Unit VII Spreadsheet Template in Excel (Special Order tab), calculate the net increase or decrease in profit if they take the special order.

Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss the results and comment on if you think the cookie business should take on this special order of cookies for a wedding. Business has been slow the last few months, and the offer is less than the usual selling price for the cookies.

As part of your discussion, include both quantitative (based on the numbers) and qualitative (not based on numbers) factors that would go into the decision to take on the special order, including pricing decisions.

Part 4: Based on the data presented in the in Excel (IRR tab), calculate the internal rate of return (IRR) for the new equipment purchase.

Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Note: the PV Annuity table is provided for you. Discuss if you think the cookie business should accept or reject the purchase of the new equipment and why.

Additional information has come to your attention regarding the equipment purchase. One of the partner’s brothers owns the company that sells the equipment and insists the equipment is needed. Discuss any ethical concerns you see with this type of transaction.

Part 5: Based on the data presented in the Unit VII Spreadsheet Template in Excel (Cash Budget tab), calculate the cash receipts for the first quarter of this year.

Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss your observations about the way cash is collected if the company needs $150,000 per month for expenses.

Part 6: Based on the data presented in the Unit VII Spreadsheet Template in Excel (Variances tab), complete the following calculations.

• Calculate the material variances.
• Calculate the labor variances.

Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss your observations about the variances and ways to plan to improve any of the variances.

End this paper with the key observations and present any future recommendations.

Submission: Save the submission as a Word document and upload the document to Blackboard.

Grading: The assignment will be reviewed in alignment with the grading rubric criteria. The assignment is worth 20% of your course grade.

You have been hired at ABC Manufacturing, and you have been asked to work on the budget for the upcoming year regarding labor costs and the number of employees needed. Complete the attached template for this assignment.

APA Style is not required for this assignment.

1. Review the data given, fill in the information in yellow cells to determine number of employees needed.

2. Based on the calculations result and information given, address how this information can be useful for managers in terms of scheduling, planning, and control. Include ethical considerations in the budget process. Type your response in the box below.

3. Brieftly address how regulatory and compliance requirements (e.g., minimum wage, benefits, safety, etc.) might impact labor costs and pricing decision. Type response in the below box.

DO NOT ACCEPT IF YOU DO NOT HAVE ACCESS TO TABLEAU

Project Comment:

In this project, you will work with a fact table that provides denormalized data that is ready for analysis.

Project Scenario:

You are performing an analysis for the owner of Owl Games, and you need to communicate the results. The owner has asked you which customer has contributed the most total dollar amount of gross margin (sales less costs). The owner asks you to provide a column chart, showing gross margin for all customers. The owner asked for you to provide the analysis as a Tableau Packaged Workbook.

Project Instructions:

• Using the dataset included above, perform a Gross Margin Analysis. Use the instructions for Lab 2-2 on page 95 of your textbook as a guide. Your data is different and will not look like the screenshots in the textbook. You do not need to perform the Assessment Steps 1 and 2 described by your textbook on page 98. Instead you will be submitting your data analysis as a Tableau Packaged Workbook.
• Create a Word document and draft a hypothetical email to the Owner. Since this is just an email, a single, short paragraph is sufficient. Your email should include a recap of the work that you performed (use the AMPS model to help you know what to write), including the following:
• A: Restate the question that is being answered and the purpose of the analysis.
• M: Describe how you transformed or used the data.
• P: State analytics procedures you used.
• S: Share the results. Answer the owner’s question in your email.
• Submit two files: The TWBX file and the Word document.

Refer to the

1. (PDF) from earlier in the week.Completely answer the 10 questions found on the first 2 pages of the reading (click the link to access the reading) providing numerical answers to support your conclusions.
2. Answer the questions in an Excel spreadsheet. Be sure to show your work.

This is a one page Executive Summary and an Exel Spreadsheet. The company I selected in Stanley Black and Decker, Inc (SWK)

Purpose

Using your publicly traded manufacturing company, you will identify types of receivables, apply inventory costing methods, and calculate asset management ratios.

Task

1. Use your selected publicly traded manufacturing company.
2. Identify the different types of receivables that the company has.
3. Identify the following inventory costing methods based on the company’s selected inventory valuation found in the SEC 10-K report:

• FIFO
• LIFO

1. Calculate the following asset management ratios for the company:

• Current ratio
• Quick ratio
• Inventory turnover ratio
• Total asset turnover ratio

1. Create an to organize your data and calculations.
2. Write a report summarizing your findings.

Submission

Report Outline:

• Introduction
• Company overview
• Types of receivables
• Inventory costing methods
• Asset management ratios
• Conclusion and recommendations

Excel Spreadsheet:

The Excel spreadsheet should include the following columns:

• Company name
• Type of receivable
• Amount
• Inventory costing method
• Inventory value
• Asset management ratio

References

IMPORTANT: Please carefully read AFM L6 M1 Assignment Brief, and follow all guidelines.

OVERVIEW

In this assignment, students must select a contemporary issue in accounting or finance that has significantly impacted a business. The issue should be analysed using relevant theories, case studies, and academic literature. The report should provide critical insights into the selected issue, its implications, and recommendations for businesses or policymakers. The case study will focus on the UK market.

Students should choose a contemporary issue from areas such as:

Corporate Governance and Ethics (e.g., creative accounting, earnings management)

Sustainability and ESG Reporting (e.g., carbon accounting, circular economy in finance)

Technological Disruptions (e.g., blockchain in accounting, AI in auditing)

Financial Fraud and Regulation (e.g., tax avoidance, financial scandals)

Capital Market Trends (e.g., impact of fintech, cryptocurrency accounting)

Case Study Selection:

Students must select a real-world business or financial case where the chosen issue has had a significant impact in the last 5 years. The case study should be supported by financial data, company reports, and academic sources.

Report Structure

1. Introduction (500 words)

Overview of the contemporary issue.

Justification for its relevance in accounting and finance.

Outline of the case study and objectives of the report.

2. Literature Review (1,000 words)

Theoretical background and key academic debates.

Analysis of relevant accounting or financial principles.

Discussion of previous case studies or industry examples.

3. Case Study Analysis (1,500 words)

Background of the company/industry affected.

Detailed examination of how the issue impacted financial performance, governance, or compliance.

Use of financial statements, market data, or regulatory findings to support arguments.

4. Discussion and Recommendations (800 words)

Critical analysis of business responses and industry trends.

Suggestions for best practices, regulatory improvements, or managerial strategies.

5. Conclusion (200 words)

Summary of key findings.

Future research directions or anticipated industry developments

Important:

All tasks must be supported by relevant industry and academic research.

As this is a case study report, all images and statistical data must be directly linked to the information on each section and supported by reliable sources.

All your work must be based on reliable research and have 20 different pieces of research done in it. Please ensure you use both direct and indirect citations.

All sources used must be referenced using Canterbury Christ Church University (CCCU) – Harvard Referencing Standards.

Full Case Study details are available in the document

.