solve pls and prepare excel.
Glerman Ine, operates at capacity and makos plustic conbs and leairbrushos, Although the comls and brushes are a matching set, they are sold individually and so the sales mix is not 1:1. Haglett's management is planning its aumaal budget for fiscal year 2018. Haxkett accounts for direct materials and ending finished goods using a FIFO cost flow mssmuption. Here is information for 2018 ; Coanle are manafictured ia betches of 200 , and brebbes are anautactured in batches of 100 . It tafos 25 minutes to set up for a batch of combs and 1 hour to set up for a batch of brukhes. Haslett uss activity-besed costing and has classibied all overbead costs as shown in the followiag table. Budgeted fixed overhead costs vary with capacity, Hazlntt operates at capocity so budgeted fixed overhead cost per unit equals the badgeted fixed overhead costs divided by the budgeted uatitios of the cont allocation base. Delivery trucks tramsport uaits sold in delivery sizes of 1,000 cosabs or 1,000 brushes. Q-1) Calculate budgeted number of comliw to be produced. Q-2) Culculate budgeted unit production cost of connh. Q-3) Cnlculate budgeted unit production cost of brush. Q-4) Calculate budgeted dollar cost of ending finished good inventory. Q-5) Calculate budgeted cost of goods manufactured. Q-6) Calculate budgeted sales revenue. Q-7) Calculate budgeted cost of goods sold. Q-8) Calculate budgeted marketing coeth. Q-9) Calculate budgeted distribution costs. Q-10) Calculate budgeted operating incoune. Gulerman Inc., operates at capacity and makes plastic combs and hairbrushes. Although the combs and brushes are a matching set, they are sold individually and so the sales mix is not 1:1. Hazlett's management is planning its annual budget for fiscal year 2018. Hazlett accounts for direct materials and ending finished goods using a FIFO cost flow assumption. Here is information for 2018: Combs are manufactured in batches of 200 , and brushes are mamufactured in batches of 100 . It takes 25 minutes to set up for a batch of combs and 1 hour to set up for a batch of brushes. Hazlett uses activity-based costing and has classified all overhead costs as shown in the following table. Budgeted fixed overhead casts vary with capacity. Hazlett operates at capacity so budgeted fixed overhead cost per unit equals the budgeted fixed overhead costs divided by the budgeted quantities of the cost allocation base. Delivery trucks transport units sold in delivery sizes of 1,000 combs or 1,000 brushes. Combs are manufactured in batches of 200 , and brushes are manufactured in batches of 100 . It takes 25 minutes to set up for a batch of combs and 1 hour to set up for a batch of brushes. Hazlett uses activity-based costing and has classified all overhead costs as shown in the following table. Budgeted fixed overhead costs vary with capacity. Hazlett operates at capacity so budgeted fixed overhead cost per unit equals the budgeted fixed overhead costs divided by the budgeted quantities of the cost allocation base. Delivery trucks transport units sold in delivery sizes of 1,000 combs or 1,000 brushes. Q-1) Caleulate budgeted number of combs to be produced. Q-2) Calculate budgeted unit production cost of comb. Q-3) Calculate budgeted unit production cost of brush. Q-4) Calculate budgeted dollar cost of ending finished good inventory. Q-5) Calculate budgeted cost of goods manufactured. Q-6) Calculate budgeted sales revenue. Q-7) Calculate budgeted cost of goods sold. Q-8) Calculate budgeted marketing costs. Q-9) Calculate budgeted distribution costs. Q-10) Calculate budgeted operating income. Glerman Ine, operates at capacity and makos plustic conbs and leairbrushos, Although the comls and brushes are a matching set, they are sold individually and so the sales mix is not 1:1. Haglett's management is planning its aumaal budget for fiscal year 2018. Haxkett accounts for direct materials and ending finished goods using a FIFO cost flow mssmuption. Here is information for 2018 ; Coanle are manafictured ia betches of 200 , and brebbes are anautactured in batches of 100 . It tafos 25 minutes to set up for a batch of combs and 1 hour to set up for a batch of brukhes. Haslett uss activity-besed costing and has classibied all overbead costs as shown in the followiag table. Budgeted fixed overhead costs vary with capacity, Hazlntt operates at capocity so budgeted fixed overhead cost per unit equals the badgeted fixed overhead costs divided by the budgeted uatitios of the cont allocation base. Delivery trucks tramsport uaits sold in delivery sizes of 1,000 cosabs or 1,000 brushes. Q-1) Calculate budgeted number of comliw to be produced. Q-2) Culculate budgeted unit production cost of connh. Q-3) Cnlculate budgeted unit production cost of brush. Q-4) Calculate budgeted dollar cost of ending finished good inventory. Q-5) Calculate budgeted cost of goods manufactured. Q-6) Calculate budgeted sales revenue. Q-7) Calculate budgeted cost of goods sold. Q-8) Calculate budgeted marketing coeth. Q-9) Calculate budgeted distribution costs. Q-10) Calculate budgeted operating incoune. Gulerman Inc., operates at capacity and makes plastic combs and hairbrushes. Although the combs and brushes are a matching set, they are sold individually and so the sales mix is not 1:1. Hazlett's management is planning its annual budget for fiscal year 2018. Hazlett accounts for direct materials and ending finished goods using a FIFO cost flow assumption. Here is information for 2018: Combs are manufactured in batches of 200 , and brushes are mamufactured in batches of 100 . It takes 25 minutes to set up for a batch of combs and 1 hour to set up for a batch of brushes. Hazlett uses activity-based costing and has classified all overhead costs as shown in the following table. Budgeted fixed overhead casts vary with capacity. Hazlett operates at capacity so budgeted fixed overhead cost per unit equals the budgeted fixed overhead costs divided by the budgeted quantities of the cost allocation base. Delivery trucks transport units sold in delivery sizes of 1,000 combs or 1,000 brushes. Combs are manufactured in batches of 200 , and brushes are manufactured in batches of 100 . It takes 25 minutes to set up for a batch of combs and 1 hour to set up for a batch of brushes. Hazlett uses activity-based costing and has classified all overhead costs as shown in the following table. Budgeted fixed overhead costs vary with capacity. Hazlett operates at capacity so budgeted fixed overhead cost per unit equals the budgeted fixed overhead costs divided by the budgeted quantities of the cost allocation base. Delivery trucks transport units sold in delivery sizes of 1,000 combs or 1,000 brushes. Q-1) Caleulate budgeted number of combs to be produced. Q-2) Calculate budgeted unit production cost of comb. Q-3) Calculate budgeted unit production cost of brush. Q-4) Calculate budgeted dollar cost of ending finished good inventory. Q-5) Calculate budgeted cost of goods manufactured. Q-6) Calculate budgeted sales revenue. Q-7) Calculate budgeted cost of goods sold. Q-8) Calculate budgeted marketing costs. Q-9) Calculate budgeted distribution costs. Q-10) Calculate budgeted operating income
