Reference no: EM131768074

Compute the total cost under the two separate scenarios in a 1-2 page document. Clearly label your calculations and explain the differences in the two scenarios.

Part 1 - The City of Eagle Rock uses an Internal Service Fund to provided printing services to its various departments. It bills departments on the basis of an estimated rate per page of printed material, computed on the accrual basis of accounting. From the following information, compute the total cost that will be used to develop the cost per page. Assume that the equipment in the item 6 was contributed by the city and that the pricing objective was to recoup the cost of equipment in the rate charged over the life of the equipment.

Inventory of paper on hand at beginning of year: $10, 000.
Estimated paper purchase during the year: $60,000.
Estimated amount of paper to be consumed during the year: $55,000.
Estimated salaries to be paid during the year: $255,000.
Estimated salaries earned during the year, including both what was paid and what was owed at year end: 265,000.
Cost of equipment on hand at beginning of the year (estimated life was 10 years):$1,000,000.

Part 2 - Assume the information presented in part 1, except that the city did not contribute the equipment. Instead, the manager of the Internal Service Fund arranged to buy the equipment, paying for it over a period of 5 years. The terms of the acquisition required annual payments of $200,000 at the end of each year, with interest of 8% on the unpaid balance. The first payment was made, and it is in the second year of operation. Assume also that the fund has just enough cash on hand to finance its working capital needs, such as inventory requirements. Using these assumptions, determine and explain the different calculation requirements.

Attach the Excel spreadsheet to your Word document with your calculations.

A one- to two-page summary of the computations of the total cost of printing services based on items 1-6 above.

One additional page determining and explaining your different calculation requirements.