Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. ruiz co. provides the following sales forecast for

Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 620 700 650 740 The company wants to...

Free

80.2K

Verified Solution

Question

Accounting

Ruiz Co. provides the following sales forecast for the next fourmonths:

   

AprilMayJuneJuly
Sales (units)620700650740


The company wants to end each month with ending finished goodsinventory equal to 40% of next month's forecasted sales. Finishedgoods inventory on April 1 is 248 units. Assume July's budgetedproduction is 650 units. In addition, each finished unit requiresfive pounds (lbs.) of raw materials and the company wants to endeach month with raw materials inventory equal to 30% of nextmonth’s production needs. Beginning raw materials inventory forApril was 978 pounds. Assume direct materials cost $5 perpound.

Prepare a direct materials budget for April, May, and June.(Round your intermediatecalculations and final answers to the nearest whole dollaramount.)

Answer & Explanation Solved by verified expert
4.3 Ratings (526 Votes)

Direct Materials Budget
For April, May, and June
April May June
Budgeted production (units) 652 680 686 units
Materials requirements per unit 5 5 5 lbs.
Materials needed for production(lbs.) 3260 3400 3430 lbs.
Budgeted ending inventory (lbs.) 1020 1029 975 lbs.
Total materials requirements(lbs.) 4280 4429 4405 lbs.
Beginning inventory (lbs.) (978) (1020) (1029) lbs.
Materials to be purchased(lbs.) 3302 3409 3376 lbs.
Cost per lb. 5 5 5 per lb.
Total budgeted direct materials cost 16510 17045 16880
Workings:
Production Budget
April May June
Next month's budgeted sales (units) 700 650 740
Ratio of inventory to future sales 40% 40% 40%
Budgeted ending inventory (units) 280 260 296
Add budgeted sales for the month 620 700 650
Required units of available production 900 960 946
Deduct beginning inventory (units) -248 -280 -260
Production units 652 680 686

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Biology
1.2K views

Select the feature s of an acidic dye select all that apply a Alkaline b...

Physics
1.2K views

d Both assertion and reason are false 17 A particle is executing linear simple harmonic...

Geometry
1.2K views

Find the volume of a pyramid with a square base where the perimeter of the...

Basic Math
1.2K views

Zachary earns $8.00 per hour. He get paid time and a half for any hours...

Basic Math
1.2K views

Which of the following is NOT the equation for a conic section?Enter a, b, c,...

Statistics
1.2K views

LAHAS LArcer Mean 2 B HAS LArGer Mean 3 The means of A and B...

Algebra
1.2K views

Let A 0 1 2 1 2 3 B y EQ y 1 2 E...

Algebra
1.2K views

If 1 4 plus 7 1 times a number equals the sum of the number...

Accounting
1.2K views

The following departmental information is for the four departments at Samoa Industries. The Janitorial and...

Accounting
1.2K views

Ali and Kamel are partners who share income and losses in the ratio of 3:2,...

Accounting
1.2K views

34 BE14-4 Assume the bonds in BE14-2 were issued at 92.6393 to yield 12%. Prepare...

Accounting
1.2K views

PLEASE SHOW YOUR SOLUTION. THANK YOUU Explain the laws of superposition, faunal assemblages,...