Week 4 Mod 4.2 Mastery_test Steph

# Week 4 Mod 4.2 Mastery_test Steph - g httpsﬂfdmsdewytdufd...

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

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

View Full Document

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

View Full Document

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: g, httpsﬂfdmsdewytdufd 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 aﬁerthe 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 Iﬁt g] httpsﬂdrnsdewyﬁiufdmWebPagafflashfco 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] httpsﬁfdrnsdeulyedufd msN-rebPa g afflashfco ntenﬂstudentfrnasteryTest.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 aﬁerthe 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, httpsﬂfdmsdeuqtdufdeebPagesfflashfcontenﬂstudentl'masteryTestaspx?courseID:534245?SduserID:23920225£dsﬂD=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 aﬁerthe 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. Tpcttﬁt = \$9.000+ \$12.000 + \$2.500 + \$1.100 + \$15.500 + \$55400 + \$55.000 ' " " ' = \$135,500 Done 9 Internet | Protected Mode: On 'v’h V Tﬁt g, httpsﬂfdmsdeumedufdmsNJebPagesfflashfcontenﬂstudentl'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 ﬁnancing 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’llﬂl’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 {ﬂ ' 100% V Tﬁt g, httpsﬂfdmsdeuqtdufdeebPagesfflashfcontenﬂstudenbl'masteryTestaspx?courseID:534245?SduserID:23920225£dsﬂD=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 ﬁnancing 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 aﬁerthe 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 .Ilﬁllhatisthe amounth moneﬂhatwi” 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 Tﬁt g, httpsﬂfdmsdeuwtdufd msNJebPa g esfflashfc o ntenﬂstudentl'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 ﬁnancing 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

{[ snackBarMessage ]}

### Page1 / 7

Week 4 Mod 4.2 Mastery_test Steph - g httpsﬂfdmsdewytdufd...

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

View Full Document
Ask a homework question - tutors are online