CMA2MK2_06 - Proper instructions to user on entering data?...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
CMA2 - EXCEL ASSIGNMT #2 MARKING KEY NAME: GENERAL Purpose of template stated? Proper preparation date? Prepared by? INPUT SECTION Input sheet has a heading---- Input Sheet? Input cells highlighted or clearly indicated to user HI-LO METHOD VC/unit and TFC are properly calc'd and referenced? Cost formula is correctly stated using a string? Named ranges were used for input ranges? REGRESSION METHOD Cost formula is correctly stated using a string? Named ranges were used for input ranges? OTHER Cell contents properly refnc'd? Co. name appears on all pages? Proper header at top of all pages? CHART Proper graph titles (top and sides)? Proper legend to describe graph? Cost driver units & cost descriptions ref'd to column headings?
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Proper instructions to user on entering data? Eg. Enter amounts in $ unless otherwise stated with no $ signs or commas. Date description,format, and cell location for initial input date is clear? Initial input date used to generate other dates on input table? VC/unit and TFC are properly calc'd using SLOPE & INTERCEPT functions? 4-col data table is complete with correct formulas, references, and amounts? Chart axes ares properly scaled to eliminate waste space? Proper display of actual data points including round dots? Proper regression line including formula with pointer line and no visible points ? Proper high-low line including formula with pointer line and no visible points?...
View Full Document

This note was uploaded on 03/03/2012 for the course ACCT 2460 taught by Professor Farrar during the Winter '12 term at Conestoga.

Ask a homework question - tutors are online