Direct Materials Purchases budget for Soda Company
Not what you're looking for?
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 are as follows for the month of March:
Brand 1 37,000 two-liter bottles
Brand 2 28,000 two-liter bottles
In addition, assume that the concentrate costs $81 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 liter bottles cost $0.09 per bottle and carbonated water costs $0.07 per liter.
Prepare a direct materials purchases budget for March 2010, assuming no changes between beginning and ending inventories for all three materials.
SODA COMPANY
Direct Materials Purchases Budget
For the Month Ending MARCH 31, 2010
(assumed data)
Concentrate 2-Liter Bottles Carbonated Water
Materials required for production:
Brand 1 lbs. btls. ltrs.
Brand 2 lbs. btls. ltrs.
Total materials lbs. btls. ltrs.
Direct materials unit price (Enter as dollars and cents.) $ $ $
Total direct materials to be purchased $ $
Purchase this Solution
Solution Summary
Your tutorial is attached in Excel. I have a section for assumptions and costs, a computation of the materials needed for production, and a computation of purchases needed.
Education
- BSc, University of Virginia
- MSc, University of Virginia
- PhD, Georgia State University
Recent Feedback
- "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
- "Thank, this is more clear to me now."
- "Awesome job! "
- "ty"
- "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
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.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Learning Lean
This quiz will help you understand the basic concepts of Lean.