Statement showing Production Budget for the month of January 2020.
| Bannon, Inc. | |
| Production Budget for the month of January 2020. | |
| Particulars | No. of Units |
| Production Budget | |
| Expected Sales during the month | 128000 |
| Add: - Ending Inventory (Finished Goods) | 32000 |
| Less: - Beginning Inventory (Finished Goods) | -20000 |
| No. of units to be produced | 140000 |
.
Statement showing Direct Material Consumption and Purchase Budget for the month of January 2020.
| Particulars | Milk | Fruit |
| No. of units to be produced | 140000 | 140000 |
| Qty of Raw material (Pounds per unit) | 0.36 | 0.14 |
| Total Raw material required (in Pounds) | 50400 | 19600 |
| Add: - Ending Inventory (Raw Material) | 20000 | 20000 |
| Less: - Beginning Inventory (Raw Material) | -14000 | -14000 |
| Qty of Raw material to be Purchased (in Pounds) | 56400 | 25600 |
| Price Per Pound of Material | $1.20 | $3.00 |
| Total Purchase amount in $ | $67,680 | $76,800 |
.
Statement Showing The Standard Direct Material cost per unit (One 0.5 Pound Container)
| Particulars | Per Unit ($) |
| Milk (0.36 Pound x $1.20 per Pound) | 0.43 |
| Fruit (0.14 Pound x $3.00 per Pound) | 0.42 |
| Standard Direct material Cost Per Product Unit | 0.85 |
Problems 27-29 (16 points cach) 1. Bannon, Inc, makes yogurt using two ingredients: milk and fruit...
On January 1, 2020, the Johnson Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales Units: First quarter 5,600; second quarter 6,400; third quarter 7,000 Ending raw materials inventory: 40% of the next quarter's production requirements. Ending finished goods inventory: 25% of the next quarter's expected sales units. Third-quarter production: 7,440 Units The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to...
Trebblehorn Industries has adopted the following sales budget for the first 3 months of 2017. Month Units January 11,000 February 15,000 March 13,000 Management requires 30% of next month sales to be in ending inventory. Each unit requires 5 pounds of raw materials costing $3 per pound. Management wants to have a raw materials inventory at the end of the month equal to 35% of next month's production requirements. April's expected sales are 12,000 with a total of 13,500 required...
Answer in excel
Problems: 1. Benliver, Inc. manufactures and distributes a number or products to retailers. One of these products. Super Jetdry, requires two pounds of material R2D8 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter - July August, and September. Peak sales of Super Jetdry occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. The...
finished goods inventory budget
Ending Finished Goods inventory Budget Item Quanity Cost Total pounds production cost per case direct materials direct labor manufacturing over head unit product cost Ending Finished Goods inventory Budget Item Quanity Cost Total pounds production cost per case direct materials direct labor manufacturing over head unit product cost Budgeted finished goods inventory: ending finished goods inventory in cases unit product cost endine finished poods inventory in dollars Desired ending FG inventory at year end 12,000 cases...
Direct Materials Purchases Budget Pasadena Candle Inc. budgeted production of 735,000 candles for the year. Wax is required to produce a candle. Assume 12 ounces of wax is required for each candle. The estimated January 1 wax inventory is 17,900 pounds. The desired December 31 wax inventory is 12,800 pounds. If candle wax costs $2.10 per pound, determine the direct materials purchases budget for the year. (One pound = 16 ounces.) Round all computed answers to the nearest whole dollar....
Please Do part B
Garver Industries has budgeted the following unit sales: 2020 January February March April May Units 10,000 8,000 9,000 11,000 15,000 The finished goods units on hand on December 31, 2019, was 2,000 units. Each unit requires 3 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 20% of next month's anticipated...
beginning RM inventory (in units) Quantity of DM needed per unit M cost per pound Hesired ending RM inventory/next quarter's RM needs desired ending RM inventory at year-end 24,000 pounds 20.00 pounds $0.30 dollars 15% 30,000 pounds Cash payments to suppliers: paid in the quarter of purchase paid in the quarter following purchase 40% of the purchases 60% of the purchases L hours per unit Late per hour 0.24 hours $12.00 dollars Manufacturing overhead Variable MOH Fixed MOH $5.00 per...
DeWitt Industries has adopted the following production budget for the first 4 months of 2020. Month Units Month Units 5,490 10,470 March January 8,260 April 4,450 February Each unit requires 5 pounds of raw materials costing $2 per pound. On December 31, 2019, the ending raw materials inventory was 10,470 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month's production requirements. Prepare a direct materials purchases budget by...
QUESTION 1 On the Direct Materials Budget, the total number of direct materials needed is computed as: a. Quantity needed for production + desired ending inventory of DM - beginning inventory of DM b. Units to be produced + desired ending inventory of DM - beginning inventory of DM c. Quantity needed for production - desired ending inventory of DM + beginning inventory of DM d. Units to be produced - desired ending inventory of DM + beginning inventory of...
Yem expects to produce 1,700 units in January and 2,180 units in February. The company budgets 3 pounds per unit of direct materials at a cost of $25 per pound. Indirect materials are insignificant and not considered for budgeting purposes. The balance in the Raw Materials Inventory account (all direct materials) on January 1 is 5,700 pounds. Yem desires the ending balance in Raw Materials Inventory to be 20% of the next month's direct materials needed for production. Desired ending...