Information concerning sales and production for ABC Co. for November 2019 are summarized as follows: A. Estimated Sales: Product X: 80,000 units at $60, per unit Product Y: 40,000 units at $130 per unit B. Estimated inventories, November 1, 2019 Material A: 8,000 lbs Product X: 6,000 units at $34 per unit $204,000 Material B: 7,000 lbs Product Y: 5,400 units at $70 per unit 378,000 Total $582,000 C. Desired inventories at November 30,2019 Material A: 6,000 lbs Product X: 5,000 units at $34 per unit $170,000 Material B: 5,000 lbs Product Y: 4,000 units at $70 per unit 280,000 Total $450,000 D. Direct materials used in production Product X Product Y Material A 1.4 lbs per unit 7.0 lbs per unit Material B 2.4 lbs per unit 3.6 lbs per unit E. Unit costs for direct materials Material A: $ 8.0 per lb Material B: $ 4.0 per lb F. Direct labor requirements Department 1 Department 2 Product X 0.8 hr per unit 0.30 hr per unit Product Y 1.2 hr per unit 0.50 hr per unit What to do: 1. Prepare a sales budget for November 2. Prepare a production budget for November 3. Prepare a direct materials purchases budget for November 4. Prepare a direct labor cost budget for November
Information concerning sales and production for ABC Co. for November 2019 are summarized as
follows:
A. Estimated Sales:
Product X: 80,000 units at $60, per unit
Product Y: 40,000 units at $130 per unit
B. Estimated inventories, November 1, 2019
Material A: 8,000 lbs Product X: 6,000 units at $34 per unit $204,000
Material B: 7,000 lbs Product Y: 5,400 units at $70 per unit 378,000
Total $582,000
C. Desired inventories at November 30,2019
Material A: 6,000 lbs Product X: 5,000 units at $34 per unit $170,000
Material B: 5,000 lbs Product Y: 4,000 units at $70 per unit 280,000
Total $450,000
D. Direct materials used in production
Product X Product Y
Material A 1.4 lbs per unit 7.0 lbs per unit
Material B 2.4 lbs per unit 3.6 lbs per unit
E. Unit costs for direct materials
Material A: $ 8.0 per lb
Material B: $ 4.0 per lb
F. Direct labor requirements
Department 1 Department 2
Product X 0.8 hr per unit 0.30 hr per unit
Product Y 1.2 hr per unit 0.50 hr per unit
What to do:
1. Prepare a sales budget for November
2. Prepare a production budget for November
3. Prepare a direct materials purchases budget for November
4. Prepare a direct labor cost budget for November
Step by step
Solved in 3 steps
