Question

A company plans to purchase inventory for the second half of 2014 as follows: July $100,000...

A company plans to purchase inventory for the second half of 2014 as follows: July $100,000 August $75,000 September $225,000 October $125,000 November $250,000 December $30,000

They usually pay 50% of inventory purchases in the month of purchase, 35% in the following month, and 15% in the second month.

Based on this information, what are the forecasted total 2014 cash payments for inventory purchased in the second half of 2014?

Homework Answers

Answer #1

forecasted total 2014 cash payments for inventory purchased in the second half of 2014

is the payment made in 2014 for inventory purchased in 2014

As per the payment pattern, all amount will be paid in second half itself except 15% of inventory purchased in November and 50% of Inventory purchased in December

Hence, payments = 100,000+75,000+225,000+125,000+250,000*85% + 30,000*50%

= $752,500

Note: Please check the figure for December, Is it 30,000 or 300,000?

The answer has been given on the basis of stated figure of 30,000

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Walker Company prepares monthly budgets. The current budget plans for a September ending merchandise inventory of...
Walker Company prepares monthly budgets. The current budget plans for a September ending merchandise inventory of 30,000 units. Company policy is to end each month with merchandise inventory equal to 15% of budgeted sales for the following month. Budgeted sales and merchandise purchases for the next three months follow. The company budgets sales of 200,000 units in October. Sales (Units) Purchases (Units) July 170,000 191,000 August 310,000 308,500 September 300,000 285,000 Prepare the merchandise purchases budgets for the months of...
It is November 1 of Year 1. Sales for Burt Company for November and December of...
It is November 1 of Year 1. Sales for Burt Company for November and December of Year 1 and January of Year 2 are forecasted to be as follows: November, 300,000; December 700,000; January, 200,000 On average, cost of goods sold is 60% of sales. During this period, Burt Company expects inventory levels to remain constant. This means that inventory purchases are expected to equal the amount of cost of goods sold. 90% of purchases are on credit. Of the...
It is November 1 of Year 1. Sales for Corbin Company for November and December of...
It is November 1 of Year 1. Sales for Corbin Company for November and December of Year 1 and January of Year 2 are forecasted to be as follows: November, 400,000; December 600,000; January, 200,000 On average, cost of goods sold is 70% of sales. During this period, Corbin Company expects inventory levels to remain constant. This means that inventory purchases are expected to equal the amount of cost of goods sold. 40% of purchases are for cash. Of the...
Hardy Company’s cost of goods sold is consistently 60% of sales. The company plans ending merchandise...
Hardy Company’s cost of goods sold is consistently 60% of sales. The company plans ending merchandise inventory for each month equal to 30% of the next month’s budgeted cost of goods sold. All merchandise is purchased on credit, and 40% of the purchases made during a month is paid for in that month. Another 45% is paid for during the first month after purchase, and the remaining 15% is paid for during the second month after purchase. Expected sales are:...
E22-28 Purchases and Cash Budgets On July 1, MTC Wholesalers had a cash balance of $175,000...
E22-28 Purchases and Cash Budgets On July 1, MTC Wholesalers had a cash balance of $175,000 and accounts payable of $99,000. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual Sales. Month Budgeted Sales May $150,000 July $90,000 June 160,000 August 80,000 September 100,000 October 120,000 All sales are on credit with 75 percent collected during the month of sales, 20 percent collected during the next month, and 5 percent collected...
C. The Sun Pacific Company budgeted the following sales: July​​200,000 August​​210,000 September​190,000 Sales in May were...
C. The Sun Pacific Company budgeted the following sales: July​​200,000 August​​210,000 September​190,000 Sales in May were 190,000 and in June 180,000. 60% of sales are cash, 30% of sales are to be collected the next month, and the remaining 10% in 2 months. Budgeted purchases of the required materials for production are: July​​100,000 August​​105,000 September​95,000 Purchases in June were 90,000. 70% of purchases are cash and 30% should be paid the next month. Direct Labor is 35% of purchases Selling...
V had actual sales and purchases for July and August 2020 as given in the Excel...
V had actual sales and purchases for July and August 2020 as given in the Excel spreadsheet, along with its forecast sales and purchases for the period September 2020 through February 2021. The firm makes 30% of all sales for cash and collects 35% of its sales in each of the two months following the sale. Other cash inflows are expected to be $22,000 in September and February, $25,000 in November and January, and $37,000 in December. The firm pays...
The following information pertains to Amigo Corporation:         Month                        &
The following information pertains to Amigo Corporation:         Month                                  Sales             Purchases         July                                  $30,000                 $10,000         August                               34,000                   12,000         September 38,000                   14,000         October                             42,000                   16,000         November 48,000                   18,000         December                         60,000                   20,000 Cash is collected from customers in the following manner:         Month of sale 45%         Month following sale 40%         Two months following sale                               10%         Amount uncollectible 5% 50% of purchases are paid for in cash in the month of purchase, and the other 50% is paid the...
Green lighting supply plans inventory levels (at cost) at the end of each month as follows:...
Green lighting supply plans inventory levels (at cost) at the end of each month as follows: May, $271,000; June, $226,000; July, $209,000; and August, $241,000. Sales are expected to be June, $449,000; July, $359,000; and August, $306,000. Cost of goods sold is 65% of sales. Purchases in April were $258,000 and in May they were $188,000. Payments for each month’s purchases are made as follows: 15% during that month, 70% the next month, and the final 15% the next month....
Jones company has sales of $400,000 in July and $500,000 in August. It’s purchases are $250,000...
Jones company has sales of $400,000 in July and $500,000 in August. It’s purchases are $250,000 in July and $300,000 in August. Accounts payable at the beginning of July are $110,000. All sales are for cash. Payments for purchases are paid for half in the month of purchase and half in the following month. Expenses for each month are the following; rent $10,000; depreciation, $4,000; Utilities, $1,000; sales salaries, 10% of sales; administrative expenses, 5% of sales. Prepare a cash...