[lilmagic21]

The question asks what is the planned cost of tellers in an average month

The information given is that in November 1,520 hours were worked, 19,000$ was received in wages, 32,000 transactions were made in a bank. The transactions were higher in November because the average monthly volume is 24,000 transactions. And the employees get paid 12.50$ and on budget should be making about 20 transactions an hour.

Now what I'm confused on is how to set up the table to find the cost of tellers in an average month.
Like all the examples in my book have tables for master budgets that include revenue but this one is for cost and I don't have an example. So I don't know what's needed to find the cost.

My assumption is that it would be the transactions and the transactions made per hour plus the amount of hours worked and the total wages paid.

[morgaine300]

That table of yours is a book thing and no one would know how they set that up. A book can set things up any way they like. Since what you wrote at the bottom doesn't make any sense math-wise, I'll assume you're trying to say what you think goes on that table. I'm sure all of it goes in there some place, but wouldn't know where or how without knowing what the table is.

If you need to know what is budgeted, it's $12.50 per hour. And if you divide the normal monthly transactions by the 20 average per hour, that tells you what is the normal number of hours in a month. That's all your budgeted numbers.

However, since you're asking about the table, I'm not sure if you're just confused about the (unimportant) table, or what you do or do not understand about the information itself and what you're supposed to be doing with it. It's more important that you understand the information. A table is just a way to keep it all neat and organized so you know what you've got to work with, have everything labeled, etc. You should do that anyway.

Don't count on tables to learn how to do things. That's just plug n chug. Study the table and see if you can figure out WHY the numbers are doing what they're doing, not just some slot to stick them in.