Question

In: Operations Management

The following figures are extracted from the recent financial statements of a manufacturer called Technograph. The...

The following figures are extracted from the recent financial statements of a manufacturer called Technograph. The company produces custom-use monitors and has a large amount of working capital due to many purchases of electronic materials from suppliers, inventory of finished goods and work-in-process. However, due to recent hikes in loan rates the cost of financing has gone up and the management is not happy with the large amount of cash that is being tied up in the firm.

Management first wants to know how long cash is tied up in the operations, from the time it is spent on raw materials to the time it is recovered through sales.

All numbers are in thousands of dollars.
Starting inventory 12843
Ending inventory 1293
Starting Accounts Receivable 7193
Ending Accounts Receivable 6594
Starting Accounts Payable 4384
Ending Accounts Payable 5615
COGS 112101
Sales 130721

What is the Days of Inventory Outstanding? ____________________

What is the Days of Payables Outstanding? ____________________

What is the Days of Sales Outstanding? _______________________

Part 2)

What is the cash to cash cycle (cash conversion cycle) for the company? Answer in full days:

Solutions

Expert Solution

ANS 1) Days of Inventory outstanding is calculated by the following formula

Days of inventory outstanding= Average Inventory/Cost of goods sold(COGS)*No. of days in year

Average inventory=(starting inventory +closing inventory)/2

=(12843+ 1293)/2

=7068

Now, Days of inventory outstanding=7068/112101*365

=23.01 days

ANS 2) Days of Payables outstanding=Average accounts payable/COGS*365

Average accounts payable=(starting accounts payable+ending accounts payable)/2

=(4384+5615)/2

=4999.5

Now, Days of payables outstanding=4999.5/112101*365

=16.27 days

ANS 3) Days of sales outstanding=Average accounts receivables/COGS*365

Average accounts receivables=(starting accounts receivable+ending accounts receivable)/2

=(7193+6594)/2

=6893.5

Now, Days of sales outstanding= 6893.5/112101*365

=22.44 days

ANS 4) Cash to Cash Cycle= Days of inventory outstanding+Days of sales outstanding-Days of payables outstanding

=23.01+22.44-16.27

=29.18 days.


Related Solutions

