Choose a company and summarize each strategy. Explore one or two strategies; you have two options: you can discuss the strategies briefly, or you can choose three strategies and discuss them in detail. I have attached a lecture on strategies.
Requirements:
This course contains a Course Project, where you will be required to submit one draft of the project at the end of Week 6, and the final completed project at the end of Week 8. Using the financial statements for Apple Inc. and Microsoft, Inc., respectively, you will calculate and compare the financial ratios listed further down this document and prepare your comments about the two companies’ performances based on your ratio calculations. The entire project will be graded by the instructor at the end of the final submission in Week 8, and one grade will be assigned for the entire project.
Below is the link for the financial statements for Apple Inc. for the fiscal year ending 2021.
When you arrive at this website, please do the following.
First, select SEC Filings, next select Annual Filings using the drop-down arrow labeled All Filings and then select 2021, using the drop-down arrow labeled Year,
You should select the 10-K dated 10/29/2021 and choose to download in PDF, HTML, or Excel format. The PDF format is the best format for searching.
Below is the link for the financial statements for Microsoft, Inc. for the fiscal year ending 2021.
Once on the page, filter out the “Annual Filings” and “2021” year, which will bring up the link to the 10-K report. Click on Documents for the 10-K dated 07/29/2021. Finally, click on the .pdf link next to the Form 10-K. This will open the 10-K in HTML format which is searchable.
A
is available for download. The sample project compares the ratio performance of Nike and Under Armour using the 2014 financial statements of Nike and Under Armour provided at their websites.
For the Final Submission:
Your final Excel workbook submission should contain the following. You cannot use any other software but Excel to complete this project.
Required Ratios for Final Project Submission
Note: The Excel files uploaded as the assignment submission should not include any unnecessary numbers or information (such as previous years’ ratios, ratios that were not specifically asked for in the project, etc.).
Other Helpful Information:
If you feel uncomfortable with Excel, you can find many helpful tutorials on Excel by performing a Google search.
Chapter 13 contains ratio calculations and comparison comments for two fictitious companies Chicago Cereal and Giant Mills so you will likely find this information helpful.
APA style must be used to complete the references on your Bibliography tab. The Library contains information on APA formatting.
This course contains a Course Project, where you will be required to submit one draft of the project at the end of Week 6, and the final completed project at the end of Week 8. Using the financial statements for Apple Inc. and Microsoft, Inc., respectively, you will calculate and compare the financial ratios listed further down this document and prepare your comments about the two companies’ performances based on your ratio calculations. The entire project will be graded by the instructor at the end of the final submission in Week 8, and one grade will be assigned for the entire project.
Below is the link for the financial statements for Apple Inc. for the fiscal year ending 2021.
When you arrive at this website, please do the following.
First, select SEC Filings, next select Annual Filings using the drop-down arrow labeled All Filings and then select 2021, using the drop-down arrow labeled Year,
You should select the 10-K dated 10/29/2021 and choose to download in PDF, HTML, or Excel format. The PDF format is the best format for searching.
Below is the link for the financial statements for Microsoft, Inc. for the fiscal year ending 2021.
Once on the page, filter out the “Annual Filings” and “2021” year, which will bring up the link to the 10-K report. Click on Documents for the 10-K dated 07/29/2021. Finally, click on the .pdf link next to the Form 10-K. This will open the 10-K in HTML format which is searchable.
A
is available for download. The sample project compares the ratio performance of Nike and Under Armour using the 2014 financial statements of Nike and Under Armour provided at their websites.
For the Final Submission:
Your final Excel workbook submission should contain the following. You cannot use any other software but Excel to complete this project.
Required Ratios for Final Project Submission
Note: The Excel files uploaded as the assignment submission should not include any unnecessary numbers or information (such as previous years’ ratios, ratios that were not specifically asked for in the project, etc.).
Other Helpful Information:
If you feel uncomfortable with Excel, you can find many helpful tutorials on Excel by performing a Google search.
Chapter 13 contains ratio calculations and comparison comments for two fictitious companies Chicago Cereal and Giant Mills so you will likely find this information helpful.
APA style must be used to complete the references on your Bibliography tab. The Library contains information on APA formatting.
Module Assignment: Managerial Accounting Report
The Purpose and Context
This assignment will help you develop your understanding of the managerial accounting processes and you will earn how different accounting methods create different pictures for a company given the same data.
Case Scenario
Swipe 50 limited manufactures a specialized screen protector for laptops computers. The plus swipe is a screens protector that prevent scratches on laptop screens. The company has been in operation for 3 years and now that company has refined its production process, the directors have decided to focus on the income and cost arising from the activities. Therefore, the CFO, Tamara J. Blooms, wants to focus on product costing. She wants to look into how both absorption and variable costing affect the profits of the company. The following information is available for the month February and March:
February
March
Production (units)
12,500
14,500
Sales (units)
11,500
15,500
Direct Materials
29,000
33,250
Direct Labour
19,000
22,000
Variable Production Overhead
7,300
8,500
Total Selling and Administrative Expenses
44,500
57,100
Additional Information
1. Swipes 50 Ltd. production capacity 20,000 units per month.
2. Fixed production overheads are 28,600 per month.
3. Swipe 50 sells Plus Swipes at 22 each.
4. On 31st January, the companys warehouse has no Plus Swipes in inventory.
5. Fixed and variable elements (variable portion is incurred based on units sold) are included in the total administration expenses.
Assignment Instructions
Please create a report for 50 swipes limited and please include the following in your report.
1. Prepare a profit statement for Swipe 50 Limited for the month of February and March using: (20%)
a. Absorption costing
b. Variable costing
2. Reconcile the profit calculated using absorption costing to that using variable costing. (20%)
3. Explain how each method differs from the other method and also explain the importance of the each methods.
(20%)
4. Explain three ways that Swipes 50 Ltd. can improve its accounting systems. (20%)
5. State why managing accounting jobs are important in a manufacturing company. (20%)
Requirements:
Outside Environment, Inc. provides commercial landscaping services in San Diego. Sasha Cairns, the
firm’s owner, wants to develop cost estimates that she can use to prepare bids on jobs. After analyzing
the firm’s costs, Cairns has developed the following preliminary cost estimates for each 1,000 square
feet of landscaping.
Cairns is quite certain about the estimates for direct material and direct labor. However, she is not as
comfortable with the overhead estimate. The estimate for overhead is based on the overhead costs that
were incurred during the past 12 months as presented in the following schedule. The estimate of $18
per direct-labor hour was determined by dividing the total overhead costs for the 12-month period
($1,296,000) by the total direct-labor hours (72,000).
Cairns believes that overhead is affected by total monthly direct-labor hours. Cairns decided to perform
a least-squares regression of overhead (OH) on total direct-labor hours (DLH).
Required:
1. Develop cost formula for overhead cost using least square regression method by constructing
excel spreadsheet.
2. The overhead rate developed from the least-squares regression is different from Cairns’
preliminary estimate of $18 per direct-labor hour. Explain the difference in the two overhead
rates.
3. Using the overhead formula that was derived from the least-squares regression, determine a
total variable-cost estimate for each 1,000 square feet of landscaping.
4. Cairns has been asked to submit a bid on a landscaping project for the city government
consisting of 50,000 square feet. Cairns estimates that 30 percent of the direct-labor hours
required for the project will be on overtime. Calculate the incremental costs that should be
included in any bid that Cairns would submit on this project. Use the overhead formula derived
from the least-squares regression.
5. Should management rely on the overhead formula derived from the least-squares regression as
the basis for the variable overhead component of its cost estimate? Explain your answer.were incurred during the past 12 months as presented in the following schedule. The estimate of $18
per direct-labor hour was determined by dividing the total overhead costs for the 12-month period
($1,296,000) by the total direct-labor hours (72,000).
Cairns believes that overhead is affected by total monthly direct-labor hours. Cairns decided to perform
a least-squares regression of overhead (OH) on total direct-labor hours (DLH).
Required:
1. Develop cost formula for overhead cost using least square regression method by constructing
excel spreadsheet.
2. The overhead rate developed from the least-squares regression is different from Cairns’
preliminary estimate of $18 per direct-labor hour. Explain the difference in the two overhead
rates.
3. Using the overhead formula that was derived from the least-squares regression, determine a
total variable-cost estimate for each 1,000 square feet of landscaping.
4. Cairns has been asked to submit a bid on a landscaping project for the city government
consisting of 50,000 square feet. Cairns estimates that 30 percent of the direct-labor hours
required for the project will be on overtime. Calculate the incremental costs that should be
included in any bid that Cairns would submit on this project. Us
Requirements:
Kimm Bearheart is the corporate buyer for vehicles put into service by Express Car Rental. Kimm has the option to buy several lots of vehicles from another rental agency that is downsizing, and wants to get a better idea of the number of rentals nationwide by vehicle type. The corporate accountant has forwarded Kimm a worksheet containing rental data for last year. Kimm wants to use this summarized data but feels that embedding charts will provide a quicker analysis in a more visual manner for the chief financial officer at their meeting next week.
|
Step |
Instructions |
Points Possible |
|
1 |
Start Excel. Download and open the file named Excel_Ch04_Express.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. |
0 |
|
2 |
Charting data is good way to analyze data visually. Use the cell ranges A5:A10 and O5:O10 on the AnnualData worksheet to create a 3-D Pie chart of the number of annual rentals for the six car types. |
13 |
|
3 |
Having a descriptive chart title is important to understand the chart’s contents. On the 3-D pie chart, change the title to Annual Rentals |
8 |
|
4 |
To make the pie chart more descriptive, data labels can be added. Add data labels on the pie chart to include the category name and percentage only. |
8 |
|
5 |
Change the color palette of the 3-D pie chart to Monochromatic, Palette 1. |
2 |
|
6 |
Explode the slice of the 3-D pie chart to 20% that represents the auto type with the lowest percentage of annual rentals. |
6 |
|
7 |
Adjust the 3-D rotation of the chart to have the X rotation of 70 and a Y rotation of 50 |
0 |
|
8 |
Click the clustered column chart located below the monthly data. Change the chart type of the chart to a Line chart. |
2 |
|
9 |
Increase the data used in the line chart to include the months of July, August, and September. |
1 |
|
10 |
Format the appearance of the line chart with the following: |
0 |
|
11 |
Create a 3-D Clustered Column chart using the cell ranges A5:A10 and H5:H10 for the Semi-Annual Total for all auto types on the AnnualData worksheet. The primary horizontal axis should be the auto types. |
0 |
|
12 |
Change the chart title by creating a reference to cell H4 on the AnnualData worksheet. |
0 |
|
13 |
Move the 3-D column chart from the AnnualData worksheet to a chart sheet, and then name that worksheet SemiAnnualReport |
0 |
|
14 |
Add data labels to the chart. Change the font size of the data labels to 14 and then bold the data labels. |
0 |
|
15 |
Change the color of the Chart Area to Turquoise, Accent 4, Lighter 80% fill. |
0 |
|
16 |
Move the SemiAnnualReport worksheet to the right of the AnnualData worksheet. |
0 |
|
17 |
Save and close Excel_Ch04_Express.xlsx. Exit Excel. Submit the file as directed. |
0 |
|
Total Points |
40 |
Requirements: instructions
Kimm Bearheart is the corporate buyer for vehicles put into service by Express Car Rental. Kimm has the option to buy several lots of vehicles from another rental agency that is downsizing, and wants to get a better idea of the number of rentals nationwide by vehicle type. The corporate accountant has forwarded Kimm a worksheet containing rental data for last year. Kimm wants to use this summarized data but feels that embedding charts will provide a quicker analysis in a more visual manner for the chief financial officer at their meeting next week.
|
Step |
Instructions |
Points Possible |
|
1 |
Start Excel. Download and open the file named Excel_Ch04_Express.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. |
0 |
|
2 |
Charting data is good way to analyze data visually. Use the cell ranges A5:A10 and O5:O10 on the AnnualData worksheet to create a 3-D Pie chart of the number of annual rentals for the six car types. |
13 |
|
3 |
Having a descriptive chart title is important to understand the chart’s contents. On the 3-D pie chart, change the title to Annual Rentals |
8 |
|
4 |
To make the pie chart more descriptive, data labels can be added. Add data labels on the pie chart to include the category name and percentage only. |
8 |
|
5 |
Change the color palette of the 3-D pie chart to Monochromatic, Palette 1. |
2 |
|
6 |
Explode the slice of the 3-D pie chart to 20% that represents the auto type with the lowest percentage of annual rentals. |
6 |
|
7 |
Adjust the 3-D rotation of the chart to have the X rotation of 70 and a Y rotation of 50 |
0 |
|
8 |
Click the clustered column chart located below the monthly data. Change the chart type of the chart to a Line chart. |
2 |
|
9 |
Increase the data used in the line chart to include the months of July, August, and September. |
1 |
|
10 |
Format the appearance of the line chart with the following: |
0 |
|
11 |
Create a 3-D Clustered Column chart using the cell ranges A5:A10 and H5:H10 for the Semi-Annual Total for all auto types on the AnnualData worksheet. The primary horizontal axis should be the auto types. |
0 |
|
12 |
Change the chart title by creating a reference to cell H4 on the AnnualData worksheet. |
0 |
|
13 |
Move the 3-D column chart from the AnnualData worksheet to a chart sheet, and then name that worksheet SemiAnnualReport |
0 |
|
14 |
Add data labels to the chart. Change the font size of the data labels to 14 and then bold the data labels. |
0 |
|
15 |
Change the color of the Chart Area to Turquoise, Accent 4, Lighter 80% fill. |
0 |
|
16 |
Move the SemiAnnualReport worksheet to the right of the AnnualData worksheet. |
0 |
|
17 |
Save and close Excel_Ch04_Express.xlsx. Exit Excel. Submit the file as directed. |
0 |
|
Total Points |
40 |
Requirements: SEE INSTRUCTIONS