Question

Valotic Tech Inc. sells electronics over the Internet. The Consumer Products Division is organized as a cost center. The budget for the Consumer Products Division for the month ended January 31 is as follows (in thousands):
1. Customer service salaries $546,840.00
2. Insurance and property taxes 114,660.00
3. Distribution salaries 872,340.00
4. Marketing salaries 1,028,370.00
5. Engineer salaries 836,850.00
6. Warehouse wages 586,110.00
7. Equipment depreciation 183,792.00
8. Total $4,168,962.00
During January, the costs incurred in the Consumer Products Division were as follows:
1. Customer service salaries $602,350.00
2. Insurance and property taxes 110,240.00
3. Distribution salaries 861,200.00
4. Marketing salaries 1,085,230.00
5. Engineer salaries 820,008.00
6. Warehouse wages 562,632.00
7. Equipment depreciation 183,610.00
8. Total $4,225,270.00
Required:
1. Prepare a budget performance report for the director of the Consumer Products Division for the month of January. Enter all amounts as positive numbers.
Valotic Tech Inc.
Budget Performance Report—Director, Consumer Products Division
For the Month Ended January 31, 2016
1 Budget Actual Over Budget Under Budget
2 Customer service salaries
3 Insurance and property taxes
4 Distribution salaries
5 Marketing salaries
6 Engineer salaries
7 Warehouse wages
8 Equipment depreciation
9 Total
2. For which costs might the director be expected to request supplemental reports?

Answer 1

Answer:

Total Over budget = $112370

Total Under Budget= $ 56062

Explanation:

Valotic Tech Inc.

Budget Performance Report—Director, Consumer Products Division

For the Month Ended January 31, 2016

                                                 Budget          Actual       (Over) Under Budget

Customer service salaries   $546,840     $602,350         (55,510)

Insurance & property taxes    114,660        110,240             4420

Distribution salaries               872,340         861,200           11,140

Marketing salaries               1,028,370       1,085,230          (56,860)

Engineer salaries                 836,850          820,008         16842

Warehouse wages                586,110          562,632          23478

Equipment depreciation        183,792        183,610                182              

Total                                  $4,168,962      $4,225,270        (56308)      

Total Over budget = $112370

Total Under Budget= $ 56062

Over budget means that the amount is spent more than the amount budgeted.

The Customer service salaries and  Marketing salaries are over budgeted and the the director is expected to request supplemental reports of these to analyze where the amount has been overspent.