Schedule of non-discretionary data, Managerial Accounting

Assignment Help:

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.


Related Discussions:- Schedule of non-discretionary data

Assigment, taking the role of a consultant, discuss the factors you would c...

taking the role of a consultant, discuss the factors you would consider in selecting a suitable accounting system solutio for a small to medium enterprise. i has to be 1200 q\work

Steps in strategic cost analysis, Steps in Strategic Cost Analysis 1) Rec...

Steps in Strategic Cost Analysis 1) Recognize the suitable value chain and allocate costs and assets to it. 2) Identify the cost drivers of each value activity and how they int

Credit investigation, Once the credit information is accumulated the subseq...

Once the credit information is accumulated the subsequent step is to analyze the gathered information and isolate those matters that may need further investigation. The factors whi

Evaluate marginal cost, 1. If the marginal cost of producing a good is incr...

1. If the marginal cost of producing a good is increasing as a firm produces more of the good, then which of the following must be true? a. AFC is rising               b. AVC i

Ageing schedule, Ageing Schedule: AS is classifies outstanding accounts r...

Ageing Schedule: AS is classifies outstanding accounts receivable at a specified point of time into various age brackets. A clarifying ageing schedule is specified below.

State the steps for standard costing system, State the steps for Standard c...

State the steps for Standard costing system standard costing system involves the following steps 1) Setting-up of standards for each element of cost: standards should be s

Summary journal entries, Stine Company uses a job order cost system. On May...

Stine Company uses a job order cost system. On May 1, the company has a balance in Work in Process Inventory of $3,730 and two jobs in process: Job No. 429 $2,150, and Job No. 430

Multiple regression, MULTIPLE REGRESSION The least square regression eq...

MULTIPLE REGRESSION The least square regression equation discussed above was based on the assumption that total cost was determined by only one activity based variable. However

Differential analysis, Barker Company has a single product called a Zet. Th...

Barker Company has a single product called a Zet. The company normally produces and sells 80,000 Zets each year at a selling price of $40 per unit. The company’s unit costs at this

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd