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
- 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
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)
20250309_171241.xlsx
300 KBs Excel File
