ew the ew the ew the ew the ng tha machi total d - X Additional data Tulsa Dairy's employees are available for 135 hours of work each month and have a total monthly compensation of $4,320 per employee. This results in a cost rate per employee of $32 per hour. Tulsa Dairy leases machines on a monthly basis. The lease cost for each machine is $7,854 with a total available capacity per machine line of 154 hours per month. This results in a cost rate for machines of $51 per machine hour. Print Done 0.03 s can be hired, deter red to meet this proc achines required for ine income statemers nd the ratio of gross used capacity? this production plan. to view additional data to to to to SU er t 3 Total direct labor hours Production and sales volume (gallons) Direct labor hours per gallon Total direct labor hours Vanilla 13,500 0.03 405.0 Print on is the same except for the following: (Click the icon to view the updated information.) Requirements X hired, determine the bet this production equired for this e statement. io of gross profit to acity? uction plan. Also, Chocolate Strawberry Mocha-Almond Total 9,100 1,000 900 24,500 0.03 0.03 0.03 273.0 30.0 27.0 735.0 Done ico e ico ico e ico e ico (a) A numb minin nd sal ns) Hours Total indirect labor hours # of production runs Handle production runs (hours/run) Indirect labor-handle runs Setup time per run (hours) Indirect labor hours per run Indirect labor-total setup hours Indirect labor-maintain products Total indirect labor hours Vanilla Chocolate Strawberry Mocha-Almond 19 9 2 3 2.3 2.3 2.3 2.3 43.7 20.7 4.6 6.9 2.6 1.3 1.8 3.3 5.2 2.6 3.6 6.6 98.8 23.4 7.2 19.8 7.9 7.9 7.9 7.9 52.0 150.4 19.7 34.6 Print Done Total 75.9 149.2 31.6 256.7 ed, determine the this production uired for this Statement of gross profit to by? ion plan. Also, the icon he icon the icon The icon he icon at (a) As e numbe termining and sale lons) Total machine hours Production volume Machine hours per 1000 gallon Total machine run time (hours) Number of production runs Setup time per run (hours) Machine setup time (hours) Total machine hours Vanilla 13,500 8 108.0 19 2.6 49.4 157.4 Print unaoon is the same except for the following: - X red, determine the t this production quired for this statement. of gross profit to city? ction plan. Also, Chocolate Strawberry Mocha-Almond 9,100 1,000 900 8 8 8 72.8 8.0 7.2 9 2 3 1.3 1.8 3.3 11.7 3.6 9.9 84.5 11.6 17.1 Done Total 24,500 196.0 74.6 270.6 ry has an Tor forecas ick the ico ick the ico lick the ico ick the ico lick the ico rma product profitability evenues ement (a) A ne the numb y determinin ction and sal e (gallons) labor hours Pro forma product profitability (Amounts are rounded to the nearest dollar.) Vanilla Selling price Sales volume Direct materials Direct labor (including fringes). Indirect labor Machinery Gross profit Gross profit (% of sales) $ $ $ 2.75 $ 13,500 37,125 $ 8,370 12,960 4,813 8,027 2,955 $ 8.0% Print Chocolate Strawberry 2.75 $ 9,100 1,000 25,025 $ 3,600 $ 5,642 620 8,736 960 1,664 630 4,310 592 4,673 S 798 $ 18.7% Mocha-Almond 22.2 % Done 3.60 $ 4.20 $ 900 3,780 $ 594 864 1,107 872 343 $ 9.1% Total - X 2.84 24,500 69,530 15,226 23,520 8,214 13,801 8,769 12.6 % the following: ed, determine the this production ired for this statement of gross profit to by? on plan. Also, plete f1 Jalal cookleber baused Data table Sales volume (gallons) # production runs Vanilla 16,000 15 Requirements (a) Data Table hat only full-time employees can be hired, determin get this product equired for this X e statement. io of gross profi acity? uction plan. Also, Chocolate Strawberry Mocha-Almond Total 15,000 1,800 1,000 33,800 20 7 2 44 Print Done al cream plant. They prepared the following time-driven ABC analysis for forecasting resource capacity. Suppose that all the information is the same except for the following (Click the icon to view the updated information) (Click the icon to view additional data.) Requirements (Click the icon to view the total direct labor hours.) (Click the icon to view the total indirect labor hours.) (a) Assuming that only full-time employees can be hired, determine the number of production employees required to meet this production plan. Also, determine the number of machines required for this production plan. (Click the icon to view the total machine hours.) (Click the icon to view the pro forma product profitability) (b) Prepare a pro forma monthly product line income statement (c) What are the company's gross profit and the ratio of gross profitto sales after incorporating the cost of unused capacity? C piete Requirement (a) Assuming that only full-time employees can be hired, determine the number of production employees required to meet this production plan. Also, determine the number of machines required for this production plan. Begin by determining the total direct labor hours using the updated information, (Round your answers to one decimal place.) Vanilla Chocolate Strawberry Mocha-Almond Total Production and sales volume (gallions) 0.03 Direct labor hours per gallon 0.03 0.03 0.03 Total direct labor hours. Total Next determine the total indirect labor hours using the updated information. (Round your answers to one decimal place) Vanilla Chocolate Strawberry Mocha-Almond hr See sco 100 84.63 57.811 100W see score hachines requi production plan. (b) Prepare a pro forma monthly product line income sta (c) What are the company's gross profit and the ratio of sales after incorporating the cost of unused capacity View the total machine hours.) (Click the icon to view the pro forma product profitability.) E Next determine the total indirect lapor nours using the updated information. (Kound your answers to one decimal place. Vanilla Chocolate Strawberry Mocha-Almond Total # of production runs Handle production runs (hours/run) 2.3 2.3 2.3 2.3 Indirect labor-handle runs Setup time per run (hours) 2.6 1.3 1.8 3.3 Indirect labor hours per run 5.2 2.6 3.6 6.6 Indirect labor-total setup hours 7.9 7.9 7.9 7.9 Indirect labor-maintain products Total indirect labor hours (Round your answer up to the nearest whole number.) N 10 31.6 (Round your answer up to the nearest whole number.) Tulsa Dairy would require production employees to meet this production plan. Next determine the total machine hours using the updated information. (Round your answers to one decimal place.) Vanilla Chocolate Strawberry Mocha-Almond Total Production volume Machine hours per 1000 gallon 8 8 8 8 Total machine run time (hours) Number of production runs Setup time per run (hours) Machine setup time (hours) 2.6 1.3 3.3 1.8 Used capacity? C mure of this k the icon to view the total machine hours.) (b) production plan. Prepare a pro forma monthly product line income statement What are the company's gross profit and the ratio of gross profit to sales after incorporating the cost of unused capacity? (Click the icon to view the pro forma product profitability) (c) ma plete Total machine hours (Round interim calculations to one decimal place and round your final answer up to the nearest whole number.) Tulsa Dairy would require machines to meet this production plan. Requirement (b) Prepare a pro forma monthly product line income statement. (Round all interim and final per unit calculations to the nearest cent and all other dollar amounts to the nearest whole dollar, then round the gross profit (% of sales) to the nearest tenth percent, XX%) Total Vanilla 2.75 $ Chocolate Strawberry Mocha-Almond 2.75 $ 3.60 $ 4.20 #f1 Selling price Sales volume Revenues Direct materials $ 84.6 57.8 100 see scors 2.75 $ Selling price Sales volume 3.60 $ 4.20 Revenues Direct materials Direct labor (including fringes) Indirect labor plete Machinery Gross profit Gross profit (% of sales) Requirement (c) What are the company's gross profit and the ratio of gross profit to sales after incorporating the cost of unused capacity? (Round dollar amounts to the nearest whole dollar, then round the gross profit (% of sales) to the nearest tenth percent. X.X%.) Gross profit 201 Unused labor capacity cost Unused machine capacity cost Adjusted gross profit % Adjusted gross profit (% of sales) $ 2.75 $ Next see 84 573 10 see scon