ch07 (3) Excel File Insert Draw Page Layout Formulas Data Review View Tell me what you want to do Home Cut 110A' A' |9- bewrap Text E3Merge & Centera $ .% , Arial General Copy ,Format Painter Blu -A- Clipboard Font Number Steve is in trouble. He has never been a particularly strong labor cost co 1 Chapter 7, Question 6 3 Steve is in trouble. He has never been a particularly strong labor cost control person. He likes to think of himself 4 more as a people person. His boss, however, believes that Steve must get more serious about controling 5 labor costs or he will make Steve an unemployed people person! Steve estimates his weekly sales and then 6 submits that figure to his boss, who then assigns Steve a labor budget for the week. Steve's operating results 7 and budget figures for last month are presented below 9 | a. Compute Steve's % of Budget figures for both sales and labor cost. Also, fill in the columns for Budget and 10 | Labor Cost%per week for the five-week accounting penod. 12 Sales Labor Cost Labor Cost % %of %of 13 Week Budget Actual Budget Budget Actual Budget Budget Actual 14 1 15 2 16 3 17 18 5 19 Total 20 S2,500 $2,250 1,700 1,610 4,080 3,650 3,100 2,800 2,600 2,400 $875 $900 595 630 1,224 1,300 1,085 1,100 910 980 1 Do you feel that Steve has significant variations from budget? Why do you think Steve's boss assigned Steve Ready O Type here to search