Question 16

You need to structure a model to support both planning and reporting of expenses by project, while classifying each project by its funding source. How do you structure the model to meet these requirements?
  • Question 17

    You are building a model for Travel Expenses. Finance needs to see detailed travel plans, and expenses will be included with corporate reporting. Planners are expected to complete their travel plans for each forecast. What model design should you use?
  • Question 18

    You are creating a report in OfficeConnect with dates as the column headers. You want the dates to automatically reflect changes from the Adaptive Planning model. What tool do you use?
  • Question 19

    You are building a Headcount cube sheet for a manufacturing company. Plant managers input headcounts across dozens of levels and multiple job profile dimension values for each month. Job profile salaries are standardized and global for an entire year. What design for assumptions would have minimal inputs and segregated security?
  • Question 20

    Scenario: A financial planner is conducting a comprehensive audit of the income statement structure and formulas. The goal is to ensure accuracy, consistency, and optimal performance for the upcoming budget cycle.
    The General Ledger account 5010 (Labor) in the Budget version currently uses a formula that calculates labor costs as 6% of the Income account value within the same time period. The current formula is limited to the Manufacturing and Sales levels and does not apply to other versions. Which configuration would enable the Labor cost calculation to apply consistently across all levels and all versions?