Move It Across Town is a delivery service that uses four small vans and six pickup trucks to deliver small to medium sized packages around the Denver Metropolitan area. The company costs include a considerable amount for gas, oil, and regular maintenance of these vehicles, which is done at a variety of service stations and repair shops. To budget vehicle expense for the upcoming year, the company’s accountant has gathered data on these expenses and the number of deliveries for each month of the current year.
we have Total vehicle expense and total delivery
| January | $63,650 | 645 |
| February | $68,900 | 743 |
| March | $59,439 | 605 |
| April | $62,694 | 658 |
| May | $57,593 | 555 |
| June | $68,339 | 699 |
| July | $57,866 | 529 |
| August | $61,620 | 681 |
| September | $52,329 | 516 |
| October | $55,826 | 602 |
| November | $59,192 | 604 |
| December | $58,182 | 571 |
Required:
Move It Across Town is a delivery service that uses four small vans and six pickup...
Travel
Pickup and
Delivery
Customer
Service
Other
Totals
Driver and guard
wages..........................
Vehicle operating
expense......................
Vehicle
depreciation................................
Customer
representative salaries and
expenses..............................................
Office
expenses......................................
Administrative
expenses.........................
Total
cost................................................
$628,000
$306,000
$417,000
$279,000
$1,630,000
Each entry in the table is derived by
multiplying the total cost for the cost category by the percentage
taken from the table below that shows the distribution of resource
consumption:
Travel
Pickup and
Delivery
Customer
Service
Other
Totals
Driver and guard
wages..........................
Vehicle operating
expense......................
Vehicle...