First Page
Make a Proposed Budget about Kpop merchandise store.
?Sales Budget
?Sales Forecast
?Production Budget
?Cost Per piece
?Direct Materials Budget
Example and Guide:
PROPOSED BUDGET Sales Budget Earthy Essentials Sales Budget For the Year Ended December 31,2020 Quarter 2 3 Year Sales in Units (per variant) 10,000 11,002 12,350 13,002 46,354 x Selling Price per unit 75 75 75 75 75 Total Sales 750,000 825, 150 926,250 975, 150 3,476,550 Sales per box 500 562 875 937 2,874 x Selling Price per box 290 290 290 290 290 Total Sales 145,000 162,980 253,750 271,730 833,460 Total P4,310,010 Sales Forecast Sales Forecast 18000 16000 14000 12000 10000 8000 6000 4000 2000 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Sales ForecastIn the first several months of opening, the company will prioritize promotion in order for the consumers to be aware of this newly introduced product. The production will then be stable throughout the year, together with the consistent and increasing activity of advertising and promoting the item to be cotinuously spread out through a variety of buyers. With the acceleration of awareness, the gross sales would also increase. Production Budget Earthy Essentials Production Budget For the Year Ended December 31, 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Budget Sales 12000 13250 15850 16750 57850 Add: Desired Ending Inventory 663 793 838 904 3198 Total Needs 12663 14043 16688 17654 61048 Less: Beginning Inventory 663 793 838 2294 Required Production (unit] 12663 13380 15895 16816 58754 Desired ending inventory = 5% of next quarter's budget sales Desired begining inventory = 5% of current quarter's budget sales Cost per Piece Materials Cost per piece Sodium Cocoyl Isethionide P 28.00 Incroquate Pastilles P 2.60 Incroquate Liquid P 0.70 Stearic Acid P 7.60 Cetyl Alcohol P 1.50 Sodium Lactate P 0.25 Carrier Oil P 0.90 Packaging P 0.85 Total P 42.40Direct Materials Budget Earthy Essentials Direct Materials Budget For the Year Ended December 31, 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Budget Production (unit) 12663 13380 15895 16816 58754 Pieces per Unit Budget Products in Pieces 12663 13380 15895 16816 58754 Add: Desired Ending Inventory 395 1112.81 1176.63 693 3377.44 Total Direct Material Needs 13058 14492.81 17071.63 17509 62131.44 Less: Beginning Inventory 0 395 484 1176.63 2055.63 Required materials Purchase 13058 14097.81 16587.63 16332.37 60075.81 Cost per Piece 42.4 42.4 42.4 42.4 42.4 Materials Purchase Cost 553659.2 597747.144 703315.512 692492.488 2547214.344 Desired ending inventory = 7% of next quarter's budget Products in Pieces Desired beginning inventory = 7% of current quarter's budget product in Pieces
