Management Accounting Assignment

Management accounting 
The following are various sales and cost data for Camelot Corporation for the year ended
December 31, 2020:
Finished goods inventory, January 1
$20,000
Finished goods inventory, December 31
40,000
Depreciation, factory
27,000
Administrative expenses
110,000
Utilities, Factory
8,000
Maintenance, factory
40,000
Indirect factory materials 11,000
Insurance, factory
4,000
Purchases of raw materials
75,000
Raw materials inventory, January 1
9,000
Raw material inventory, December 31
6,000
Direct factory labour
120,000
Indirect factory labour
15,000 Work in process inventory, January 1
17,000 Work in process inventory, December 31
30,000
Sales
500,000
Selling expenses
80,000
Required:
1. Prepare a schedule of cost of goods manufactured for the year ended December 31, 2020.
2. Prepare a schedule of cost of goods sold for the year ended December 31, 2020.
3. Prepare an income statement for the year ended December 31, 2020
Note:
You must answer this question using the Excel spreadsheet. Each part of the solution must be
entered in the appropriate tab set-up in the spreadsheet. Please make sure that your schedules
and statements have the appropriate titles and headings. Where calculation are involved, make
sure you use the appropriate functions embedded in Excel rather than doing the calculation on
your calculator and simply recording the final answer in the cell.

Cost Accounting 

Topic: Cost Accounting

 

Paper details:

About This Assignment Imagine you are the new CFO for a furniture manufacturer named American Furniture Company (AFC) that has only been in business for a few years. The company manufactures three products: wooden chairs, tables and dressers. AFC started off as a ‘Mom & Pop’ shop but has grown rapidly. AFC uses one assembly line to build all three products, and each product is hand-assembled before going through an automated painting process. You have been tasked with modernizing the company’s accounting methods towards their future goals. The four different parts of this assignment should be submitted together. While outside sources are NOT required for this assignment, formatting and citations for all parts of this assignment should be done in APA format. For more information on APA format, please see the section on APA Formatting below. Part #1 Justify to the CEO what type of costing method (job-order, process costing, variable costing and/or activity-based costing) you would recommend AFC use. Assume that all of the items produced are sold. Use the following accounting data in your analysis. (see part 1 screenshot) Production & Cost DescriptionProduction & Cost AmountsAnnual Production5000 chairs/10 batches; 4000 tables/20 batches; 3000 dressers/20 batchesRaw materials in board feet (BF) per unit1 chair = 10 BF; 1 table = 15 BF; 1 dresser = 20 BFRaw materials price per unit$2 per BFAssembly labor time (hours per unit)1 chair = 5 hours; 1 table = 7 hours; 1 dresser = 10 hoursLabor pay rate$15 per hourAssembly department overhead per direct labor hour$5Painting process machine hours (MH)1 chair = 0.5 MH; 1 table = 1.5 MH; 1 dresser = 2 MHPainting department overhead per MH$20Changeover cost per batch1 chair = $100; 1 table = $150; 1 dresser = $200Sales price1 chair = $180; 1 table = $270; 1 dresser = $270Fixed Cost$50,000Variable SG&A$5 per unitFixed SG&A$25,000 Within your analysis, make sure to include the following: Briefly discuss the advantages and disadvantages of the four costing methods.Narrow the choice down to two cost methods you would most recommend and provide your justification.Demonstrate how each of the two costing methods you chose would allocate overhead and administrative costs by calculating product costs using each method.Provide an income statement for each of the two methods.Recommend one of the two final costing methods, providing justification for your final costing method selection. Your justification should be between 1,000 to 1,500 words in length. Part #2 Determine what inventory cost flow assumption (weighted average, FIFO and/or LIFO) would be best suited for valuing inventory near the current replacement cost. You will make your analysis based on the following inventory transactions involving chairs only. Remember that the sales price of chairs is $180 per unit according to the table in Part 1. (see part 2 screenshot) TransactionGoodsPrice1/1 Beginning Inventory120 chairs$120/unit1/15 Transferred into finished goods140 chairs$130/unit3/15 Sold110 chairs$180/unit4/15 Transferred into finished goods100 chairs$140/unit6/15 Sold90 chairs$180/unit7/15 Transferred into finished goods130 chairs$150/unit9/15 Sold120 chairs$180/unit10/15 Transferred into finished goods140 chairs$160/unit12/15 Sold110 chairs$180/unit Within your analysis, make sure to include the following: Briefly discuss the advantages and disadvantages of each inventory costing assumption.Calculate the cost of goods sold and ending inventory for each cost flow assumption.Demonstrate which of these should be used to net the highest income during inflationary periods.Provide justification on what inventory costing assumption you choose.Record journal entries for each purchase and sales transaction listed. Your justification should be between 500 to 750 words in length. Part #3 You will need to submit a budget report to the CEO, including an explanation of the utility of master budgets. You will also submit a variance report that shows how the company is performing versus budgeted amounts. Use the following data. (see part 3 screenshot) Amount of Goods Sold Per Quarter: Q1Q2Q3Q4Chairs sold per quarter1150120012501400Tables sold per quarter90095010001150Dressers sold per quarter650700750900 Target Sales Goal Per Quarter: GoodsQuantityChairs1300Tables1100Dressers800 Q1 beginning inventory: GoodsQuantityChairs120Tables90Dressers70 Assume that the material and labor costs from Part 1 are standards. Compare those standard costs to the actual amounts listed below. These are the actual amounts used for the entire fiscal year: Actual amount of wood purchased and used46,120 bd. ft.Actual cost of wood purchased and used$80,028Actual amount of direct labor hours17,900Actual cost of direct labor$275,550 Within your analysis, make sure to include the following: Create variance reports for Q1, Q2, Q3, and Q4 against the Quarterly Budget.Generate a quarterly budget for the upcoming year that includes sales, production, materials and labor budgets. Assume a 10% increase in sales.Explain how a master budget can be a useful tool in aligning a company’s operations to its long-term goals.Discuss how a variance report can be used to direct management toward production issues. Your explanations of master budgets and variance reports should be 500 to 750 words in length. Part #4 Use the following data to generate a quote model for future business. This can be accomplished by performing a high-low or regression analysis to generate an equation relating direct labor hours to product cost: (see part 4 screenshot) YearQuarterDirect labor hrs.Manufacturing cost2014Q12,512$224,9502014Q22,432$214,1002014Q32,645$226,8402014Q42,723$228,7602015Q12,355$211,950 Within your analysis, make sure to include the following: Explain how jobs can be estimated by using a quote model based on previous data.Discuss the different methods of cost estimation.Prepare a bid for a job that would require 2,700 direct labor hours. Your justification should be between 350 to 500 words in length

Cost Accounting 

Topic: Cost Accounting

 

Paper details:

About This Assignment Imagine you are the new CFO for a furniture manufacturer named American Furniture Company (AFC) that has only been in business for a few years. The company manufactures three products: wooden chairs, tables and dressers. AFC started off as a ‘Mom & Pop’ shop but has grown rapidly. AFC uses one assembly line to build all three products, and each product is hand-assembled before going through an automated painting process. You have been tasked with modernizing the company’s accounting methods towards their future goals. The four different parts of this assignment should be submitted together. While outside sources are NOT required for this assignment, formatting and citations for all parts of this assignment should be done in APA format. For more information on APA format, please see the section on APA Formatting below. Part #1 Justify to the CEO what type of costing method (job-order, process costing, variable costing and/or activity-based costing) you would recommend AFC use. Assume that all of the items produced are sold. Use the following accounting data in your analysis. (see part 1 screenshot) Production & Cost DescriptionProduction & Cost AmountsAnnual Production5000 chairs/10 batches; 4000 tables/20 batches; 3000 dressers/20 batchesRaw materials in board feet (BF) per unit1 chair = 10 BF; 1 table = 15 BF; 1 dresser = 20 BFRaw materials price per unit$2 per BFAssembly labor time (hours per unit)1 chair = 5 hours; 1 table = 7 hours; 1 dresser = 10 hoursLabor pay rate$15 per hourAssembly department overhead per direct labor hour$5Painting process machine hours (MH)1 chair = 0.5 MH; 1 table = 1.5 MH; 1 dresser = 2 MHPainting department overhead per MH$20Changeover cost per batch1 chair = $100; 1 table = $150; 1 dresser = $200Sales price1 chair = $180; 1 table = $270; 1 dresser = $270Fixed Cost$50,000Variable SG&A$5 per unitFixed SG&A$25,000 Within your analysis, make sure to include the following: Briefly discuss the advantages and disadvantages of the four costing methods.Narrow the choice down to two cost methods you would most recommend and provide your justification.Demonstrate how each of the two costing methods you chose would allocate overhead and administrative costs by calculating product costs using each method.Provide an income statement for each of the two methods.Recommend one of the two final costing methods, providing justification for your final costing method selection. Your justification should be between 1,000 to 1,500 words in length. Part #2 Determine what inventory cost flow assumption (weighted average, FIFO and/or LIFO) would be best suited for valuing inventory near the current replacement cost. You will make your analysis based on the following inventory transactions involving chairs only. Remember that the sales price of chairs is $180 per unit according to the table in Part 1. (see part 2 screenshot) TransactionGoodsPrice1/1 Beginning Inventory120 chairs$120/unit1/15 Transferred into finished goods140 chairs$130/unit3/15 Sold110 chairs$180/unit4/15 Transferred into finished goods100 chairs$140/unit6/15 Sold90 chairs$180/unit7/15 Transferred into finished goods130 chairs$150/unit9/15 Sold120 chairs$180/unit10/15 Transferred into finished goods140 chairs$160/unit12/15 Sold110 chairs$180/unit Within your analysis, make sure to include the following: Briefly discuss the advantages and disadvantages of each inventory costing assumption.Calculate the cost of goods sold and ending inventory for each cost flow assumption.Demonstrate which of these should be used to net the highest income during inflationary periods.Provide justification on what inventory costing assumption you choose.Record journal entries for each purchase and sales transaction listed. Your justification should be between 500 to 750 words in length. Part #3 You will need to submit a budget report to the CEO, including an explanation of the utility of master budgets. You will also submit a variance report that shows how the company is performing versus budgeted amounts. Use the following data. (see part 3 screenshot) Amount of Goods Sold Per Quarter: Q1Q2Q3Q4Chairs sold per quarter1150120012501400Tables sold per quarter90095010001150Dressers sold per quarter650700750900 Target Sales Goal Per Quarter: GoodsQuantityChairs1300Tables1100Dressers800 Q1 beginning inventory: GoodsQuantityChairs120Tables90Dressers70 Assume that the material and labor costs from Part 1 are standards. Compare those standard costs to the actual amounts listed below. These are the actual amounts used for the entire fiscal year: Actual amount of wood purchased and used46,120 bd. ft.Actual cost of wood purchased and used$80,028Actual amount of direct labor hours17,900Actual cost of direct labor$275,550 Within your analysis, make sure to include the following: Create variance reports for Q1, Q2, Q3, and Q4 against the Quarterly Budget.Generate a quarterly budget for the upcoming year that includes sales, production, materials and labor budgets. Assume a 10% increase in sales.Explain how a master budget can be a useful tool in aligning a company’s operations to its long-term goals.Discuss how a variance report can be used to direct management toward production issues. Your explanations of master budgets and variance reports should be 500 to 750 words in length. Part #4 Use the following data to generate a quote model for future business. This can be accomplished by performing a high-low or regression analysis to generate an equation relating direct labor hours to product cost: (see part 4 screenshot) YearQuarterDirect labor hrs.Manufacturing cost2014Q12,512$224,9502014Q22,432$214,1002014Q32,645$226,8402014Q42,723$228,7602015Q12,355$211,950 Within your analysis, make sure to include the following: Explain how jobs can be estimated by using a quote model based on previous data.Discuss the different methods of cost estimation.Prepare a bid for a job that would require 2,700 direct labor hours. Your justification should be between 350 to 500 words in length

