Question

The budgeted sales for Jan, Feb and March are $40,000, $90,000 and $80,000 respectively. The inventory...

The budgeted sales for Jan, Feb and March are $40,000, $90,000 and $80,000 respectively. The inventory policy is to keep 80% COS of the following month plus 40% COS of the second following month.

What is budgeted purchase amount for January if   

the cost of sales (COS) is 75% and the beginning Inventory is $68,000?

Homework Answers

Answer #1

--Budgeted purchase amount for January = $ 40,000

Sales for January $40,000
Cost of Goods Sold for January $30,000
Desired ending inventory for January $78,000
Less: Beginning inventory for January $68,000
Budgeted purchase amount for January $40,000

--Working

Sales for January 40000
Cost of Goods Sold for January =40000*75%
Desired ending inventory for January =+(90000*75%*80%)+(80000*75%*40%)
Less: Beginning inventory for January 68000
Budgeted purchase amount for January =+78000 - 68000
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
ABC company has budgeted the following sales: Jan: $100,000 Feb: $200,000 March: $250,000 COGS is 60%...
ABC company has budgeted the following sales: Jan: $100,000 Feb: $200,000 March: $250,000 COGS is 60% of sales and the unit cost is $6. The selling price is $10 per unit In addition to having enough units to meet monthly sales, ABC would like ending inventory to be equal to 10% of the following months sales. Inventory at Dec 31 $6,000 at a cost of $6 per unit 1. How much inventory in units should ABC buy in January? a....
The O'Brien Company has the following information available: Month                        Budgeted Sales Jan     
The O'Brien Company has the following information available: Month                        Budgeted Sales Jan                                          $150,000 Feb                                            153,000 March                                       151,000 April                                         254,500 May                                          252,500 The gross profit rate is 20% and the desired ending inventory level is 10% of the next month's cost of sales. Required: Prepare purchase and cost of goods sold budget for Feb, March, and April.
4. The Khaki Company has the following budgeted sales data: January February March April Credit Sales...
4. The Khaki Company has the following budgeted sales data: January February March April Credit Sales $350,000 $320,000 $400,000 $360,000 Cash Sales $70,000 $90,000 $80,000 $70,000 The regular pattern of collection of credit sales is 30% in the month of sales, 25% in the month following sales, and the remainder in the second month following the month of sale. There are no bad debts. Required: a. Determine budgeted cash receipts for April. b. Determine budgeted accounts receivable balance on March...
The sales budget is provided below for the product of Company ABC. Jan 30,000 units Feb...
The sales budget is provided below for the product of Company ABC. Jan 30,000 units Feb 20,000 units Mar 10,000 units Apr 20,000 units May 30,000 units Finished goods at the end of each month must be 10% of the next month’s budgeted sales. On Dec 31 of the last year, the finished goods totaled 2,000 units. The selling price is $1 per unit. 80% of the credit sales are collected in the month of sale, 15% in the month...
Upstairs Company has the following data: Month Budgeted Sales January $108,000 February 132,000 March 144,000 April...
Upstairs Company has the following data: Month Budgeted Sales January $108,000 February 132,000 March 144,000 April 120,000 The gross profit rate is 40% of sales and ending inventory at December 31 was $19,440. Desired ending inventory levels are 30% of next month's sales at cost. What are the expected total purchases for February? A) $79,200 B) $81,360 C) $102,960 D) $105,120 Answer: B The correct option:B) $ 81,360 Can someone show me the steps to below numbers? the calculation steps?...
Company A developed the following budgeted data: Budgeted Sales…… 70% of sales on account are collected...
Company A developed the following budgeted data: Budgeted Sales…… 70% of sales on account are collected in the month of sale, 15% of sales on account are collected in the first month following the sale, 10% of sales on account are collected in the second month following the sale. Total budgeted sales in June ($40,000 of total sales are sales on account) $80,000 Total budgeted sales in July ($40,000 of total sales are sales on account) $95,000 Total budgeted sales...
Company A developed the following budgeted data: Budgeted Sales…… 70% of sales on account are collected...
Company A developed the following budgeted data: Budgeted Sales…… 70% of sales on account are collected in the month of sale, 15% of sales on account are collected in the first month following the sale, 10% of sales on account are collected in the second month following the sale. Total budgeted sales in June ($40,000 of total sales are sales on account) $80,000 Total budgeted sales in July ($40,000 of total sales are sales on account) $95,000 Total budgeted sales...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six months of 2010 are as follows: Month Unit Sales Month Unit Sales January 130,000 April 190,000 February 160,000 May 190,000 March 190,000 June 230,000 Beginning inventory for 2010 is 40,000 units. The budgeted inventory at the end of a month is 20 percent of units to be sold the following month. Purchase price per unit is $3. Prepare a purchases budget in units and...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $254,600 $39,100 February 220,900 46,100 March 326,000 48,500 Nieto’s sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto’s purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $215,000 $33,800 February 253,000 44,500 March 262,000 39,200 Nieto’s sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto’s purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...