Question

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. 10,000 units

b. 12,000 units

c. 11,000 units

2. How much inventory in dollars should ABC buy in Jan?

a. $100,000

b. 130,000

c. 78,000

Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1
Particulars Jan Feb
Budgeted sales in $ 100000 200000
Selling Price in $ 10 10
Units sold 10000 20000
Ending Inventory (20000*10%) 2000
Less: Opening Stock ($6000/6) 1000
Inventory shoukd Buy ( in Units) 11000
Inventory shoukd Buy ( in $) (11000*6) 66000

1. Inventory Should ABC Buy in January In Units is 11,000 units

2. Inventory Should ABC Buy in January In $ is $66,000/- (11,000*6).

Please like this answer it helps me a lot. Thank You.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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...
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?
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.
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 13,000 units April 28,000 units May 36,000 units June 12,000 units July 42,000 units August 69,000 units ABC Company sells its inventory to customers for $20 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 13,000 units April 27,000 units May 34,000 units June 10,000 units July 48,000 units August 69,000 units ABC Company sells its inventory to customers for $21 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
Spelling Company has the following sales projection (in units) for the next six months: Feb: 9500...
Spelling Company has the following sales projection (in units) for the next six months: Feb: 9500 Mar: 11000 Apr: 8500 May: 12000 Jun: 10000 Jul: 7500 Each unit sells for $30. Spelling has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 8500 12000 10000 30500 Selling price per unit x $30 x $30 x $30 Sales revenue $255000 $360000 $300000 $915000 Spelling's cost of goods sold...
Spelling Company has the following sales projection (in units) for the next six months: Feb: 19000...
Spelling Company has the following sales projection (in units) for the next six months: Feb: 19000 Mar: 21000 Apr: 17000 May: 24000 Jun: 20000 Jul: 15000 Each unit sells for $50. Spelling has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 17000 24000 20000 61000 Selling price per unit x $50 x $50 x $50 Sales revenue $850000 $1200000 $1000000 $3050000 Spelling's cost of goods sold...
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?...
The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and...
The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and September are 8,900, 20,000, 22,000, and 23,000 units, respectively. All sales are on credit. Forty percent of credit sales are collected in the month of the sale and 60% in the following month. The ending finished goods inventory equals 20% of the following month’s unit sales. The ending raw materials inventory equals 10% of the following month’s raw materials production needs. Each unit of...
ABC is forecasting its cash flows for the upcoming year. The forecast sales levels for each...
ABC is forecasting its cash flows for the upcoming year. The forecast sales levels for each month are shown below. On average, 10% of ABC's customers pay in the same month of the sale, 35% pay in the month after the sale, and the rest pay two months after the sale is made. Given that information, how much total cash inflow from sales should ABC actually receive during the three month period from July through September? Month Sales JAN 78,000...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT