Best Of
Re: Snapshot Challenge with #list
It is hard to tell, but based on what you have above, the code should be CC_CE_KPU and then import the transactional data (Amount) into a module dimensionalized by that list and Time. Remember, you shouldn't be importing data into properties, especially transactional data like you have above. For more information about this, read this.
Re: Conditional Formatting Help
Hi @aishabhy05
What you are trying to achieve requires quite advanced techniques and knowledge but I will try to help you.
This type of conditional formatting requires to create a separate line item per each line item you want to color.
In their formulas, you have to mention an IF statement with the condition:
IF ITEM(<LIST>) <> <list>.GAP or <Total year boolean> THEN<white color formatting value> ELSE <put color formatting logic here>
Instead of "<>" you have to apply your logic.
Question 2 is covered by @SriNitya but you have to know that it is based on Style column value in the blueprint mode of the module.
For question 3 - you can add a dummy list item. Add a subset where only real items are selected and apply this subset to all line items. This will create subsidiary views for them and will not count the dummy item in Cell Count. Then you can try to apply a filter to columns with a logic of only FY24 is TRUE.
Hope this will help.
Planning in high gear: Accelerating manufacturing companies to success
Author: Daniel Dunleavy, Certified Master Anaplanner and Manager at Lionpoint Group.
Manufacturing is the lifeblood of the US economy. In 2022, it generated $2.1 trillion of revenue, and would have ranked it as the world’s ninth largest economy(1). The sector also plays a major role in promoting growth around the world. With the average car requiring at least 30,000 components (2), and planes such as the Boeing 747 requiring six million parts — manufactured by more than 550 suppliers in almost 30 countries (3) — US manufacturing has true global reach.
This complexity comes at a price, however. At a time of rising input and labor costs, companies need to ensure that their source materials are high quality, their supply chain is efficient, accounted for accurately, and they can allocate capital resources in an effective and timely manner. Perhaps there is no clearer illustration of the importance of this than in the promotion of supply chain professionals to the very top of major global brands, including Tim Cook at Apple, Brian Cornell at Target, Mary Barra at General Motors, and Doug McMillan at Walmart.
The economics of manufacturing
The manufacturing industry is also having to grapple with a very particular set of supply chain disruptions brought about by just-in-time inventory management — known as the “bullwhip effect.” This occurs when an initial change in demand creates an even larger effect on other companies in the supply chain — who tend to overcompensate — creating increased volatility.
When the COVID-19 pandemic first struck, manufacturing clearly drew to a standstill. However, when manufacturers attempted to ramp up production again, they could not keep up with demand, as seen with the dramatic shortages of toilet paper supplies. This led to a situation where the estimated value of out-of-stock items reached $1.14 trillion (4).
By the end of 2022, this bullwhip effect had started to take shape as consumer goods manufacturers found themselves with too much stock. Walmart, for example, ended its third quarter in October 2022 with at least $1 billion in excess inventory (5).
The impact of the pandemic is still being felt today. Demand has declined, not least because consumers stopped receiving government stimulus money, and household debts have reached an all-time high. Inflationary pressures are still very real, and employment growth has been dropping. As a result, the manufacturing industry is now in a period of rebalancing — of inventories against sales projections — as they try to navigate economic uncertainty and attempt to smooth out their supply chain volatility.
Managing risks at every level
Risk management, therefore, plays a significant role in supply chain planning, including political, environmental and regulatory, supplier, labor, and transportation risks. However, one of the costliest risks in recent years has been product recalls, which hit a four-year high in the first quarter of 2023. Consumer products were recalled at their highest rate since 2015, and pharmaceuticals recorded the most recalls in the last 18 years (6).
Recalls are so damaging because, when they occur, companies incur the costs of reverse logistics, sourcing new parts, the labor impact of changing out the recalled product, together with costs associated with waste and removal, customer logistics, and brand value. When you also consider the global — and complex — nature of the supply chain, costs can skyrocket.
The planning imperative
Managing an organization’s bottom line against these risks is therefore crucial. However, 62% of companies report having limited visibility of their supply chain, and managers continue to use legacy systems with more than 67% of supply chain departments running on Excel spreadsheets as management tools. In today’s world of interconnected just-in-time supply chains, these tools are no longer viable (4).
It’s critical that companies minimize their data management headaches and focus on being more disciplined, data-driven, prepared, and agile than ever before.
Putting the pieces together — a blueprint for success
Anaplan is relevant to almost every business process within an organization. Three use cases particularly stand out within the manufacturing industry:
Strategic sourcing and supplier management
- Anaplan helps overcome supply fulfillment volatility. Many manufacturers use a limited number of suppliers in their supply chain process, and when existing suppliers can’t meet the manufacturing demand, there is often a scramble to add more suppliers. However, potential new suppliers often can’t fulfill inventory shortfall on time, and vendor approval processes can take months, leading to delays in meeting specific requirements.
Anaplan helps the strategic supplier planning process with specific tools to help organizations focus on cost control, flexibility, and quality when considering raw materials, purchased products, and transportation. It enables planners to see in one place their fulfillment risks and where to compensate with additional quality suppliers and provides greater control of supplier costs.
Plant management
- Anaplan helps streamline operational planning. Managing a plant requires the ability to plan for constant change, like demand changes, machine replacements or upgrades, retooling, labor and scheduling. Anaplan helps manufacturers achieve greater visibility in the management of their plants by helping them to focus on:
- Demand planning: including production, demand and inventory planning, and purchase order management
- Expense planning: including process planning, scheduling, labor, standardized product costing (including intercompany costing), delivery, and plant and labor utilization rates
- Energy planning: This includes managing sustainability issues, fuel and energy planning, waste, and regulatory management
- Plant project planning: Anaplan can be used to plan all capital expenditure planning processes.
- Demand planning: including production, demand and inventory planning, and purchase order management
Digital transformation
- Anaplan can be at the heart of the digital transformation of planning. Digitalization is crucial in three key areas: data analytics, scenario analysis and decision-making.
- Data analytics: It’s estimated that poor data quality costs the US economy up to $3.1 trillion yearly and that the average company only analyzes about 40% of their available data
(7). Anaplan is designed to help companies overcome these challenges and places data at the heart of the Connected Planning process. - Scenario analysis: Anaplan helps organizations use scenario planning to actively manage risks. It enables scenarios to be tested – in real-time – such as: what happens to the business if a plant shuts down? What happens to the product costs if an extra shift or machine is added? What happens to forecasts if the plan is updated using today’s prices? What happens if labor costs continue to rise? Anaplan enables almost real-time decision-making, allowing executives to dynamically plan and quickly aggregate the most critical information.
- Decision making: When planning in today’s market, manufacturers should be able to exploit data to improve their decision-making. Anaplan’s Connected Planning environment enables collaboration between the many different teams that contribute to the success of a business. For example, sales and marketing teams can collaborate in real-time with operations before the start of new campaigns to ensure production teams can meet requirements and fill the demand. Finance and operations teams can collaborate in real-time to ensure that any initiatives to improve cash flow — such as decreasing days on hand — won’t adversely affect customer fill rates from having lower inventory levels while incurring increased freight costs from less than full truckload shipments.
- Data analytics: It’s estimated that poor data quality costs the US economy up to $3.1 trillion yearly and that the average company only analyzes about 40% of their available data
Embracing Connected Planning
By using Anaplan, companies in the manufacturing industry will achieve increased supply chain optimization, reduce costs, improve customer service levels, and gain a competitive advantage. Organizations will be in a much better position to reinforce their manufacturing and supply chain operations, ensuring they are well-equipped to navigate the complexities of today's business landscape and deliver value to their customers.
……………
Sources:
- 1: National Association of Manufacturing: https://www.nam.org/facts-about-manufacturing/
- 2: NAPA Auto Parts: https://knowhow.napaonline.com/how-many-parts-are-in-a-car/
- 3: Boeing Media: https://boeing.mediaroom.com/2013-05-29-Boeing-Celebrates-Delivery-of-50th-747-8
- 4: 25 Supply Chain Management Statistics Every Business Owner Should Know: https://getstimulus.medium.com/supply-chain-management-stats-biz-owner-bcc79d784c62
- 5: Walmart Investor Reporting
- 6: US product recalls hit four-year high in first quarter of 2023: https://www.prnewswire.com/news-releases/us-product-recalls-hit-four-year-high-in-first-quarter-of-2023-301834964.html
- 7: 25+ Impressive Big Data Statistics for 2023: https://techjury.net/blog/big-data-statistics/
- Chart: Mfg Inventory vs Mfg Customer Inventory Index: US ISM
- Chart: CCI vs Regular Retail Fuel: CCI = OECD. Regular Retail Fuel = EIA
- Chart: Employment Growth = BLS
- Chart: Target Inventory to Sales % = Target Investor Reporting
- Chart: Walmart Inventory to Sales % = Walmart Investor Reporting
Re: Line Item 'Held or Revised' and 'To change' in Level 3 Sprint 1
The denominator is the sum of Initial Sales Target where there is no Hold or override. Make a line item and have an if else condition that says if hold or override then 0 else Initial Sales Target and then sum up and fetch the value in order to use it as the denominator.
Dikshant
Re: Revenue Distribution Help
@S-Blaeser You can also check Profile formula if you are only interested in Final Total column. It will profile the % spread for each period and cumulate values accordingly and give you total value in your line item
Cheers!!
Re: Revenue Distribution Help
Hi @S-Blaeser
In this scenario, basically you need cumulative value of last all months with existing month.
It can be achieved as below.
Forecasted Amount —- This is by Month
Percentage value——This is by Month
Forecasted with Percentage value —- This is by month and Formulate as Forecasted Amount * Percentage value.
Cumulate period count ———This is by Month and each month will have 1, 2, 3, 4, corresponding and will reset as 1 for next year ——-Formula——-if previous (Cumulate period count) = 0 then 1 else if previous(parent(parent(item(time)))) <> (parent(parent(item(time)))) then 1 else 1+
Final forecasted amount —- This is by month and Formula—-Cumulate (Forecasted with Percentage value, false, Cumulate period count)
Let me know if this helps out.
Thanks
Pujitha
PujithaB
Re: Sort User List / Group Users by Model Role
Yes, users management is in dire need of something up to the standards for enterprise level usage.
What used to work for a couple / tens of users with the one or 2/3 odd models becomes completely unmanageable at scale
Re: How to delete "filter" drop down selections - case: driver -> filter/driver -> filter
place the actions in one place as process, so when you run it erases all the selections and they have to start selections from scratch, or place them as individual clear actions for individual selections if you want them to erase at an individual level
sobaid
Re: How to delete "filter" drop down selections - case: driver -> filter/driver -> filter
Unless the selectors are cleared by user they remain selected so workaround for this to create Clear action for each selector and ask the user to run them before he makes new selection.
Individually create the clear actions as mentioned by Sobaid and put then in process and provide instructions to user to run them once they land on that UX page.
SriNitya
Re: How to delete "filter" drop down selections - case: driver -> filter/driver -> filter
May be whenever you are changing the dropdown option you need to run a Clear/Reset action button that clears out the remaining selections as well.
Step1 Create 3 Line items Clear Division, Clear Area, Clear Type and format them as No Data and create 3 saved views with individual line items and map it to respective Line items e.g:- Clear Division maps to Division
Step2: So now you have 3 actions created, now create a process and put them in a process in the correct order of dropdown selection
Step 3: Place this action in your NUX DB, with instructions to the user suggesting whenever the wish to change selections, they must run clear selections,
Additional Step is to Highlight Red with Conditional Format for improper selections made, this logic you can create else you can reach out if needed help
sobaid










