would anyone be able to answer this step by step? I'm having a little tro
uble understanding it
Question 2 (45 Marks) - please complete in Excel l all 1 Real 16. 980s 3 .c8. 24 I Completica Mashar luder Tha: Gallowing clalu rulletproof Company, a wiha:Isak druruf consume da, gaur Mandi June purch Toral disbursement $47ASO 4- Schedule of exported each dobursements sciug and administrative exponen's Sack) Huggiral 1. Uring the data sher, complete the following: 1. Schedule od cxpected cash collections: 20 Nacka May June Quarter Cash $ 9,000 ALINIS TV 20,000 Invertory 36,000 Building almui.perl. 120.000 and Acous paule 21.750 Cons 160.000 Keland 12.250 2. The grocs margin is 25?cod saks b. Actual and budgeted sales data are as allow: April May June Quarter Curth stiles $36.000 Credit sales 2000 Total collections SL6,000 *10% of pror months sules 2. Merchandise patches boda (10 Matka April Commission $ 7,200 Real 2,500 Other apenas 3,500 Total disbursema VS 13.300 5 Caboscou Muts) April May June Quartur Cashbalance, beginning April May June Quarter $ 8,000 56,000 $ 64,000 Budgeted Lulur goods sold $ 46,000 $64.000 Add desired ending Inventory 12.2001 Total need: 89200 Acash collections Toral cah available Le cash disbursements For inventory $ 47.650 March (actual $60.000 April 60.000 May 72,000 lume 20,000 July 48,000 c. Sales arc con doc cash and 10 cedit. Credits are collected in the mooth % sale Sollowing sale. The accounts receivable at March 31 are a result of Marthered sales " l. Fad mans culing iilary shuukiul Sulthulling muntl'i luhysical H. Ofof.x months immatory purchases is paid for in the month of purchase the cost of goods sold. other lullis paid for in Tollwity cath. Theylilal Man in the sot Manch part in C Monthly paix Gullmars, 1966 ;rul. $2900 H montothes especulescuing depreciation of salesAssume that these spensa panid monthly papereristion is $400 per month (includes depreciation clx) Peppa in $1G00 will love for cash in Ajira fi. The company must maintain a mom cant balance at 39.000. An open Inect Credit Bavailable at a local bank All borrowing is done at the beginning of a month and all repayments are made at the end of 2 month. The monthly interesate is 1. Less beginning investury 3600C Required porches $52,200 For April sales: $60,000 sales 7555costrato - $15,000 $54,000 -80% - $43700 3. Schedule od expected cash disbursements Merchandise purchascarparks) Tor Hp 19,300 Torget 1,500 Total taslidasbursements 62.650 Excess (elemy) for $ 1.350 | April May June Quarter $21750 $21.750 LLC Manthi purune April purchases Hay purchases 26,100 $26,100 52 200 Question 2 (45 Marks) - please complete in Excel l all 1 Real 16. 980s 3 .c8. 24 I Completica Mashar luder Tha: Gallowing clalu rulletproof Company, a wiha:Isak druruf consume da, gaur Mandi June purch Toral disbursement $47ASO 4- Schedule of exported each dobursements sciug and administrative exponen's Sack) Huggiral 1. Uring the data sher, complete the following: 1. Schedule od cxpected cash collections: 20 Nacka May June Quarter Cash $ 9,000 ALINIS TV 20,000 Invertory 36,000 Building almui.perl. 120.000 and Acous paule 21.750 Cons 160.000 Keland 12.250 2. The grocs margin is 25?cod saks b. Actual and budgeted sales data are as allow: April May June Quarter Curth stiles $36.000 Credit sales 2000 Total collections SL6,000 *10% of pror months sules 2. Merchandise patches boda (10 Matka April Commission $ 7,200 Real 2,500 Other apenas 3,500 Total disbursema VS 13.300 5 Caboscou Muts) April May June Quartur Cashbalance, beginning April May June Quarter $ 8,000 56,000 $ 64,000 Budgeted Lulur goods sold $ 46,000 $64.000 Add desired ending Inventory 12.2001 Total need: 89200 Acash collections Toral cah available Le cash disbursements For inventory $ 47.650 March (actual $60.000 April 60.000 May 72,000 lume 20,000 July 48,000 c. Sales arc con doc cash and 10 cedit. Credits are collected in the mooth % sale Sollowing sale. The accounts receivable at March 31 are a result of Marthered sales " l. Fad mans culing iilary shuukiul Sulthulling muntl'i luhysical H. Ofof.x months immatory purchases is paid for in the month of purchase the cost of goods sold. other lullis paid for in Tollwity cath. Theylilal Man in the sot Manch part in C Monthly paix Gullmars, 1966 ;rul. $2900 H montothes especulescuing depreciation of salesAssume that these spensa panid monthly papereristion is $400 per month (includes depreciation clx) Peppa in $1G00 will love for cash in Ajira fi. The company must maintain a mom cant balance at 39.000. An open Inect Credit Bavailable at a local bank All borrowing is done at the beginning of a month and all repayments are made at the end of 2 month. The monthly interesate is 1. Less beginning investury 3600C Required porches $52,200 For April sales: $60,000 sales 7555costrato - $15,000 $54,000 -80% - $43700 3. Schedule od expected cash disbursements Merchandise purchascarparks) Tor Hp 19,300 Torget 1,500 Total taslidasbursements 62.650 Excess (elemy) for $ 1.350 | April May June Quarter $21750 $21.750 LLC Manthi purune April purchases Hay purchases 26,100 $26,100 52 200
