Question: 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

  1. 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 as follows. (5 points)

Compute Steve's percentage of budget figures for both sales and labor cost. Also, compute Steve's budget and actual labor cost percentages per week and for the 5week accounting period.

Operating Results: Steves Airport Deli

For Weeks 15

Sales

Labor Cost

Labor Cost %

Week

Budget

Actual

% of Budget

Budget

Actual

% of Budget

Budget

Actual

1

$5,500

$5,250

$785

$800

2

1,700

1,610

595

630

3

4,080

3,650

1,224

1,300

4

3,100

2,800

1,085

1,100

5

2,600

2,400

910

960

Total

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The table displaying Steves budget and actual labor cost ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

20250309_171241.xlsx

300 KBs Excel File

Students Have Also Explored These Related Accounting Questions!