Identify and record the most current three years? sales (in dollars) for both companies using their financial statements. Be sure the financial statements come from the company’s annual report. Do not use statements provided by third parties, like Yahoo Finance or others.
Using the data in question 1, predict both companies? sales activity for the next two to three years. Hint: use trend analysis (Chapter 13). If possible, compare your predictions to actual sales figures for those years.
Use Excel to compute profit margin for both companies for the two most recent years. Comment on your findings.

Requirements:

Divide the parts of this assignment equitably among your team members. Always make sure that at least two people compute any calculations and check each other?s work to make sure there are no errors. If your numbers are incorrect, your comments are going to be moot.

Include student names on the first page of the assignment for those who contributed. If a group member did not participate in the completion of the assignment, do not include his/her name.

Type the assignment question number, then the question, and then your response. Be sure all teammates read the documents and review that all components are included before submitting the assignment.

Make sure there are zero spelling/grammar errors.

Include the income statements (from the companies? websites) for the three years so I can check your answers. Copy/paste them in your Word document. Do not submit them separately. NO links!

Use a plagiarism checker (find a free one using Google) before you submit the assignment to ensure that no written work has been copied. Plagiarism will result in zero points for all teammates in the group.

Submit the assignment in Blackboard by clicking on the underlined Project 1 – Sales (right next to the paper/pencil/ruler icon) in this folder.

You will be attaching two documents for this assignment: a Word document and an Excel document. Do not combine them; in other words, don’t write the answers to the questions in Excel and don’t copy/paste your Excel results in the Word document. Keep them separate!

Late assignments are accepted no later than the day following the deadline and carry an automatic 20% penalty.

Project 2 – COGS
Use Excel to compute the ratios of cost of goods sold to total expenses (see formulas below) for both companies for their two most recent fiscal years.

COGS + Operating Expenses = Total Expenses

COGS/Total Expenses

Record answers as percentages, rounded to one decimal place. Remember to have at least two people compute these ratios and check each other?s work for accuracy.

Comment on the similarities and/or differences in the ratio results across both years between the two companies.
Which company has a higher ratio of costs, defined as COGS plus total operating expenses, to revenues?

{ (COGS + Operating Expenses)/Revenue}

Use the two most recent years? income statements. Use Excel to show your analysis computations (use formulas; don?t just type them in). Again, have at least two people work on this and check each other?s work.

How might the use of activity-based costing help the less competitive company become more competitive?

Requirements:

Divide the assignment equitably among your team members making sure that at least two members complete each section and then compare answers for possible errors and corrections.

Include student names on the first page of the assignment for those who contributed. If a group member did not participate in the completion of the assignment, do not include his/her name.

Type the assignment question number, then the question, and then your response. Be sure all teammates read the documents and review that all components are included before submitting the assignment.

Make sure there are zero spelling/grammar errors.

Submit the income statements for both companies (from their websites) for the two years so I can check your answers. Copy/paste them in your Word document. Do not submit them separately. NO links!

Use a plagiarism checker (find a free one using Google) before you submit the assignment to ensure that no written work has been copied. Plagiarism will result in zero points for all teammates in the group.

Submit the assignment in Blackboard by clicking on the underlined Project 2 – COGS (right next to the paper/pencil/ruler icon). You will be attaching two documents for this assignment: a Word document and an Excel document. Do not combine them; in other words, don’t write the answers to the questions in Excel and don’t copy/paste your Excel results in the Word document. Keep them separate!

Late assignments are accepted no later than the day following the deadline and carry an automatic 20% penalty.

Project 3 – Inventory
Identify the impact on operating cash flows (increase or decrease) for changes in inventory levels (increase or decrease) for both companies for each of the three most recent years. Use Excel for your analysis.
What impact would a JIT inventory system have on each company?s operating income? Link this answer to your response in question 1 above.
Would the move to a JIT system have a one-time or recurring impact on operating cash flow?

Requirements:

Divide the assignment equitably among your team members making sure that at least two members complete each section and then compare answers for possible errors and corrections.

Include student names on the first page of the assignment for those who contributed. If a group member did not participate in the completion of the assignment, do not include his/her name.

Type the assignment question number, then the question, and then your response. Be sure all teammates read the documents and review that all components are included, before submitting the assignment.

Make sure there are zero spelling/grammar errors.

Submit the Cash Flow statements & Balance Sheets for both companies (from their websites) for the three years so I can check your answers. Copy/paste them in your Word document. Do not submit them separately. NO links!

Use a plagiarism checker (find a free one using Google) before you submit the assignment to ensure that no written work has been copied. Plagiarism will result in zero points for all teammates in the group.

Submit the assignment in Blackboard by clicking on the underlined Project 3 – Inventory (right next to the paper/pencil/ruler icon). You will be attaching two documents for this assignment: a Word document and an Excel document. Do not combine them; in other words, don’t write the answers to the questions in Excel and don’t copy/paste your Excel results in the Word document. Keep them separate!

And this project includes excel and word document.

Leave a Reply

Your email address will not be published. Required fields are marked *

