hello how are you ? I uploaded some pictures with the numbers but some of them I did it by my own i would like you to help me with the others please help me last time you helped me and I was so happy
Problem 5-22A Basics of CVP Analysis; Cost Structure [LO5-I, LOB-3, LOB-4, L05-5. L05-6] Due to erratic sales ofits ante prudud~e high-capacity battery for lepth computersFEM, lm, has been samerienc'ng difallty for some lime. The company's ennlrihution fumlet inmrne ata'lernmt for the most recent month is given below: Sales (13.300 write x :20 per mil) 3250.000 Variable emenaes 133,000 (hnlribuiinn margin 133,000 nd expenses 143,000 Net meraling loss 5 (15,000) Required: 1. Compute the eunpany's CM relic end its breakeven paint in bolh unit sales and dollar sales. CM ratio 50 \"Ma Brash-even point in units 1430!) Break-even paint in dollars $ 290000 2. The president bdieves lhat e $6.900 increase in lhe monthly advertising budget. nonbined wilh en inlena'lierl elfart by the sales staff. will result in an $35,000 increm- in monthly 591%. if the pres'dent is right. what wil be the eecl an lhe company: monthly net operating 'neume 0r less? (Use the incremental approach in preparing your answer.) Increases -$ 35.600 E12 Cl l eztu.mheduoatian.nom cl T F F 3. Refer lo the o 'ginel data. The sales manager is oonvinmd that e 10% reduction in 1er selling price, eon-lined with In increase OFSEQJDO in the monthly advertising budget, will dmhle unit mlII. What wll the new contribution fonnatinoome statement look like if these charges are Idopted? Sales Variable expenses Contribution margin 0 Fixed expenses Net operating inoome $ 0 4. Retel- lo the original da1a. The Marketing DepIrtrnent thinks that a fancy new padtage for the laptop oormuter battery would help sales. The new padtage would increase portraying ooeki by 50.70 cents per unit. Assuming no other changes, how manyI mite would have to be sold each month to eem a prot of 54,700? (Do not round your intermediate calculations. Round your final aaner to nearest whole number.) : 5. Retertolhe original data. By automating, the mnpeny oould reduoe variable emenses in half. However, xed expenses would increase to} 553,000 eed'r month. a. Compute the new GM ratio and the new breekeven point in bath unit sales and dollar sales. (Use the CM ratio to calculate your break-even point in dollIrI. Do not round your Intermediate calculationl. Round up your nal break even answers to the nearaIt whole number.) CM ratio % Break-even point in units m :J l ezlomhadunaliamnnm (3| ? F F 5. Reiei'lolhe original data. By automating, the mmpany muld raduoe variable expenses in half. However, xed expenses would increase in} $53,000 each rnonlh. a. Compute lhe new GM ratio and he new braakeven point in balh unit sales and dollar sales. (Use the CM rao lo alculale your break-oven point In dollars. Do not round your lnlermedlate oaloulationl. Round upyour nal break even answers to the nearali whole number.) CM raiio % Break-even pninl in units Breakeven poinl in dollars la. Assume that the company expects to sell 20,600 uniis next moml'i. Prepare Mo oonlribuh'on lorrnat inmme statements, one assuming that operaiions an; noi llldnmled and one assuming lhal lhey are. Sales % '5'. Variable expenses % Va Conlribuiion margin 0 0 0 % I) 0 0 Va Fixed expenses Mei open-ing inoume $ 0 $ 0 (2. Would you remmmend lhal lhe mmpany automate its operations? Yes ONe lilill E I eztemheduoetionoom C. | 0 II m It Eil , mwm I Problem 7~22A Cash Budget with Supporting Schedules [l_07~2, LOT-4, LOT-8] Garden SIlas, Inc., sells garden supplies. Management is planning ih sash naeds forthe second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for AprilJuly are: Apli MIy June Jliy Sales 5 730,000 S 350,000 $ 300,000 $ 520,000 Gustaf goods sold 511,000 595,000 210,000 364,000 Gross margin 219,000 255,000 90,000 156,000 Sailing and administrative expenses: Selling expense 91,000 120,000 35,000 52,000 Administrative expense\" 50,500 07,200 34,000 49,000 Total selling and administrative axpensm; 141 mu 207,200 69,000 101,000 Net operating income 5 77,500 S 47,800 S 21,000 S 55,000 i "Includes $22,000 of depredation ead'i month. b.5ales are 20% for rash and 80% on account. c. Sales on amount are cnlleded over a threemonth period with 10% mllected in the month ()1 sale; 70% collected in the rst month following the month ofsale; and the remaining 20% collected in the second month following the month 01 sale. February's sales totaled $200,000. and March's sales totaled 5320mm. d. Inventory purchases are paid for within 15 days. Theratore, 50% of a month's inventory purchases Ire paid for in the month of purchase. The rema ng 50% is paid in the following month. Aomunts payable at March 31 for inventory purchases during MIrdi total $140,700. a. Eadi month's ending inventory must equal 20% of the costalthe merchandise to be sold in the following month. The merdiandise inventoryat Mardi 31 is $102,200. f. Dividends d340,000 will be declared and paid in April. 9. Land costing $48,000 will be purchased forcash in May. h.The emit! balanm at March 31 is $62,000: the company must maintain a cash balance ofatleast $40,000 It the end of each month. i. The company has an agreement with a local bank that allows the company to borrow in increments 01 51,000 at the beginning of each month, up to a total loan balance of $200,000. The interest rate on these loans is 1% per month and for simplicitywe will assume that interest is not compounded. The company would, as tar as it is able, repay the loan plus amumulated interestat the end of the quarter. Required: 1. Prepare a schedule 01 expected cash collections for April, May, and June, and tor the quarter in total. Answer is complete and correct: Raqulmd: 1. Prepay-e a amedule 0! expected cash ullecans fol-April, May, and June, and hr the quaar in hial. Annular II complete and correct Cash sales 5 140W 5 170W 5 00W 5 370000 Sales on amount: February 32,000.] 32,000 Mani-I 179,200.! 51W 230,400 April 53,400J 403,000'] \"0,000" 534,000 May 83,000J 470W 544000 June 24W 24,000 Total sh mlleclinns $ 415,600 $ 693,000 $ 675350 5 1,790,400 2. Prapare the following for merchandise lrwemnry: 3' A merchandise punxhsses budget forApril, May, and June. Answer Is complete Illll aormt Budgeted run ufgoads qud s 511,000.; s 095,000'; 3 210.0000; Add: Dauired ending rnard'landile invanlnry .1 119,000,) 42,000,] 72,000'; Total needs 000,000 \"1.00 202.000 Len: Baginnirg meml'landila irrrrunrury .1 102,200.} 119,000.; 42W Required invarnrrry purchases 5 027,300 5 5100-0 3 240.000 T 7 I ezlomheduealian'cem 6| 0 E E] h. Asd'ledule of expeered sash disbursements fer rnerduandise per-chasm for April, May, and June, and forlhe querner in Ialai. Answer In complete and correct Beginning lueuums payable 3 140,?00J S 140,700 April purchases 263,90w $330M 527 B00 May purchases 259,000.! $990M 510,000 June purchase: 120,400" 120 ,400 Tami cash disbursements 5 404,600 5 522,900 5 370,400 5 1,316,900 3. Prepare a mash budget fer April, May, and June as well as in ml for 019 quarter. (Gash deciency, repayments and Interest almuld be Indicated by a minus sign.) Am b not We! Beginning ash balance 3 6230M Add oulleelions from customers 415,80M 690,00W 670mm] 1,790,40M Talal (ash available 477,600 690,000 676,800 1,790,400 Less .511 disbursements; Purchases forinvenwry 404,600" 522,900.] 370,40w LMBQOW Selling expenses 9130M 120,00W 3530M WWW Adminislralive expenses Lanrl purd'lases 0.] 45,0110.) W 45,050,] Dividends paid mmw w W 40,0004 Total cash disbursements 535,600 690,900 414,400 1,640,900 Excess (delency) ef ush available over disbursements (50,000) 7,100 262,400 14I,50D nancing: Ba'rewings W May purchases 259,000,] $13,000" 51 8,000 June ptl'd'la 120W 12mm Telal mad-I disbursements S 404,600 5 522,900 3 379,400 3 1,306,900 3. Prepare a cash budget far April, May, and June as well as in metal for the quaner. (Gilli deciency, repayment: and Interest ahnuld be Indicated by a minus sign.) MHMM Begiming cash balance 5 82m Add mllemions from Bummer: 415.550.] memo.) 676W 1390,4410.) Telal cash available 477,600 698,000 676.8I0 1,790.4\" Less 03:11 disbursements: Purchases iarirwenkary 404,600.] 522,900.] 379W LEDBSW Selling expenses BLOOM 120W 3530M 240W Adminis'a'live expenses Land punaaeti W W DJ W Dividends paid 40,000,; M 0.] 40,000.] Total Ish disbursement; 535,600 69l,900 414,4ID 1,640.9ID Ema-155 (delidenqr) of lush availae aver disbursements (58,00I) 7,100 262,4I0 149,5I0 nalizing: Burmwings DJ Repayment 0" DJ Inierasl M D.) Total iinanu'ng 0 0 0 0 Ending Isl'l balanue 5 (SEMI) 5 7.100 S 262,4ID S 145.5ID LIL l | ezto.rnheducelion_r:om a...\" Problem 7-23A Cash Budget with Supporting Schedules; Changing Assumptions [L07-2, LOT-4, LOT-8] Garden Sales, Inc., sells garden supplies. Management is planning its (sash needs forthe second quarter. The company usually has to borrow money durl ng thls quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to asslst in preparlng a cash budget for the quarter: a. Budgeted monthly absorpllon ousting income statements for AprilJuly are: April May Jute Jily Sales 5 Bloom Suwanee s 530.000 s 540,000 Cost of goods sold 483,000 819,000 441,000 378,000 Gross margin 207,000 351.000 100.000 162,000 Selling and administrative expensm: Selling expense 125,000 112,000 74,000 54,000 Adminlstretive expense\" 52,500 70,400 45,000 51,000 Total selling end administrative expenses 177,500 182,400 119,800 105,000 Net operating income 3 20,500 5 168,600 5 60.200 S 57,000 'lncludes $35,000 of depreo'ation ead'l month. b. Sales are 20% for cash and 00% on account. c. Sales on account are colleded over a threemonth period with 10% collected in the month at sale; 70% collected in the rst month following the month ofsale: and the remainlng 20% collected in the second month following the month at sale. February's sales totaled $295,000. and Marchs sales totaled 5310mm. (1. Inventory purdrams are paid For within 15 days. Therefore, 50% of a month's inventory purchases are paid for in the month of purchase. The remaining 50% is paid in the following month. Accounts payable at March 31 for lnventory purchases during March total $135,100. e. Eadl month's ending lnventory must equal 20% of the costolthe merchandise to be sold in the following month. The merchandise inventory at March 31 is 5%.600. f. Dividends M342,m0 will be dedared and paid in Aprilt g. Land costing $50,000 will be purchased forcash in May. h.The cash balante at March 31 ls $64,000; the company must malntain a cash balance ofatleast $40,000 at the end of each month. i. The company has an agreement with a local bank that allows the company to borrow in increments at 51,000 at the beginning of each month, up to a total loan balance of $200,000. The interest rate on these loans is 1% per month and for simplicitywe will assume that interest is not compounded. The company would, as tar as lt is able, repay the loan plus accumulated interestat the end of the quarter. The company's president is interested in knowing how reducing lnventnry levels and collecting accounts receivable sooner will impad the cash budget. He revises the cash colledlon and endlng lnventory assumptions as follow: 1.5ales contlnue to be 20% for cash and 00% on credit. However, credit sales from April, May, and June are collected over a threemonth period wlth 25% collected ln the month otsale, 65% collected in the month following sale, and 10% ' the second month following sale. Credit sales from Febmary and March .._. _...u._.....a .4.._-_.. n... ......__.4 ......s._. ....:.... u... _._n_...:_.. ...._...a......._ ........::...4 :_ n... .....:.. ._.._.;:....
