6-30 Budget schedules for a manufacturer. Lame Specialties manufactures, among other thing, woolen blankets for the athletic teams of the two local high schools. The company sews the blankets from fabric and sews on a logo patch purchased from the licensed logo store site. The teams are as follow:
- Knights, with red blankets and the Knights logo
- Raiders, with black blankets and Raider logo
Also, the black blankets are slightly larger than the red blankets.
The budgeted direct-cost inputs for each product in 2014 are as follows:
Knights Blanket Raiders Blanket
Red wool fabric 4 yards 0 yards
Black wool fabric 0 5
Knight logo patches 1 0
Raider logo patches 0 1
Direct manufacturing labor 3 hours 4 hours
Unit data pertaining to the direct materials for March 2014 are as follow:
Actual Beginning Direct Materials Inventory (3/1/2014)
Knights Blanket Raiders Blanket
Red wool fabric 35 yards 0 yards
Black wool fabric 0 5
Knight logo patches 45 0
Raider logo patches 0 60
Target Ending Direct Materials Inventory (3/1/2014)
Knights Blanket Raiders Blanket
Red wool fabric (per yards) 25 yards 0 yards
Black wool fabric (per yards) 0 0
Knight logo patches (per patch) 25 7
Raider logo patches (per patch) 0 25
Unit cost data for direct-cost inputs pertaining to February 2014 and March 2014 are as follow:
February 2014(actual) March 2014 (budget)
Red wool fabric $9 $10
Black wool fabric 12 11
Knight logo patches 7 7
Raider logo patches 6 8
Manufacturing labor costs per hour 26 27
Manufacturing overhead (both variable and fixed) is allocated to each blanket on the basis of budgeted direct manufacturing labor-hours per blanket. The budgeted variable manufacturing overhead rate for March 2014 is $16 per direct manufacturing labor-hour. The budgeted fixed manufacturing overhead for March 2014 is $14’640. Both variable and fixed manufacturing overhead costs are allocated to each unit of finished goods.
Data relating to finished goods inventory for March 2014 are as follow:
Knights Blanket Raiders Blankets
Beginning inventory in units 12 17
Beginning inventory in dollars(cost) $1,440 $2,550
Target ending inventory in units 22 27
Budgeted sales for March 2014 are 130 units of the knights blankets and 190 units of the Riders blankets. The budgeted selling prices per unit in March 2014 are $229 for the Knights blankets and $296 for the Raiders blankets. Assume the following in your answer.
- Work-in-process inventories are negligible and ignored.
- Direct materials inventory and finished goods inventory are costs using the FIFO method
- Unit costs of direct materials purchased and finished goods are constant in March 2014.
1. Prepare the following budgets for March 2014:
a. Revenues budget
b. Production budget in units
c. Direct material usage budget and direct material purchases budget
d. Direct manufacturing labor budget
e. Manufacturing overhead budget
f. Ending inventories budget (direct materials and finished goods)
g. Cost of goods sold budget
2. Suppose Lame Specialties decides to incorporate continuous improvement into its budgeting process. Describe two areas where it could incorporate continuous improvement into the budget schedules in requirement 1.