Direct Materials Purchases Budget
Not what you're looking for?
Soda Company is the largest bottler in Western Europe. The company purchases Brand 1 and Brand 2 concentrate from The Soda Company, dilutes and mixes the concentrate with carbonated water, and then fills the blended beverage into cans or plastic two-liter bottles. Assume that the estimated production for Brand 1 and Brand 2 two-liter bottles at the Wakefield, UK, bottling plant are as follows for the month of March:
Brand 1 51,000 two-liter bottles
Brand 2 39,000 two-liter bottles
In addition, assume that the concentrate costs $87 per pound for both Brand 1 and Brand 2 and is used at a rate of 0.2 pound per 100 liters of carbonated water in blending Brand 1 and 0.25 pound per 100 liters of carbonated water in blending Brand 2. Assume that two liters of carbonated water are used for each two-liter bottle of finished product. Assume further that two-liter bottles cost $0.08 per bottle and carbonated water costs $0.06 per liter.
Prepare a direct materials purchases budget for March 2014, assuming inventories are ignored, because there are no changes between beginning and ending inventories for concentrate, bottles, and carbonated water. If required, round to the nearest whole number (except for unit price amounts, which should be rounded to nearest cent if required).
Purchase this Solution
Solution Summary
The Solution uses Excel to provide a purchase budget for the example company.
Education
- MPhil, Madurai Kamaraj University
- MCom, Annamalai University
- IATA, International Air Transport Association
Recent Feedback
- "Great explanations on how the answers were obtained."
- "Love the way she explains everything step by step."
- "Solutions were thoroughly explained."
- "Excellent explanations of how problems are solved"
- "Thanks"
Purchase this Solution
Free BrainMass Quizzes
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.