Identify and record the most current three years? sales (in dollars) for both companies using their financial statements. Be sure the financial statements come from the company’s annual report. Do not use statements provided by third parties, like Yahoo Finance or others.
Using the data in question 1, predict both companies? sales activity for the next two to three years. Hint: use trend analysis (Chapter 13). If possible, compare your predictions to actual sales figures for those years.
Use Excel to compute profit margin for both companies for the two most recent years. Comment on your findings.

Requirements:

Divide the parts of this assignment equitably among your team members. Always make sure that at least two people compute any calculations and check each other?s work to make sure there are no errors. If your numbers are incorrect, your comments are going to be moot.

Include student names on the first page of the assignment for those who contributed. If a group member did not participate in the completion of the assignment, do not include his/her name.

Type the assignment question number, then the question, and then your response. Be sure all teammates read the documents and review that all components are included before submitting the assignment.

Make sure there are zero spelling/grammar errors.

Include the income statements (from the companies? websites) for the three years so I can check your answers. Copy/paste them in your Word document. Do not submit them separately. NO links!

Use a plagiarism checker (find a free one using Google) before you submit the assignment to ensure that no written work has been copied. Plagiarism will result in zero points for all teammates in the group.

Submit the assignment in Blackboard by clicking on the underlined Project 1 – Sales (right next to the paper/pencil/ruler icon) in this folder.

You will be attaching two documents for this assignment: a Word document and an Excel document. Do not combine them; in other words, don’t write the answers to the questions in Excel and don’t copy/paste your Excel results in the Word document. Keep them separate!

Late assignments are accepted no later than the day following the deadline and carry an automatic 20% penalty.

Project 2 – COGS
Use Excel to compute the ratios of cost of goods sold to total expenses (see formulas below) for both companies for their two most recent fiscal years.

COGS + Operating Expenses = Total Expenses

COGS/Total Expenses

Record answers as percentages, rounded to one decimal place. Remember to have at least two people compute these ratios and check each other?s work for accuracy.

Comment on the similarities and/or differences in the ratio results across both years between the two companies.
Which company has a higher ratio of costs, defined as COGS plus total operating expenses, to revenues?

{ (COGS + Operating Expenses)/Revenue}

Use the two most recent years? income statements. Use Excel to show your analysis computations (use formulas; don?t just type them in). Again, have at least two people work on this and check each other?s work.

How might the use of activity-based costing help the less competitive company become more competitive?

Requirements:

Divide the assignment equitably among your team members making sure that at least two members complete each section and then compare answers for possible errors and corrections.

Include student names on the first page of the assignment for those who contributed. If a group member did not participate in the completion of the assignment, do not include his/her name.

Type the assignment question number, then the question, and then your response. Be sure all teammates read the documents and review that all components are included before submitting the assignment.

Make sure there are zero spelling/grammar errors.

Submit the income statements for both companies (from their websites) for the two years so I can check your answers. Copy/paste them in your Word document. Do not submit them separately. NO links!

Use a plagiarism checker (find a free one using Google) before you submit the assignment to ensure that no written work has been copied. Plagiarism will result in zero points for all teammates in the group.

Submit the assignment in Blackboard by clicking on the underlined Project 2 – COGS (right next to the paper/pencil/ruler icon). You will be attaching two documents for this assignment: a Word document and an Excel document. Do not combine them; in other words, don’t write the answers to the questions in Excel and don’t copy/paste your Excel results in the Word document. Keep them separate!

Late assignments are accepted no later than the day following the deadline and carry an automatic 20% penalty.

Project 3 – Inventory
Identify the impact on operating cash flows (increase or decrease) for changes in inventory levels (increase or decrease) for both companies for each of the three most recent years. Use Excel for your analysis.
What impact would a JIT inventory system have on each company?s operating income? Link this answer to your response in question 1 above.
Would the move to a JIT system have a one-time or recurring impact on operating cash flow?

Requirements:

Divide the assignment equitably among your team members making sure that at least two members complete each section and then compare answers for possible errors and corrections.

Include student names on the first page of the assignment for those who contributed. If a group member did not participate in the completion of the assignment, do not include his/her name.

Type the assignment question number, then the question, and then your response. Be sure all teammates read the documents and review that all components are included, before submitting the assignment.

Make sure there are zero spelling/grammar errors.

Submit the Cash Flow statements & Balance Sheets for both companies (from their websites) for the three years so I can check your answers. Copy/paste them in your Word document. Do not submit them separately. NO links!

Use a plagiarism checker (find a free one using Google) before you submit the assignment to ensure that no written work has been copied. Plagiarism will result in zero points for all teammates in the group.

Submit the assignment in Blackboard by clicking on the underlined Project 3 – Inventory (right next to the paper/pencil/ruler icon). You will be attaching two documents for this assignment: a Word document and an Excel document. Do not combine them; in other words, don’t write the answers to the questions in Excel and don’t copy/paste your Excel results in the Word document. Keep them separate!

And this project includes excel and word document.

Leave a Reply

Your email address will not be published. Required fields are marked *