Tiêu đề CFO Monthly Management Report - 2023.pdf ✅

Monthly Management Report PQR Pvt. Ltd. October 2022
Table of Contents Executive Summary 1 Key Financial Results 2 E-commerce Results 5 Other Financial Results 10 Details Financials 13
Page 1 Executive Summary Overview • Revenue of $449,344, a decrease of 88% or $352k against the budget of $802,154. Driven by lower than budgeted MM - sales - website, MM - sales - showroom and sales - naptime. A decrease of 18% or $44K against $492,720 last month due to a decrease in MM - sales - website, MM - sales - showroom and an increase in nap - discounts. YTD Actual of $2,369,606, 34% below the budget of $2,845,618. • Gross Margin of 72.79%, an increase of 2% against the budget of 94.08%. Driven by lower than the budgeted cost of sales (Cost of Goods Sold and Other Direct Costs (Freight Courier - International and MM - Freight & Courier-National)). An increase of 16% against 32.34% last month due to a decrease in the cost of sales (Other Direct Costs (Freight Courier - International, Nap - Freight & Courier - National and Contractors - Direct Cost)). YTD Actual of 70.38%, 18% below the budget of 92.95%. • Operating Expenses of $25,594, a decrease of 26% or $32K against the budget of $236,314. Driven by lower than the budgeted customer acquisition costs (Advertising) and administrative expenses (Accounting). A decrease of 32% or $38K against $257,612 last month due to a decrease in customer acquisition costs (Advertising and Consultants - Marketing) and administrative expenses (Rent). YTD Actual of $968,432 2% above the budget of $920,008. • Net Profit before interest and tax (EBIT) of -$60,282 a decrease of 92% or $130K against the budget of $141,052. Driven by lower than the budgeted revenue generation. Anincrease of $94K against the last month of -$98,252 due to an increase in gross margin and a decrease in operational costs. YTD Actual of -$130,114, $660K below the budget of $415,878. • Free Cash Flow: -$57,868 $54K lower than last month of $1826. Driven by a decrease in amex account balance, payment of invoices to the suppliers and payment of statutory obligations (GST and Superannuation). YTD Actual of -$212,208. Upcoming Statutory Obligations: • October 2022 BAS: -$4,612 (GST(Refund): $19000 + IAS: $14,735) (due on 22 November 2022). • October 2022 Superannuation Accrual: $7,530.10 (due on 28 January 2023). *Tax amount subject to review by your tax accountant. *Please note, there are some bank entries that are yet to be reconciled. In the absence of relevant invoice/Feedback from you, we have not been able to reconcile all the bank transactions.
Page 2 Key Financial Results REVENUE Sep 2022 Oct 2022 This month Budget This Month Budget YTD YTD (budget) Sales $588 $0 $0 $0 $18,924 $0 Nap - Discounts $1,704 ($14,488) ($7,978) ($6,510) ($40,252) ($30,430) Nap - Returns & Exchanges ($8,640) ($10,228) ($20,944) $10,716 ($54,100) ($79,878) Nap - Sales - Website $110,052 $129,908 $0 $129,908 $571,146 $0 MM - Discounts ($36,742) ($35,160) ($67,272) $32,112 ($129,432) ($233,806) MM - Sales - Website $311,456 $287,884 $486,182 ($198,298) $1,541,098 $1,905,630 MM - Returns & exchanges ($15,942) ($16,772) ($48,584) $31,812 ($99,104) ($168,858) MM - Sales - Showroom $130,244 $108,200 $261,276 ($153,076) $560,602 $692,208 Bedding Sales $0 $0 $0 $0 $728 $0 Sales - Naptime $0 $0 $199,474 ($199,474) $0 $760,752 Total Revenue $492,720 $449,344 $802,154 ($352,810) $2,369,606 $2,845,618 COST OF SALES Sep 2022 Oct 2022 This month Budget This month vs budget($) YTD YTD (Budget) Cost of Goods Sold Cost of Goods Sold $171,078 $165,402 $256,690 ($91,288) $862,932 $910,600 Other Direct Costs Afterpay Fees $5,138 $4,530 $8,022 ($3,492) $24,254 $28,456 Freight Courier - International $26,918 $55,518 $48,130 $7,388 $236,382 $170,738 Postage - Customer $240 $470 $1,244 ($774) $1,586 $4,414 ZipPay Fees $1,644 $728 $2,406 ($1,678) $5,846 $8,536 MM - Shopify Fees $2,870 $2,294 $7,474 ($5,180) $13,020 $25,978 MM - Freight & Courier- National $36,284 $33,016 $67,272 ($34,256) $199,016 $233,806 Nap - Freight & Courier - National $29,522 $17,882 $21,942 ($4,060) $111,130 $83,682 Nap - Shopify Fees $990 $1,252 $1,994 ($742) $5,286 $7,606 Tyro Fees $918 $874 $1,604 ($730) $5,914 $5,690 Paypal - Fees $1,672 $1,436 $4,010 ($2,574) $8,222 $14,226 Paypal Fees $482 $630 $0 $630 $2,098 $0 Contractors - Direct Cost $55,600 $0 $4,000 ($4,000) $55,600 $16,000