Question

company 5 feet by 5 feet wires. To produce one of these wires requires 30 square...

company 5 feet by 5 feet wires. To produce one of these wires requires 30 square feet of copper. Production needs for the year 2017 are as follows: 6,000 units in quarter 1; 7,000 units in quarter 2; 8,000 units in quarter 3; and 9,000 units in quarter 4. First quarter of 2018 expects production of 10,000 units. Each square foot of copper costs $5. Beginning inventory of canvas for the year is 800 square feet. Bob, wants to have 10% of direct materials needed for following quarter's production needs. Instructions Prepare a quarterly direct material purchases budget for 2017.

Homework Answers

Answer #1

Direct material purchase budget

Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year
Production units 6000 7000 8000 9000 30000
Direct material needed for production 30 30 30 30 30
Direct material needed for production 180000 210000 240000 270000 900000
Add: Desired ending inventory 21000 24000 27000 30000 30000
Total required 201000 234000 267000 300000 930000
Less: Beginning inventory -800 -21000 -24000 -27000 -800
Direct material purchase 200200 213000 243000 273000 929200
Cost per square feet 5 5 5 5 5
Cost of material purchase 1001000 1065000 1215000 1365000 4646000
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
Question 3: Brown Company manufactures wood tables. Each table requires 15 board-feet of wood. Wood costs...
Question 3: Brown Company manufactures wood tables. Each table requires 15 board-feet of wood. Wood costs $6 per board foot. The company had 2,000 board feet wood on hand at the beginning of July and required enough wood inventory to be on hand to meet 20% of the following month’s production requirements. July August September Quarter Required Production 5,000 7,000 10,000 22,000 The company expects to produce 8,000 units in October. Required: Prepare a materials purchases budget for the quarter....
A company manufactures product X. The company requires 8 pounds of raw material to produce each...
A company manufactures product X. The company requires 8 pounds of raw material to produce each unit of X. The company expects sales as follows: October 15,000 units, November 28,000 units, December 49,000 units, January 9,000 units, and February 7,000 units. The company has 4,200 pounds of raw materials and 4,000 units of finished goods on hand at the end of September. The company’s accounting policies require the company to have 10% of the next month’s sales and 25% of...
Exercise 10-5 Tarjee Adventures provides tours of scenic locations in Oregon. The company expects tours taken...
Exercise 10-5 Tarjee Adventures provides tours of scenic locations in Oregon. The company expects tours taken to increase dramatically compared with the prior year. For the past year, 2017, the number of tours given were as follows: First quarter 7,000 Second quarter 8,000 Third quarter 8,000 Fourth quarter 9,000 Assume that sales for each quarter in 2018 will be 27 percent higher than in 2017 and that the price per tour is $64. Prepare a sales budget by quarter for...
Exercise 8-16 (Algo) Direct Materials and Direct Labor Budgets [LO8-4, LO8-5] The production department of Zan...
Exercise 8-16 (Algo) Direct Materials and Direct Labor Budgets [LO8-4, LO8-5] The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 9,000 12,000 11,000 10,000 In addition, 15,750 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $5,600. Each...
Exercise 8-16 Direct Materials and Direct Labor Budgets [LO8-4, LO8-5] The production department of Zan Corporation...
Exercise 8-16 Direct Materials and Direct Labor Budgets [LO8-4, LO8-5] The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 11,000 14,000 13,000 12,000 In addition, 11,000 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $6,000. Each unit...
Problem 8-30 Integration of the Sales, Production, and Direct Materials Budgets [LO8-2, LO8-3, LO8-4] Milo Company...
Problem 8-30 Integration of the Sales, Production, and Direct Materials Budgets [LO8-2, LO8-3, LO8-4] Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 38,000 October 28,000 August 86,000 September 55,000 November 14,500 December 15,000 The selling price of the beach umbrellas is $13 per...
The following particulars were obtained from the books of a light Engineering Company for the half...
The following particulars were obtained from the books of a light Engineering Company for the half year ended 30th September, 2003. The expenses for 6 months were: Indirect material. 5,000 Stores overhead. 4,000 Depreciation. 6,000 Motive power. 1,500 Repairs & Maintenance. 1,500 Electric lighting. 800 General overheads. 10,000 Labour welfare. 3000 Worker's training, 700 Additional information: Particulars Production Departments Service Departments A B C X Y Direct wages 7,000 6,000 5,000 1,000 1,000 Direct materials    3,000 2,500 2,000 1,500...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 32,000 October 22,000 August 74,000 November 8,500 September 43,000 December 9,000 The selling price of the beach umbrellas is $13 per unit. All sales are on account. Based on past experience, sales are collected in the...
Refer to the Carteret Inc. information below. Carteret Inc. manufactures hammocks under various brand names. The...
Refer to the Carteret Inc. information below. Carteret Inc. manufactures hammocks under various brand names. The company sells most of its hammocks in the second quarter of each year. Their production budget for the second quarter shows the following number of hammocks needs to be produced: April   6000 units May 10 000 units June 15 000 units Each unit requires 30 feet of cotton rope cord which costs $0.50 per foot. The company has determined that it needs 20 per...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 41,000 October 31,000 August 92,000 November 17,500 September 61,000 December 18,000 The selling price of the beach umbrellas is $13 per unit. All sales are on account. Based on past experience, sales are collected in the...