HELP!!! WHat are the steps on excel to answer questions a,b, and c

istructions: here are three parts to this problem. Use Excel to perform the following: a. Complete the direct materials purchases budget for milk for the three. month period. b. Create a pivot chart that identifies the specific days in which more than 28 gallons of milk are expected to be purchased. Whaut providing further calculations, indicate what may occur to the budgeted cost of malk purchases if any milk left over at the end of each day is disposed of, so that the milk tank can be sanitized dally. is this option preferable to the current practice? Provide justification for your response. Oaly cone production and sales for hune, July, and August \begin{tabular}{|c|c|c|c|c|c|} \hline Bate & NeCrewsCoveNoductionandSoled & Oate & forCiraveConeProdictionandsules & Date & keCreamCoreProtuctionandSales \\ \hline 6/1 & 505 & 7/1 & 508 & 8/1 & 626 \\ \hline 6/2 & 510 & 7/2 & 511 & 1/2 & 631 \\ \hline 6/3 & 514 & 7/3 & 700 & 8/3 & 516 \\ \hline 6/4 & 520 & 7/4 & 740 & 3/4 & 579 \\ \hline 6/5 & 602 & 7/5 & 755 & & 502 \\ \hline 6/6 & 645 & 7/6 & 50 s & 3/6 & 507 \\ \hline 6/7 & 654 & 7/7 & 508 & & 600 \\ \hline 6/8 & 501 & 7/8 & 519 & E/8 & 608 \\ \hline 6/9 & 502 & 7/9 & 315 & 8/9 & 617 \\ \hline 6/10 & 528 & 7/10 & 606 & x/10 & 511 \\ \hline 0/11 & 522 & 7/11 & 603 & /31 & 320 \\ \hline 6/12 & 620 & 7/12 & 620 & 8/22 & 525 \\ \hline 6/13 & 645 & 7/13 & 500 & 8/13 & 511 \\ \hline 6/14 & 665 & 7/14 & 530 & 8/14 & 625 \\ \hline 6/15 & 325 & 7/15 & 521 & W/15 & 624 \\ \hline 6/116 & 515 & 7/16 & 506 & 8/16 & 611 \\ \hline 6/17 & 509 & 7/17 & 604 & 8/17 & 526 \\ \hline 6/18 & 514 & 7/1n & 615 & N/1a & 527 \\ \hline 6/19 & 618 & 7/19 & 675 & 8/19 & 511 \\ \hline 6/20 & 600 & 7/20 & 520 & 8/20 & 501 \\ \hline 6/21 & 624 & 2/21 & 523 & 8/21 & 610 \\ \hline 6/22 & 520 & 7/22 & 514 & 8/22 & 615 \\ \hline 6/23 & 506 & 7/23 & 527 & 8/23 & 610 \\ \hline 6/24 & 570 & 7/24 & 620 & 8/24 & 501 \\ \hline 6/25 & 522 & 7/25 & 607 & 0/25 & 508 \\ \hline 6/26 & 607 & 7/26 & 613 & 2/26 & 501 \\ \hline 6/27. & 613 & 7/27 & 529 & M/27 & 518 \\ \hline 6/26 & 608 & 7/28 & & 3/28 & 630 \\ \hline 6/29 & 511 & 7/20 & 506 & N/29 & 617 \\ \hline fola & & & 5n1 & R/a0 & sul \\ \hline \end{tabular} a. Oirect materiali purchases budget b. Prvot tabie 5085302.250 514 520 602 (6/6) 6/7 645 654 504 501 502 528 522 629 645 665 525 6/16 6/17 515 509 6/18 514 6/19 618 600 Problem Ivy lce Cream operates a soft serve ice cream truck in the city of Neptune. During the summer months, a constant stream of customers are in line to purchase ice cream cones from 10AM through 6 PM from the truck which is parked at Neptune Beach regardless of the day of the week. Each day, the ice cream truck picks up its budgeted supply of milk from the dairy on its way to the beach where the truck parks for the day. The production of soft serve ice cream consists of two ingredients, milk and pre-made ice cream mix, which are mixed into ice cream in the truck's soft serve machine. The company has estimated the number of ice cream cones to be produced and sold each day for the three summer months. Production equals sales because there is no finished goods inventory at the end of the day. Because the beach season ends on August 31 no materials inventory is needed after that date, and no beginning materials inventory is on hand at the start of the season. The accountant is currently budgeting the amount of milk the beach ice cream truck needs on hand for summer operations. The number of gallons of milk expected to be on hand at the end of each day is equal to 12% of the gallons needed for sales the next day. Milk may be purchased in any quantity as it is pumped from a dairy tank into a milk holding tank in the ice cream truck upon purchase. Student Work Area Dally cone production and sales for June, July, and August a. Direct materials nurchases budat Shalomt Wert Arsa Shatemt Werk Arsa 1. Anvonesteperte is bacterlu buldop in the tank, and thir who ses asgeds moer protable. istructions: here are three parts to this problem. Use Excel to perform the following: a. Complete the direct materials purchases budget for milk for the three. month period. b. Create a pivot chart that identifies the specific days in which more than 28 gallons of milk are expected to be purchased. Whaut providing further calculations, indicate what may occur to the budgeted cost of malk purchases if any milk left over at the end of each day is disposed of, so that the milk tank can be sanitized dally. is this option preferable to the current practice? Provide justification for your response. Oaly cone production and sales for hune, July, and August \begin{tabular}{|c|c|c|c|c|c|} \hline Bate & NeCrewsCoveNoductionandSoled & Oate & forCiraveConeProdictionandsules & Date & keCreamCoreProtuctionandSales \\ \hline 6/1 & 505 & 7/1 & 508 & 8/1 & 626 \\ \hline 6/2 & 510 & 7/2 & 511 & 1/2 & 631 \\ \hline 6/3 & 514 & 7/3 & 700 & 8/3 & 516 \\ \hline 6/4 & 520 & 7/4 & 740 & 3/4 & 579 \\ \hline 6/5 & 602 & 7/5 & 755 & & 502 \\ \hline 6/6 & 645 & 7/6 & 50 s & 3/6 & 507 \\ \hline 6/7 & 654 & 7/7 & 508 & & 600 \\ \hline 6/8 & 501 & 7/8 & 519 & E/8 & 608 \\ \hline 6/9 & 502 & 7/9 & 315 & 8/9 & 617 \\ \hline 6/10 & 528 & 7/10 & 606 & x/10 & 511 \\ \hline 0/11 & 522 & 7/11 & 603 & /31 & 320 \\ \hline 6/12 & 620 & 7/12 & 620 & 8/22 & 525 \\ \hline 6/13 & 645 & 7/13 & 500 & 8/13 & 511 \\ \hline 6/14 & 665 & 7/14 & 530 & 8/14 & 625 \\ \hline 6/15 & 325 & 7/15 & 521 & W/15 & 624 \\ \hline 6/116 & 515 & 7/16 & 506 & 8/16 & 611 \\ \hline 6/17 & 509 & 7/17 & 604 & 8/17 & 526 \\ \hline 6/18 & 514 & 7/1n & 615 & N/1a & 527 \\ \hline 6/19 & 618 & 7/19 & 675 & 8/19 & 511 \\ \hline 6/20 & 600 & 7/20 & 520 & 8/20 & 501 \\ \hline 6/21 & 624 & 2/21 & 523 & 8/21 & 610 \\ \hline 6/22 & 520 & 7/22 & 514 & 8/22 & 615 \\ \hline 6/23 & 506 & 7/23 & 527 & 8/23 & 610 \\ \hline 6/24 & 570 & 7/24 & 620 & 8/24 & 501 \\ \hline 6/25 & 522 & 7/25 & 607 & 0/25 & 508 \\ \hline 6/26 & 607 & 7/26 & 613 & 2/26 & 501 \\ \hline 6/27. & 613 & 7/27 & 529 & M/27 & 518 \\ \hline 6/26 & 608 & 7/28 & & 3/28 & 630 \\ \hline 6/29 & 511 & 7/20 & 506 & N/29 & 617 \\ \hline fola & & & 5n1 & R/a0 & sul \\ \hline \end{tabular} a. Oirect materiali purchases budget b. Prvot tabie 5085302.250 514 520 602 (6/6) 6/7 645 654 504 501 502 528 522 629 645 665 525 6/16 6/17 515 509 6/18 514 6/19 618 600 Problem Ivy lce Cream operates a soft serve ice cream truck in the city of Neptune. During the summer months, a constant stream of customers are in line to purchase ice cream cones from 10AM through 6 PM from the truck which is parked at Neptune Beach regardless of the day of the week. Each day, the ice cream truck picks up its budgeted supply of milk from the dairy on its way to the beach where the truck parks for the day. The production of soft serve ice cream consists of two ingredients, milk and pre-made ice cream mix, which are mixed into ice cream in the truck's soft serve machine. The company has estimated the number of ice cream cones to be produced and sold each day for the three summer months. Production equals sales because there is no finished goods inventory at the end of the day. Because the beach season ends on August 31 no materials inventory is needed after that date, and no beginning materials inventory is on hand at the start of the season. The accountant is currently budgeting the amount of milk the beach ice cream truck needs on hand for summer operations. The number of gallons of milk expected to be on hand at the end of each day is equal to 12% of the gallons needed for sales the next day. Milk may be purchased in any quantity as it is pumped from a dairy tank into a milk holding tank in the ice cream truck upon purchase. Student Work Area Dally cone production and sales for June, July, and August a. Direct materials nurchases budat Shalomt Wert Arsa Shatemt Werk Arsa 1. Anvonesteperte is bacterlu buldop in the tank, and thir who ses asgeds moer protable