เนื่องจากมีการเปลี่ยนแปลงในด้าน Interface ที่แตกต่างไปจาก Version เดิม ๆ Siam Monsooner Library จึงทำ content เป็นรูปแบบคลิป และอาจมีการเสริมเอกสาร ความรู้เสริมในแต่ละเรื่องเพืมเติม
กลุ่ม Module/Feature ที่เกี่ยวกับการเงิน/การบัญชี, วัดผล และการวิเคราะห์ข้อมูล
Finance & Accounting (FIN), Measurement, Business Intelligent & Data Analytics
Finance & Accounting (FIN), Measurement, Business Intelligent & Data Analytics
FIN; Finance & Accouting
พื้นฐาน ความเข้าใจ และ Interface
|
การใช้งานกราฟที่เกี่ยวข้อง และตัวชี้วัด
|
Operating model [Finance Module]
By : Abdybroto Taminsjah
The following describes the operating model of the MonsoonSIM Finance module.
Baseline:
By : Abdybroto Taminsjah
The following describes the operating model of the MonsoonSIM Finance module.
Baseline:
- Focus on how to manage money. (not yet about funds acquisition and management.)
- Optimize profit by increasing sales (retail, b2b, e-commerce, and services.)
- Optimize profit by decreasing expenses (overflow, penalty, and non-feasible research.)
- There are two types of Accounting:
- Cash
- Accrual
- Journal entries will record the company's transactions chronologically with an equal amount of debits and credits.
- There are three financial reports which are more in line with GAAP (General Accepted Accounting Practice):
- Profit & Loss
- Balance Sheet
- Trial Balance
- Integrated reporting shows how a company communicates its financial and value creation performance.
- A bank overdraft facility (standby-loan) is available for immediate drawdown when the operating cash runs out.
- When the accumulated overdraft has reached the bank facility limit, the company may not be able to draw down any more for new purchases.
- An overdraft will incur daily interest.
- An overdraft will appear as a short termed liability in the Balance Sheet.
- Overdraft payoff will use cash (from sales) to reduce interest expenses.
- Start with initial cash for all teams.
- Every transaction will be fully recorded and traceable in the Accounting.
- The team will not be able to run the business anymore (bankrupt) when the cash runs out, and at the same time, the bank facility is exhausted.
- Cash Accounting
- Will not involve account payables and receivables.
- Payment requires cash on hand.
- If you made a purchase and do not have enough cash to pay upon vendor delivery, the goods will NOT arrive. You will also NOT be penalized or considered delinquent.
- If you have an undeliverable outstanding PO due to insufficient funds, the vendors will cancel your POs. Typically, this will happen around ten days after the promised delivery day.
- No partial payment is allowed.
- Delinquent Payout
- If you have exhausted your overdraft limit, any incoming dues, such as salary, rental, and goods PO, will be counted as delinquent.
- You can find the list of your delinquent out-payments in your Finance Menu.
- Exceeding a certain amount of outstanding delinquents will also bring about bankruptcy. This limit is configurable by the CT.
- Every day, the system will automatically try to settle your delinquent payment, starting from one with the lowest amount, and the process will repeat daily.
- Bankruptcy
- When the number of delinquent payments exceeds the limit set by the CT, the team will be bankrupt.
- Once bankrupt, the team will not be able to perform any transactions, no sales, bidding, and expenses. However, other participating teams can continue as usual.
- Accrual Accounting
- Will not involve account payables and account receivables.
- No partial payment is allowed.
- Payment to a vendor will comply with the vendor's terms of payment.
- Besides payment to vendors, all other payments (salary, etc.) will not accrue.
- The concept of Vendor Credit Limit
- Account Payable to the vendor will decrease this credit limit.
- Foreign currency can affect the price of an imported product. Assuming our local currency gets weaker against the foreign currency, the imported product quoted in a foreign currency will be more expensive, and vice versa.
- Delinquent Payout
- The number of outstanding delinquents now affects your CREDIT RATING.
- Credit Rating
- There are five types of credit ratings a company can get
- Unrated - your company is not rated yet. The system will start rating on day 10.
- DDD - if your outstanding delinquent payments exceed 20.
- CCC - if your outstanding delinquent payments are between 10 to 20.
- BBB - if your outstanding delinquent payments are between 1 to 10.
- AAA - if you do not have any outstanding delinquent out-payment.
- AAA is the best rating that indicates your company is the most credit-trustworthy.
- Credit Rating is critical when applying for a business loan.
- There are five types of credit ratings a company can get
- Loan
- There are several types of loans available. These are configurable by CT.
- Terms - indicates the duration of the loan.
- Base Interest - indicates the base interest usually set by the lending institutions.
- Central Bank rate - simulates the Central Bank's inter-bank overnight lending rate. This rate is a floating rate. In MonsoonSIM, the future fluctuations are accurately predicted and can be viewed in the Forecast menu.
- Effective rate = Base Interest + Central Bank's rate.
- Fully amortization - where the loan is being paid off based on an equal amount at every period. This amount consists of an ever-increasing principal portion and an ever-decreasing interest portion.
- Interest only - where the loan is being paid off based on interest only at every period and a lump sum of principal at the very end of the term. (Balloon payment)
- A loan in MonsoonSIM is a long-term payable in accounting.
- Current Ratio Requirement
- It is one of the requirements to obtain a loan.
- Its definition is total asset divided by total liability.
- One can find the current ratio from the Business Intelligence menu. It appears in Finance Section.
- Credit Rating Requirement
- Credit Rating is one of the requirements to obtain a loan.
- Crisis
- Happens when the economic environment is turbulent.
- Will affect the overall demand of the game, fees, interest rates, forex rates, and account receivable delay dates.
- Has four recovery shapes, U, V, L, and W. V represents the fastest crisis period, while L represents a lengthier period.
- Has few attributes, including:
- Interest,
- Retail demand,
- Inflation,
- B2B demand,
- Transport company fee,
- Forex (foreign currency/local currency), and
- Account receivable delay.
- High inflation will cause an increase in price, with a higher inflation percentage means a higher increase in price
- An increase in account receivable delay means a lengthier waiting period for teams to receive their unpaid account receivable.
ส่วน Advance Feature ที่เกี่ยวข้องกับ Module Finance
Clip เหล่านี้บันทึกโดยใช้ Interface ใน Version 9 ซึ่งไม่ได้เปลี่ยนแปลงสาระใด ๆ เปลี่ยนเพียงขนาดของหน้าจอ และการวาง Lay out ต่าง ๆ ใน Version 10 Interface หากมีการเปลี่ยนแปลงในนัยยะสำคัญจะมีการสร้างคลิปเพื่อทดแทนในภายหลัง
Clip เหล่านี้บันทึกโดยใช้ Interface ใน Version 9 ซึ่งไม่ได้เปลี่ยนแปลงสาระใด ๆ เปลี่ยนเพียงขนาดของหน้าจอ และการวาง Lay out ต่าง ๆ ใน Version 10 Interface หากมีการเปลี่ยนแปลงในนัยยะสำคัญจะมีการสร้างคลิปเพื่อทดแทนในภายหลัง
Research & Development (R&D)
Excel คำนวน R&D NPV ของ Deakin University |
|
Business Intellegent (BI) และ Measurement
การวัดผลแบบต่าง ๆ ใน MonsoonSIM
การวัดผลแบบต่าง ๆ ใน MonsoonSIM
|
Business Intellegent Service หรือ BI เป็น feature หนึ่ง ซึ่งให้ concept ของการนำเอา Data ที่มีส่วนเกี่ยวข้องกัน มาเปรียบเทียบกัน เพื่อให้เกิดความเข้าใจในเชิงลึกมากขึ้น ซึ่งเป็นส่วนหนึ่งของ Descriptive Analytics, Diagnostic Analytics
หมายเหตุ: ใน Version 10 นั้นสามารถเลือกข้อมูลมาเทียบได้ ครั้งละ 5 ข้อมูลมีการเข้าถึง 2 วิธี ได้แก่ กดที่เมนูรูปแว่นขยาย และเลือก Sub menu รูปกราฟตัวขวามือ หรือ เลือกให้แสดงแบบ Live ผ่าน icon รูปกราฟ Design Your Chart ได้ ที่ Panel สีส้มด้านขวามือของจอ |
Data Analytics