I just need part e, f and g
are ure Tollowing Duagers. a. Prepare the revenues budget. Revenues Budget For the Month of March Units Selling Price Total revenues 140 $ 42700 195 378 73710 116,410 Broncos Blankets 305 Rams Blankets Total b. Prepare the production budget in units, Rams Production Budget For the Month of March Broncos Budgeted units sales Add target ending finished goods inventory Total required units 164 Deduct beginning finished goods inventory 140 24 Units of finished goods to be produced 205 Prepare the direct material usage budget and direct material purchases budget. egin with the physical units portion, then prepare the cost budget portion of the direct material usage budget. (For amounts wil Direct Material Usage Budget in Quantity and Dollars For the Month of March Material Broncos Red wool Black wool logo patches Rams logo patches Physical Units Budget Direct materials required for Broncos 750 yds. yds Rams yds. 750 yds 205 otal quantity of direct material to be used Tost Budget wailable from beginning direct materials inventory (under a FIFO cost-flow assumption) Broncos Rams Broncos logo patches Rams logo patches Red wool Black wool To hysical Units Budget irect materials required for Broncos 750 yds. yds. yds. 1230 yds. Rams 205 N Syds. 205 tal quantity of direct material to be used ost Budget vailable from beginning direct materials inventory (under a FIFO cost-flow assumption) Broncos Rams be purchased this period Broncos 400 400 D260 LT 455 7810 Rams 8210 1200 irect materials to be used this period 27135 Rams logo patches Total Now prepare March's direct material purchases budget. Direct Materials Purchases Budget For the Month of March Materials Broncos Red wool Black wool logo patches Physical Units Budget To be used in production 750 yds. 1230 yds. 150 Add target ending inventory 30 yds. 20 yds. Total requirement 1250 yds Deduct beginning inventory 1230 Purchases to be made yds Cost Budget Purchases 15990 205 170 1530 26700 d. Prepare the direct manufacturing labor costs budget. (Abbreviation used: DMLH = Direct manufacturing labor hours) Direct Manufacturing Labor Costs Budget For the Month of March Output units DMLH Total Hourly produced per unit DMLH wage rate 150 4.0 600 28 205 5.0 1025 28 Broncos blankets Rams blankets Total Total 16800 28700 45500 e. Prepare the manufacturing overhead costs budget. Start by selecing the formula, and calculating the budgeted variable manufacturing overhead costs for March Variable manufacturing overhead costs e. Prepare the manufacturing overhead costs budget. Start by selecing the formula, and calculating the budgeted variable manufacturing overhead costs for March Variable manufacturing overhead costs Now prepare the total manufacturing overhead cost budgets by entering the appropriate amounts then calculate the total manufactu Manufacturing Overhead Budget For the Month of March Variable manufacturing overhead costs Fixed manufacturing overhead costs Total manufacturing overhead costs f. Prepare the ending inventories budget (direct materials and finished goods). Complete the information below by entering the appropriate amounts to calculate the unit costs of ending finished goods inventory for the Broncos manufacturing overhead divided by the total direct manufacturing labor hours. Unit Costs of Ending Finished Goods Inventory March 31, 2017 Product Broncos Rams Cost per unit of input Input per unit of output 5 yds. Cost per unit of input Total Total Input per unit of output 6 yds. 1 5 hrs. Wool Logo Direct manufacturing labor Fixed manufacturing overhead Variable manufacturing overhead Total 4 hrs. 4 hrs 5 hrs. 4 hrs 5 hrs. Now prepare the ending inventories budget. Ending Inventories Budget March 31, 2017 Quantity Cost per unit Total Direct materials Red wool Black wool Broncos logo Rams logo Finished goods Broncos blankets Rams blankets Total ending inventory g. Prepare the cost of goods sold budget. Cost of Goods Sold Budget For the Month of March, 2017 Beginning finished goods inventory, March 1 Direct materials used Direct manufacturing labor Manufacturing overhead Cost of goods manufactured Cost of goods available for sale Deduct ending finished goods inventory, March 31 Cost of goods sold Requirement 2. Suppose Hale Specialties decides to incorporate continuous improvement into its budgeting process. Select two areas where O To continually improve the direct material usage budget, the company should verify that the beginning inventory is as low as possible to de Direct manufacturing labor can incorporate continuous improvement by revising the budgeted usage of 4 hours and 5 hours on a monthly By increasing the target ending finished goods inventory, Hale Specialties will reduce the production budget therefore continually improve Hale Specialties can continually improve variable manufacturing overhead by budgeting more efficient use of the allocation base Only by reducing the budget on a monthly basis for the amounts of fixed overhead can Hale Specialties continually improve fixed manufact Choose from any list or enter any number in the input fields and then continue to the next question * Budgeted Direct-Cost Inputs Direct Materials les manufactured loon to view add icon to view the icon to view the icon to view the The budgeted direct-cost inputs for each product in 2017 are as follows: Broncos Blanket Rams Blanket Red wool fabric 5 yards Oyards Black wool fabric Broncos logo patches Rams logo patches Direct manufacturing labor 5 hours Unit data pertaining to the direct materials for March 2017 are as follows: Actual Beginning Direct Materials Inventory (3/1/2017) Broncos Blanket Rams Blanket Red wool fabric 40 yards Oyards Black wool fabric Broncos logo patches Rams logo patches cost of goods * Direct-Cost Inpus Target Ending Direct Materials Inventory (1/31/2017) Broncos Blanket Rams Blanket 30 yards Oyards Red wool fabric Black wool fabric Broncos logo patches Rams logo patches Unit cost data for direct-cost inputs pertaining to February 2017 and March 2017 are as follows: February 2017 (actual) March 2017 budgeted) Red wool fabric (per yard) Black wool fabrio (per yard) Broncos logo patches (per patch) Rams logo patches (per patch) Manufacturing labor cost per hour Print Done as possible to decrease the materials used during production urs on a monthly basis. Intinually improve the direct material purchases budget. Print Done loon manufacturing labor-hours per blanket * Manufacturing Overhead Information Finised Goods Inventory ck the icon to ck the icon to mok the icon to The budgeted variable manufacturing overhead rate for March 2017 is $17 per direct manufacturing labor hour. The budgeted fixed manufacturing overhead for March 2017 is $14,625. Both variable and food manufacturing overhead costs are allocated to each unit of finished goods Data relating to finished goods inventory for March 2017 are as follows Broncos Blanket Rams Blanket are the cost Beginning inventory in units Beginning inventory in dollars (ost) Tarpet ending inventory in units * $ $1,960 Sales and Other Information 2.045 Print Done Budgeted sales for March 2017 are 140 units of the Broncos blankets and 195 units of the Rams blankets. The budgeted selling prices per unit in March 2017 are $305 for the Broncos blankets and 5378 for the Rama blankets. Assume the following in your answer Work-inprocess inventories are negligible and ignored. Direct materials inventory and finished goods inventory are costed using the FIFO method. Unit costs of direct materials purchased and finished goods are constantin March 2017 Print Done 1 Direct Materials 1 Direct-Cost Inputs Unit data pertaining to the direct materials for March 2017 are as follows: Actual Beginning Direct Materials Inventory (3/1/2017) Broncos Blanket Rams Blanket Red wool fabric 40 yards yards Black wool fabric Broncos logo patches Rams logo patches Unit cost data for direct cost inputs pertaining to February 2017 and March 2017 are as follows: February 2017 (actual) March 2017 (budgeted) Red wool fabric (per yard) Black wool fabric (per yard) Broncos logo patches (per patch) Rams logo patches (per patch) Manufacturing labor cost per hour 65 Print Done Target Ending Direct Materials Inventory (3/31/2017) Broncos Blanket Rams Blanket Red wool fabric 30 yards O yards Black wool fabric Broncos logo patches Rams logo patches & O 0 Print Done The budgeted direct cost inputs for each product in 2017 are as follows Broncos Blanket Rams Blanket Red wool fabric 5 yards O yards Black wool fabric Broncos logo patches Rams logo patches Direct manufacturing labor 4 hours 5 hours Additional Blanket Information Budgeted Add target Total requir Deduct beg Print Done The company sews the blankets from fabric and sows on a logo patch purchased from the licensed logo store site. The teams are as follows: Broncos, with red blankets and the Broncos logo Rams, with black blankets and the Rams logo Also, the black blankets are slightly larger than the red blankets. Choose fror the next question. Save for Print Done 1. 0 Finished Goods Inventory Prepare the following budgets for March 2017: a. Revenues budget b. Production budget in units c. Direct material usage budget and direct material purchases budget d. Direct manufacturing labor costs budget .. Manufacturing overhead costs budget f. Ending inventories budget direct materials and finished goods) 9. Cost of goods sold budget Suppose Hale 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. Data relating to finished goods inventory for March 2017 res follows Broncos Blanket Rams Blanket Beginning inventory in units Beginning inventory in dollars (out) $ 1,960 $ 2,945 Target ending inventory in units 2. Print Done i Manufacturing Overhead Information 6 Sales and Other Information The budgeted variable manufacturing overhead rate for March 2017 is $17 per direct manufacturing labor hour. The budgeted fixed manufacturing overhead for March 2017 is $14,626. Both variable and fixed manufacturing overhead costs are allocated to each unit of finished goods. Budgeted sales for March 2017 are 140 units of the Broncos blankets and 195 units of the Rams blankets. The budgeted selling prices per unit in March 2017 are $305 for the Broncos blankets and $378 for the Rams blankets. Assume the following in your answer: Work-in-process inventories are negligible and ignored. Direct materials inventory and finished goods Inventory are costed using the FIFO method. Unit costs of direct materials purchased and finished goods are constant in March 2017 Print Done Add target ending finished goods Inventory Total required units Print Done e. Prepare the manufacturing overhead costs budget Start by selecing the formula, and calculating the budgeted variable manufacturing overhead costs for March. Variable manufacturing overhead costs x - Prepare the ending inventories budget direct materials and finished goods) Complete the information below by entering the appropriate amounts to calculate the unit costs of ending finished goods inventory for the Broncos Markets and Ramblares. Remember the food manufacturing overhead rate is the total manufacturing overhead divided by the total direct manufacturing labor hours Unit Costs of Ending Fished Goods Inventory March 11, 2017 Product Cost per unit Cost per unit input per un input per un of output Total Direct mantening bor Padmancing Overhead Variable manufacturing overtad To Now prepare the ending inventories budget. Ending Inventories Budget March 31, 2017 Quantity Cost per unit Total Direct materials Red wool Black wool Broncos logo Rams logo Finished goods Broncos blankets Rams blankets Total ending inventory g. Prepare the cost of goods sold budget. Cost of Goods Sold Budget For the Month of March, 2017 Beginning finished goods inventory, March 1 Direct materials used Direct manufacturing labor Manufacturing overhead Cost of goods manufactured Cost of goods available for sale Deduct ending finished goods inventory, March 31 Cost of goods sold Requirement 2. Suppose Hale Specialties decides to incorporate continuous improvement into its budgeting process. Select To continually improve the direct material usage budget, the company should verify that the beginning inventory is as lo Direct manufacturing labor can incorporate continuous improvement by revising the budgeted usage of 4 hours and 5 h By increasing the target ending finished goods inventory, Hale Specialties will reduce the production budget therefore or Hale Specialties can continually improve variable manufacturing overhead by budgeting more efficient use of the allocat Only by reducing the budget on a monthly basis for the amounts of fixed overhead can Hale Specialties continually imp O Choose from any list or enter any number in the input fields and then continue to the next