Question

A restaurant has the following quarterly record of revenue and employee wage costs. Using the maximum/minimum...

  1. A restaurant has the following quarterly record of revenue and employee wage costs. Using the maximum/minimum (high-low) method, determine (A.) the quarterly fixed wage cost,(B.) total fixed wage cost for a year, (C.) total variable wage cost for a year, and (D.) the variable cost percentage. Show your work and answers

Revenue

Wage Costs

1st Q

33,000

13,500

2nd Q

50,500

20,300

3rd Q

58,000

21,800

4th Q

45,500

18,200

Sum

187,000

73,800

Homework Answers

Answer #1

Solution: (A.) Variable cost = (Highest activity cost - Lower activity cost) / (Highest activity units - Lower activity units)

= (21,800 - 13,500) / (58,000 - 33,000)

= 8,300 / 25,000 = 0.332

Quarterly Fixed Cost = Total cost - Variable Cost

= 13,500 - 33,000 * 0.332

= 13,500 - 10,956 = 2,544

(B.) Total fixed wage cost for a year = Quarterly fixed cost * 4

= 2,544 * 4 = 10,176

(C.) Total variable wage cost for a year = Total wage cost - Total fixed cost

= 73,800 - 10,176 = 63,624

(D.) Variable cost percentage = Variable cost / Total cost * 100

= 63,624 / 73,800 *100 = 86.21%

Please rate positive and comment in case of any doubt. I would be happy to help you further.

  

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The Production Department of Hruska Corporation has submitted the following forecast of units to be produced...
The Production Department of Hruska Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 10,700 9,700 11,700 12,700 Each unit requires 0.25 direct labor-hours and direct laborers are paid $13.00 per hour. In addition, the variable manufacturing overhead rate is $1.80 per direct labor-hour. The fixed manufacturing overhead is $87,000 per quarter. The only noncash element of manufacturing overhead...
The Production Department of Hruska Corporation has submitted the following forecast of units to be produced...
The Production Department of Hruska Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 11,600 10,600 12,600 13,600 Each unit requires 0.20 direct labor-hours and direct laborers are paid $15.00 per hour. In addition, the variable manufacturing overhead rate is $1.75 per direct labor-hour. The fixed manufacturing overhead is $96,000 per quarter. The only noncash element of manufacturing overhead...
A restaurant currently has a sales revenue of $1,000,000 with variable cost averaging 60%. Fixed costs...
A restaurant currently has a sales revenue of $1,000,000 with variable cost averaging 60%. Fixed costs are $300,000. The owner wants a net income after tax of $150,000 and the tax rate is 20% Determine the “current” net income after tax Determine the “new” required total sales revenue based on owner’s request
ch 7 exer #10 The Production Department of Hruska Corporation has submitted the following forecast of...
ch 7 exer #10 The Production Department of Hruska Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter   Units to be produced 10,500 9,500 11,500 12,500 Each unit requires 0.30 direct labor-hours and direct laborers are paid $12.50 per hour.      In addition, the variable manufacturing overhead rate is $1.80 per direct labor-hour. The fixed manufacturing overhead is $85,000 per quarter. The only noncash...
You have the following projections about the costs in a fast food restaurant for the next...
You have the following projections about the costs in a fast food restaurant for the next year: Net income [AT] required is 18% on the equity investment of $240,00. The income tax rate is 28%. Depreciation on restaurant furnishings and equipment is 20% of the present book value of $112,000. Interest on the bank loan is 12% of the present balance owed of $50,000. Other costs are: Insurance expense $4,500 Licenses expense $3,200 Utilities expense $12,600 Maintenance expense $1,200 Management...
The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming...
The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 8,400 6,500 7,200 8,100 Each unit requires 0.65 direct labor-hours, and direct laborers are paid $12.00 per hour. Required: 1. Prepare the company’s direct labor budget for the upcoming fiscal year. Assume that the direct labor workforce is adjusted each quarter to match the number of hours required to produce...
The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming...
The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 8,200 6,500 7,100 8,000 Each unit requires 0.25 direct labor-hours, and direct laborers are paid $12.00 per hour. Required: 1. Prepare the company’s direct labor budget for the upcoming fiscal year. Assume that the direct labor workforce is adjusted each quarter to match the number of hours required to produce...
4. A company that makes optical computer input devices has calculated their revenue and costs as...
4. A company that makes optical computer input devices has calculated their revenue and costs as follows for the most recent fiscal period: Sales ​$522 000 Costs: ​Fixed Costs​ $145 000 ​Variable Costs ​208 800 Total Costs ​353 800 Net Income ​$168 200 ​What is the break-even point in sales dollars? 5. A company that makes environmental measuring devices has calculated their revenue and costs as follows for the most recent fiscal period: Sales ​$750 000 Costs: ​Fixed Costs​ $200...
The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming...
The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 8,200 6,500 7,100 8,000 Each unit requires 0.25 direct labor-hours, and direct laborers are paid $12.00 per hour. Required: 2. Prepare the company’s direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is not adjusted each quarter. Instead, assume that the company’s direct labor workforce...
The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming...
The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 11,200 8,500 8,600 10,900 Each unit requires 0.55 direct labor-hours, and direct laborers are paid $16.00 per hour. Required: 1. Prepare the company’s direct labor budget for the upcoming fiscal year. Assume that the direct labor workforce is adjusted each quarter to match the number of hours required to produce...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT