Osage Inc. - Production and purchases budgets
Not what you're looking for?
Osage Inc.. has actual sales for June and July and forecast sales for August, September, October, and November as follows:
Actual:
June 4,150 units
July 4,350 units
Forecasted:
August 4,200 units
September 4,950 units
October 3,900 units
November 3,700 units
Required:
(a) The firm's policy is to have finished goods inventory on hand at the end of the month that is equal to 70% of the next month's sales. It is currently estimated that there will be 3,300 units on hand at the end of July. Calculate the number of units to be produced in each of the months of August, September, and October.
August September October
Production
(b) Each unit of finished product requires 5 pounds of raw materials. The firm's policy is to have raw material inventory on hand at the end of each month that is equal to 80% of the next month's estimated usage. It is currently estimated that 13,000 pounds of raw materials will be on hand at the end of July. Calculate the number of pounds of raw materials to be purchased in each of the months of August and September.
August September
Purchases
Purchase this Solution
Solution Summary
Your tutorial is in Excel (attached). You can see the layout for solving problems like this. Click in cells to see how the figures were computed.
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
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
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.
Basics of corporate finance
These questions will test you on your knowledge of finance.
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.