question archive A sales budget is given below for one of the products manufactured by the OMI Co

A sales budget is given below for one of the products manufactured by the OMI Co

Subject:AccountingPrice:3.87 Bought7

A sales budget is given below for one of the products manufactured by the OMI Co.: January 25,000 units February 40,000 units March 65,000 units April 45,000 units May 35,000 units June 30,000 units The inventory of finished goods at the end of each month must equal 20% of the next month's sales. However, on December 31 the finished goods inventory totaled only 4,000 units. Each unit of product requires three pounds of specialized material. Since the production of this specialized material by OMI's suppliers is sometimes irregular, the company has a policy of maintaining an ending inventory at the end of each month equal to 30% of the next month's production needs. This requirement had been met on January 1 of the current year. Required: a. Prepare a budget showing the required production each month for January, February, March, and April. b. Prepare a budget showing the quantity of switches to be purchased each month for January, February, and March.

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Answer:

 

a.          
OMI Co.
Production Budget
Particulars Month Total
January February March April
Expected Sales (in units) 25000 40000 65000 45000 175000
Add: Closing Inventory 8000 13000 9000 7000  
Less: Opening Inventory 4000 8000 13000 9000  
Required Production (in units) 29000 45000 61000 43000 178000
           
b.          
OMI Co.
Direct Materials Budget
Particulars Month Total  
January February March
Required Production (in units) 29000 45000 61000 135000
Consumption per Bag (in lbs) 3  
 
Consumption 87000 135000 183000 405000
Add: Closing Inventory 40500 54900 38700  
Less: Opening Inventory 26100 40500 54900  
Purchase (in lbs) 101400 149400 166800 417600

Related Questions