Managerial Accounting Paper

Managerial Accounting Paper
Your essay must include a cover page, introduction, body, conclusion, and a reference page. Be sure to address all relevant parts of each question. Your response should be a minimum of 1000 words in length (not including the cover page and the reference page). Cite all references you use in APA format. Note: You must use at least six (6) references. Proper citation format for a reference includes the name of the author(s), the title of the work, the date of the publication, and the page number.
1.Cost and Pricing
Many businesses are offering their products and services over the Internet. Find well known company and, determine the following: A product (or service) description A product price Based on your responses to parts (1) and (2), along with the description of the company’s business, identify the potential costs that are required to provide the product selected in part (1) and categorize them as fixed or variable. Which product do you believe has the largest contribution margin per incremental unit sold? Describe at least two types of standard costs your selected company might use. Additionally, explain the types of direct and overhead variances each of your selected organizations might encounter. Provide an example of each.
2. Activity-Based Costing Define activity-based costing (ABC) systems.
What benefits does implementing an ABC system bring to the company? Explain at least two benefits. What are the disadvantages to implementing an ABC system? List and explain at least two. Would the proposed changes make ABC a universally applicable costing method in your opinion? Why or why not? Elaborate your response.
3. Non-Financial Performance
Many city and county governments are discovering that you can control only what you measure. As a result, many municipal governments are introducing non-financial performance measures to help improve municipal services. Use the Google search engine to perform a search for “municipal government performance measurement.” Google will provide a list of Internet sites that outline various city efforts in using nonfinancial performance measures. Report on the types of measures used by one of the cities from the search.
4. Personal Investment Analysis
Find of the cost of a bachelor’s degree at the university of your choice assume additional costs of $16,000 for an additional fifth year of education to get Master’s degree. Assume that all tuition is paid at the beginning of the year. A student considering this investment must evaluate the present value of cash flows from possessing a graduate degree versus holding only the undergraduate degree. Assume that the average student with an undergraduate degree is expected to earn an annual salary of $55,000 per year (assumed to be paid at the end of the year) for 10 years. Assume that the average student with a graduate Masters degree is expected to earn an annual salary of $76,000 per year (assumed to be paid at the end of the year) for nine years after graduation. Assume a minimum rate of return of 10%. Determine the net present value of cash flows from an undergraduate degree. Use the present value table provided in this chapter 26. Determine the net present value of cash flows from a Masters degree, assuming that no salary is earned during the graduate year of schooling. What is the net advantage or disadvantage of pursuing a graduate degree under these assumption?

Managerial Accounting Paper

Managerial Accounting Paper
Your essay must include a cover page, introduction, body, conclusion, and a reference page. Be sure to address all relevant parts of each question. Your response should be a minimum of 1000 words in length (not including the cover page and the reference page). Cite all references you use in APA format. Note: You must use at least six (6) references. Proper citation format for a reference includes the name of the author(s), the title of the work, the date of the publication, and the page number.
1.Cost and Pricing
Many businesses are offering their products and services over the Internet. Find well known company and, determine the following: A product (or service) description A product price Based on your responses to parts (1) and (2), along with the description of the company’s business, identify the potential costs that are required to provide the product selected in part (1) and categorize them as fixed or variable. Which product do you believe has the largest contribution margin per incremental unit sold? Describe at least two types of standard costs your selected company might use. Additionally, explain the types of direct and overhead variances each of your selected organizations might encounter. Provide an example of each.
2. Activity-Based Costing Define activity-based costing (ABC) systems.
What benefits does implementing an ABC system bring to the company? Explain at least two benefits. What are the disadvantages to implementing an ABC system? List and explain at least two. Would the proposed changes make ABC a universally applicable costing method in your opinion? Why or why not? Elaborate your response.
3. Non-Financial Performance
Many city and county governments are discovering that you can control only what you measure. As a result, many municipal governments are introducing non-financial performance measures to help improve municipal services. Use the Google search engine to perform a search for “municipal government performance measurement.” Google will provide a list of Internet sites that outline various city efforts in using nonfinancial performance measures. Report on the types of measures used by one of the cities from the search.
4. Personal Investment Analysis
Find of the cost of a bachelor’s degree at the university of your choice assume additional costs of $16,000 for an additional fifth year of education to get Master’s degree. Assume that all tuition is paid at the beginning of the year. A student considering this investment must evaluate the present value of cash flows from possessing a graduate degree versus holding only the undergraduate degree. Assume that the average student with an undergraduate degree is expected to earn an annual salary of $55,000 per year (assumed to be paid at the end of the year) for 10 years. Assume that the average student with a graduate Masters degree is expected to earn an annual salary of $76,000 per year (assumed to be paid at the end of the year) for nine years after graduation. Assume a minimum rate of return of 10%. Determine the net present value of cash flows from an undergraduate degree. Use the present value table provided in this chapter 26. Determine the net present value of cash flows from a Masters degree, assuming that no salary is earned during the graduate year of schooling. What is the net advantage or disadvantage of pursuing a graduate degree under these assumption?

Accounting CAFR

Help me with the 8 questions.
The first file is book. The second file and the third file are the 8 questions we need to solve.
Requirements are as follow:
Examine the CAFR responses: Students will submit word document responses to “Examine the CAFR” questions relating to The City of Colton 2019 Comprehensive Annual Financial Report (CAFR) (available in course documents in McGraw-hill Connect and blackboard). Students will be expected to have read the questions and provide answers (including page references in the CAFR. The response for all Examine the CAFR questions are due on May 19, 2020 but I highly recommend students complete the response for each chapter before the quiz date of the chapter (it is very helpful to learning the material).

Accounting CAFR

Help me with the 8 questions.
The first file is book. The second file and the third file are the 8 questions we need to solve.
Requirements are as follow:
Examine the CAFR responses: Students will submit word document responses to “Examine the CAFR” questions relating to The City of Colton 2019 Comprehensive Annual Financial Report (CAFR) (available in course documents in McGraw-hill Connect and blackboard). Students will be expected to have read the questions and provide answers (including page references in the CAFR. The response for all Examine the CAFR questions are due on May 19, 2020 but I highly recommend students complete the response for each chapter before the quiz date of the chapter (it is very helpful to learning the material).

Challenges Facing Management Accountants in the 21st Century

Challenges Facing Management Accountants in the 21st Century and changes in the role of Management Accountant in the organizations 
Also….

Challenges Facing Management Accountants in the 21st Century

Challenges Facing Management Accountants in the 21st Century and changes in the role of Management Accountant in the organizations 
Also….

Challenges Facing Management Accountants in the 21st Century

Challenges Facing Management Accountants in the 21st Century and changes in the role of Management Accountant in the organizations 
Also….