Can you show the formulas used?

B D E F G Steve is in trouble. He has never been a particularly strong labor cost control person. He likes to think of himself more as a "people person." His boss, however, believes that Steve must get more serious about controlling labor costs or he will make Steve an unemployed people person! Steve estimates his weekly sales, and then submits that figure to his boss, who then assigns Steve a labor budget for the week. Steve's operating results and budget figures for last month are presented below. Compute Steve's % of budget figures for both sales and labor cost. Also compute Steve's budgeted and actual labor cost percentages per week and for the five-week accounting period. - 5 3 Sales Labor Cost Labor Cost Percent % of % of 7 Week Budget Actual Budget Budget Actual Budget Budget Actual 8 1 $2,500 $2,250 $875 $900 9 2 1,700 1,610 595 630 10 3 4,080 3,650 1,224 1,300 11 4 3,100 2,800 1,085 1,100 12 5 2,600 2,400 910 980 13 Total Q2 Q3 Q4 Q5 Q6 Q8 fx Answer: A19 G AD B D E F H 11 4 3,100 2,800 1,085 1,100 12 5 2,600 2,400 910 980 13 Total 14 15 Do you feel that Steve has significant variations from his budgeted numbers? Why do you think Steve's boss 16 assigned Steve a lower labor cost % goal during week 3? fow do you feel about Steve's overall performance? What would you do if you were Steve's boss? If you were Steve? Type your answers in the box below. CO DO 17 18 19 Answer 20 21 22 23 24 25 26 27 28 29 30 NN- NNNNNNNN CONA