Chicago dairy has an ice cream plant. they prepared the following time-driven ABC analysis for forecasting resource capacity

ps: I have this question with answers however I can't understand how it got those results at certain points of the exercise.

Requirements

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.

B) Prepare a pro forma monthly product line income statement

C) what are the companies gross profit at the ratio of gross profit to sales after incorporating the cost of unused capacity?

there's a comment saying the data is not clear but this is literally the whole exercise with answers and all the information provided for me I included in the question.

Chicago Dairy has an ice 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) (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 indirect labor hours) (b) Prepare a pro forma monthly product line income statement (Click the icon to view the total machine hours) (c) 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) Requirement (a) Assuming that only fut-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) Vanila Chocolate Strawberry Mocha-Almond Total Production and sales volume (gallons) 17,000 11,500 1,700 1,500 31,700 Direct labor hours per gallon 0.02 0.02 0.02 0.02 Chicago Dairy has an ice cream plant. They prepared the following time-driven ABC analysis for D Vanilla Chocolate Strawberry Mocha-Almond Total Production and sales volume (gallons) 17,000 11,500 1,700 1,500 31,700 Direct labor hours per gallon 0.02 0.02 0.02 0.02 Total direct labor hours 340.0 230.0 34.0 30.0 634.0 Next determine the total indirect labor hours using the updated information. (Round your answers to one decimal place.) Vanilla Chocolate Strawberry Mocha-Almond Total # of production runs 17 6 Handle production runs (hours/run) 2.7 2.7 2.7 Indirect labor-handle runs Setup time per run (hours) Indirect labor hours per run Indirect labor-total setup hours 15 2.7 40.5 1.8 3.6 54.0 Y 45,9 0.9 1.8 30.6 10.8 2.4 4.8 19.2 16.2 4 D 3.0 6.0 36.0 113.4 139.8 Suppose that all the information is the same exce 54.0 Chicago Dairy has an ice cream plant. They prepared the following time-driven ABC analysis for BRUAR TRUS JA TU J.U 1.0 4.0 U.U Indirect labor-total setup hours 30.6 19.2 7.8 7.8 Indirect labor-maintain products 7.8 7,8 Total indirect labor hours 102.3 84.3 37.8 60.0 284.4 (Round your answer up to the nearest whole number.) Chicago Dairy would require 7 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 17,000 11,500 1,700 1,500 31,700 10 10 10 Machine hours per 1000 gallon Total machine run time (hours) Number of production runs 170.0 115.0 317.0 15 17 Setup time per run (hours); 1.8 0.9 10 17.0 2.4 36.0 O 15.0 3.0 139.8 31.2 Suppose that all the information is the same except for t Chicago Dairy has an ice cream plant. They prepared the following time-driven ABC analysis for Suppose that all the information is the same excep Setup time per run (hours) 1.8 0.9 2.4 3.0 27.0 15.3 9.6 18.0 69.9 Machine setup time (hours) 197.0 130.3 Total machine hours 26.6 33.0 386.9 (Round interim calculations to one decimal place and round your final answer up to the nearest whole number.) Chicago Dairy would require 3 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 a round the gross profit (% of sales) to the nearest tenth percent, X.X%.) Vanilla Chocolate Strawberry Mocha-Almond Total Selling price Sales volume Revenues Direct materials Direct labor (including fringes) 3.00 $ 17,000 $ 51,000 $ 9,350 10,200 3.25 $ 11,500 37,375 S 6,325 6,900 3.65 $ 1,700 6,205 $ 935 1,020 4.40 $ 3.19 1,500 31,700 6,600 $ 101,180 840 17,450 900 19,020 Chicago Dairy has an ice cream plant. They prop red the following um-aven ABC dialysis for 9,350 6,325 935 840 Direct materials 10,200 6,900 1,020 900 Direct labor (including fringes) 3,069 2.529 1,134 Indirect labor 1,800 10,441 6,906 1,410 1,749 Machinery 17.940 S 14,715 S 1,706 S 1,311 S Gross profit 35.2 % 39.4% 27.5% 19.9% Gross profit (% of sales) 35.3% 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 r profit (% of sales) to the nearest tenth percent, XX%.) Gross profit $ 35,672 Unused labor capacity cost 798 3,662 Unused machine capacity cost $ 31,212 Adjusted gross profit Adjusted gross profit (% of sales) 30.8 % 17,450 19,020 8,532 20,506 35,672 (Click the icon to view the updated information.) - X - Additional data Chicago Dairy's employees are available for 135 hours of work each month and have a total monthly compensation of $4,050 per employee. This results in a cost rate per employee of $30 per hour. Chicago Dairy leases machines on a monthly basis. The lease cost for each machine is $8,056 with a total available capacity per machine line of 152 hours per month. This results in a cost rate for machines of $53 per machine hour. Print Done es can be hired, determine duction plan. Also, determin line income statement. and the ratio of gross profit so, determine the number Total direct labor hours Production and sales volume (gallons) Direct labor hours per gallon Total direct labor hours Vanilla Chocolate Strawberry Mocha-Almond 12,500 9,700 1,500 1,300 0.02 0.02 0.02 0.02 250.0 194.0 30.0 26.0 Print Click the icon to view the updated information) - X Done Total 25,000 500.0 e hired, determine an. Also, determin me statement. atio of gross profit mine the number of The da ire ndi 30 m -ti 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 Total 18 10 2 3 2.7 2.7 2.7 48.6 27.0 8.1 89.1 1.8 3.0 3.6 6.0 64.8 18.0 110.4 7.8 7.8 31.2 121.2 33.9 230.7 Print 0.9 1.8 18.0 7.8 52.8 Done - X the following: 2.7 5.4 2.4 4.8 9.6 7.8 22.8 red, determine the number Also, determine the numbe statement. of gross profit to sales afte e the number of machines T 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 Chocolate Strawberry Mocha-Almond 12,500 9,700 1,500 1,300 10 10 10 10 125.0 97.0 15.0 13.0 18 10 2 3 1.8. 0.9 2.4 3.0 9.0 4.8 9.0 106.0 22.0 32.4 157.4 Print Done 19.8 Total 25,000 250.0 55.2 305.2 X the following: hired, determine the number . Also, determine the numb e statement. o of gross profit to sales aft ne the number of machines m plant. The additional da the total dire the total indi the total mad the pro form that only full-ti Pro forma product profitability (Amounts are rounded to the nearest dollar.) Vanilla Selling price Sales volume Revenues Direct materials Direct labor (including fringes) Indirect labor Machinery Gross profit Gross profit (% of sales) $ $ $ Chocolate Strawberry Mocha-Almond 3.25 $ 3.65 $ 4.40 $ 3.00 $ 12,500 37,500 $ 6,875 7,500 3,636 8,342 11,147 S 29.7% Print 9,700 31,525 $ 5,335 5,820 1,584 5,618 13,168 S 41.8% 1,500 5,475 S 825 900 684 1,049 2,017 S 36.8 % Done 1,300 5,720 $ 728 780 1,017 1,166 2,029 $ 35.5% Total 3.21 25,000 80,220 13,763 15,000 6,921 16.176 28,360 35.4% I X the following: red, determine the number of production Also, determine the number of machines statement of gross profit to sales after incorporating e the number of machines required for (Click the icon to view the updated information.) Requirements. e hired, determine the r X an. Also, determine them me statement. atio of gross profit to sa Mocha-Almond Total 1,500 31,700 Sales volume (gallons) # production runs 6 42 Print Done employees can be hired, determine the number of production employees required to meet this production plan. Also, determine the number of mach Data table Vanilla 17,000 15 Chocolate: 11,500 17 Strawberry 1,700 4 Chicago Dairy has an ice 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) (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 indirect labor hours) (b) Prepare a pro forma monthly product line income statement (Click the icon to view the total machine hours) (c) 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) Requirement (a) Assuming that only fut-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) Vanila Chocolate Strawberry Mocha-Almond Total Production and sales volume (gallons) 17,000 11,500 1,700 1,500 31,700 Direct labor hours per gallon 0.02 0.02 0.02 0.02 Chicago Dairy has an ice cream plant. They prepared the following time-driven ABC analysis for D Vanilla Chocolate Strawberry Mocha-Almond Total Production and sales volume (gallons) 17,000 11,500 1,700 1,500 31,700 Direct labor hours per gallon 0.02 0.02 0.02 0.02 Total direct labor hours 340.0 230.0 34.0 30.0 634.0 Next determine the total indirect labor hours using the updated information. (Round your answers to one decimal place.) Vanilla Chocolate Strawberry Mocha-Almond Total # of production runs 17 6 Handle production runs (hours/run) 2.7 2.7 2.7 Indirect labor-handle runs Setup time per run (hours) Indirect labor hours per run Indirect labor-total setup hours 15 2.7 40.5 1.8 3.6 54.0 Y 45,9 0.9 1.8 30.6 10.8 2.4 4.8 19.2 16.2 4 D 3.0 6.0 36.0 113.4 139.8 Suppose that all the information is the same exce 54.0 Chicago Dairy has an ice cream plant. They prepared the following time-driven ABC analysis for BRUAR TRUS JA TU J.U 1.0 4.0 U.U Indirect labor-total setup hours 30.6 19.2 7.8 7.8 Indirect labor-maintain products 7.8 7,8 Total indirect labor hours 102.3 84.3 37.8 60.0 284.4 (Round your answer up to the nearest whole number.) Chicago Dairy would require 7 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 17,000 11,500 1,700 1,500 31,700 10 10 10 Machine hours per 1000 gallon Total machine run time (hours) Number of production runs 170.0 115.0 317.0 15 17 Setup time per run (hours); 1.8 0.9 10 17.0 2.4 36.0 O 15.0 3.0 139.8 31.2 Suppose that all the information is the same except for t Chicago Dairy has an ice cream plant. They prepared the following time-driven ABC analysis for Suppose that all the information is the same excep Setup time per run (hours) 1.8 0.9 2.4 3.0 27.0 15.3 9.6 18.0 69.9 Machine setup time (hours) 197.0 130.3 Total machine hours 26.6 33.0 386.9 (Round interim calculations to one decimal place and round your final answer up to the nearest whole number.) Chicago Dairy would require 3 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 a round the gross profit (% of sales) to the nearest tenth percent, X.X%.) Vanilla Chocolate Strawberry Mocha-Almond Total Selling price Sales volume Revenues Direct materials Direct labor (including fringes) 3.00 $ 17,000 $ 51,000 $ 9,350 10,200 3.25 $ 11,500 37,375 S 6,325 6,900 3.65 $ 1,700 6,205 $ 935 1,020 4.40 $ 3.19 1,500 31,700 6,600 $ 101,180 840 17,450 900 19,020 Chicago Dairy has an ice cream plant. They prop red the following um-aven ABC dialysis for 9,350 6,325 935 840 Direct materials 10,200 6,900 1,020 900 Direct labor (including fringes) 3,069 2.529 1,134 Indirect labor 1,800 10,441 6,906 1,410 1,749 Machinery 17.940 S 14,715 S 1,706 S 1,311 S Gross profit 35.2 % 39.4% 27.5% 19.9% Gross profit (% of sales) 35.3% 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 r profit (% of sales) to the nearest tenth percent, XX%.) Gross profit $ 35,672 Unused labor capacity cost 798 3,662 Unused machine capacity cost $ 31,212 Adjusted gross profit Adjusted gross profit (% of sales) 30.8 % 17,450 19,020 8,532 20,506 35,672 (Click the icon to view the updated information.) - X - Additional data Chicago Dairy's employees are available for 135 hours of work each month and have a total monthly compensation of $4,050 per employee. This results in a cost rate per employee of $30 per hour. Chicago Dairy leases machines on a monthly basis. The lease cost for each machine is $8,056 with a total available capacity per machine line of 152 hours per month. This results in a cost rate for machines of $53 per machine hour. Print Done es can be hired, determine duction plan. Also, determin line income statement. and the ratio of gross profit so, determine the number Total direct labor hours Production and sales volume (gallons) Direct labor hours per gallon Total direct labor hours Vanilla Chocolate Strawberry Mocha-Almond 12,500 9,700 1,500 1,300 0.02 0.02 0.02 0.02 250.0 194.0 30.0 26.0 Print Click the icon to view the updated information) - X Done Total 25,000 500.0 e hired, determine an. Also, determin me statement. atio of gross profit mine the number of The da ire ndi 30 m -ti 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 Total 18 10 2 3 2.7 2.7 2.7 48.6 27.0 8.1 89.1 1.8 3.0 3.6 6.0 64.8 18.0 110.4 7.8 7.8 31.2 121.2 33.9 230.7 Print 0.9 1.8 18.0 7.8 52.8 Done - X the following: 2.7 5.4 2.4 4.8 9.6 7.8 22.8 red, determine the number Also, determine the numbe statement. of gross profit to sales afte e the number of machines T 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 Chocolate Strawberry Mocha-Almond 12,500 9,700 1,500 1,300 10 10 10 10 125.0 97.0 15.0 13.0 18 10 2 3 1.8. 0.9 2.4 3.0 9.0 4.8 9.0 106.0 22.0 32.4 157.4 Print Done 19.8 Total 25,000 250.0 55.2 305.2 X the following: hired, determine the number . Also, determine the numb e statement. o of gross profit to sales aft ne the number of machines m plant. The additional da the total dire the total indi the total mad the pro form that only full-ti Pro forma product profitability (Amounts are rounded to the nearest dollar.) Vanilla Selling price Sales volume Revenues Direct materials Direct labor (including fringes) Indirect labor Machinery Gross profit Gross profit (% of sales) $ $ $ Chocolate Strawberry Mocha-Almond 3.25 $ 3.65 $ 4.40 $ 3.00 $ 12,500 37,500 $ 6,875 7,500 3,636 8,342 11,147 S 29.7% Print 9,700 31,525 $ 5,335 5,820 1,584 5,618 13,168 S 41.8% 1,500 5,475 S 825 900 684 1,049 2,017 S 36.8 % Done 1,300 5,720 $ 728 780 1,017 1,166 2,029 $ 35.5% Total 3.21 25,000 80,220 13,763 15,000 6,921 16.176 28,360 35.4% I X the following: red, determine the number of production Also, determine the number of machines statement of gross profit to sales after incorporating e the number of machines required for (Click the icon to view the updated information.) Requirements. e hired, determine the r X an. Also, determine them me statement. atio of gross profit to sa Mocha-Almond Total 1,500 31,700 Sales volume (gallons) # production runs 6 42 Print Done employees can be hired, determine the number of production employees required to meet this production plan. Also, determine the number of mach Data table Vanilla 17,000 15 Chocolate: 11,500 17 Strawberry 1,700 4