Question

In: Accounting

Contigo Company provided the following information related to its inventory sales. Actual – December: 80,000 Budgeted-January:...

Contigo Company provided the following information related to its inventory sales.

Actual – December: 80,000

Budgeted-January: 140,000

Budgeted-February: 180,000

Budgeted-March: 120,000

Contigo desired ending inventory levels are 20% of the following months projected COGS. Budgeted purchases of inventory in February 2017 would have been:

Solutions

Expert Solution

  • All working forms part of the answer
  • Budgeted purchases of inventory in February = Budgeted sales + Desired ending inventory (20% x 120000 sales of march) – Beginning Inventory (equal to Ending inventory on January)
  • Working, complete for all months:

Working

December

January

February

March

A

Sales Units

                                  80,000

                                              140,000

                         180,000

                120,000

B = 20% of next month's 'A'

Desired ending Inventory

                                  28,000

                                                36,000

                           24,000

                            -  

C = A+B

Total needs

                                108,000

                                              176,000

                         204,000

                120,000

D = Last month's 'B'

Beginning Inventory

                                           -  

                                                28,000

                           36,000

                  24,000

E = C - D

Budgeted Purchases

                                108,000

                                              148,000

                         168,000 = ANSWER

                  96,000

  • Hence, The Budgeted purchases of Inventory in February = 168,000


Related Solutions

Information pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019...
Information pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019 (Budgeted) Cash sales $ 80,000 $ 100,000 $ 60,000 Credit sales 240,000 360,000 180,000 Total sales $ 320,000 $ 460,000 $ 240,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next...
Information pertaining to Noskey Corporation’s sales revenue follows: November 2015 (Actual) December 2015 (Budgeted) January 2016...
Information pertaining to Noskey Corporation’s sales revenue follows: November 2015 (Actual) December 2015 (Budgeted) January 2016 (Budgeted)   Cash sales $ 155,000   $ 145,000     $ 90,000     Credit sales 330,000   465,000     240,000     Total sales $ 485,000 $ 610,000     $ 330,000     Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the...
Tyler Company has the following information related to purchases and sales of one of its inventory items.
Inventory Costing MethodsTyler Company has the following information related to purchases and sales of one of its inventory items.DateDescriptionUnits Purchased at CostUnits Sold at RetailSept. 1Beginning inventory400 units @ $16Sept. 10Purchase600 units @ $18Sept. 20Sales690 units @ $31Sept. 25Purchase800 units at $19Assume the company uses a perpetual inventory system.Required:Calculate ending inventory and cost of goods sold using the FIFO, LIFO, and average cost methods.FIFOLIFOAvg CostCost of goods sold$fill in the blank 1$fill in the blank 2$fill in the blank 3Ending...
Amar Ltd furnishes the following information relating to budgeted sales and actual sales for the month...
Amar Ltd furnishes the following information relating to budgeted sales and actual sales for the month of March 2010. PRODUCT STANDARD UNITS STANDARD RATE (INR) ACTUAL UNITS ACTUAL RATE (INR) A 1200 15 880 18 B 800 20 880 20 C 2000 40 2640 38 calculate : (a) Sales price variance (b) Sales volume variance (c) Sales mix variance (d) Sales quantity variance
XYZ Company provided the following inventory information for 2021: January 1 December 31 Direct materials 14,000...
XYZ Company provided the following inventory information for 2021: January 1 December 31 Direct materials 14,000 19,000 Work in process 38,000 26,000 Finished goods 51,000 74,000 The following additional information was available for 2021: Advertising ........................................ $ 61,000 Cost of goods sold (unadjusted) .................... 294,000 Depreciation on copier in the sales office ......... 19,000 Direct materials purchased ......................... 123,000 Prime costs ........................................ 228,000 Sales commissions .................................. 47,000 Calculate XYZ Company's conversion costs for 2021.
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.   The budgeted net...
Pacific company provides the following information about its budgeted and actual results for June 2019. Although...
Pacific company provides the following information about its budgeted and actual results for June 2019. Although the expected June volume was 25, 000 units produced and sold, the company actually produced and sold 27, 000 units as detailed here: Budgeted (25, 000 units) Actual (27, 000 units) Selling price $5.00 per unit $5.23 per unit Variable costs (per unit): Direct materials 1.24 per unit 1.12 per unit Direct labour 1.50 per unit 1.40 per unit Manufacturing supplies* 0.25 per unit...
La Famiglia Pizzeria provided the following information for the month of October: a. Sales are budgeted...
La Famiglia Pizzeria provided the following information for the month of October: a. Sales are budgeted to be $157,000. About 85% of sales is cash; the remainder is on account. b. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. c. Food and supplies purchases, all on account, are expected to be $116,000. La Famiglia pays 25% in the month of purchase...
nformation pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019...
nformation pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019 (Budgeted) Cash sales $ 180,000 $ 160,000 $ 100,000 Credit sales 360,000 500,000 260,000 Total sales $ 540,000 $ 660,000 $ 360,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next...
9. Below is budgeted production and sales information for Flushing Company for the month of December....
9. Below is budgeted production and sales information for Flushing Company for the month of December.     Product XXX     Product ZZZ Estimated beginning inventory 29,100 units 16,300 units Desired ending inventory 36,100 units 15,500 units Region I, anticipated sales 303,000 units 264,000 units Region II, anticipated sales 190,000 units 146,000 units The unit selling price for product XXX is $4 and for product ZZZ is $16. Budgeted sales for the month are a.$3,612,000 b.$14,448,000 c.$8,532,000 d.$9,528,000 11. Stephanie Corporation sells a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT