5-2 Final Project Milestone Two- Draft of Inventory Management and Benchmarking
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
550
Subject
Accounting
Date
Apr 3, 2024
Type
docx
Pages
6
Uploaded by sherrybabe96
1
5-2 Final Project Milestone Two: Draft of Inventory Management and Benchmarking
Sherry Gerges
Southern New Hampshire University
ACC 550: Cost Accounting
Brian McCloskey
January 14
th
, 2024
2
Memorandum To:
President and Board From:
Sherry Gerges, CFO of the Hampshire Company Date:
January 14
th
, 2024 Subject:
Inventory Management and Benchmarking
In this memo, I will be discussing my analysis of sections II and III on the Hampshire Company Spreadsheet. I will touch base on inventory management and benchmarking. For inventory management I will determine an optimal cost allocation method besed on the relevant costs and I will describe how this method should be used by decision makers to fulfill their responsibilities. I will talk about the pros and cons of the just-in-time (JIT) system and I will identify the inventory management method that I recommend. I will also look into benchmarking
and what the advantage is to it and well as identifying possible approaches to benchmarking. Lastly, I will suggest which benchmarking method management should adopt and why. Inventory Management
Inventory management is the process that is used for companies to keep track of ordering,
storing, using and selling their inventory (Hayes, 2023). Relevant Costs
An optimal cost allocation method based on the relevant costs is the activity-based allocation method. This method “allocates costs based on the actual activities that drive expenses” (Imarticus, 2023).
3
Method
This method should be used by decision makers to fulfill their responsibilities by allowing them to be able to identify the cost drivers and assign costs properly. For example, if the decision makers find that a certain product in their inventory is using a lot of the resources that the company offers, decision makers might find it more beneficial to the company to higher the price of the product or find a cheaper way to produce it. Pros and Cons
There are many pros and cons for implementing the just-in-time (JIT) inventory system. A few pros are: production time for each product is short, costs are reduced because warehouse needs are minimized, and less money is spent because only what is needed for the orders is purchased and nothing extra (Banton, 2023). A few cons are: if a supplier can not deliver the raw
materials on time then there is a delay in the production line and if there is a random order for products that is not expected (Banton, 2023). For Hampshire Company, the pros outweigh the cons because it will allow for the company to ensure that there is no wasted materials and all the products and supplies are allocated properly. Inventory System
The just-in-time (JIT) inventory system can benefit this organization because it will allow
for the company to only order materials per order requested as opposed to having a lot of excess products lying around that are not sold. Based on section II of the spreadsheet, we can see that there is a lot of leftover inventory, $152,000 to be exact, which is a loss for the company because
it is a lot of unsold products. If the JIT inventory system is implemented, Hampshire Company would be able to minimize the ending inventory.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
4
Inventory The inventory management method that I recommend would be the just-in-time (JIT) inventory system because it would allow for the company to manage the amount of inventory they are holding in their warehouses, and it will improve cash flow. The only con to this inventory system
that our company should try to get ahead of is that they should ensure that they have a good understanding with the suppliers they are dealing with of what their ordering patterns are like so that they can reduce the risk of their being a stockout.
Benchmarking
Benchmarking can be used for a company to compare their accounting practices to the best in the industry (James, 2017). Advantage
The advantage to benchmarking in terms of improving companies’ performance is that it allows for the company to compare their practices to that of the best in the industry. This will allow them to see where they are lacking and see what they can do to improve. By doing this, they can set realistic targets for them to reach to become one of the best in the industry. Approaches
There are 4 types of approaches to benchmarking: internal, external, performance and practice. “Performance benchmarking involves gathering and comparing quantitative data (i.e., measures or key performance indicators)” (
What Are the Four Types of Benchmarking?
, 2019). “Practice benchmarking involves gathering and comparing qualitative information about how an activity is conducted through people, processes, and technology” (
What Are the Four Types of Benchmarking?
, 2019). “Internal benchmarking compares metrics (performance benchmarking) and/or practices (practice benchmarking) from different units, product lines, departments,
5
programs, geographies, etc., within the organization” (
What Are the Four Types of Benchmarking?
, 2019). “External benchmarking compares metrics and/or practices of one organization to one or many others” (
What Are the Four Types of Benchmarking?
, 2019). Benchmarking Method
The benchmarking method that I believe management should adopt is external benchmarking. This method will allow for the company to company their methods directly with their competitors to be able to identify where the company needs improvement.
6
References
Banton, C. (2023, December 19).
Just-in-Time (JIT): Definition, Example, and Pros & Cons
. Investopedia. https://www.investopedia.com/terms/j/jit.asp
Hayes, A. (2023, March 28).
Inventory management defined, plus methods and techniques
. Investopedia. https://www.investopedia.com/terms/i/inventory-management.asp
Imarticus. (2023, October 20). The pros and cons of top cost allocation methods.
Finance, Tech & Analytics Career Resources | Imarticus Blog
. https://imarticus.org/blog/the-pros-and-
cons-of-top-cost-allocation-methods/#:~:text=These%20methods%20aid%20in
%20accurate,diverse%20organisational%20structures%20and%20goals.
James, T. (2017, July 12).
Benchmarking Accounting Practices - Success tax professionals
. Success Tax Professionals. https://www.stptax.com/benchmarking-accounting-practices/
#:~:text=Benchmarking%20involves%20comparing%20your%20accounting,why
%20they%20perform%20so%20highly.
What are the Four Types of Benchmarking?
(2019, November 13). APQC. https://www.apqc.org/blog/what-are-four-types-benchmarking#:~:text=There
%20are%20four%20main%20types,measures%20or%20key%20performance
%20indicators).
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
M Question 4-CH
https://ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F... Q
37 ACG3343 2023 X M Question 3-Chapter X GEN Exercises
Homework i
Required Information
[The following information applies to the questions displayed below.]
Beginning WIP inventory
Direct materials
Conversion costs
Current period costs
Direct materials
Conversion costs
Check my work mode: This shows what is correct or Incorrect for the work you have completed so far. It doe
Annin Laboratories uses the FIFO method to account for its work-in-process Inventories. The accounting records show the
following Information for February:
Cost of goods transferred out
Cost of ending inventory
9
Quantity Information is obtained from the manufacturing records and includes the following:
Beginning inventory
Current period units started
Ending inventory
F2
Answer is complete but not entirely correct.
$ 181,069 X
Is
$ 115,010 X
$ 29,053
9,355
Compute the cost of goods transferred…
arrow_forward
Problem 5 *
Baby Co. recorded the following data pertaining to raw material X during January
2023:
Received
Your answer
Units
Cost
8.00
Date
1/1/23 Inventory
1/11/23 Issue
1/22/23 Purchase
4,000
9.40
The moving-average unit cost of X inventory on January 31, 2023, is.
Issued
1,600
on Hand
3,200
1,600
5,600
arrow_forward
Exercise 9-05
Presented below is information related to Crane Enterprises.
Jan. 31
Feb. 28
Mar. 31
Apr. 30
Inventory at cost
$15,150
$15,251
$17,170
$14.140
Inventory at LCNRV
14,645
12,726
15,756
13,433
Purchases for the month
17,170
24,240
26,765
Sales for the month
29,290
35,350
40,400
7 Your answer is partially correct. Try again.
From the information, prepare (as far as the data permit) monthly income statements in columnar form for February, March, and April. The inventory is to be shown in the statement at cost; the gain or loss due to market fluctuations is to be shown separately (using a valuation account). (Enter negative amounts using either a negative sign preceding the number e.g.
-45 or parentheses e.g. (45).)
February
March
April
Sales Revenue
Cost of Goods Sold
Inventory, Beginning
Purchases
Cost of Goods Available
arrow_forward
Review
View
Help
O Editing v
A A A
ミッニッ 三三>Tく
AaBbCc
AaBbCc
No Spacing
AaBbCc
AaBbCc
AaBbCc
Normal
Heading 1
Heading 2
Heading 3
Paragraph
Styles
Question 3:
Supersave Ltd. has the below inventory balances and other information at the end of Dec 2020.
Balances
Beginning
Ending
Direct Material
$
15,750.00
$
8,000.00
Working in Process Inventory
Finished Goods Inventory
$
2,850.00
24
3,500.00
2$
2,200.00
24
3,800.00
Other information
Purchase of Direct Material
50,000.00
Factory Supervisor Salaries
$
5,750.00
Sales Salaries and Commissions
24
7,250.00
Delivery Cost
2$
1,400.00
Sales Revenue
$
115,000.00
Factory Utility Costs
2$
1,200.00
Factory Rent
24
17,750.00
Direct Labor
$
26.000.00
Required:
Please calculate the amount of cost of goods manufactured.
DELL
arrow_forward
need solution for the problem p-22-3 from the book INTERMEDIATE ACCOUNTING AND REPORTING BY JAMES WAHLEN (3RD edition)
Koopman company began operations on january 1 2018,and uses FIFO inventory method....
problem attached as pictures
Required:
Prepare the 2020 Financial Statements
arrow_forward
answer in detail with concept introduction explanation calculation concept introduction steps correctly and completely in detail answer in text
arrow_forward
I need correct solution for correct answer with question is solution
arrow_forward
I need help with question is correct answer with solution
arrow_forward
Module Three Assignment - ACCX
* CengageNOWv2 | Online teachir x
ew.com/ilrm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogre... *
G| 曲
O eBook
Show Me How
Inventory turnover and number of days' sales in inventory
Financial statement data for years ending December 31 for Tango Company follow:
20Υ7
20Y6
Cost of goods sold
$3,864,000 $4,001,500
Inventories:
Beginning of year
770,000
740,000
End of year
840,000
770,000
Required
a. Determine the inventory turnover for 20Y7 and 20Y6. Round to one decimal place.
20Υ7
20Υ6
Inventory turnover
b. Determine the number of days' sales in inventory for 20Y7 and 20Y6. Use 365 days and round to one decimal place.
20Υ7
20Υ6
X days
X days
Number of days' sales in inventory
C. Are the changes in inventory turnover and the number of days' sales in inventory from 20Y6 to 20Y7 favorable or unfavorable?
Unfavorable
Feedback
Check My Work
a. The inventory turnover ratio indicates how many times a company has sold and…
arrow_forward
M Question 4 - Chapter 5, Assign X M Connect
zto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launch
211 AF Prin X
Maps O Porter's Five Forc...
5, Assignment 2 i
!
January 1
April 1
October 1
Required information
[The following information applies to the questions displayed below.]
The following information pertains to the inventory of Parvin Company during Year 2.
Beginning Inventory
Purchased
Purchased
FIFO General
Journal
FIFO T
accounts
https://lms.mheducation.com/n X
Url=https%253A%252F%252Flms.mheducation.com%252Fmghmiddlew
During Year 2, Parvin sold 3,500 units of inventory at $80 per unit and incurred $46,000 of operating expenses. Parvin
currently uses the FIFO method but is considering a change to LIFO. All transactions are cash transactions. Assume a 30
percent income tax rate. Parvin started the period with cash of $84,000, inventory of $11,100, common stock of $59,000,
and retained earnings of $36,100.
View transaction list
X
Required
a. Record the above…
arrow_forward
10-30
arrow_forward
Section 4: Problem for solving
arrow_forward
Question 5
Prepare the journal entry for the inventory write-down using the LCM, net realizable method
Company A is preparing their annual financial statements dated December 31,
20X1. Ending inventory is presently recorded at its total cost of $5,465.
Information about its inventory item is as follows:
Product Line
Quantity on
Hand
Unit Cost When Value at Year-End
Acquired (FIFO)
Product A
20
12
14
Product B
75
40
38
Product C
35
55
50
Product D
10
30
35
arrow_forward
PROBLEM 15
Preparation of Audit Working Paper for Adjusting Entries - Periodic System
The cost of goods sold section of the income statement prepared by your client, Happy People Company, for the year ended December 31, 2020
appears as follows:
Inventory, January 1
32,150
Purchases
211,720
243,870
Cost of goods available for sale
Inventory, December 31
Cost of goods sold
43,210
200,660
Although the books have been closed, your working paper trial balance is prepared showing all accounts with activity during the year. This is the
first time your firm has made an examination. The January 1 and December 31 inventories appearing above were determined by physical count
of the goods on hand on those dates and no reconciling items were discovered. All purchases are FOB shipping point.
In the course of your examination of the inventory cut-off, both at the beginning and end of the year, you discovered the following facts:
BEGINNING OF THE YEAR:
1. Invoices totalling P 3,640 were entered in the…
arrow_forward
5: Chapter 6 Homework ×
<
CengageNOWv2 | Online teach
Beginning inventory, purchases, and sales for an inventory item are as follows:
Sep. 1 Beginning Inventory 23 units @ $11
5 Sale
17 Purchase
30 Sale
14 units
Check My Work
26 units @ $14
14 units
Assuming a perpetual inventory system and the last-in, first-out method:
a. Determine the cost of the goods sold for the September 30 sale.
S
b. Determine the inventory on September 30.
$
+
Search
All work saved.
h
ASUS VIVOBOOK
E
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Corporate Financial Accounting
Accounting
ISBN:9781305653535
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning

