ive started it, but my ending isnt matching to the check point.

07208 Input Data Galluny in 150 Non seule Humay yerere Budgeted sales pertung Stay tunitsi unila | utilal Augustus Expected 190 5.00 3.000 Budgeted) Seing price per unit Todes 2.000 13 Selline Primir $ 11 Cash Collection Pattern Month of 1 Folloin 15 Uncollectible counts relvabe Begining balans May NELERS 12. Cal Payment fur Material Sonth of purchase 12 Following month G june sales 1a Collectie 57.00 uniscella Production time 22 Kanarial per writilb. matal cost perib. Directeurs per unit Directione per hour lindile MDD prilor 2 Tid HD Deprecacanne NORD 33 Selling Alminicirii (NA ishleSuperiod Fixed 58.Aco per month Deprecacan SSAGE $40.00 59000 $3.950 Budgeted sales M Desired enclusive Tals 51.15 $63.000 $20.000 Bequired Productie Other Cash Onthos Geldivimuspaidah 2 galpurdue Way Equipment purchaec June Desired Ending Inventory Finished w stil $35.000 $0820 $134.000 qui in Baw materials per un Prodaction steeds s. Me Desired enesen Tales teeginning inventory Buw material to be purda Lolo T S Total Castor Row Me $30,000 ROSSSSS Reginning Account balances of March $37.745 Aurdal S1:12000 Til innkey $10,20 Fatched goods cost per unit 875.00 Fished goods story unitsi kriisin $13.10 w mirish Scors pratie 335.000 Schedul Arenal 5 36 Land Buildings and met Aumalad wishin $530,000 $1,200.00 150X Mithrases Resined canines 5121491 1 Den for Miss annum 6.42A 07208 H roborwse al calderas Bluray yer Tittle Anningmakers Sales Budget US) April 2.9% GO $120 $120 0033 32 Budgeted sales funts) Selling price per unit Tuan 2 $123 11.30 51211 31. SALIERI 5 Little Aunin Hazmakers Struleafspod Doh Chlete (SS April Curier ACCUBUS ovable Einning balance $112.000 $132.00 April sales 5 120.000 5 165.00 $ 2500 May 3 25 100 une sales $ 141000$ TO Tralash ti $1. ANNI LOS Receivedle as of 195.000 Little Annin Hagmans PM! 6.000 2.30 Budgeted sales Adat Desired ending invent Thal Ilinning in Bequired Production 2.300 1.200 123 -110 320 3.000 0 143 11,500 2.500 1:LINI 231 1 1 11,20 2. 2 Little Annin Hagmakers rect Steals Badget IUSSI si putin in una 320 Sa 11,500 Farv materials per unit be Produsen needs lbs. 16430 27.000 14.300 57.990 Add Desired endirinin 10.900 3.900 1800 23.180 Thale 272.00 19:23 RII 400 10 31.3 www materials to be purchas 22.000 12.900 58190 Co wa 3700 S. Toral Costot Baw Ngeras 5 155.550 $ 154.00 5 9130S WIGI tills in lagukura Schedule of Expected Cash Disbursements for Nuneral IUSSI AT 5 63.4203 9.13 1910 Strypurtha 15400 GLOR ihare Hei ud Hete S.12 Thalhah for 5118 $1:13 SA 07208 Ad: Deind din went D.CO 5.900 21 LIO Raw mats 19 be purchas 22.650 22.000 051 0 1 1 lit II S70 7.00 Tabel O nowe Materials 15,5S 15111805 Cuyas 20 4800 14 IS) 13.300 3700 22 Jan 11.1:31 21.30 58.190 $7.00 S 4 Lattle.win Flames Schedule of Expected Ch Thishersements for Mineral My June Curter Accounts pasile Beanin 355,000 558,00 April parchases $ 95.130 158530 Mhes und 5 61.000 23 15 June pure 5 37.200 $ 37,500 Total Cash Disburs for Materials 3115,420 $136.730 $131,200 SUG,300 Aunts Payable spines Lattle in onlara Det labore Myy June Qurer 11 Luis werd Darlan hal Total direct labor house Direct labor to Tal Direito ILS 1.615 OS 2.700 LASI $10.00 SHIN 3 100 21.11 5 TOOS Curr Little in Fazmakers Manufacturing Overhead Budzet IUSSI P. In alvrhu 1,545 20 1.491 SID 330 $10 Total cable MOEID $ 16,4505 270008 11.9008 Per MOHD 5 574905 To MOHD 5 744005 HAOS Les Depecciation $ 20.0005 20.000 200023 Col Dissements for MDS 54,4005 649308 $10 57,500 17 231. NII 171,00 NO rate DEID pense direct labore hour Absorpconcos per unit litili Anaimer: Untt Produs: Cost (US) Quantity Cost Costunit 2150 $13,250,00 37600 $211,000 SHO 3735.00 $281.800,00 310.00 Dar Nafacturas oresheed Unit Product Coat 1. Annin maker Cast of Goods Sold BudgILSDI Us Total Cast 110 11,90 Coat of Goods sold CFO) Beginning finished goods interior Athi: Lalur Landsfore 15: ins Den Guld 95.00 5 0.00 5 1,002 Share LUI SOS 1043A Cost of Goods Sold CFTFO) Beginning finished good try Ad Categorks minut Good Jailable to sale Les: Ending finished roads 07208 TWS Cost of Good Son USD Unins sunt Total 410 $75.00 310 11.10 $7.00 $ 1.00 $ 1.000.000 500 43,900 $ La Annin lama Selling and Administrative Excparce Budget (US$1 May 2.300 6.000 3,000 51.25 $1.25 $123 3.1995 3.7305 3 68,000 63000 $ 13,000 3 3 6125$ 2005 3 $ 10,000 $ 10.000 10,000 Quarter 21.500 $1.25 5 Budgeted sales in units Veuil Total arable SAA Total fixed RA Tutal SRA Les: Deprecatice Col sur SS. 7.300 20.000 56,125 GO.300 173,375 Little Annin Flammakers Crehur Quarter Tirginningschalen 5 4sha ulleriirs $250,000 289, TUSS SU $1245.000 117.5 11 5 3000 $116,431 Les churmat Ilire maria Tireler 5 Saulturingwthamil : Selling med mingit Divads $ $1960 31313 TOOS SUD 61950 $ 52.490 $211 $110 $13,3 345,000 5135 15,000 15.000 15,000 15 3312,400 Total Disburscn.cat 8308, 745 403.180 81229,745 Txerres deficiency of the wilali 3 (20,000 160,831 5 50,000 $ Finan Borrowing Reparments Interest Total Penang $ $ 1941,00 18.05 158,00018 30,000 0,0001 IRO 18,000 50,000 $ Endine Case Balance 30,200 $ 772205 Schadh little Annin Haymakers Budgeted Income Street (USSI Quur online June 10 Net als 10:nulleda $ 130,00 3 3 3 5 141,045 3 IR OCH TAIS SELIG Decbc NH Lassinle Rece Crepulsimal Net Sales Sales Los collins Net Sales 07208 104A Poticelor cash arable 20.0000 $ 1160220 5 Finanang re Bar Terest Total Finans $ 150,000 $ IRRINS (S, M 30000 0300000 CO BODO $ 30.0005 S 5 Ending Chile 152220 $ 20.000 S2000 Linile Amin ligulars Biednyme Statement (USSO Daar Ending Nelle Less! Cost of good old S 1.1 3 9310 3 $ 203375 3 181045 $ 8.0000 3 181045 Nelsingin Less: innerst expense Natiname Computation of Net Sales Sales Less uncollectible amounts Net Sales through Budpeed Income Statement per Case Study requirements Budgeted Balance Sheet the peace Sheet Little Annin ligmakers Budgeted Balance Sheet IUSS) Entre March Ending June 30 Current Cash Accounts receivable inventory Finished inventory Pantal Land luilling, 41: V H Actualated depreciation Tu Aceite S Come sindi Thallistite and She's Bully . Hece Share AutoSave Gutierre: Lea_casestucy - lea_chantelyahoo.com File Home Insert Draw Page Layout Formulas Data Review View Help Shar H25 B 1 Input Data (all currency in US$) D Yellow-use only cell references Blue-may type mmbers here 2 Expected 2,500 E G Little Annin Flagmakers Sales Budget (US$) April May June Quarter 2,500 6,000 3,000 11,500 $120 $120 $120 $120 300,000 S 720,000 $360,000 $ 1,380,000 6,000 Budgeted sales (units) Selling price per unit Total Sales $ 3,000 2,500 2,000 $120.00 Little Annin Flagmakers Schedule of Expected Cash Collections (USS) April May June Quarter Accounts receivable Beginning balance $132,000 $132.000 3 Budgeted Sales 4 April (units) 5 May (units) 6 June (units) 7 July (units) 8 August (units) 9 10 Selling Price/Unit 11 2 Cash Collection Pattern 3 Month of sale 4 Following month 15 Uncollectible 16 17 Cash Payments for Materials 18 Month of purchase 19 Following month 20 1 Production Requirements 2 Raw material per unit (lb.) 3 Raw material cost per lb. 4 Direct labor hours per unit TACCT 311 - Student template 40% 55% 5% April sales $ 120.000 $ 165.000 $ 285,000 May sales $ 288,000 S 396,000 $ 684,000 40% 60% June sales S 144.000 $ 144,000 Total Cash Collections $252.000 $453.000 $540,000 $1.245.000 5 Accounts Receivable as of Junc $ 198.000 $7.00 0.5 29 decrease + A x W Type here to search sutoSave Gutierre: Les casestudy- les chantel yahoo.com de Home Insert Draw Page Layout Formulas Data Review View Help Share o Corn 15 X f C D E F H Accounts Receivable as of June $ 198,000 A Raw material per unit (Ib.) Raw material cost per lb. Direct labor hours per unit Direct labor rate per hour Variable MOHD per direct labor hour Fixed MOHD per month Depreciation in fixed MOHD B 5 $7.00 0.5 $40.00 $10.00 $57,950 $20,000 Little Annin Flagmakers Production Budget April May 2,500 6,000 1.200 600 3,700 6,600 410 1,200 3,290 5,400 Budgeted sales Add: Desired ending inventory Total needs Less: Beginning inventory Required Production June 3,000 500 3,500 600 2.900 Quarter 11,500 2,300 13,800 2,210 11,590 July 2,500 400 2,900 500 Selling & Administrative (S&A) Costs Variable S&A cost per unit sold Fixed S&A cost per month Depreciation in fixed S&A cost $1.25 $63,000 $10,000 + 2,400 Other Cash Outflows Cash dividends paid each month Equipment purchases May Equipment purchases June $15.000 $47,820 $154.600 Little Annin Flagmakers Direct Materials Budget (US$) April May Junc 3.290 5.400 2.900 5 5 5 16.450 27,000 14,500 10.800 5.800 4,800 27.250 32.800 4.600 10,800 5,800 22.650 22.000 13.500 $7.00 $7.00 $7.00 158.550 $ 154.000 S 94.500 Required production in units Raw materials per unit (lbs.) Production needs (lbs.) Add: Desired ending inventory Total needs Less: Beginning inventory Raw materials to be purchased Cost of raw materials Total Cost of Raw Materials Desired Ending Inventory Finished goods Raw materials Cash Quarter 11,590 5 57,950 23.180 81.130 21,200 58.150 $7.00 407,050 19,300 20% 40% $30.000 S Beginning Account Balances as of March 31 TACCT 311 - Student template 296 decrease a ? 09 10:58 A 6/5/20 X Type here to search AutoSave w Gutierre: Lea_casestudy les_chantel@yahoo.com File Home Insert Draw Page Layout Formulas Data Review View Help Share H25 C D E F Raw materials to be purchased 22,650 22,000 Cost of raw materials $7.00 $7.00 Total Cost of Raw Materials $ 158,550 $ $ 154,000 $ Check figure for April Cost of Raw Materials $158,550 G 13,500 58,150 $7.00 $7.00 94,500 $ 407,050 B 43 Cash $30,000 44 45 Beginning Account Balances as of March 31 46 Cash $37,745 47 Accounts receivable $132,000 48 Finished goods inventory $30.750 49 Finished goods cost per unit $75.00 50 Finished goods inventory (units) 410 51 Raw materials inventory $32.200 52 Raw materials (Ib.) 4,600 53 Accounts payable $55.000 54 55 Land $520,000 56 Buildings and equipment $1,800.000 57 Accumulated depreciation ($750.000) 58 Common stock $500.000 59 Retained earnings $1.247.695 Little Annin Flagmakers Schedule of Expected Cash Disbursements for Material (USS) April May June Quarter Accounts payable Beginning balance $55.000 $55,000 + April purchases $ 63,420 $ 95,130 $ 158,550 May purchases $ 61,600 $ 92.400 $ 154,000 June purchases $ 37,800 $ 37,800 Total Cash Disbursements for Materials $118,420 $156.730 $130.200 $405,350 60 61 62 63 64 65 Accounts Payable as of June 31 S 56.700 Little Aunin Flagmakers TACCT 311 - Student template 296 decrease E Type here to search X w 09 (2 Comn Units to be produced Direct labor hours per unit Total direct labor hours needed Direct labor cost per hour Total Direct Labor Cost Little Annin Flagmakers Direct Labor Budget (US$) April May June 3,290 5,400 2,900 0.5 0.5 0.5 1,645 2,700 1,450 $40.00 $40.00 $40.00 65,800 $ 108,000 S 58,000 Quarter 11,590 0.5 5,795 $40.00 $ 231,800 $ $10 Little Annin Flagmakers Manufacturing Overhead Budget (US$) April May June Quarter Budgeted direct labor hours 1,645 2,700 1,450 5,795 Variable MOHD rate $10 $10 $10 Total variable MOHD $ 16,450 $ 27,000 $ 14,500 $ 57,950 Fixed MOHD expense $ 57,950 $ 57,950 $ 57,950 $ 173,850 Total MOHD expense $ 74.400 $ 84,950 $ 72,450 $ 231,800 Less: Depreciation $ 20.000 $ 20,000 $ 20.000 $ 60.000 Cash Disbursements for MOHI $ 54.400 $ 64,950 $ 52.450 $ 171.800 S52,450 Check Figure for June Cash Disbursements for MOHD MOHD rate IOHD expense /direct labor hour Little Annin Flagmaker's late 29 decrease + HI e BI P 10:59 AM 6/5/2020 Absorption cost per unit Direct materials Direct labor Manufacturing overhead Unit Product Cost Unit Product Cost (US$) Quantity Cost 58150 $407,050.00 5795.00 $231,800.00 5795.00 $231,800.00 Cost/unit $7.00 $40.00 $40.00 $87.00 Little Annin Flagmakers Cost of Goods Sold Budget (USD) Units Cost/unit Total Cost 410 11,590 Cost of Goods Sold (FIFO) Beginning finished goods inventory Add: Cost of goods manufactu Good available for sale Less: Ending finished goods inventory Cost of Good Sold $75.00 $ 30,750 $87.00 $ 1,008,330 $ 1,039,080 500 $87.00 $ $ 43,500 995,580 Little Annin Flagmakers Selling and Administrative Expense Budget (US$) April May June 2.500 6,000 3.000 $1.25 $1.25 $1.25 $ 3.125 $ 7.500 $ 3.750 $ Budgeted sales in units Variable S&A per unit Total variable S&A Quarter 11,500 $1.25 14.375 se 10:59 6/5/2 A ma E G $ Little Annin Flagmakers Selling and Administrative Expense Budget (US$) April May June Quarter Budgeted sales in units 2.500 6,000 3,000 11,500 Variable S&A per unit $1.25 $1.25 $1.25 $1.25 Total variable S&A $ 3,125 $ 7,500 $ 3.750 $ 14,375 Total fixed S&A $ 63,000 63,000 $ 63,000 $ 189,000 Total S&A expense $ 66,125 $ 70.500 $ 66.750 $ 203,375 Less: Depreciation $ 10.000 $ 10,000 $ 10,000 $ 30.000 Cash Disbursements for S&A $ 56.125 $ 60,500 $ 56.750 $ 173,375 $60.500 Check Figure for May Cash Disbursements for S&A Little Annin Flagmakers Cash Budget (US$) April May June Quarter Beginning Cash Balance $ 37.745 $ 30.000 $ 77.820 $ 145,565 Add: Receipts Cash collections $252.000 $453.000 $540,000 $1,245,000 Total Cash Available $ 289.745 $ 483.000 $ 617.820 $ 1.390,565 Less disbursements Direct materials Direct labor Manufacturing overhead $ $ $118.420 65.800 54.400 $ $ $156.730 108.000 64.950 $ $ $130.200 58.000 52.450 $405,350 $231.800 $171.800 1. ano.com Data Review View Help Share Coms F D Total Cash Available $ E 289,745 $ 483,000 G $ 617,820 $ 1,390,565 $ $ $ $ $ $118,420 65,800 54,400 56,125 15.000 Less disbursements Direct materials Direct labor Manufacturing overhead Selling and administrative Dividends Equipment purchases Total Disbursements $ $156.730 108,000 64,950 60,500 15,000 47,820 $405,180 $130,200 58,000 52,450 56,750 15,000 154,600 $312,400 $405,350 $231,800 $171,800 $173,375 $45,000 $202,420 $1,229,745 $309.745 + Excess (deficiency) of cash available $ (20,000 $ 77.820 $ 305.420 $ 160.820 $ 50,000 $ Financing Borrowing Repayments Interest Total Financing $ $ (50.000) $ (8,000 $ (58.000 $ 50,000 (50,000) (8,000) (8,000) $ $ 50.000 $ $ 152.820 Ending Cash Balance $ 30.000 $ 77.820 $ 247.420 $30,000 Check Figure for April Ending Cash Balance Little Annin Flagmaker's D G Ending Cash Balance $ 30,000 $ 77,820 $ 247,420 $30,000 Check Figure for April Ending Cash Balance $ 152,820 Little Annin Flagmakers Budgeted Income Statement (US$) Quarter Ending June 30 Net sales Less: Cost of goods sold Gross margin Less: S&A expenses Net operating income Less: Interest expense Net income $ 1,380,000 $ 995,580 $ 384,420 $ 203,375 $ 181,045 $ (8,000) $ 189,045 S243,125 Check Figure for Net Income Computation of Net Sales Sales Less uncollectible amounts Net Sales es Budget through Budgeted Income Statement per Case Study requirements, Budgeted Balance Sheet optional for extra en Complete the Budgeted Balance Sheet Little Annin Flagmakers Budgeted Balance Sheet (US$) 11:00 AM D let the Budgeled Balance Sheet Little Annin Flagmakers Budgeted Balance Sheet (US$) Ending March 31 Ending June 30 Current assets Cash Accounts receivable Raw materials inventory Finished goods inventory Plant and equipment Land Buildings and equipment Accumulated depreciation Total Assets Liabilities Accounts payable Stockholder's equity Common stock Retained earnings Total Liabilities and Stockholder's Equity 09 11:00 AM 6/5/2020 07208 Input Data Galluny in 150 Non seule Humay yerere Budgeted sales pertung Stay tunitsi unila | utilal Augustus Expected 190 5.00 3.000 Budgeted) Seing price per unit Todes 2.000 13 Selline Primir $ 11 Cash Collection Pattern Month of 1 Folloin 15 Uncollectible counts relvabe Begining balans May NELERS 12. Cal Payment fur Material Sonth of purchase 12 Following month G june sales 1a Collectie 57.00 uniscella Production time 22 Kanarial per writilb. matal cost perib. Directeurs per unit Directione per hour lindile MDD prilor 2 Tid HD Deprecacanne NORD 33 Selling Alminicirii (NA ishleSuperiod Fixed 58.Aco per month Deprecacan SSAGE $40.00 59000 $3.950 Budgeted sales M Desired enclusive Tals 51.15 $63.000 $20.000 Bequired Productie Other Cash Onthos Geldivimuspaidah 2 galpurdue Way Equipment purchaec June Desired Ending Inventory Finished w stil $35.000 $0820 $134.000 qui in Baw materials per un Prodaction steeds s. Me Desired enesen Tales teeginning inventory Buw material to be purda Lolo T S Total Castor Row Me $30,000 ROSSSSS Reginning Account balances of March $37.745 Aurdal S1:12000 Til innkey $10,20 Fatched goods cost per unit 875.00 Fished goods story unitsi kriisin $13.10 w mirish Scors pratie 335.000 Schedul Arenal 5 36 Land Buildings and met Aumalad wishin $530,000 $1,200.00 150X Mithrases Resined canines 5121491 1 Den for Miss annum 6.42A 07208 H roborwse al calderas Bluray yer Tittle Anningmakers Sales Budget US) April 2.9% GO $120 $120 0033 32 Budgeted sales funts) Selling price per unit Tuan 2 $123 11.30 51211 31. SALIERI 5 Little Aunin Hazmakers Struleafspod Doh Chlete (SS April Curier ACCUBUS ovable Einning balance $112.000 $132.00 April sales 5 120.000 5 165.00 $ 2500 May 3 25 100 une sales $ 141000$ TO Tralash ti $1. ANNI LOS Receivedle as of 195.000 Little Annin Hagmans PM! 6.000 2.30 Budgeted sales Adat Desired ending invent Thal Ilinning in Bequired Production 2.300 1.200 123 -110 320 3.000 0 143 11,500 2.500 1:LINI 231 1 1 11,20 2. 2 Little Annin Hagmakers rect Steals Badget IUSSI si putin in una 320 Sa 11,500 Farv materials per unit be Produsen needs lbs. 16430 27.000 14.300 57.990 Add Desired endirinin 10.900 3.900 1800 23.180 Thale 272.00 19:23 RII 400 10 31.3 www materials to be purchas 22.000 12.900 58190 Co wa 3700 S. Toral Costot Baw Ngeras 5 155.550 $ 154.00 5 9130S WIGI tills in lagukura Schedule of Expected Cash Disbursements for Nuneral IUSSI AT 5 63.4203 9.13 1910 Strypurtha 15400 GLOR ihare Hei ud Hete S.12 Thalhah for 5118 $1:13 SA 07208 Ad: Deind din went D.CO 5.900 21 LIO Raw mats 19 be purchas 22.650 22.000 051 0 1 1 lit II S70 7.00 Tabel O nowe Materials 15,5S 15111805 Cuyas 20 4800 14 IS) 13.300 3700 22 Jan 11.1:31 21.30 58.190 $7.00 S 4 Lattle.win Flames Schedule of Expected Ch Thishersements for Mineral My June Curter Accounts pasile Beanin 355,000 558,00 April parchases $ 95.130 158530 Mhes und 5 61.000 23 15 June pure 5 37.200 $ 37,500 Total Cash Disburs for Materials 3115,420 $136.730 $131,200 SUG,300 Aunts Payable spines Lattle in onlara Det labore Myy June Qurer 11 Luis werd Darlan hal Total direct labor house Direct labor to Tal Direito ILS 1.615 OS 2.700 LASI $10.00 SHIN 3 100 21.11 5 TOOS Curr Little in Fazmakers Manufacturing Overhead Budzet IUSSI P. In alvrhu 1,545 20 1.491 SID 330 $10 Total cable MOEID $ 16,4505 270008 11.9008 Per MOHD 5 574905 To MOHD 5 744005 HAOS Les Depecciation $ 20.0005 20.000 200023 Col Dissements for MDS 54,4005 649308 $10 57,500 17 231. NII 171,00 NO rate DEID pense direct labore hour Absorpconcos per unit litili Anaimer: Untt Produs: Cost (US) Quantity Cost Costunit 2150 $13,250,00 37600 $211,000 SHO 3735.00 $281.800,00 310.00 Dar Nafacturas oresheed Unit Product Coat 1. Annin maker Cast of Goods Sold BudgILSDI Us Total Cast 110 11,90 Coat of Goods sold CFO) Beginning finished goods interior Athi: Lalur Landsfore 15: ins Den Guld 95.00 5 0.00 5 1,002 Share LUI SOS 1043A Cost of Goods Sold CFTFO) Beginning finished good try Ad Categorks minut Good Jailable to sale Les: Ending finished roads 07208 TWS Cost of Good Son USD Unins sunt Total 410 $75.00 310 11.10 $7.00 $ 1.00 $ 1.000.000 500 43,900 $ La Annin lama Selling and Administrative Excparce Budget (US$1 May 2.300 6.000 3,000 51.25 $1.25 $123 3.1995 3.7305 3 68,000 63000 $ 13,000 3 3 6125$ 2005 3 $ 10,000 $ 10.000 10,000 Quarter 21.500 $1.25 5 Budgeted sales in units Veuil Total arable SAA Total fixed RA Tutal SRA Les: Deprecatice Col sur SS. 7.300 20.000 56,125 GO.300 173,375 Little Annin Flammakers Crehur Quarter Tirginningschalen 5 4sha ulleriirs $250,000 289, TUSS SU $1245.000 117.5 11 5 3000 $116,431 Les churmat Ilire maria Tireler 5 Saulturingwthamil : Selling med mingit Divads $ $1960 31313 TOOS SUD 61950 $ 52.490 $211 $110 $13,3 345,000 5135 15,000 15.000 15,000 15 3312,400 Total Disburscn.cat 8308, 745 403.180 81229,745 Txerres deficiency of the wilali 3 (20,000 160,831 5 50,000 $ Finan Borrowing Reparments Interest Total Penang $ $ 1941,00 18.05 158,00018 30,000 0,0001 IRO 18,000 50,000 $ Endine Case Balance 30,200 $ 772205 Schadh little Annin Haymakers Budgeted Income Street (USSI Quur online June 10 Net als 10:nulleda $ 130,00 3 3 3 5 141,045 3 IR OCH TAIS SELIG Decbc NH Lassinle Rece Crepulsimal Net Sales Sales Los collins Net Sales 07208 104A Poticelor cash arable 20.0000 $ 1160220 5 Finanang re Bar Terest Total Finans $ 150,000 $ IRRINS (S, M 30000 0300000 CO BODO $ 30.0005 S 5 Ending Chile 152220 $ 20.000 S2000 Linile Amin ligulars Biednyme Statement (USSO Daar Ending Nelle Less! Cost of good old S 1.1 3 9310 3 $ 203375 3 181045 $ 8.0000 3 181045 Nelsingin Less: innerst expense Natiname Computation of Net Sales Sales Less uncollectible amounts Net Sales through Budpeed Income Statement per Case Study requirements Budgeted Balance Sheet the peace Sheet Little Annin ligmakers Budgeted Balance Sheet IUSS) Entre March Ending June 30 Current Cash Accounts receivable inventory Finished inventory Pantal Land luilling, 41: V H Actualated depreciation Tu Aceite S Come sindi Thallistite and She's Bully . Hece Share AutoSave Gutierre: Lea_casestucy - lea_chantelyahoo.com File Home Insert Draw Page Layout Formulas Data Review View Help Shar H25 B 1 Input Data (all currency in US$) D Yellow-use only cell references Blue-may type mmbers here 2 Expected 2,500 E G Little Annin Flagmakers Sales Budget (US$) April May June Quarter 2,500 6,000 3,000 11,500 $120 $120 $120 $120 300,000 S 720,000 $360,000 $ 1,380,000 6,000 Budgeted sales (units) Selling price per unit Total Sales $ 3,000 2,500 2,000 $120.00 Little Annin Flagmakers Schedule of Expected Cash Collections (USS) April May June Quarter Accounts receivable Beginning balance $132,000 $132.000 3 Budgeted Sales 4 April (units) 5 May (units) 6 June (units) 7 July (units) 8 August (units) 9 10 Selling Price/Unit 11 2 Cash Collection Pattern 3 Month of sale 4 Following month 15 Uncollectible 16 17 Cash Payments for Materials 18 Month of purchase 19 Following month 20 1 Production Requirements 2 Raw material per unit (lb.) 3 Raw material cost per lb. 4 Direct labor hours per unit TACCT 311 - Student template 40% 55% 5% April sales $ 120.000 $ 165.000 $ 285,000 May sales $ 288,000 S 396,000 $ 684,000 40% 60% June sales S 144.000 $ 144,000 Total Cash Collections $252.000 $453.000 $540,000 $1.245.000 5 Accounts Receivable as of Junc $ 198.000 $7.00 0.5 29 decrease + A x W Type here to search sutoSave Gutierre: Les casestudy- les chantel yahoo.com de Home Insert Draw Page Layout Formulas Data Review View Help Share o Corn 15 X f C D E F H Accounts Receivable as of June $ 198,000 A Raw material per unit (Ib.) Raw material cost per lb. Direct labor hours per unit Direct labor rate per hour Variable MOHD per direct labor hour Fixed MOHD per month Depreciation in fixed MOHD B 5 $7.00 0.5 $40.00 $10.00 $57,950 $20,000 Little Annin Flagmakers Production Budget April May 2,500 6,000 1.200 600 3,700 6,600 410 1,200 3,290 5,400 Budgeted sales Add: Desired ending inventory Total needs Less: Beginning inventory Required Production June 3,000 500 3,500 600 2.900 Quarter 11,500 2,300 13,800 2,210 11,590 July 2,500 400 2,900 500 Selling & Administrative (S&A) Costs Variable S&A cost per unit sold Fixed S&A cost per month Depreciation in fixed S&A cost $1.25 $63,000 $10,000 + 2,400 Other Cash Outflows Cash dividends paid each month Equipment purchases May Equipment purchases June $15.000 $47,820 $154.600 Little Annin Flagmakers Direct Materials Budget (US$) April May Junc 3.290 5.400 2.900 5 5 5 16.450 27,000 14,500 10.800 5.800 4,800 27.250 32.800 4.600 10,800 5,800 22.650 22.000 13.500 $7.00 $7.00 $7.00 158.550 $ 154.000 S 94.500 Required production in units Raw materials per unit (lbs.) Production needs (lbs.) Add: Desired ending inventory Total needs Less: Beginning inventory Raw materials to be purchased Cost of raw materials Total Cost of Raw Materials Desired Ending Inventory Finished goods Raw materials Cash Quarter 11,590 5 57,950 23.180 81.130 21,200 58.150 $7.00 407,050 19,300 20% 40% $30.000 S Beginning Account Balances as of March 31 TACCT 311 - Student template 296 decrease a ? 09 10:58 A 6/5/20 X Type here to search AutoSave w Gutierre: Lea_casestudy les_chantel@yahoo.com File Home Insert Draw Page Layout Formulas Data Review View Help Share H25 C D E F Raw materials to be purchased 22,650 22,000 Cost of raw materials $7.00 $7.00 Total Cost of Raw Materials $ 158,550 $ $ 154,000 $ Check figure for April Cost of Raw Materials $158,550 G 13,500 58,150 $7.00 $7.00 94,500 $ 407,050 B 43 Cash $30,000 44 45 Beginning Account Balances as of March 31 46 Cash $37,745 47 Accounts receivable $132,000 48 Finished goods inventory $30.750 49 Finished goods cost per unit $75.00 50 Finished goods inventory (units) 410 51 Raw materials inventory $32.200 52 Raw materials (Ib.) 4,600 53 Accounts payable $55.000 54 55 Land $520,000 56 Buildings and equipment $1,800.000 57 Accumulated depreciation ($750.000) 58 Common stock $500.000 59 Retained earnings $1.247.695 Little Annin Flagmakers Schedule of Expected Cash Disbursements for Material (USS) April May June Quarter Accounts payable Beginning balance $55.000 $55,000 + April purchases $ 63,420 $ 95,130 $ 158,550 May purchases $ 61,600 $ 92.400 $ 154,000 June purchases $ 37,800 $ 37,800 Total Cash Disbursements for Materials $118,420 $156.730 $130.200 $405,350 60 61 62 63 64 65 Accounts Payable as of June 31 S 56.700 Little Aunin Flagmakers TACCT 311 - Student template 296 decrease E Type here to search X w 09 (2 Comn Units to be produced Direct labor hours per unit Total direct labor hours needed Direct labor cost per hour Total Direct Labor Cost Little Annin Flagmakers Direct Labor Budget (US$) April May June 3,290 5,400 2,900 0.5 0.5 0.5 1,645 2,700 1,450 $40.00 $40.00 $40.00 65,800 $ 108,000 S 58,000 Quarter 11,590 0.5 5,795 $40.00 $ 231,800 $ $10 Little Annin Flagmakers Manufacturing Overhead Budget (US$) April May June Quarter Budgeted direct labor hours 1,645 2,700 1,450 5,795 Variable MOHD rate $10 $10 $10 Total variable MOHD $ 16,450 $ 27,000 $ 14,500 $ 57,950 Fixed MOHD expense $ 57,950 $ 57,950 $ 57,950 $ 173,850 Total MOHD expense $ 74.400 $ 84,950 $ 72,450 $ 231,800 Less: Depreciation $ 20.000 $ 20,000 $ 20.000 $ 60.000 Cash Disbursements for MOHI $ 54.400 $ 64,950 $ 52.450 $ 171.800 S52,450 Check Figure for June Cash Disbursements for MOHD MOHD rate IOHD expense /direct labor hour Little Annin Flagmaker's late 29 decrease + HI e BI P 10:59 AM 6/5/2020 Absorption cost per unit Direct materials Direct labor Manufacturing overhead Unit Product Cost Unit Product Cost (US$) Quantity Cost 58150 $407,050.00 5795.00 $231,800.00 5795.00 $231,800.00 Cost/unit $7.00 $40.00 $40.00 $87.00 Little Annin Flagmakers Cost of Goods Sold Budget (USD) Units Cost/unit Total Cost 410 11,590 Cost of Goods Sold (FIFO) Beginning finished goods inventory Add: Cost of goods manufactu Good available for sale Less: Ending finished goods inventory Cost of Good Sold $75.00 $ 30,750 $87.00 $ 1,008,330 $ 1,039,080 500 $87.00 $ $ 43,500 995,580 Little Annin Flagmakers Selling and Administrative Expense Budget (US$) April May June 2.500 6,000 3.000 $1.25 $1.25 $1.25 $ 3.125 $ 7.500 $ 3.750 $ Budgeted sales in units Variable S&A per unit Total variable S&A Quarter 11,500 $1.25 14.375 se 10:59 6/5/2 A ma E G $ Little Annin Flagmakers Selling and Administrative Expense Budget (US$) April May June Quarter Budgeted sales in units 2.500 6,000 3,000 11,500 Variable S&A per unit $1.25 $1.25 $1.25 $1.25 Total variable S&A $ 3,125 $ 7,500 $ 3.750 $ 14,375 Total fixed S&A $ 63,000 63,000 $ 63,000 $ 189,000 Total S&A expense $ 66,125 $ 70.500 $ 66.750 $ 203,375 Less: Depreciation $ 10.000 $ 10,000 $ 10,000 $ 30.000 Cash Disbursements for S&A $ 56.125 $ 60,500 $ 56.750 $ 173,375 $60.500 Check Figure for May Cash Disbursements for S&A Little Annin Flagmakers Cash Budget (US$) April May June Quarter Beginning Cash Balance $ 37.745 $ 30.000 $ 77.820 $ 145,565 Add: Receipts Cash collections $252.000 $453.000 $540,000 $1,245,000 Total Cash Available $ 289.745 $ 483.000 $ 617.820 $ 1.390,565 Less disbursements Direct materials Direct labor Manufacturing overhead $ $ $118.420 65.800 54.400 $ $ $156.730 108.000 64.950 $ $ $130.200 58.000 52.450 $405,350 $231.800 $171.800 1. ano.com Data Review View Help Share Coms F D Total Cash Available $ E 289,745 $ 483,000 G $ 617,820 $ 1,390,565 $ $ $ $ $ $118,420 65,800 54,400 56,125 15.000 Less disbursements Direct materials Direct labor Manufacturing overhead Selling and administrative Dividends Equipment purchases Total Disbursements $ $156.730 108,000 64,950 60,500 15,000 47,820 $405,180 $130,200 58,000 52,450 56,750 15,000 154,600 $312,400 $405,350 $231,800 $171,800 $173,375 $45,000 $202,420 $1,229,745 $309.745 + Excess (deficiency) of cash available $ (20,000 $ 77.820 $ 305.420 $ 160.820 $ 50,000 $ Financing Borrowing Repayments Interest Total Financing $ $ (50.000) $ (8,000 $ (58.000 $ 50,000 (50,000) (8,000) (8,000) $ $ 50.000 $ $ 152.820 Ending Cash Balance $ 30.000 $ 77.820 $ 247.420 $30,000 Check Figure for April Ending Cash Balance Little Annin Flagmaker's D G Ending Cash Balance $ 30,000 $ 77,820 $ 247,420 $30,000 Check Figure for April Ending Cash Balance $ 152,820 Little Annin Flagmakers Budgeted Income Statement (US$) Quarter Ending June 30 Net sales Less: Cost of goods sold Gross margin Less: S&A expenses Net operating income Less: Interest expense Net income $ 1,380,000 $ 995,580 $ 384,420 $ 203,375 $ 181,045 $ (8,000) $ 189,045 S243,125 Check Figure for Net Income Computation of Net Sales Sales Less uncollectible amounts Net Sales es Budget through Budgeted Income Statement per Case Study requirements, Budgeted Balance Sheet optional for extra en Complete the Budgeted Balance Sheet Little Annin Flagmakers Budgeted Balance Sheet (US$) 11:00 AM D let the Budgeled Balance Sheet Little Annin Flagmakers Budgeted Balance Sheet (US$) Ending March 31 Ending June 30 Current assets Cash Accounts receivable Raw materials inventory Finished goods inventory Plant and equipment Land Buildings and equipment Accumulated depreciation Total Assets Liabilities Accounts payable Stockholder's equity Common stock Retained earnings Total Liabilities and Stockholder's Equity 09 11:00 AM 6/5/2020