Question

EcoSacks manufactures cloth shopping bags. The controller is preparing a budget for the coming year and asks for your assistance. The following costs and other data apply to bag production:

Direct materials per bag 1.30 yard cotton at $4.30 per yard 0.50 yards canvas finish at $12.30 per yard Direct labor per bag 0.80 hour at $18.30 per hour Overhead per bag Indirect labor Indirect materials Power Equipment costs Building occupancy Total overhead per unit $0.90 0.50 0.70 1.60 1.20 $4.90

You learn that equipment costs and building occupancy are fixed and are based on a normal production of 630,000 units per year. Other overhead costs are variable. Plant capacity is sufficient to produce 810,000 units per year.

Labor costs per hour are not expected to change during the year. However, the cotton supplier has informed EcoSacks that it will impose a 20 percent price increase at the start of the coming budget period. No other costs are expected to change.

During the coming budget period, EcoSacks expects to sell 570,000 bags. Finished goods inventory is targeted to increase from the current balance of 150,000 units to 240,000 units to prepare for an expected sales increase the year after next as a result of legislation in several states regarding plastic bags. Production will occur evenly throughout the year. Inventory levels for cotton and canvas are expected to remain unchanged throughout the year. There is no work-in-process inventory.

Answer 1

Requirement a: ECOSACKS Production Budget For the Coming year (in Units) Expected sales Add: Desired ending inventory of finished goods Total needs Less: Beginning inventory of finished goods Units to be produced 570000 240000 810000 150000 660000

Requirement b: Materials costs Labor Costs Overhead Costs $8,486,280 $9,662,400 Workings: Direct materials Cotton 660,000 x 1.3 yard < $4.30 x 1.20 Canvas 660,000 x 0.5 yards x $12.30 Total direct materials $4,427,280 4,059,000 $8,486,280 Direct labor: 660,000 x 0.8 hr. x $18.30 $9,662,400 Overhead: Indirect labor (660,000 $0.90) Indirect Material (660,000 $0.50) Power (660,000 x $ 0.70) Equipment costs (630,000 x $ 1.60) Building occupancy (630,000 Ⓡ$ 1.20) Total overhead Total budgeted manufacturing costs $594,000 330,000 462,000 1,008,000 756,000 $3,150,000 $21,298,680