Corporate Financial Accounting
Accounting
ISBN:9781337398169
Author:Carl Warren, Jeff Jones
Publisher:Cengage Learning

Financial & Managerial Accounting
Accounting
ISBN:9781337119207
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning

Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning
Related Questions
- M Question 4-CH https://ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F... Q 37 ACG3343 2023 X M Question 3-Chapter X GEN Exercises Homework i Required Information [The following information applies to the questions displayed below.] Beginning WIP inventory Direct materials Conversion costs Current period costs Direct materials Conversion costs Check my work mode: This shows what is correct or Incorrect for the work you have completed so far. It doe Annin Laboratories uses the FIFO method to account for its work-in-process Inventories. The accounting records show the following Information for February: Cost of goods transferred out Cost of ending inventory 9 Quantity Information is obtained from the manufacturing records and includes the following: Beginning inventory Current period units started Ending inventory F2 Answer is complete but not entirely correct. $ 181,069 X Is $ 115,010 X $ 29,053 9,355 Compute the cost of goods transferred…arrow_forwardProblem 5 * Baby Co. recorded the following data pertaining to raw material X during January 2023: Received Your answer Units Cost 8.00 Date 1/1/23 Inventory 1/11/23 Issue 1/22/23 Purchase 4,000 9.40 The moving-average unit cost of X inventory on January 31, 2023, is. Issued 1,600 on Hand 3,200 1,600 5,600arrow_forwardExercise 9-05 Presented below is information related to Crane Enterprises. Jan. 31 Feb. 28 Mar. 31 Apr. 30 Inventory at cost $15,150 $15,251 $17,170 $14.140 Inventory at LCNRV 14,645 12,726 15,756 13,433 Purchases for the month 17,170 24,240 26,765 Sales for the month 29,290 35,350 40,400 7 Your answer is partially correct. Try again. From the information, prepare (as far as the data permit) monthly income statements in columnar form for February, March, and April. The inventory is to be shown in the statement at cost; the gain or loss due to market fluctuations is to be shown separately (using a valuation account). (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) February March April Sales Revenue Cost of Goods Sold Inventory, Beginning Purchases Cost of Goods Availablearrow_forward
- Review View Help O Editing v A A A ミッニッ 三三>Tく AaBbCc AaBbCc No Spacing AaBbCc AaBbCc AaBbCc Normal Heading 1 Heading 2 Heading 3 Paragraph Styles Question 3: Supersave Ltd. has the below inventory balances and other information at the end of Dec 2020. Balances Beginning Ending Direct Material $ 15,750.00 $ 8,000.00 Working in Process Inventory Finished Goods Inventory $ 2,850.00 24 3,500.00 2$ 2,200.00 24 3,800.00 Other information Purchase of Direct Material 50,000.00 Factory Supervisor Salaries $ 5,750.00 Sales Salaries and Commissions 24 7,250.00 Delivery Cost 2$ 1,400.00 Sales Revenue $ 115,000.00 Factory Utility Costs 2$ 1,200.00 Factory Rent 24 17,750.00 Direct Labor $ 26.000.00 Required: Please calculate the amount of cost of goods manufactured. DELLarrow_forwardneed solution for the problem p-22-3 from the book INTERMEDIATE ACCOUNTING AND REPORTING BY JAMES WAHLEN (3RD edition) Koopman company began operations on january 1 2018,and uses FIFO inventory method.... problem attached as pictures Required: Prepare the 2020 Financial Statementsarrow_forwardanswer in detail with concept introduction explanation calculation concept introduction steps correctly and completely in detail answer in textarrow_forward
- I need correct solution for correct answer with question is solutionarrow_forwardI need help with question is correct answer with solutionarrow_forwardModule Three Assignment - ACCX * CengageNOWv2 | Online teachir x ew.com/ilrm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogre... * G| 曲 O eBook Show Me How Inventory turnover and number of days' sales in inventory Financial statement data for years ending December 31 for Tango Company follow: 20Υ7 20Y6 Cost of goods sold $3,864,000 $4,001,500 Inventories: Beginning of year 770,000 740,000 End of year 840,000 770,000 Required a. Determine the inventory turnover for 20Y7 and 20Y6. Round to one decimal place. 20Υ7 20Υ6 Inventory turnover b. Determine the number of days' sales in inventory for 20Y7 and 20Y6. Use 365 days and round to one decimal place. 20Υ7 20Υ6 X days X days Number of days' sales in inventory C. Are the changes in inventory turnover and the number of days' sales in inventory from 20Y6 to 20Y7 favorable or unfavorable? Unfavorable Feedback Check My Work a. The inventory turnover ratio indicates how many times a company has sold and…arrow_forward
- M Question 4 - Chapter 5, Assign X M Connect zto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launch 211 AF Prin X Maps O Porter's Five Forc... 5, Assignment 2 i ! January 1 April 1 October 1 Required information [The following information applies to the questions displayed below.] The following information pertains to the inventory of Parvin Company during Year 2. Beginning Inventory Purchased Purchased FIFO General Journal FIFO T accounts https://lms.mheducation.com/n X Url=https%253A%252F%252Flms.mheducation.com%252Fmghmiddlew During Year 2, Parvin sold 3,500 units of inventory at $80 per unit and incurred $46,000 of operating expenses. Parvin currently uses the FIFO method but is considering a change to LIFO. All transactions are cash transactions. Assume a 30 percent income tax rate. Parvin started the period with cash of $84,000, inventory of $11,100, common stock of $59,000, and retained earnings of $36,100. View transaction list X Required a. Record the above…arrow_forward10-30arrow_forwardSection 4: Problem for solvingarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Corporate Financial AccountingAccountingISBN:9781305653535Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningCorporate Financial AccountingAccountingISBN:9781337398169Author:Carl Warren, Jeff JonesPublisher:Cengage LearningFinancial & Managerial AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
- Accounting Information SystemsFinanceISBN:9781337552127Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan HillPublisher:Cengage Learning

Corporate Financial Accounting
Accounting
ISBN:9781305653535
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning

Corporate Financial Accounting
Accounting
ISBN:9781337398169
Author:Carl Warren, Jeff Jones
Publisher:Cengage Learning

Financial & Managerial Accounting
Accounting
ISBN:9781337119207
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning

Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning