Budget for Internal Service Fund

 

Using Chapter 7, compute the total cost under the two separate scenarios in a one to two page document. Clearly label your calculations and explain the differences in the two scenarios.
Budget for Internal service Fund
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.
Continuation
Assume the information presented in chapter 7, 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.
Your submission must include the following:
• 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.
Required Resources
Text
Ives, M., Patton, T., Patton, S. (2013). Introduction to governmental and not-for-profit accounting (7th ed.). Pearson.
• Chapter 5: The Governmental Fund Accounting Cycle: Additional Transactions of General and Special Revenue Funds – Introduction to Permanent Funds
• Chapter 6: The Governmental Fund Accounting Cycle: Capital Projects Funds, Debt Service Funds, and Special Assessments
• Chapter 7: The Governmental Fund Accounting Cycle: Proprietary-Type Funds
• Chapter 9: Reporting Principles and Preparation of Fund Financial Statements
• The full-text version of this ebook is available in your online classroom through the VitalSource platform.

This question has been answered.

Get Answer