Solve the following year. You should do the same in MS Excel, showing all steps to resolve it and then sends the file to the platform. Points will be provided by the process. If only samples the result will not get score.
The following formula of cost-volume costs "overhead" for the company offered Manufacturers Caribbean, for the current year 20xx:
Item Cost-Volume Formula
Utilities $ 1,000 a year, plus $ 0.85 per hour of work
Supplies (Utilities) $ 3.180 per year, plus $ 1.05 per hour of work
Depreciation is $ 2.850 per year
The indirect labor is $ 2.350 per year, plus $ 0.55 per hour of work
Insurance - $ 500 per year
During the year, the following activities took place:
Working hours budgeted 6.200 hours
Working Hours worked 5.980 hours
General expenses were:
Utilities ($ 700 fixed) $ 3.350
Supplies ($ 1.235 fixed) $ 5.325
Depreciation $ 2,850
Indirect labor ($ 3, 337 fixed) $ 5.850
Insurance $ 500
REQUIRED: Prepare a "performance report" for the 20xx. Remember to include header and all its components.