Question: Calculate Each Ratio for February Actual 2018 and February Budget 2018(Return on assets and Profit Margin)
Pets r Us 8 Peacock Drive Wndsor Q_D 4030 Profit & Loss [ Budget Anal ysi s] February 2018 12/05/2019 22: 02 PM el ected Period Budget ed $ D ffer ence Differ ence I ncone Sal es $32, 230. 00 $45, 000. 00 -$12, 770. 00 (28. 4% Freight Collected $1, 130. 00 $1, 500. 00 -$370. 00 (24. 7% Late Fees Collected $0. 00 $0. 00 $0. 00 NA Miscell aneous I ncone $0. 00 $0. 00 $0. 00 NA Discount Received $56. 30 $80. 00 -$23. 70 29. 6% Total I ncone $33, 416. 30 $46, 580. 00 -$13, 163. 70 (28. 3% Cost of Sales Cost of Sal es $22, 956. 47 $31, 500. 00 -$8, 543. 53 (27. 1% Freight Expense $75. 00 $190. 00 60. 5% Di scount Allowed $864. 70 -$115. 00 $1, 000. 00 (13. 5% Total Cost of Sales $32, 690. 00 -$135. 30 $23, 896. 17 $8, 793. 83 (26. 9% Gross Profit $9, 520. 13 $13, 890. 00 -$4, 369. 87 (31. 5% Expenses Account ing Fees $0. 00 $0. 00 $0. 00 Advertising $181. 82 $418. 18 NA $600. 00 (69. 7% Bank Charges $10. 00 $10. 00 $0. 00 0. 0% Deprn and Anorth Expense $1, 445. 28 Dues & Subscriptions $0. 00 $1, 450. 00 -$4. 72 (0. 3% $0. 00 $500. 00 $500. 00 $0. 00 $0. 00 NA I nsur ance 0. 0% Late Fees Paid $0. 00 $0. 00 NA Legal Fees $0. 00 $0. 00 $0. 00 $0. 00 NA Mai nt enance $0. 00 $0. 00 NA Store Suppli es $0. 00 $0. 00 $0. 00 $0. 00 NA Enpl oynent Expenses Staff Aneni ties $43. 90 $692 00 $40. 00 $1, 000. 00 $3. 90 $308. 00 9. 7% Super annuat i on (30. 8% Wages & Sal ari es $7, 284. 00 $7, 300. 00 -$16. 00 (0. 2% Workers' Compensation $0. 00 $0. 00 $0. 00 NA Other Enpl oyer Expenses $0. 00 $0. 00 NA Total Enpl oynent Expenses $8, 019. 90 $50. 00 $8, 340. 00 $0. 00 -$320. 10 3. 8% Post age & Stationary $1, 055. 00 $50. 00 $0. 00 0. 0% Rent $1, 055. 00 $348. 64 $0. 00 $0. 00 0. 0% Repairs $348. 64 NA Tel ephone $0. 00 $0. 00 $0. 00 NA Travel & Entertainment $0. 00 $0. 00 $0. 00 NA Services Gas $0. 00 $0. 00 $0. 00 NA Bectri city $0. 00 $0. 00 $0. 00 NA What er $189. 00 $200. 00 $12, 205. 00 -$11. 00 Total Expenses $11, 799. 64 $405. 36 5. 5% ( 3. 3% Operating Profit $2, 279. 51 $1, 685. 00 -$3, 964. 51 235. 3% Other Income Interest I ncone $0. 00 $0. 00 $0. 00 NA Total Other I ncone $0. 00 $0. 00 $0. 00 NA at her Expenses Interest Expense $221. 98 $1 10. 00 $1 11. 98 101. 8% I ncone Tax Expense $0. 00 $0. 00 $0. 00 NA Total Other Expenses $221. 98 $110. 00 $1 11. 98 101. 8% Net Profit / (Loss) $2, 501. 49 $1, 575. 00 $4, 076. 49 (258. 8%\fPets r Us 8 Peacock Drive Wndsor Q_D 4030 Anal yse Sales [I ten] February 2018 12/05/2019 Page 1 4: 23: 24 PM I tem # Name Sal es Cost of Sales Gross Profit % Margin Uhits Sol Average Cost ABO1 Andi s a i $435. 00 $1 50. 00 $285. 00 65. 5% 15 $10. 00 AC25 Andi s Dog $4, 560. 00 $3, 164. 62 $1, 395. 38 30. 6% 17 $186. 154 AF10 Advocat e $240. 00 $1 00. 00 $140. 00 58. 3% 4 $25. 00 AGRO Aquarium $6, 715. 00 $5, 040. 00 $1, 675. 00 24. 9% 21 $240. 00 BOO5 Parrot Ca $13, 300. 00 $9, 997. 37 $3, 302. 63 24. 8% 29 $344. 737 BO09 Budgie Bi $1 00. 00 $60. 00 $40. 00 40. 0% 2 $30. 00 BD1 8 Cer ani c D $182. 00 $97. 41 $84. 59 46. 5% 10 $9. 741 CB1 9 Bristle C $508. 00 $260. 00 $248. 00 48. 8% 26 $10. 00 CB22 Cat Bed S $480. 00 $235. 07 $244. 93 51. 0% 8 $29. 384 CL01 Lar ge Dog $0. 00 $0. 00 $0. 00 NA 0 NA CM02 Medi um Do $0. 00 $0. 00 $0. 00 NA NA CS03 Shall Dog $0. 00 $0. 00 $0. 00 NA 0 NA DK40 Double Do $5, 190. 00 $3, 600. 00 $1, 590. 00 30. 6% 10 $360. 00 FF07 Fish Food $520. 00 $252. 00 $268. 00 51. 5% 28 $9. 00 TO01 Premi um T $0. 00 $0. 00 $0. 00 NA 0 NA $32, 230. 00 $22, 956. 47 $9, 273. 53 28. 8%