(i) The following information is extracted from the financial statements of XERO
(i) The following information is extracted from the financial statements of XEROLimited:Cash $677,423 Accounts Payable $1,721,669Accounts Receivable $1,845,113 Notes Payable $2,113,345Inventories $1,312,478Total Current Assets $3,835,014 Total Current Liabilities $3,835,014Net Sales $9,912,332Cost $5,947,399 (a) Briefly explain what you understand by the term ‘operating cycle’. (1 mark)Click or tap here to enter text. (b) What is the operating cycle for XERO Limited? Click or tap here to enter text. (c) What can you say about XERO Limited’s accounts receivable and inventorymanagement if...
The following information was extracted from the 2020 financial statements of Arigato LLC:
The following information was extracted from the 2020 financial statements of Arigato LLC:Income from continuing operations before income tax           $755,123Selling and administrative expenses                                            480,357Income from continuing operations                                            495,951Gross profit                                                                                           1,357,530The amount reported for Other Revenue/Gains and Other Expenses/Losses is: $  Blank 1. Fill in the blank, read surrounding text.Use “-“ sign for negative amount, as needed. Use commas, as needed.
The following financial information was extracted from MCL’s current draft financial statements and those of the...
The following financial information was extracted from MCL’s current draft financial statements and those of the previous year:​ 2017 ($M) 2016 ($M) 2015 ($M) Revenue 220 260 240 Total assets 260 280 250 Net Profit before tax 19 (3) 17 The car parts and accessories industry has been very competitive and consumer demand appears to be slowing in anticipation of change with electric and driverless cars coming into the market. The company has recently restructured its operations to outsource its...
The following are extracted from the financial statements of Frem, Inc., for 2012, 2011, and 2010....
The following are extracted from the financial statements of Frem, Inc., for 2012, 2011, and 2010. 2012 2011 2010 Net sales $233,000 $204,000 Cost of sales (124,000) (110,000) Selling and administrative expenses (95,000) (81,500) Other income:    Interest (3,700) (3,050)    Other      100    1,175 Earnings before tax and extraordinary credit $ 10,400 $ 10,625 Provision for income tax (4,800) (4,740) Earnings before extraordinary credit 5,600 5,885 Extraordinary credit       -    1,510 $  5,600 $  7,395 Total assets $202,000 $173,000 $161,000 Long-term debt 24,600 17,400 15,200...
The following information has been extracted from the financial statements of a company. Use it to...
The following information has been extracted from the financial statements of a company. Use it to answer the 4 questions that follow it. When answering the questions (filling in the blanks), DO NOT use dollar signs, USE commas to separate thousands, DO NOT use parenthesis to denote negative numbers, USE the negative sign in front of first digit for negative numbers. Round to the nearest dollar. Earnings before interests and taxes: EBIT in 2020 = 600 Tax rate: T =  ...
The following information has been extracted from the financial statements of a company. Use it to...
The following information has been extracted from the financial statements of a company. Use it to answer the 4 questions that follow it. When answering the questions (filling in the blanks), DO NOT use dollar signs, USE commas to separate thousands, DO NOT use parenthesis to denote negative numbers, USE the negative sign in front of first digit for negative numbers. Round to the nearest dollar. Earnings before interests and taxes: EBIT in 2020 = 400 Tax rate: T =  ...
FINANCIAL STATEMENT ANALYSIS AND INTERPRETATION The following information has been extracted from the financial statements and...
FINANCIAL STATEMENT ANALYSIS AND INTERPRETATION The following information has been extracted from the financial statements and notes of Brown Ltd. 2014 2013 Revenue $ 870 000 $ 862 500 Interest expense 34 500 39 750 Income tax expense 66 900 39 750 Profit 78 750 84 150 Dividends 42 000 42 000 Total assets 810 000 832 500 Total debt 429 750 458 250 Share capital 258 000 243 000 Retained earnings 122 250 131 250 Required: Using the above...
Financial Statement Elements: Manufacturer The following selected information was extracted from the 20x1 accounting records of...
Financial Statement Elements: Manufacturer The following selected information was extracted from the 20x1 accounting records of Lone Oak Products: Raw material purchases $175,000 Direct labor 254,000 Indirect labor 109,000 Selling and administrative salaries 133,000 Building depreciation 80,000 Other selling and administrative expenses 195,000 Other factory costs 344,000 sales revenue ($130perunil) 1,495,000 *Seventy five percent of the company's building was devoted to production activities; the remaining 25 percent was used for selling and administrative functions. Inventory data: January1 December 31 Raw...
The following information as at the year-end date is extracted from the Freddy Corporation's financial statements:...
The following information as at the year-end date is extracted from the Freddy Corporation's financial statements: December 31 2019 ($) 2018 ($) Cash 95,000 27,000 Accounts receivable 92,000 80,000 Allowance for doubtful accounts (4,500) (3,100) Inventory 155,000 175,000 Prepaid expenses 7,500 6,800 Land 90,000 60,000 Buildings 287,000 244,000 Buildings - Accumulated depreciation (32,000) (13,000) Machinery 50,000 60,000 Machinery- Accumulated depreciation (30,000) (25,000) Leased equipment* 28,594 - Leased equipment - Accumulated depreciation (9,531)                          - 729,063 611,700 Accounts payable 90,000 84,000 Accrued...
1 The following information is extracted from the financial statements of Tasty Road Bhd. at 31...
1 The following information is extracted from the financial statements of Tasty Road Bhd. at 31 December 2018. Tasty Road Bhd. Statement of Financial Position as at 31 December 2018 RM’000 Assets 2700 Cash 2700 Trade Receivable(Net) 400 Interest Receivable 1100 Inventory 2000 Plant 2000 Research & Development 8000 Total 16,800 Equity & Liabilities Trade Payable 2,900 Loan 4,650 Provision for Warranties 150 Deferred tax liability 290 Share Capital 7,000 Retained Earnings 1.750 Total 16,800 RM’000 Additional information for relevant...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT