This assignment is based on the Jamestown case which is available on D2L (ABC Jamestown Case)....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This assignment is based on the Jamestown case which is available on D2L (ABC Jamestown Case). The purpose of this assignment is to give you an opportunity to learn about of some of the complexities involved in designing a real activity-based cost system and to start you thinking about how the resulting information will be used in managing a firm. We will not use the Part I requirements on p. 268. Instead, we will use the questions provided at the end of this assignment. We will focus on the three key customers that Jamestown is using as examples for its profitability analyses: Alanson, Boyne, and Conway. Exhibit 2 in the case provides estimates of profits from each of the three key customers. These estimates are not very credible to some managers at Jamestown. Use the information provided in Exhibits 4 and 5 and the accompanying text to create a new cost system that you can use to make better estimates of customer profits. More specific guidance is provided below for creating an alternative cost system to estimate customer profits. Guidance on designing a new cost system The controversies in the company appear to be focused on the costs of warehousing and shipping activities, so this is the part of the system that you need to redesign. A worksheet for cost system design is included in the Assignments folder. The row for "Special Handling" has been completed already. You will need to complete the other rows, choosing allocation bases (= cost drivers) based on information provided in the case. Here are some things to note: a) Typically we use budgeted MOH costs and budgeted activity levels to create MOH allocation rates. The 2007 activity costs from Exhibit 4 of the case are the budgeted" costs, and 2007 activity driver information are the "budgeted" quantity of the allocation bases. b) When taking numbers from the Exhibits in the case, be sure to pay attention to whether the numbers are given in $$, thousands of $$, physical units, etc. c) The total $$ volume of inventory stored at Jamestown is $16,630,890. The average dollar volume of inventory stored for a given customer can be estimated with this formula: COGS for customer * (customer's average number of days in inventory 365) d) Don't try to create separate allocation rates for automotive and non-automotive customers. The case provides no reason to believe that the costs of holding a given amount of inventory or processing an order of a given size are different for these two customer types. e) Assume that there is no difference in $$ size of order between orders that require special services and orders that do not. (Thus if 10% of a customer's orders require special services, then this represents 10% of its $$ volume of sales.) Excel requirements Always use formulas and cell addresses when you can, rather than typing in numbers. The output should be clearly labeled and easily readable. A reader should be able to understand quickly where all your numbers came from, by looking at your formulas and accompanying notes. For the analysis of profitability of each of the 3 customers, show 3 sections: (i) background data taken directly the case (e.g., number of orders, average days in inventory), (ii) intermediate calculations required (e.g., average value of inventory on hand, estimated sales volume of special orders), and (iii) a revised customer profitability statement in the same format as Exhibit 2 in the case. To submit: 1. Completed "Cost system" worksheet in the spreadsheet provided in Assignments folder. 2. Create a replacement for Exhibit 2, with new estimates of profit per customer. This should also be in Excel. When you calculate profits for the three key customers, you can use the same numbers for Sales, Cost of Goods Sold and General & Administrative Expenses that appear in Exhibit 2 of the case. 3. Brief answers to the following questions (Separate tab in your Excel file). a) In your new version of Exhibit 2, one customer will be much less profitable than it appeared to be in the original Exhibit 2, because the cost of serving this customer is high. According to your new cost system, what are two things that this customer does that generates such high costs for Jamestown? b) The time you have spent creating a new cost system is not worthwhile unless it enables Jamestown to make better management decisions that will improve its profits. Suggest two ways that Jamestown could improve its profits, which it could not do so easily without the information provided by your new cost system. Be sure to explain how the ABC costing system provides the information to support your suggested changes. Grading New cost system correct 1 points New customer profits correct 1 points Answers to questions 3a-b 2 points Use of formulas in Excel 1 points Check Figure: Conway Net Income = $58,120 This assignment is based on the Jamestown case which is available on D2L (ABC Jamestown Case). The purpose of this assignment is to give you an opportunity to learn about of some of the complexities involved in designing a real activity-based cost system and to start you thinking about how the resulting information will be used in managing a firm. We will not use the Part I requirements on p. 268. Instead, we will use the questions provided at the end of this assignment. We will focus on the three key customers that Jamestown is using as examples for its profitability analyses: Alanson, Boyne, and Conway. Exhibit 2 in the case provides estimates of profits from each of the three key customers. These estimates are not very credible to some managers at Jamestown. Use the information provided in Exhibits 4 and 5 and the accompanying text to create a new cost system that you can use to make better estimates of customer profits. More specific guidance is provided below for creating an alternative cost system to estimate customer profits. Guidance on designing a new cost system The controversies in the company appear to be focused on the costs of warehousing and shipping activities, so this is the part of the system that you need to redesign. A worksheet for cost system design is included in the Assignments folder. The row for "Special Handling" has been completed already. You will need to complete the other rows, choosing allocation bases (= cost drivers) based on information provided in the case. Here are some things to note: a) Typically we use budgeted MOH costs and budgeted activity levels to create MOH allocation rates. The 2007 activity costs from Exhibit 4 of the case are the budgeted" costs, and 2007 activity driver information are the "budgeted" quantity of the allocation bases. b) When taking numbers from the Exhibits in the case, be sure to pay attention to whether the numbers are given in $$, thousands of $$, physical units, etc. c) The total $$ volume of inventory stored at Jamestown is $16,630,890. The average dollar volume of inventory stored for a given customer can be estimated with this formula: COGS for customer * (customer's average number of days in inventory 365) d) Don't try to create separate allocation rates for automotive and non-automotive customers. The case provides no reason to believe that the costs of holding a given amount of inventory or processing an order of a given size are different for these two customer types. e) Assume that there is no difference in $$ size of order between orders that require special services and orders that do not. (Thus if 10% of a customer's orders require special services, then this represents 10% of its $$ volume of sales.) Excel requirements Always use formulas and cell addresses when you can, rather than typing in numbers. The output should be clearly labeled and easily readable. A reader should be able to understand quickly where all your numbers came from, by looking at your formulas and accompanying notes. For the analysis of profitability of each of the 3 customers, show 3 sections: (i) background data taken directly the case (e.g., number of orders, average days in inventory), (ii) intermediate calculations required (e.g., average value of inventory on hand, estimated sales volume of special orders), and (iii) a revised customer profitability statement in the same format as Exhibit 2 in the case. To submit: 1. Completed "Cost system" worksheet in the spreadsheet provided in Assignments folder. 2. Create a replacement for Exhibit 2, with new estimates of profit per customer. This should also be in Excel. When you calculate profits for the three key customers, you can use the same numbers for Sales, Cost of Goods Sold and General & Administrative Expenses that appear in Exhibit 2 of the case. 3. Brief answers to the following questions (Separate tab in your Excel file). a) In your new version of Exhibit 2, one customer will be much less profitable than it appeared to be in the original Exhibit 2, because the cost of serving this customer is high. According to your new cost system, what are two things that this customer does that generates such high costs for Jamestown? b) The time you have spent creating a new cost system is not worthwhile unless it enables Jamestown to make better management decisions that will improve its profits. Suggest two ways that Jamestown could improve its profits, which it could not do so easily without the information provided by your new cost system. Be sure to explain how the ABC costing system provides the information to support your suggested changes. Grading New cost system correct 1 points New customer profits correct 1 points Answers to questions 3a-b 2 points Use of formulas in Excel 1 points Check Figure: Conway Net Income = $58,120
Expert Answer:
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these accounting questions
-
A random sample of 5 0 suspension helmets used by motorcycle riders and automobile race - car drivers was subjected to an impact test, and on 2 2 of these helmets some damage was observed. Find a 9 9...
-
Image transcription text Module 5 Discussion A' Instructions: This discussion will be completed in two parts, and will give you an opportunity to reect upon this week's content and to interact with...
-
Available online at www.sciencedirect.com Operational Research in Sustainable Development and Civil Engineering - meeting of EURO working group and 15th German-Lithuanian-Polish colloquium...
-
A pack of iron bolts is such that the difference in masses or weights of successive sizes is the same bolt being of mass 13.5 grams and the largest is 94.5 grams. If the total mass of the complete...
-
Barbara and Dianne go target shooting. Suppose that each of Barbaras shots hits a wooden duck target with probability p1, while each shot of Diannes hits it with probability p2. Suppose that they...
-
Some economists and policymakers have argued that one way to control federal government spending on Medicare is to have a board of experts decide whether new medical technologies are worth their...
-
Refer to Exercise 5-4 and prepare the appropriate journal entries for DeSoto Co. to record the May 5 purchase and each of the three separate transactions a through c. DeSoto is a retailer that uses a...
-
Guardian, Inc. is trying to develop an asset-financing plan. The firm has $400,000 in temporary current assets and $300,000 in permanent current assets. Guardian also has $500,000 in fixed assets....
-
Hicks Cable Company has a defined benefit pension plan. Three alternative possibilities for pension-related data at January 1, 2024, are shown below: ($ in thousands) Case 1 Case 2 Case 3 Net loss...
-
Briefly explain the standardization process for the Internet related protocols
-
Compare the retailing channels used by Blue Nile and Tiffany. You may describe their retailing channels, summarize how these two companies operate differently, pros and cons, etc. b . What do you...
-
Following is information on an investment in a manufacturing machine. The machine has zero salvage value. The company requires a 3% return from its investments. Initial investment Net cash flows:...
-
Answer all questions with explanation What-If you have $185,500 available for part procurement for a new assembly line equipment, however the invoice amount is $500,000. If the annual interest rate...
-
Use the following to answer the next two questions, O'Donnell Industries generated the following income statement over the past year: Sales$36,000 Operating costs excluding depreciation 23,400...
-
Identify the key elements of the Just-in-time (JIT) Purchasing and Just-in-time (JIT) Porduction processes. Identify what elements would be more disrupted by the Cobid-19 virus and indicate why.
-
16. King Corporation produces a product that passes through two departments. For December, the following equivalent unit schedule was prepared for the first department: Units completed Units in EWIP...
-
What are the risks and liability factors in an audit? What are the implications to the auditor? What are the implications to the organization? How can the auditor mitigate these risks and liability...
-
What is the popular saying on which the cash flow fade method is founded?
-
Should the buyers costs be separated from the target companys costs in the cost savings that come out of a merger of two companies?
-
What is the cost of capital equal to?
Study smarter with the SolutionInn App