Question

In: Accounting

Prepare a Production Budget EcoBags manufactures cloth shopping bags. The controller is preparing a budget for...

Prepare a Production Budget EcoBags 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.0 yard cotton at $4 per yard

0.2 yards canvas finish at $12 per yard

Direct labor per bag

0.5 hour at $18 per hour

Overhead per bag

Indirect labor …………………………………………… $0.60

Indirect materials ………………………………………. 0.20

Power …………………………………………………… 0.40

Equipment costs ………………………………………… 1.30

Building occupancy …………………………………….. 0.90

Total overhead per unit    $3.40

You learn that equipment costs and building occupancy are fixed and are based on a normal production of 600,000 units per year. Other overhead costs are variable. Plant capacity is sufficient to produce 750,000 units per year. Labor costs per hour are not expected to change during the year. However, the cotton supplier has informed EcoBags 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, EcoBags expects to sell 540,000 bags. Finished goods inventory is targeted to increase from the current balance of 120,000 units to 210,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. Required Prepare a production budget and estimate the materials, labor, and overhead costs for the coming year.

Solutions

Expert Solution

Computation of No. Unit Produce
Production (Number of units need to produce) = Sales (in units) + Ending Inventory Target (in units) - Beginning Inventory (in units)
= 540,000 + 210,000 - 120,000= 630000
Production Budget for 630000 Unit
Amount Amount
Direct Materials
Cotton (630,000 * 1 Yard * $4*1.20) $30,24,000.00
Canvas (630,000 *0.2 Yard * $12) $15,12,000.00
Total Direct Materials $45,36,000.00
Direct Labor (630,000 * 0.5 Hour * $18) $56,70,000.00
Overhead
Indirect labor (630,000 * 0.60)       378,000
Indirect materials (630,000 * 0.20)       126,000
Power (630,000 * 0.40)       252,000
*Equipment costs (600000 Unit*1.30)       780,000
*Building occupancy (600000 Unit*0.90)       540,000
Total Overhead $20,76,000.00
Total Budgeted Costs $1,22,82,000.00
Cost Per Unit (12,282,000/ 630,000) $19.50
*in calculation of Equipment and Building Occupancy Overhead cost , Normal Production capacity Considered

Related Solutions

EcoSacks manufactures cloth shopping bags. The controller is preparing a budget for the coming year and...
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 2.80 yard cotton at $3.80 per yard 1.10 yards canvas finish at $11.20 per yard Direct labor per bag 1.20 hour at $18.60 per hour Overhead per bag Indirect labor $ 1.30 Indirect materials 2.00 Power 2.20 Equipment costs 3.10 Building occupancy 2.70 Total overhead per...
EcoSacks manufactures cloth shopping bags. The controller is preparing a budget for the coming year and...
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.0 yard cotton at $4 per yard 0.2 yards canvas finish at $12 per yard Direct labor per bag 0.5 hour at $18 per hour Overhead per bag Indirect labor $ 0.60 Indirect materials 0.20 Power 0.40 Equipment costs 1.30 Building occupancy 0.90 Total overhead per...
EcoSacks manufactures cloth shopping bags. The controller is preparing a budget for the coming year and...
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.50 yard cotton at $4.50 per yard 0.70 yards canvas finish at $12.50 per yard Direct labor per bag 1.00 hour at $18.50 per hour Overhead per bag Indirect labor $ 1.10 Indirect materials 0.70 Power 0.90 Equipment costs 1.80 Building occupancy 1.40 Total overhead per...
13-51) EcoSacks manufactures cloth shopping bags. The controller is preparing a budget for the coming year...
13-51) 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 2.20 yard cotton at $3.20 per yard 1.10 yards canvas finish at $11.80 per yard Direct labor per bag 0.60 hour at $18.00 per hour Overhead per bag Indirect labor $ 0.70 Indirect materials 1.40 Power 1.60 Equipment costs 2.50 Building occupancy 2.10 Total overhead...
A company is preparing the production budget
A company is preparing the production budget for the second quarter Projected sales (in units) are as follows: • April 600 Units • May 680 units • June 750 units The company policy decided at the start of the period on 1 April to have an ending finished goods stocks of 20% of the next month's projected sales. Assuming that there was no opening stock for April, what should be the production quota for May? Select one: O a. 680 units O b. 666 units O c....
Birken Company manufactures shopping bags made of recycled plastic that it plans to sell for $5...
Birken Company manufactures shopping bags made of recycled plastic that it plans to sell for $5 each. Birken budgets production and sales of 800,000 bags for 2014, with a standard of 400,000 machine-hours for the whole year. Budgeted fixed overhead costs are $500,000, and variable overhead cost is $1.60 per machine-hour.Because of increased demand, Birken actually produced and sold 900,000 bags in 2014, using a total of 440,000 machine-hours. Actual variable overhead costs are $699,600 and actual fixed overhead is...
Peter’s Pretzels is preparing their 2018 budget. They want to prepare a flexible budget for use...
Peter’s Pretzels is preparing their 2018 budget. They want to prepare a flexible budget for use each month. They estimate sales/production will be between 700,000 and 900,000 boxes of pretzels per month. Monthly budget data                      Selling price of pretzels $5.00    per box Ingredient cost $1.50    per box Packaging cost   $0.50    per box Salary and wages cost    $270,000.00 per month Overtime for production over 800,000 units         $1.00    per box Fringe benefits 50% of wages and overtime...
Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the...
Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the coming year. The income statements for the last four quarters follow: First Second Quarter $220,000 110,000 110,000 22,000 $ 88,000 Third Fourth Quarter $190,000 95,000 95,000 19,000 S 76,000 Quarter Quarter $280,000 140,000 140,000 28,000 Total $920,000 460,000 460,000 92,000 Sales revenue Cost of goods sold Gross profit Selling administrative expenses $230,000 115,000 115,000 23,000 $ 92,000 Net income $112,000 $368,000 Historically, cost of...
Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the...
Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the coming year. The income statements for the last four quarters follow: First Quarter Second Quarter Third Quarter Fourth Quarter Total Sales revenue $ 90,000 $ 100,000 $ 105,000 $ 130,000 $ 425,000 Cost of goods sold 54,000 60,000 63,000 78,000 255,000 Gross profit 36,000 40,000 42,000 52,000 170,000 Selling & administrative expenses 8,500 10,000 10,500 13,000 42,000 Net income $ 27,500 $ 30,000 $...
Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the...
Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the coming year. The income statements for the last four quarters follow:    First Quarter Second Quarter Third Quarter Fourth Quarter Total Sales revenue $ 174,000 $ 204,000 $ 214,000 $ 264,000 $ 856,000 Cost of goods sold 121,800 142,800 149,800 184,800 599,200 Gross profit 52,200 61,200 64,200 79,200 256,800 Selling & administrative expenses 17,400 20,400 21,400 26,400 85,600 Net income $ 34,800 $ 40,800...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT