Question

In: Finance

Suppose the following: Beginning Inventory = 11141 Ending Inventory= 12245 Beginning Receivables = 6450 Ending Receivables...

Suppose the following:

Beginning Inventory = 11141

Ending Inventory= 12245

Beginning Receivables = 6450

Ending Receivables = 6825

Beginning Payables = 8304

Ending Payables = 8758

Credit Sales = 91199

Cost of Goods Sold = 73243

Calculate the following (round final answers to 2 decimal places):

Operating Cycle = days

Cash Cycle = days

Expert Solution

Average inventory = ( beginning inventory + ending inventory)/2

Average inventory = (11141+12245)/2

Average inventory = 11693

Average Receivables= ( beginning Receivables+ ending Receivables)/2

Average Receivables = (6450+6825)/2

Average Receivables = 6637.5

Average Payables= ( beginning Payables+ ending Payables)/2

Average Payables = (8304+8758)/2

Average Payables = 8531

Purchases = COGS + beginning inventory - ending inventory

Purchases = 73243+11141-12245

Purchases = 72139

Inventory turnover = COGS/inventory

Inventory turnover = 73243/11693

Inventory turnover = 6.26

days of inventory on hand = number of days in a year/inventory turnover

days of inventory on hand = 365/6.26

days of inventory on hand = 58.31

Receivables turnover = Credit sales/receivables

Receivables turnover = 91199/6637.5

Receivables turnover = 13.74

days of sales outstanding = number of days in a year/receivables turnover

days of sales outstanding = 365/13.74

days of sales outstanding = 26.56

Accounts payables turnover = purchases/payables

Accounts payables turnover = 72139/8531

Accounts payables turnover = 8.46

days of payables outstanding = number of days in a year/inventory turnover

days of payables outstanding = 23/8.46

days of payables outstanding = 2.72

Operating cycle = days of sales outstanding + days of inventory on hand

Operating cycle = 26.56+58.31

Operating cycle = 84.87

Cash conversion cycle = Operating cycle - days of payables outstanding

Cash cycle = 84.87-2.72

Cash cycle = 82.15

jeff jeffy answered 2 years ago

Suppose the following: Beginning Inventory = 11202 Ending Inventory= 12259 Beginning Receivables = 6123 Ending Receivables...

Suppose the following: Beginning Inventory = 11202 Ending Inventory= 12259 Beginning Receivables = 6123 Ending Receivables = 6623 Beginning Payables = 8425 Ending Payables = 8827 Credit Sales = 91254 Cost of Goods Sold = 72320 Calculate the following (round final answers to 2 decimal places): Operating Cycle = days Cash Cycle = days

inventory: beginning $21,430 Ending $23,865 Accounts receivable: beginning $15,362 Ending $17,210 accounts payable: beginning $20,416 Ending...

inventory: beginning $21,430 Ending $23,865 Accounts receivable: beginning $15,362 Ending $17,210 accounts payable: beginning $20,416 Ending $21,803 net sales for the year: $243,612 cost of goods sold for the year: $108,915 what is the cash cycle?

Item Beginning Ending Inventory $17,385 $19,108 Accounts Receivables 13,182 13,973 Accounts Payables 15,385 16,676 Net Sales...

Item Beginning Ending Inventory $17,385 $19,108 Accounts Receivables 13,182 13,973 Accounts Payables 15,385 16,676 Net Sales $178,312 Cost of Goods Sold 140,382 Assume all Sales are made on credit. Given the information provided, compute the Receivables Period. Answer should include one decimal place.

Computing Cost of Goods Sold and Ending Inventory. Bartov Corporation reports the following beginning inventory and...

Computing Cost of Goods Sold and Ending Inventory. Bartov Corporation reports the following beginning inventory and purchases for 2017 Beginning Inventory 300 @ $8 each $2,400 Inventory Purchased 700 @ $10 each 7,000 Cost of goods available 1,000 units $9,400 Bartov sells 600 of these units in 2017. Compute its cost of goods sold for 2017 and the ending inventory reported on its 2017 balance sheet under each of the following inventory costing methods. (Do not round until final answer....

Inventory Errors Haywood Inc. reported the following information for 2018: Beginning inventory $25,000 Ending inventory 53,440...

Inventory Errors Haywood Inc. reported the following information for 2018: Beginning inventory $25,000 Ending inventory 53,440 Sales revenue 1,000,000 Cost of goods sold 620,000 A physical count of inventory at the end of the year showed that ending inventory was actually $65,000. Required: 1. What is the correct cost of goods sold and gross profit for 2018? Assuming the error was not corrected, what is the effect on the statement of financial position at December 31, 2018?

Consider the following financial statement information for the Mediate Corporation: Item Beginning Ending Inventory $...

Consider the following financial statement information for the Mediate Corporation: Item Beginning Ending Inventory $ 4,880 $ 6,310 Accounts receivable 2,963 3,831 Accounts payable 4,018 5,195 Credit sales $ 50,484 Cost of goods sold 30,640 Required: (a) Calculate the operating cycles. (Do not round your intermediate calculations.) (Click to select)42.09days91.21days94.86days36.34days87.56days (b) Calculate the cash cycle. (Do not round your intermediate calculations.)

Given the following information: Beginning Inventory $ 52,000 Ending Inventory 20,800 Sales 214,400 Purchases 69,600 Sales...

Given the following information: Beginning Inventory $ 52,000 Ending Inventory 20,800 Sales 214,400 Purchases 69,600 Sales Returns and Allowances 3,600 Purchase Discounts 2,400 Transportation-In 4,400 Purchase Returns and Allowances 3,600 Sales Discounts 1,920 Required: a. Determine net sales b. Determine net cost of purchases c. Determine gross margin d. Determine cost of goods available for sale e. Determine cost of goods sold (Show your work for each calculation labeling each amount included.)

The following information pertains to Mayberry Corporation: Beginning inventory 6,000 units Ending inventory 1,000 units Direct...

The following information pertains to Mayberry Corporation: Beginning inventory 6,000 units Ending inventory 1,000 units Direct labor per unit $40 Direct materials per unit 20 Variable overhead per unit 10 Fixed overhead per unit 30 Variable selling and admin. costs per unit 6 Fixed selling and admin. costs per unit 14 A) What is the value of the ending inventory using the absorption costing method? a) $600,000 b) $100,000 c) $120,000 d) $70,000 B) What is the value of the...

Ending inventory of work in process is $200,000 while the beginning inventory of work-in-process is $400,000....

Ending inventory of work in process is $200,000 while the beginning inventory of work-in-process is $400,000. The company had ending inventory of direct materials of $250,000 and beginning inventory of direct materials of $800,000. Direct materials purchased during the period was $700,000. Discount received on direct materials purchased was $150,000 while the cost of direct materials returned was $50,000. There were records of delivery expenses (freight-out) in the amount of $70,000; and as a result of FOB shipping point on...

1.) If budgeted beginning inventory is $8,800, budgeted ending inventory is $10,000, and budgeted cost of...

1.) If budgeted beginning inventory is $8,800, budgeted ending inventory is $10,000, and budgeted cost of goods sold is $10,760, budgeted purchases should be: $1,960 $760 $11,960 $1,200 $9,560 2.) Use the following information to determine the ending cash balance to be reported on the month ended June 30 cash budget. a. Beginning cash balance on June 1, $94,900. b. Cash receipts from sales, $417,500. c. Budgeted cash disbursements for purchases, $272,500. d. Budgeted cash disbursements for salaries, $95,900. e....