Scribd
Upload
6 views3 pages

Monthly Order Trends and Insights

The document presents a detailed analysis of order statistics, including total orders, order values, and cost per order from December 2018 to June 2020. It highlights trends in order values, revenue, and costs, suggesting a need for price adjustments to break even. Additionally, it poses questions regarding the impact of price changes and the factors influencing monthly sales trends.

Uploaded by

andanmcv
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
6 views3 pages

Monthly Order Trends and Insights

The document presents a detailed analysis of order statistics, including total orders, order values, and cost per order from December 2018 to June 2020. It highlights trends in order values, revenue, and costs, suggesting a need for price adjustments to break even. Additionally, it poses questions regarding the impact of price changes and the factors influencing monthly sales trends.

Uploaded by

andanmcv
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

% of % of

Cost per
Period Total Orders Order Value inc/(dec) of inc/(dec) of
Order
order order value
Dec-18 1158 11,244.00 9.71
Jan-19 1000 10,000.00 10.00 -14% -11%
Feb-19 1108 10,591.00 9.56 11% 6%
Mar-19 1209 11,539.00 9.54 9% 9%
Apr-19 1078 9,774.00 9.07 -11% -15%
May-19 1334 11,751.00 8.81 24% 20%
Jun-19 1396 11,488.00 8.23 5% -2%
Jul-19 1569 13,078.00 8.34 12% 14%
Aug-19 1770 13,611.00 7.69 13% 4%
Sep-19 2282 15,273.00 6.69 29% 12%
Oct-19 2344 15,421.00 6.58 3% 1%
Nov-19 3295 21,641.00 6.57 41% 40%
Dec-19 3320 21,409.00 6.45 1% -1%
Total 22863 176820
Div. by: 13 13.00
Average 1758.692308 13,601.54 0.13

Jun-20 5000 40,000.00 8.00

Apr-20 May-20 Jun-20 Jul-20


Total Orders 1,000 1,507 1,706 2,000
Total Order Value 10,000.00 18,648.00 19,239.00 25,000.00
Revenue 500 932.00 962.00 1,168.13
Cost 400 1,190.00 1,310.00 1,437.50

Projected
Cost per order 10.00 12.37 11.28 12.5
No. of sold 40 96 116 115
% of no. of sold 4% 6% 7%
Sale Price per oder 12.50 9.69 8.28 10.16
Income/(loss) per order 2.50 (2.68) (3.00) (2.34)
Income/(loss) 100.00 (258.00) (348.00) (269.37)
% Income/(loss) 20% -28% -36% -23%
Ave % of No. of sold 6%
For Nos. 1 and 2. Check the trend. I provided you the cost per item and the relative %. What
would be your assumptions as to lower price and the changes/movement per month? Also
take note also the occasions per month, if there's any. It could also be a factor.

For No. 3. the cost of the item is at P8. What is your insight if there is an increase in price?
Use the trend I provided. This is related to your assumptions to question 1 and 2

1. I use the average method in terms of number of sold items and selling price in projecting
the revenue and costs.

2. Increase by P2.34 pesos per order sold to break even based on the assumptions and
method used in no. 1

3. im lost at no. 3. because there are no other factors in the problem aside from total order, order valu
nd the relative %. What
ment per month? Also
e a factor.

an increase in price?
tion 1 and 2

ling price in projecting

assumptions and

aside from total order, order value, revenue and cost.

You might also like