Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Use the following information for the Exercises below Ruiz Co. provides the foll

ID: 2556778 • Letter: U

Question

Use the following information for the Exercises below Ruiz Co. provides the following sales forecast for the next four months: Part 2 of 2 630 718 750 2.14 points the company wants to end each month with ending finished goods inventory equal to 40% of next month's forecasted sales. Finished goods inventory on April 1 is 252 units. Assume July's budgeted production is 660 units. In addition, each finished unit requires five pounds (lbs.) of raw materials and the company wants to end each month with raw materials inventory equal to 30% of next month's production needs. Beginning raw materials inventory for April was 993 pounds. Assume direct materials cost $4 per pound Exercise 20-4 Manufacturing: Direct materials budget LO P1 Prepare a direct materials budget for April, May, and June. (Round your intermediate calculations and final answers to the nearest whole dollar amount.) 8 Answer is complete but not entirely correct. For April, May, and June Ma 662 Materials requirements per unt 3,450 3830 bs 1,035 4,494 1,035 1.089 (lbs.) 993 per Ib. 13,836s 14.124

Explanation / Answer

Budgeted production in units = Sales in units + Desired ending inventory - Beginning inventory

= Sales in units + 40% of next month sales - 40% of current month sales

PRODUCTION BUDGET

RUIZ CO.

Direct Materials Budget

For April, May and June

April May June Sales in units 630 710 660 Desired ending inventory 284 (710*40%) 264 (660*40%) 300 (750*40%) Beginning inventory (252) (284) (264) Production in units 662 690 696