Troy Corporation has the following budgeted sales for the selected four-month period: Month Unit Sales October...

Troy Corporation has the following budgeted sales for the selected four-month period:

Month	Unit Sales
October	40,000
November	70,000
December	50,000
January	60,000

There were 14,000 units of finished goods in inventory at the beginning of October. Plans are to have an inventory of finished product equal to 25 percent of the unit sales for the next month.

Five pounds of a single raw material are required for each unit produced. Each pound of material costs $10. Plans are to have inventory levels for materials equal to 30 percent of the amount of materials needed to satisfy next month's production and 84,000 units of raw material on hand at the end of December. Materials inventory on October 1 was 60,000 pounds

A. Prepare a production budget in units for October, November, and December.

b. Prepare a purchase budget in pounds and dollars for October, November, and December.

Expert Solution

A. Production Budger

Production Budget	October	November	December
Opening Stock	14000	17500	12500
Add Production (Sales + Closing Stock-Opening Stock	43500	65000	52500

Less: Closing Stock (25% of next month sales)	17500	12500	15000
Sales of Finish Goods	40000	70000	50000

B. Purchase Budget

i. Closing Stock is equal to 30% of the amount of material needed to satisfy the next months production

a. Production for the month of November is 65,000 units. Hence Material required to produe the finished goods is equal to 65,000*5 pounds = 3,25,000 pounds closing stock of raw material for the month of october is 30% of 3,25,000 pounds = 97,500 Pounds similarly the closing stock of raw material inventory is to be determined.

Purchase budget

Particulars	October	November
Opening Stock	60000	97500
Consumption (Production * 5Pounds)	217500	325000

Less: Closing Stock	97500	78750

jeff jeffy answered 2 years ago

Jones Corporation has the following budgeted sales for the selected four-month period: Month Unit Sales July...

Jones Corporation has the following budgeted sales for the selected four-month period: Month Unit Sales July 35,000 August 20,000 September 30,000 October 25,000 Sales price per unit is $200 Plans are to have an inventory of finished product equal to 30% of the unit sales for the next month. There was 10,500 units in beginning inventory on July 1st. Five pounds of materials are required for each unit produced. Each pound of material costs $10. Inventory levels for materials equal...

Lubriderm Corporation has budgeted the following unit sales for the next four months: Month Unit Sales...

Lubriderm Corporation has budgeted the following unit sales for the next four months: Month Unit Sales July 120,000 August 210,000 September 150,000 October 180,000 Plans are to have an ending inventory of finished products that equals 20% of the unit sales for the next month. Five pounds of materials are required for each finished unit produced, and each pound of material costs $8. The desired ending inventory level for materials is equal to 30% of the materials needs...

Eunice Ltd. has the following budgeted sales for the next six-month period: Month Unit Sales January...

Eunice Ltd. has the following budgeted sales for the next six-month period: Month Unit Sales January 80,000 February 90,000 March 120,000 April 150,000 May 180,000 June 120,000 Eunice Ltd. sells a single product at a price of $60 per unit. There were 18,000 units of finished goods in inventory at the beginning of February. Eunice Ltd.’s policy is to keep the inventory of finished goods equal to 20% of the unit sales for the next month. Three kilograms of materials...

AH Corp has the following budgeted unit sales for the second half of the 2020: Month...

AH Corp has the following budgeted unit sales for the second half of the 2020: Month Unit Sales July 90,000 August 120,000 September 210,000 October 150,000 November 180,000 December 120,000 It is expected to have 30,000 units of finished goods in inventory at the beginning of budget period and the plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced....

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...

Jannusch Corporation makes one product. Budgeted unit sales for July, August, September, and October are 10,000,...

Jannusch Corporation makes one product. Budgeted unit sales for July, August, September, and October are 10,000, 11,600, 13,300, and 12,700 units, respectively. The ending finished goods inventory should equal 20% of the following month's sales. The budgeted required production for August is closest to: A) 11,600 units B) 11,940 units C) 14,260 units D) 16,580 units

Eckert Company has budgeted the following unit sales:

Eckert Company has budgeted the following unit sales: 2016 Units April 25,000 May 50,000 June 75,000 July 45,000 Of the units budgeted, 40% are sold by the Southern Division at an average price of $15 per unit and the remainder are sold by the Eastern Division at an average price of $12 per unit. Instructions Prepare separate sales budgets for each division and for the company in total for the second quarter of 2017 by completing the chart. Do NOT...

Budgeted sales in Acer Corporation over the next four months are given below: September October November...

Budgeted sales in Acer Corporation over the next four months are given below: September October November December Budgeted Sales $140,000 $150,000 $170,000 $130,000 25% of the company's sales are for cash and 75% are on account. Collections for sales on account follow a stable pattern as follows: 50% of a month's credit sales are collected in the month of sale, 30% are collected in the month following sale, and 15% are collected in the second month following sale. The remainder...

Razz Corporation has budgeted for the following sales: July $425,000 August $510,000 September $605,000 October $860,000...

Razz Corporation has budgeted for the following sales: July $425,000 August $510,000 September $605,000 October $860,000 November $715,000 December $680,000 Sales are collected as follows: 10% in the month of sale; 60% in the month following the sale; and the remaining 30% in the second month following the sale. 1. What is the budgeted total cash collected in December? 2. In Razz's budgeted balance sheet at December 31, at what amount will accounts receivable be shown?

Harrti Corporation has budgeted for the following sales: July $441,000 August $595,000 September $674,000 October $923,000...

Harrti Corporation has budgeted for the following sales: July $441,000 August $595,000 September $674,000 October $923,000 November $721,000 December $686,000 Sales are collected as follows: 10% in the month of sale; 60% in the month following the sale; and the remaining 30% in the second month following the sale. In Razz's budgeted balance sheet at December 31, at what amount will accounts receivable be shown? $686,000 $617,400 $833,700 $216,300

Question