Question

The Waller Merchandise Company (a retailer) has budgeted $100,000 in sales for the month of December....

The Waller Merchandise Company (a retailer) has budgeted $100,000 in sales for the month of December. The company's gross margin % is 43%. The company wants to increase inventory by $9,500 during the month.

Compute Waller's budgeted purchases for December.

Homework Answers

Answer #1

Solution:

Given data :

Budgeted Sales = $1,00,000

Gross Margin = 43%

Computation of Gross Profit -

Gross Profit = Sales * GP %

= $1,00,000 * 43%

= $43,000

Let us Assume -

Opening Stock = $X

Hence closing stock = $X+$9,500

Cost of goods sold = Sales - Gross profit

= $(1,00,000 - 43,000)

= $57,000

Cost Of Goods Sold is also = Opening stock + Purchases - Closing Stock

   $57,000 = $X + Purchases - ($X+$9,500)

$57,000 = $x + purchases - $X - $9,500

    $ 57,000 + $ 9,500 = Purchases

$66,500 = Purchases

Therefore Budgeted Purchases for December = $66,500 .

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
Upstairs Company has the following data: Month                Budgeted Sales January               &nbs
Upstairs Company has the following data: Month                Budgeted Sales January                        $112,000 February                        125,000 March                            132,000 April                              120,000 The gross profit rate is 40% of sales and ending inventory at December 31 was $26,325. Desired ending inventory levels are 25% of next month's sales at cost. What are the expected total purchases for March? A) $77,400 B) $86,480 C) $100,750 D) $105,575
Ahmed Company purchases all merchandise on credit. It recently budgeted the following month-end accounts payable balances...
Ahmed Company purchases all merchandise on credit. It recently budgeted the following month-end accounts payable balances and merchandise inventory balances. Cash payments on accounts payable during each month are expected to be: May, $1,400,000; June, $1,400,000; July, $1,250,000; and August, $1,300,000 Accounts Payable Merchandise Inventory May 31 $ 180,000 $ 250,000 June 30 160,000 300,000 July 31 300,000 400,000 August 31 180,000 300,000 (1) Compute the budgeted amounts of merchandise purchases. Budgeted amounts: June July August Ending accounts payable Payments...
Cooper Company, a retailer of camping supplies has budgeted activity for January using the following data:...
Cooper Company, a retailer of camping supplies has budgeted activity for January using the following data: Cash sales $26,200 Credit sales (60% collected in month of sale) 409,900 Selling and administrative costs (including depreciation) 52,610 Depreciation expense 4,890 Merchandise Inventory, January 1 21,110 Merchandise Inventory, January 31 21,580 Beginning cash balance 2,730 Minimum cash balance required 2,300 Cost of goods sold is 57% of Cooper’s selling price All purchases are paid in cash Selling and administrative costs are paid in...
Below is budgeted production and sales information for Flushing Company for the month of December: Product...
Below is budgeted production and sales information for Flushing Company for the month of December: Product XXX Product ZZZ Estimated beginning inventory 31,000 units 17,300 units Desired ending inventory 34,800 units 15,400 units Region I, anticipated sales 327,000 units 251,000 units Region II, anticipated sales 183,000 units 142,000 units The unit selling price for product XXX is $7 and for product ZZZ is $15. Budgeted production for product ZZZ during the month is 575,800 units 393,000 units 408,400 units 391,100...
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?...
Simone Company reported the following information for 2020:          September October November December January Budgeted sales $240,000...
Simone Company reported the following information for 2020:          September October November December January Budgeted sales $240,000 $310,000 $290,000 $360,000 $200,000 Budgeted purchases $90,000 $120,000 $128,000 $144,000 $88,000 Available information: Cost of goods sold is 35% of sales. Simone purchases and pays for merchandise 60% in the month of acquisition and 40% in the following month. Accounts payable is used only for inventory acquisitions. How much is the budgeted balance for Accounts Payable at October 31, 2020? Select one: a. $48,000...
Salem Company reported the following information for 2018: October November December Budgeted sales $300,000 $320,000 $360,000...
Salem Company reported the following information for 2018: October November December Budgeted sales $300,000 $320,000 $360,000 Budgeted purchases $120,000 $128,000 $144,000 All sales are on credit. Customer amounts on account are collected 60% in the month of sale and 40% in the following month. Instructions: Compute the amount of cash Salem will receive during November. Show your work.
Funnel Manufacturing Company has provided the follwoing information: Month Budgeted Sales January $ 76,000 February 85,000...
Funnel Manufacturing Company has provided the follwoing information: Month Budgeted Sales January $ 76,000 February 85,000 March 92,000 April 79,000 Budgeted Selling and Administrative Expenses Per Month are as follows: Wages, $15,000 Advertising, $12,000 Depreciation, $3,000 Other, 4 percent of Sales Cost of Goods Sold is 60% of Sales. All inventory is purchased in the month it is sold. Inventory purchases are paid 2/3 in the month of purchase, the remaining 1/3 paid in the following month.   How much cash...
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding...
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $85,000 $75,000 $85,000 Credit Sales 85,000 90,000 93,500 Total 170,000 165,000 178,500 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month following the...
9. A retailer has a beginning monthly inventory valued at $80,000 at retail and $52,500 at...
9. A retailer has a beginning monthly inventory valued at $80,000 at retail and $52,500 at cost. Net purchases during the month are $190,000 at retail and $115,000 at cost. Transportation charges are $10,500. Sales are $225,000. Markdowns and discounts equal $30,000. A physical inventory at the end of the month shows merchandise valued at $15,000 (at retail) on hand. Compute the following: a. Total merchandise available for sale:at cost and at retail. b. Cost complement c. Ending retail book...