Schedule of non-discretionary data, Managerial Accounting

Schedule of Non-discretionary Data: and tables, in a form that is readable and readily understood.

 This worksheet is to be used to identify/capture the various non-discretionary data variables required for the model.  As the assignment specifications do not allow data input directly into any of the supporting schedules, you are required to link all references todata (other than the discretionary data schedule) to this worksheet. And in order to prevent inappropriate data being entered into the cells used for non-discretionary the cells in this worksheet must be locked by applying cell protection.  The purpose of this schedule is to provide a single place of entry for non-discretionary data to facilitate changes that the model designer may wish to make from time to time, whilst preventing the user from entering or changing either the data item or its value.

Revenue Forecast: that identifies the annual revenue associated with the project during the period of forcast investment.  This schedule will also indicate annual revenue from other sources. Details are provided in the Case Data and Details below.

A Repairs and Maintenance Schedule: (in one report), in respect to operating plant and equipment.  This schedule should detail the annual repairs and maintenance costs of each major class of assets. The Repairs and Maintenance schedule is to be in a table formatshowing the various amounts for each year of the project adjacent to each other. Details are provided in the Case Data and Details below.

A Replacements Schedule: (in one report), in respect to operating plant and equipment.  This schedule should detail the annual Replacement costs of each major class of assets.  The Repairs, Maintenance & Replacement schedule is to be in a table format showing the various amounts for each year of the project adjacent to each other. Details are provided in the Case Data and Details below.

7. Depreciation Schedule (in one report) ,for plant and equipment required for operating the complex, detailing the annual depreciation and written down book value of each major class of assets and written down book value of all depreciable assets.  The depreciation schedule is to be in a table format showing the various amounts for each year of the project adjacent to each other. Details are provided in the Case Data and Details below.

8. A Detailed Loan Amortisation Schedule:(in one report). The loan amortisation schedule of borrowings should show a summary (at the top of the report) of the amount borrowed, the annual and periodic interest rate, the term of the loan in years, the annual repayment, followed by details for each year, of yearly payment, yearly interest expense, yearly principal repaid, balance of principal outstanding at the end of each year, and a grand total for the term of the project.  Appropriate headings are required. Details are provided in the Case Data and Details below.

Posted Date: 3/2/2013 12:15:22 AM | Location : United States







Related Discussions:- Schedule of non-discretionary data, Assignment Help, Ask Question on Schedule of non-discretionary data, Get Answer, Expert's Help, Schedule of non-discretionary data Discussions

Write discussion on Schedule of non-discretionary data
Your posts are moderated
Related Questions
Types of Factoring The factoring facilities can be largely categorized in four groups that are as follows: 1)   Full service non-recourse (old line) 2)   Full service rec

Application of Transportation Model In the direct logic, the transportation model looks for the determination of a transportation plan of a particular commodity from a number o

When the stock market is going up over a long period of time, investors can become complacent about the risks of being a stockholder. After the significant decline of the stock mar

Describe the Principles of cost accounting Principles of cost accounting: The fundamental principles of costing are identical and are given below:   1. Cost is related to

Suppose the spot price of gold is $1700 per ounce. The futures price for delivery in six months is $1712, while the futures price for delivery in one year is $1720. The interest ra

Write a response to your boss, the controller. The response should be 2-5 pages in length (double-space). Your response to the controller should include, but not be limited to, t

Describe the method of drawing a break even chart. 1) volume of production/output or sales is plotted on horizontal axis , i. e y - axis . the volume of sales or production ma

What are the factors which led to the development of ABC: 1) Traditional costing fails to capture cause and effect relationship 2) Traditional costing often fails to highlig

1 Describe the impact of different types of standards on motivations, and specifically, the likely effect on motivation of adopting the labor standard recommended for Geeta & Compa

Illustration: ABC analysis Combine items on the basis of their relative value to form three categories—A, B and C. The data in the table below illustrates the ABC analysis.