Question

In: Finance

The finance department has been directed to reduce thecash-to-cash cycle time to 44.8 days.You...

The finance department has been directed to reduce the cash-to-cash cycle time to 44.8 days.

You are the warehouse manager and need to reduce the inventory to achieve that goal. Given the following information, what must your inventory level be?

Days in the period: 70

Sales: $14375000

AR: $4740000

AP: $6500000

Cost of Sales: 75.6

Solutions

Expert Solution

The amount is computed as shown below:

cost of sales is computed as follows:

= Sales x 75.6%

= $ 14375000 x 75.6%

= $ 10,867,500

cash to cash cycle time = days in the period x (Inventory / cost of sales + AR / Sales - AP / cost of sales)

44.8 = 70 x (Inventory / $ 10,867,500 + $ 4740000 / $ 14375000 - $ 6500000 / $ 14375000)

44.8 = 70 x (Inventory / $ 10,867,500 + 0.32973913 - 0.452173913)

0.64 = Inventory / $ 10,867,500 + 0.32973913 - 0.452173913

0.64 + 0.452173913 - 0.32973913 = Inventory / $ 10,867,500

Inventory = $ 8,285,760.004


Related Solutions

The finance department has been directed to reduce the cash-to-cash cycle time to 29.7 days. You...
The finance department has been directed to reduce the cash-to-cash cycle time to 29.7 days. You are the warehouse manager and need to reduce the inventory to achieve that goal. Given the following information, what must your inventory level be? Days in the period: 85 Sales: $14225000 AR: $2360000 AP: $5300000 Cost of Sales: 77.0 (Your answer should be in whole dollars)
The finance department has been directed to reduce the cash-to-cash cycle time to 35.9 days. You...
The finance department has been directed to reduce the cash-to-cash cycle time to 35.9 days. You are the accounts receivable manager and need to reduce the AR balance to achieve that goal. Given the following information, what must your AR balance be? Days in the period: 45 Sales: $15500000 Inventory: $2500000 AP: $5100000 Cost of Sales: 67.6 (Your answer should be in whole dollars)
As part of an effort to increase cash and reduce the cash cycle, the connections between...
As part of an effort to increase cash and reduce the cash cycle, the connections between the AP and AR processes are often scrutinized to see if the company is fully billing what it is entitled to bill … to this end, folks sometimes ask about "unbilled" and how long that "unbilled" has remained in that state … is number for "unbilled" best derived from what has been declared as revenue under 606 but not yet billed or as what...
A firm wants to reduce its cash conversion cycle. Which of the following steps would reduce...
A firm wants to reduce its cash conversion cycle. Which of the following steps would reduce its cash conversion cycle? The company reduces its average inventory without increasing its sales. The company increases its days sales outstanding (DSO). The company starts paying its bills sooner, which reduces its average accounts payable without reducing its sales. Statements A and B are correct.
Summarize the article and how does it relate to time value of money The finance department...
Summarize the article and how does it relate to time value of money The finance department and CFOs are getting closer and closer to the marketing department, and for once, it’s not because marketing is asking for more budget. Here’s why your CFO peers are shifting into digital strategy, how they’re interacting with the marketing department and what your organization can do to increase alignment. The Time Value Of Money Investing, at its very core, is about patience. You put...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and wants to apply it to her department. She has identified four basic activities her employees spend most of the their time on: Interviewing, Hiring, Assessment, and Separation Processing. The department employs 12 staff who perform these activities. The manager provides the following estimates for the amount of time it takes to complete each of these activities: Interviewing: 52 minutes. Hiring: 67 minutes. Assessment: 89...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and wants to apply it to her department. She has identified four basic activities her employees spend most of the their time on: Interviewing, Hiring, Assessment, and Separation Processing. The department employs 5 staff who perform these activities. The manager provides the following estimates for the amount of time it takes to complete each of these activities: Interviewing: 45 minutes. Hiring: 60 minutes. Assessment: 75...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and wants to apply it to her department. She has identified four basic activities her employees spend most of the their time on: Interviewing, Hiring, Assessment, and Separation Processing. The department employs 25 staff who perform these activities. The manager provides the following estimates for the amount of time it takes to complete each of these activities: Interviewing: 65 minutes. Hiring: 80 minutes. Assessment: 115...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and wants to apply it to her department. She has identified four basic activities her employees spend most of the their time on: Interviewing, Hiring, Assessment, and Separation Processing. The department employs 5 staff who perform these activities. The manager provides the following estimates for the amount of time it takes to complete each of these activities: Interviewing: 45 minutes. Hiring: 60 minutes. Assessment: 75...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and wants to apply it to her department. She has identified four basic activities her employees spend most of the their time on: Interviewing, Hiring, Assessment, and Separation Processing. The department employs 20 staff who perform these activities. The manager provides the following estimates for the amount of time it takes to complete each of these activities: Interviewing: 60 minutes. Hiring: 75 minutes. Assessment: 105...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT