Week 4 Mod 4.2 Mastery_test George

Week 4 Mod 4.2 Mastery_test George - g,...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: g, httpsflfdmsdewytdufd msN-rebpa g afflashfcontentfstudentl'masteryTestaspxkou rseI[,'I:53£'l24'15]II Stu serID: 3920226£d ssID:138 Btroletype: STUD I. F'hoto Supplies. Inc. is planningtorthe 3rd quarter. The sales pudgetforthe 3rd quarter is as follows: 'September $80,000 Juli,I 'August $50000 95.000 ,3 Budgeting l-.-1TG1 02.xls I Based on history. Photo Supplies. Inc. has determined that 50% of sales are collected in the month of sale. 30% in the month following the sale and the remaining 20% is collected 2 months afierthe sale. l'ulay sales totaled $50000 and June sales totaled $58000. ‘."."hat is the amount of expected collections TOI'JUI'y'? Collections fOI'JUI‘j' = $ I Cash Collections forJuIy: [May Sales} [June Sales} [Julyr Sales} $50,000 *20% = $ 10,000 $58,000 " 30% = $ 17.400 $60,000 " 50% = 5 30.000 Expected Collections for November |.laster_. Testtotal points irossicle: 2f: setg Q Welcome. Stephni Robinson Esta Set'riltec: 9.,r “I '3‘. 2311 Ouestion‘l :' points =$10.000 + $11?,400 + 530.000 = 55?,400 a Internet | Protected Mode“. On {‘9 v 64.10093 v Ifit g] httpsfldrnsdewyfiiufdmWebPagafflashfco ntenti'studentin-1asteryTest.aspxkourseIlIII:53l‘l24‘15]II StuserID:392022StdssID:138&roletype=STUD set a Q 7 Welcome. Stephni Robinson 351% Ecc'riltec: Ex “I '3‘: 231‘. ‘ Question 2 1v.) 20b 3&1 #3; _ iI'ItS Based on sales projections. Jump on It needs to budgetfor purchases to meet possible sales demands. The sales budgetfor the 1st quarter shows the following: January FebruaryI March 500units 500units F00units _ _ Units requiredforJanuary : Budgeting MTG: 01.xls i Jump on It desires to have 30% of the following months sales budgetas ending inventory: The purchase price of‘i unit is $200. Eleginning inventory-TorJanuary'would be the desired ending inventory'forDecember. How many units need to be purchased in January“?- " ' Units Required for January = Estimated Sales January + Desired ending inventory = 500 units +150 units (February 500 units "' 30%} = ?50 needed units Needed units — Beginning Inventory = F50 units — 180 units [600 " 30%} = 5?!) units | E3 Clo-at! |.|3Eter_. Testtotal points possiclen Done a Internet | Protected Mode: On {‘5 V @{100'36 V I51; g] httpsfifdrnsdeulyedufd msN-rebPa g afflashfco ntenflstudentfrnasteryTest.aspxkou rseI[,'I:534245]II Stu serID: 392022 Std ssID:138 Stroletyp e: STUD set a Q ' Welcome. Stephni Robinson 351% Ecc'riltec: 9.? “I '3‘: 231‘. 2 Question 3 1W; 2W 3‘ ‘3} :' r“ ii'ItE. Desk Makers Inc. estimates that it pays 50% of its purchases in the men h of purchase and 40% in the month afierthe purchase. December purchases totaled $155000. All other expenses are paid forin the month they are incurred. Here is a record ofpurchases and other expenses forthe 1st quarter otthe year. January February March m Cash disbursements forJanuary = $ Advertising 59.000 511.000 $10000 m Rent $2.500 $2.500 $2.500 m "."."ages 3513.500 319.300 $19300 ELI-jg 9101-“ l-.-1T03 02.xls |:-. i Cash Disbursements forJanuary: ".l‘."ha isthe amount of cash disbLi Advertising $9.000 Commissions $12000 Rent $2.500 Utilities $1.100 Wages $18.500 Januaryr purchases $144.000 * 60% = $86400 December purchases $155000 *40% = $56000 < ,_ , n, _. T. .I _ ECU“- "'°=t*'= “5050' Total Cash Disbursements forJanuari,r Done 9 Internet | Protected Mode: On {‘5 V @{100'36 V Tat ' g, httpsflfdmsdeuqtdufdeebPagesfflashfcontenflstudentl'masteryTestaspx?courseID:534245?SduserID:23920225£dsflD=13851ro|etype= STUD set a Q \7 Welcome. Stephni Robinson Cale 9-:1'ille2: E‘." .-|?1:CI11 Question 3 18/ 28/ ‘v/ E points Desi: li-lalters Inc. estimates that it pays 50% of its purchases in the mon h of purchase and 40% in the month afierthe purchase. December purchases totaled $155.000. All other expenses are paid forin the month they are incurred. Here is a record ofpurchases and other expenses forthe 1st quarter otthe 'y'EEll'. JanuanI FebruaryI March Purchases $144.000 $1?3.000 $150000 C830 UiSbUFSBmBntSTDFJaHUEI’r‘ = 35 Advertising $0.000 $11000 $10000 Commissions $12.000 $14000 $13000 Rent $2.500 $2.500 $2.500 Utilities $1.100 $1.000 $000 "."."ages $18500 $10300 $10300 1: Budgeting mos 02.xls I A Advertising $9.030 |—| 'l‘."ha isthe amount of cash disbL Commissions $12.300 Rent $2.530 Utilities $1.130 Wages $15500 Januaryr purchases $144.000 * 50% = $55.400 December purchases $155000 *40% = $55.000 Total Cash Disbursements for January E! CID.“ “Beta. Tpcttfit = $9.000+ $12.000 + $2.500 + $1.100 + $15.500 + $55400 + $55.000 ' " " ' = $135,500 Done 9 Internet | Protected Mode: On 'v’h V Tfit g, httpsflfdmsdeumedufdmsNJebPagesfflashfcontenflstudentl'masteryTestaspx?courseID:534245?StuserID:23920225tdssID:138&ro|etype: STUD set a Q Welcome. Stephni Robinson Cale 9-:n'ille2: E‘." .-|?1:CI11 Question 4 18/ 28/ 38/ ask E points Based on the following assumptions. determine whatthe financing needs will be for Public Cleaning Company assuming they have a desired ending cash balance ot$30000 Please assume thatthe beginning cash balance for all months was $0 and that 30% ofsales are collected during the month of sale. 00% in the month alter and ‘10%inthe 2nd month atterthe sale. December sales were $300000. Inventory purchases are paid for 100% in the month _ _ _ _ followingthe purchase. All other expenses including equipment Amount borrowed “7 Fame” 2 $ purchases are paid for in cash in the month they are incurred. Public Cleaning Companyhasthe following estimated data: January February March Sales $350000 $300000 $380000 lnyentoryPLirchases $250000 $3“ Operating Expenses $T5.000 $8 Purchases of “Minn $1 Calculated Expected Collections: |_| Equipment Collections for February sales in February [$380000 * 30% } = $ 111000 . . Collections forJanuary sales in February [$350000 * 60% } = $ 210.000 Pa"ment ofdi"idends 10.000 2 . . T 0 $ $ Collections for December sales in February [$300000 * 10%} = $ 30.000 "-“-"hatisth9 amuan mone'rthatwi“ "99E Total expected collections $111000 + $210000 + $30000 = 535.7000 February"? Expected Disbursements: Purchase of Inventory in January paid in February $ 250.000 Operating Expenses for February paid same month $ 85.000 Purchase of Equipment in February paid same month $ 10.000 < \Imnnt nf FDhl’llfll’U I'li'uirlnnrlc nqirl cqmn mnnth R: on nnn ' Clan l.laeter_. Testtctal |:-:=ints | 4 Im I > J Done 9 Internet | Protected Mode: On {fl ' 100% V Tfit g, httpsflfdmsdeuqtdufdeebPagesfflashfcontenflstudenbl'masteryTestaspx?courseID:534245?SduserID:23920225£dsflD=13851ro|etype= STUD set a Q \7 Welcome. Stephni Robinson Cale 9-:1'ills2: E‘." .-|?1:CI11 Question 4 18/ 28/ 38/ E points Based on the following assumptions. determine whatthe financing needs will be for Public Cleaning Company assuming they have a desired ending cash balance ot$30.000. Please assume thatthe beginning cash balance for all months was $0 and that 30% ofsales are collected during the month of sale. 00% in the month alter and 10% inthe 2nd month afierthe sale. December sales were $300.000. Inventory purchases are paid for 100% in the month followingthe purchase. All other expenses including equipment purchases are paid for in cash in the month they are incurred. Public Cleaning Companyhasthe following estimated data: Amount borrowed in February 2 $ January February March Sales $350000 $300000 $380000 lnyentoryPLirchases $250000 $3“ OperatingExpenses $T5.000 $8 Purchases of $30.000 $1 ed Disbursements: bl Equipment 3e oflnventory in January paid in February 55 260.000 Payment mmidends $10300 $2 ng Expenses for February paid same month $ 85.000 se of Equipment in February paid same month $ 10.000 .Ilfillhatisthe amounth moneflhatwi” nee: “It of February Dividends paid same month $ 20.000 February"? (pected disbursements $250000 + $85000 + $10000 + $20.000 = $3?5.000 of disbursements over receipts = $336000 - 535.7000 = 513 000 v E! Clo-nu |.laeter_. Testtctal points | 4 I nu > J Done 9 Internet | Protected Mode: On 'v’h V Q1009E V Tfit g, httpsflfdmsdeuwtdufd msNJebPa g esfflashfc o ntenflstudentl'masteryTesta spx?cou rseID: 534245? Stu serID: 392022 Std ssID:138 Stroletyp e: STUD set a Q ' Welcome. Stephni Robinson Cate 9-:1'ittec: 9.." .-|21ECI11 Question 4 18/ 28/ 38/ ab :' points Based on the following assumptions. determine whatthe financing needs will be for Public Cleaning Compan'y assuming the'y have a desired ending cash balance ot$30000 Please assume thatthe beginning cash balance for all months was $0 and that 30% ofsales are collected during the month of sale. 00% in the month alter and 10% inthe 2nd month alterthe sale. December sales were $300000. Inventory purchases are paid for 100% in the month _ followingthe purchase. All other expenses including equipment Amount borrowed "1 February 2 $ purchases are paid for in cash in the month they are incurred. Public Cleaning Compan'yhasthe following estimated data: January February March Sales $350000 $300000 $380000 ln'v'entoryPurchases $250000 $3“ OperatingExpenses $T5.000 $8 3e o1tqurpment in i-eoruar},r paid same month a: IU.UUU bl PL'rChases 0f “0-000 $1 '1101’FI3IZH’UEI’3.r Dividends paid same month $ 20.000 Equipment Paymentofdi'u'idends $10000 $2 (pected disbursements $250000 + $85000 + $10000 + $20.000 = $3T5.000 What is the amount of money thatwill neec 0f diSbursemems WW “3990319 February"? = $3?5.000 - 335.7000 = 813 000 iancing needs — Excess of disbursements over receipts + Desired end 813 000 + $30000 = $48,000 v E Clo-nu |.laster_. Testtotal points i 4 nu I > J Done 9 Internet | Protected Mode: On 'v’h V QIUU'X. V ...
View Full Document

Page1 / 7

Week 4 Mod 4.2 Mastery_test George - g,...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online