Sales Budget Jan-25 Feb-25 Mar-25 Apr-25 May-25 Jun-25 Jul-25 Aug-25 Sep-25 Oct-25 Nov-25 Dec-25 TOTAL Expected Sales Volume 278.2 292.5 260.0 276.9 263.9 330.2 321.1 288.6 171.6 210.6 230.1 247.0 3170.7 Pedal Classic x Selling Price per Unit 500.0 $ 500.0 $ 500.0 $ 500.0 $ 500.0 $ 500.0 $ 500.0 $ 500.0 $ 500.0 $ 500.0 $ 500.0 $ 500.0 $ 500.0 Sales Revenue ($) 139,100.0 $ 146,250.0 $ 130,000.0 $ 138,450.0 $ 131,950.0 $ 165,100.0 $ 160,550.0 $ 144,300.0 $ 85,800.0 $ 105,300.0 $ 15,050.0 $ 123,500.0 $ 1,585,350.0 Folding Urban Expected Sales Volume 427.0 448.0 456.4 434.0 449.4 606.2 597.8 477.4 429.8 421.4 585.2 595.0 5927.6 x Selling Price per Unit 800.0 $ 800.0 $ 800.0 $ 300.0 $ 800.0 $ 800.0 $ 800.0 $ 800.0 $ 800.0 $ 800.0 $ 300.0 $ 800.0 $ 800.0 Dream Sales Revenue ($) 341,600.0 $ 358,400.0 |$ 365,120.0 $ 347,200.0 $ 359,520.0 $ 484,960.0 $ 478,240.0 $ 381,920.0 $ 343,840.0 $ 337,120.0 |$ 468,160.0 $ 476,000.0 $ 4,742,080.0 TOTAL Sales Revenue ($) $ 480,700.0 $ 504,650.0 $ 495,120.0 $ 485,650.0 $ 491,470.0 $ 650,060.0 638,790.0 $ 526,220.0 $ 429,640.0 $ 442,420.0 $ 583,210.0 $ 599,500.0 $ 6,327,430.0 Expected Service Volume 332.4 349.2 355.2 338.4 350.4 472.8 465.6 372.0 334.8 328.8 456.0 463.2 4618.8 eBike Repairs x Selling Price per Hour $ 80.0 $ 80.0 $ 80.0 $ 80.0 $ 80.0 $ 80.0 $ 80.0 $ 80.0 $ 80.0 $ 80.0 $ 80.0 $ 80.0 $ 80.0 TOTAL Service Revenue ($) $ 26,592.0 $ 27,936.0 $ 28,416.0 $ 27,072.0 $ 28,032.0 $ 37,824.0 $ 37,248.0 $ 29,760.0 $ 26,784.0 $ 26,304.0 $ 36,480.0 $ 37,056.0 $ 369,504.0Purchases Budget Jan-25 Feb-25 Mar-25 Apr-25 May-25 Jun-25 Jul-25 Aug-25 Sep-25 Oct-25 Nov-25 Dec-25 Expected Sales Volume add: Ending Inventory Requirement Total Units Required: Pedal Classic less: Beginning Inventory Total Purchase Units: x Cost ($) per Unit Total Purchase Cost ($) Expected Sales Volume add: Ending Inventory Requirement Folding Urban Total Units Required: Dream less: Beginning Inventory Total Purchase Units: x Cost ($) per Unit Total Purchase Cost ($) Total Overall Purchase Cost ($)FactSheet - Data on 2024 Financial Year Jan-2024 Feb-2024 Mar-2024 Apr-2024 May-2024 Jun-2024 Jul-2024 Aug-2024 Sep-2024 Oct-2024 Nov-2024 Dec-2024 Sales Volume - Pedal Classic 214 225 200 213 203 254 247 222 132 162 177 190 Sales Volume - Folding Urban Dream 305 320 326 310 321 133 427 341 307 301 418 425 Service Volume - No. of Hours (Repairs) 277 291 296 282 292 394 388 310 279 274 380 386 Selling Price - Pedal Classic 500.00 Cost Price - Pedal Classic S 300.00 Selling Price - Folding Urban Dream $ 800.00 Cost Price - Folding Urban Dream S 650.00 Service Revenue Per Hour (Repairs) S 80.00 Number of Sale Assistants: 3 Wage Rate Per Employee Per Month S 6,000 Number of Office Staff: 2 Wage Rate Per Employee Per Month 3,500 Number of Repair Technicians 4 Wage Rate Per Employee Per Month S 5,500As the manager, Tracie keeps a close eye on inventory management and would like to always maintain a monthly ending inventory requirement of 20% of next month's sales. You can assume the beginning inventory for January 2025 to be 0 units for both Pedal Classic and Folding Urban Dream ebikes
