These numbers will automatically populate as you fill in the blocks above and assist you in calculating the beginning balances for January and February. Nov Dec Jan Feb Sales in units 70,000 150,000 5,000 25,000 Desired ending inventory 37,500 1,250 6,250 Total required 107,500 151,250 11,250 Less: beginning inventory 17,500 37,500 1,250 Production required 90,000 113,750 10,000 SAA per unit 5 5 5 Total raw material needed 450,000 568,750 50,000 desired ending inventory 227,500 20,000 total required 677,500 588,750 Less: beginning inventory 180,000 227,500 RM to be purchased 497,500 361,250 cost per unit 0.45 0.45 Cost of purchases 223,875 162,563 Nov paid Dec paid Jan payable Feb payableper unit variable manufacturing: Utilities $ 0.60 Indirect materials 0.20 Plant maintenance 0.30 Environmental fee 0.14 Other 0.06 1.30 fixed manufacturing: Insurance Tax training & devel $ 43,200 Prepaid (beg) 64,000 19,200 property/bus tax $ 39,000 Purchased 96,000 39,600 supervisor's salary $ 149,400 Used 96,000 39,000 depreciation $ 178,800 Ending Bal 64,000 19,800 insurance 96,000 other $ 117,600 $ 624,000 Less: one time pay $ 96,000 insurance $ 8,000 insurance per month $ 39,000 Property tax training & develop per month from Jan to Jun property/bus tax per month from Jul to Dec Less: depreciation $ 178,800 $ 14,900 depreciation per month cash disbursements $ 349,200 or $ 29,100 cash disbursements per month Selling and Admin Lowest level of sales 375,000 total operating expenses $ 778,710 Highest level of sales 750,000 total operating expenses $ 1,022,460 Per unit fixed or per monthSales collection pattern current month 55.0% following month 35.0% 2 months after 9.5% uncollectible 0.5% Nov Dec Total sales $ 700,000 1,500,000 Nov collected Dec collected Jan receivable Feb receivable total receivable Monthly tax installments 5,000 outstanding from previous year 21,500 to be paid in April Income tax rate 25% Fixed asset purchase $ 204,300 Nov payment 40% | $ 81,720 Dec payment 60% $ 122,580Master Budget Case for PetWorks Ltd Data for Budget Assignment For the year ended December 31, 2025 estimated sales: 2024 (in units) 475,000 2025 (in units) 500,000 2026 (in units) 500,000 price per unit $10.00 cost per unit previous year $ 7.30 Absorption Costing cost per unit previous year $ 6.0520 Variable Costing Sales pattern Jan 1% Feb 5% Mar 1% Apr 10% May 1% Jun 1% Jul 2% Aug 2% Sep 2% Oct 15% Nov 20% Dec 40% 100% desired ending inventory (finished goods) 25% of next month's sales rental cost--Admn & Selling cost Sep $ 20,000 Oct 20,000 Nov 20,000 Dec $ 20,000Raw material: 55A (Space-age acrylic) required for each unit of product cost per kilogram desired ending inventory (raw materials) Accounts payable payment pattern: Beginning Accounts Payable: Movember Sales December sales 2 $ 0.45 40% 20% 45% 35% 70,000 150,000 kg next month's production needs in the month of purchase in the month following the purchase in the 2nd month following the purchase These numbers will automatically populate as you fill in the blocks above and assist you in calculating the beginning balances for January and February. Sales in units Desired ending inventory Total required Less: beginning inventory Production required SAA per unit Total raw material needed desired ending inventory total required Less: beginning inventory RM to be purchased cost per unit Cost of purchases MNaov Dec Jan Feb Time in production minutes or payable payable Mov Dec Jan 70,000 150,000 5,000 37,500 1,250 6,250 107,500 151,250 11,250 17,500 37,600 1,250 90,000 113,750 10,000 9 5 2 450,000 568,750 50,000 227,500 20,000 677 500 588,750 180,000 227 500 497 500 361,250 $ 045 % 0.45 $ 223875 % 162,563 0.30 Feb 25,000