nerdexam
Microsoft

MB-310 · Question #125

Case Study 3 - Alpine Ski House Background Alpine Ski House has three partially owned franchises and 10 fully owned resorts throughout the United States and Canada. Alpine Ski House's percentage…

Ledger Allocation Configuration - Alpine Ski House The Two Requirements Being Mapped | Requirement | Correct Setup | |---|---| | Advertising costs balanced across 10 (then 12) resorts | Equally | | Administration costs split proportional to sales | Basis |…

Implement financial management

Question

Case Study 3 - Alpine Ski House Background Alpine Ski House has three partially owned franchises and 10 fully owned resorts throughout the United States and Canada. Alpine Ski House's percentage ownership of the franchises is between two and 10 percent. Alpine Ski House is undergoing an implementation of Dynamics 365 Finance and Dynamics 365 Supply Chain Management to transform their financial management and logistics capabilities across the franchises. Implementation is complete for Alpine Ski House's corporate offices, two US franchises, and one Canadian franchise. The remaining franchises are in varying stages of the implementation. Two new resort projects are in the budget planning stages and will open in the next fiscal year. Current environment Organization and general ledger Each franchise is set up as a legal entity in Dynamics 365 Finance. Alpine Ski House Corporate uses financial dimensions for their fully owned resorts. Each resort is a financial dimension named resort. Each fully owned resort has two divisions: marketing and operations. Only Profit and Loss account postings require the division dimension. Corporate handles the advertising and administration of the fully owned resorts. Corporate uses Dynamics 365 Project Management and Accounting to manage construction of new resorts. Budgeting Organizational budgeting is decentralized but rolls up to one organizational corporate budget. Each resort manager performs budgeting in Dynamics 365 Finance. Budget preparation begins this month. All operational resorts will submit their budgets in two weeks. Sales and tax Sales tax is configured and used by all resorts that operate in the United States. You configure one US sales tax vendor account and assign the vendor account to the settlement periods for reporting. You use accounts receivable charges to track donations. Existing purchasing contracts Each franchise resort has an individual contract with a local supplier of their choosing to purchase at least $10,000 worth of suppliers during the calendar year. The franchise resorts in one US state receive a two percent discount on meat and vegetable purchases in excess of $8,000 per year. A franchise resort in Utah has agreed to purchase 1,000 units of beef at market price from a local supplier. Alpine Ski House uses a vendor collaboration portal to track purchase orders and requests for quotes. Vendors request access to the vendor collaboration portal by using a workflow which runs on a nightly schedule. Intercompany setup Vendor123 resides in US franchise Company1 and is set up for intercompany transactions. Customer345 resides in Canada franchise Company1 and is set up for intercompany transactions. Requirements Franchises Each franchise must pay two percent of monthly sales to Alpine Ski House Corporate. Each franchise must report their own financials to Alpine Ski House Corporate monthly. US franchises require a three-way-match on all purchases, with a 1-percent price tolerance. Canadian franchises require a three-way-match on all purchases except paper products, which have a 10-percent price tolerance. Corporate Advertising costs must be balanced across the 10 resorts monthly. These costs must be split across the 12 resorts once construction of the final two resorts is completed. Administration costs must be split across the 10 resorts proportional to the amount of sales generated. One percent of all pack and individual ski pass sales must be donated quarterly to an environmental protection organization. The finance department must be able to see purchasing contracts and discounts for vendors based on volume spend. Employees All employee expense reports that contain the word entertainment must be reviewed for the audit purposes. If a journal is posted incorrectly, the entire journal and not just the incorrect line must be fully reversed for audit purposes. Resorts All resorts must use Dynamics 365 Finance for budgeting and must first be approved by the regional manager. Purchased fixed assets must automatically be acquired at product receipt. Issues User1 reports that irrelevant dimensions display in the drop down when entering a General journal. User2 reports that dimension 00 is being used for all balance sheet accounts. User3 tries to generate the quarterly sales tax liability payment for a specific state but does not see any payables available for that state's vendor. User4 receives a call from a vendor who cannot access the vendor collaboration portal but needs immediate access. User5 notices a large amount of entertainment expenses being posted without an audit review. User6 needs to have visibility into the increase in budget that is necessary to staff the two new resorts opening next year. User7 needs to use Dynamics 365 Finance for situational budgeting planning with the ability to increase and decrease the existing plans by certain percentages. User8 made a mistake while posting a 1,000-line journal and reverses the entire journal but cannot find the lines that included errors during the reversal. User9 made a mistake while posting a 55-line journal and reverses the entire journal. User10 realizes that the purchase of five new computers did not acquire five new fixed assets upon receipt. Drag and Drop Question You need to configure ledger allocations to meet the requirements. What should you configure? To answer, drag the appropriate setups to the correct requirements. Each setup may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:

Exhibit

MB-310 question #125 exhibit

Answer Area

Drag items

Fixed percentageEquallyBasisFixed weight

Explanation

Ledger Allocation Configuration - Alpine Ski House

The Two Requirements Being Mapped

RequirementCorrect Setup
Advertising costs balanced across 10 (then 12) resortsEqually
Administration costs split proportional to salesBasis

Placement-by-Placement Explanation

Advertising Costs → Equally

The requirement states costs must be "balanced across the 10 resorts" and later "split across the 12 resorts" once construction completes.

Why Equally: The Equally allocation method divides the source amount into identical shares across all destination lines - no manual percentages or weights needed. Critically, when resorts 11 and 12 open, you only add new destination lines; the engine recalculates the equal share automatically. This is the only method that is inherently self-adjusting for headcount changes.


Administration Costs → Basis

The requirement states costs must be split "proportional to the amount of sales generated."

Why Basis: The Basis method reads actual posted financial data (in this case, sales account balances by resort dimension) and uses those amounts as the denominator to derive each resort's allocation percentage dynamically each period. A resort generating 30% of total sales absorbs 30% of admin costs - no manual input required.


Why the Other Items Are Wrong Here

ItemWhy Not Used
Fixed percentageRequires manually coded percentages per destination. Works if shares never change, but breaks when new resorts open and doesn't respond to shifting sales.
Fixed weightAssigns static numeric weights per destination. Same problem - static, manual, does not reflect real sales data.

Common Misconceptions

  • "Fixed percentage works for advertising (10% × 10 resorts)" - It would work today, but when resort 11 opens you'd have to manually edit all 12 lines to 8.33%. Equally handles this automatically.
  • "Fixed weight could proxy for sales" - Only if weights are updated every period manually. Basis reads live ledger balances, making it the correct dynamic choice.
  • Basis vs. Fixed weight confusion - Both sound like ratio-based splits, but Basis uses actual posted financial data as its source; Fixed weight uses manually entered static numbers. The word "proportional to sales" in the requirement is the signal that live data is needed → Basis.

Topics

#ledger allocation#basis allocation#equally split#cost distribution

Community Discussion

No community discussion yet for this question.

Full MB-310 Practice